Thursday, 16 January 2014

Document Viewer in asp net mvc

Google Docs offers an undocumented feature that lets you embed PDF files and PowerPoint presentations in a web page. The files don't have to be uploaded to Google Docs, but they need to be available online.

Copy & Past on your page :
-----------------------------------
<iframe src="http://docs.google.com/gview?url=http://infolab.stanford.edu/pub/papers/google.pdf&embedded=true" style="width:600px; height:500px;" frameborder="0"></iframe>
<iframe src="http://docs.google.com/viewer?url=http%3A%2F%2Fcrypto.stanford.edu%2FDRM2002%2Fdarknet5.doc&embedded=true"></iframe>

 Hope this help you


Tuesday, 17 December 2013

Auto Upgrade MVC 3 To MVC 4

Install-Package UpgradeMvc3ToMvc4

http://nugetmusthaves.com/Package/UpgradeMvc3ToMvc4
Hope this help you !



Wednesday, 11 December 2013

Showing loading animation in center of page while making a call to Action method in MVC



Now, use javascript to show it in and hide, when an ajax request starts. 
<script type="text/javascript">
    $(document).ajaxStart(function () {
        $('#spinner').show();
    }).ajaxStop(function () {
        $('#spinner').hide();
    });
</script>


Style the div element to position it on the centre of the browser.
<style>
div#spinner
{
    display: none;
    width:100px;
    height: 100px;
    position: fixed;
    top: 50%;
    left: 50%;
    text-align:center;
    margin-left: -50px;
    margin-top: -100px;
    z-index:2;
    overflow: auto;
}  
</style>


Put the html for the loader in the page.
<div id="spinner">
    <img src="~/Images/googleLarge.gif" alt="Loading..."/>
</div>

Hope this help you !



Saturday, 30 November 2013

MVC 3 AJAX redirecting instead of updating DIV

Finally I tracked it down to two issues.
I realized that if I set UnobtrusiveJavaScriptEnabled to false in my web.config file, everything worked.


A second issue, and one that I suspect others may run into as well, is that I didn’t have a reference to jquery.unobtrusive-ajax.min.js in my master (or child) page.  Since MVC 3 uses UnobtrusiveJavaScript by default, it’s essential that the Javascript files are referenced, otherwise it can break unrelated Javascript, making it obtrusive rather than unobtrusive.  Obviously not the desired effect.
The correct scripts that are required for MVC+AJAX plus UnobtrusiveJavaScript are:

  1. <script src="@Url.Content("~/Scripts/jquery-1.4.1.min.js")" type="text/javascript"></script>
  2. <script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script>
  3. <script src="@Url.Content("~/Scripts/jquery.unobtrusive-ajax.min.js")" type="text/javascript"></script>
  4. <script src="@Url.Content("~/Scripts/MicrosoftAjax.js")" type="text/javascript"></script>
  5. <script src="@Url.Content("~/Scripts/MicrosoftMvcAjax.js")" type="text/javascript"></script>

Hope this help you.

Wednesday, 27 November 2013

Composable LINQ to SQL query with dynamic Parameters

var _companyId = 1;
var Name = "OP";
var FromDate;
var  EmpId;
 var query = from audit in edmx.tblAudit
              from asst in edmx.tblAssets.Where(x => x.AutoId == audit.Asset_Id)
              where audit.Company_Id == _companyId
                  && asst.Name.Contains(string.IsNullOrEmpty(Name) ? asst.Name : Name)
           select new
             {
                        AssetName = asst.Name,
                        Serial_No = asst.Serial_No,
                        EmployeeName = audit.EmpName,
                        Date = audit.Audit_Date
             };

if (FromDate.Length > 7)
{
     var _FromDate = Convert.ToDateTime(FromDate);
     query = query.Where(x => x.Date >= _FromDate);
}
if (EmpId.Length > 0)
{
     var _empId = Convert.ToInt16(EmpId);
     query = query.Where(x => x.EmployeeId == _empId);
 }

 var auditData = (from asst in query
          asst.AssetName, asst.Serial_No, asst.EmployeeName,
          asst.Date, asst.AssetType
          }).OrderBy(x => x.AssetType).ToList();



looking like :
SELECT AssetName, Serial_No, EmployeeName,Date,AssetType FROM [dbo].[tblAssets] AS [t0]
 Inner join tblAudit t1 on t1.Asset_Id = t0.AutoId
WHERE (t0.
AssetName like '%op%') AND (t0.Fromdata >= '01/01/2013') AND (t1.empId = 11) 

for more information please see below link :
http://blogs.msdn.com/b/swiss_dpe_team/archive/2008/06/05/composable-linq-to-sql-query-with-dynamic-orderby.aspx?CommentPosted=true#commentmessage

Tuesday, 19 November 2013

Remove character from string using javascript


var test = '1,3,4,5,6';??

//to remove number/chracter
function removeNum(string, val){
   var arr = string.split(',');
   for(var i in arr){
      if(arr[i] == val){
         arr.splice(i, 1);
         i--;
      }
  }           
 return arr.join(',');
}

var str = removeNum(test,3);   
document.write(str); // output 1,4,5,6

Shortest method to convert an array to a string in c#/LINQ


int[] intarray = { 1, 2, 3, 4, 5 };
string getString = String.Join(",", arr.Select(p=>p.ToString()).ToArray())

Convert Int array to string array
string[] result = intarray.Select(x=>x.ToString()).ToArray();