technisher.in

Recurring Deposite Calculator using AngularJs and HTML5

noreply@blogger.com (Anonymous) — Wed, 21 Oct 2015 13:25:00 +0000

Here I have created Recurring Deposit Calculator using angularjs and HTML5

&lt!DOCTYPE html&gt
&lthtml&gt
&lthead&gt

&ltscript 
src= "http://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js"&gt
&lt/script&gt

&ltlink rel="stylesheet" 
 href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css"&gt

&ltstyle&gt
#tbl ,th, td {
  border: 1px solid grey;

  padding: 5px;
}
#tbl 
{
   width:100%;
}

div 
{
 margin:5%;
 width:500px;
}


.label
{
   background-color: #707070;
}

#tbl tr:nth-child(odd) {
  background-color: #f1f1f1;
}
#tbl tr:nth-child(even) {
  background-color: #ffffff;
}

fieldset.scheduler-border {
    border: 1px groove #ddd !important;
    padding: 0 1.4em 1.4em 1.4em !important;
    margin: 0 0 1.5em 0 !important;
    -webkit-box-shadow:  0px 0px 0px 0px #000;
            box-shadow:  0px 0px 0px 0px #000;
}

    legend.scheduler-border {
        font-size: 1.2em !important;
        font-weight: bold !important;
        text-align: left !important;
        width:auto;
        padding:0 10px;
        border-bottom:none;
    }
&lt/style&gt

&lt/head&gt

&ltbody&gt

&ltdiv  ng-app="myApp"  ng-controller="rdCtrl"&gt
&ltfieldset class="scheduler-border"&gt
&ltlegend class="scheduler-border"&gtRd Calculator&lt/legend&gt
&ltform name="myForm" step="any" ng-model="formModel" 
ng-submit="Calculate()" &gt 
&lttable&gt
&lttr&gt
&lttd&gtMonthly Installment(R) :&lt/td&gt
&lttd&gt&ltinput type="number" step="any" class="form-control" 
name="rdamount" ng-model="rdamount" required&gt&lt/td&gt
&lt/tr&gt
&lttr&gt
&lttd&gtRate of Interest :&lt/td&gt
&lttd&gt&ltinput type="number" step="any" class="form-control" 
name="interestrate" ng-model="interestrate" required&gt&lt/td&gt
&lt/tr&gt
&lttr&gt
&lttd&gtNumber of Months(n)  : &lt/td&gt
&lttd&gt
&ltselect name="rdperiod" class="form-control" ng-model="rdperiod" &gt 
 &ltoption data-ng-repeat="month in months" value="{{month.value}}"&gt
{{month.text}}
&lt/option&gt
&lt/select&gt
&lt/td&gt
&lt/tr&gt
&lttr&gt
&lttd&gtMaturity : &lt/td&gt
&lttd&gt{{rdmaturity | number:2}}&lt/td&gt
&lt/tr&gt
&lttr&gt
&lttd colspan="2"&gt
&ltinput type="submit" class="form-control btn btn-info" &gt
&lt/td&gt
&lt/tr&gt
&lt/table&gt
&lt/form&gt
 &lt/fieldset&gt
&lt/div&gt
&lt/body&gt
&lt/html&gt

&ltscript&gt

var app = angular.module('myApp', []);

app.controller('rdCtrl', function($scope) {
/****Initialisation at start ********/
 $scope.rdamount= 3000;
 $scope.interestrate = 8.7;
 $scope.rdperiod = 3;

$scope.Calculate = function() { 
 $scope.interestrate1=$scope.interestrate/400;
 $scope.quarter=$scope.rdperiod/3;
 $scope.rdmaturity=
 ($scope.rdamount*[ (Math.pow((1+$scope.interestrate1),$scope.quarter))-1])/
( 1- Math.pow((1+$scope.interestrate1),-1/3));
       }

$scope.months=[];

for(i=3;i&lt=120;i=i+3)
$scope.months.push({value:i,text:i});

});
&lt/script&gt

CRUD Operation, Searching, sorting and pagination using AngluarJs

noreply@blogger.com (Anonymous) — Mon, 12 Oct 2015 06:23:00 +0000

This is one simple angularjs Application with  Searching,Sorting, Pagination,
along with CRUD  Operation on simple array of object.

Before doing copy paste kindly add one additional JS file i.e
dirPagination.js.
After that just change the reference address of that file which is 
specified in head section.

To get dirPagination.js Click here.



<div dir="ltr" style="text-align: left;" trbidi="on">


<!DOCTYPE html>
<html>
<head>

<script 
src= "http://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js">
</script>
<script src="D:/Study/anugular/dirPagination.js"></script>
<link rel="stylesheet"
 href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">

<style>
#tbl ,th, td {
  border: 1px solid grey;
  border-collapse: collapse;
  padding: 5px;
}
#tbl 
{
   width:100%;
}

div 
{
 margin:5%;
 width:500px;
}

.label
{
   background-color: #707070;
}

#tbl tr:nth-child(odd) {
  background-color: #f1f1f1;
}
#tbl tr:nth-child(even) {
  background-color: #ffffff;
}
</style>

</head>

<body>

<div  ng-app="myApp"  ng-controller="personCtrl">

<!-- Create New Employee -->
<div ng-hide="editorEnabled">
<form name="myForm" ng-model="formModel" ng-submit="addEmployee()" 
novalidate> <table id="tbl">
<tr>
<td>Name: </td>
<td>
<input type="text" name="username" ng-model="name" required>
 
</td>
</tr>
<tr>
<td>Country:</td>
<td><input type="text" ng-model="country" required></td>
</tr>
<tr>
<td>Age:</td>
<td> <input type="number" ng-model="age" required></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="email" name="emailid" ng-model="email" required>

</td>
</tr>
<tr>
<td>Gender:</td>
<td><label data-ng-repeat="gender in genders">
    <input name="Gender"  type="radio"  value="{{gender.value}}" 
  ng-model="$parent.personGender" />  {{gender.text}}   
</label></td>
</tr>
<tr>
<td>Department:</td>
<td>
 <select name="dept" ng-model="department" > 
 <option  data-ng-repeat="dept in departments" 
       value="{{dept.value}}">{{dept.text}}</option>
 </select>
<span style="color:red" ng-show="myForm.dept.$dirty && myForm.dept.$invalid">
  <span ng-show="myForm.dept.$error.required">Department is required.</span>
  </span> </span>
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" >
</td>
</tr>
</table>
</form>
</div>

<!-- Edit Employee -->
<div ng-show="editorEnabled">
<form name="editablemyForm" ng-model="editableformModel" ng-submit="saveEmployee()" 
 novalidate>
<table id="tbl">
<tr>
<td>Name: </td>
<td>
<input type="text" name="editableusername" ng-model="editablename" required>
 
</td>
</tr>
<tr>
<td>Country:</td>
<td><input type="text" ng-model="editablecountry" required></td>
</tr>
<tr>
<td>Age:</td>
<td> <input type="number" ng-model="editableage" required></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="email" ng-model="editableemail" required></td>
</tr>
<tr>
<td>Gender:</td>
<td><label data-ng-repeat="gender in genders">
    <input name="editableGender"  type="radio"  value="{{gender.value}}"
   ng-model="$parent.editablepersonGender"/>  {{gender.text}}   
</label></td>
</tr>
<tr>
<td>Department:</td>
<td>
 <select name="dept" ng-model="editabledepartment">
 <option   data-ng-repeat="dept in departments" 
       value="{{dept.value}}">{{dept.text}}</option>
 </select>
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Update" >
<input type="button" value="Cancel"  ng-click="CancelEdit()" >
</td>
</tr>
</table>
</form>
</div>

<br/>

<span class="label">Ordered By: {{orderByField}}, 
Reverse Sort: {{reverseSort}}</span><br><br>
            <label>Search</label>
            <input type="text" ng-model="search" class="form-control" 
         placeholder="Search">
 <b>  Size :</b> <input type="text" ng-model="pagesize" 
class="form-control" placeholder="Size">
 </br>
<table class="table table-bordered">
<thead>
<th>
Edit
</th>
<th> 
 <a href="#" ng-click="orderByField='id';
   reverseSort = !reverseSort">Id
 <span ng-show="orderByField == 'id'">
 <span ng-show="!reverseSort">^</span>
 <span ng-show="reverseSort">v</span></span>
 </a>
</th>
<th> 
 <a href="#" ng-click="orderByField='name';
       reverseSort = !reverseSort">Name
 <span ng-show="orderByField == 'name'">
 <span ng-show="!reverseSort">^</span>
 <span ng-show="reverseSort">v</span></span>
 </a>
</th>
<th>Country</th>
<th>
 <a href="#" ng-click="orderByField='age';
        reverseSort = !reverseSort">
   Age <span ng-show="orderByField == 'age'">
 <span ng-show="!reverseSort">^</span>
 <span ng-show="reverseSort">v</span>
 </span>
          </a>
</th>
<th>Email</th>
<th>Gender</th>
<th>Department</th>
<th>Remove</th>
</thead>
<tr dir-paginate="employee in employees| orderBy:orderByField:reverseSort | 
filter:{name:search || ''}:strict | itemsPerPage:pagesize">
<!-- <tr ng-repeat="employee in employees| orderBy:orderByField:reverseSort | 
filter:{name:search || ''}:strict "> -->
 <td>
      <button class="btn" ng-click="editEmployee(employee.id)">
        <span class="glyphicon glyphicon-pencil"></span>  Edit
      </button>
</td>
<td>{{employee.id}}</td>
 <td>{{employee.name}}</td>
<td>{{employee.country}}</td>
<td>{{employee.age}}</td>
<td>{{employee.email}}</td>
<td>{{getGenderTextFromValue(employee.gender)}} </td>
<td>{{getDepartmentTextFromValue(employee.department)}}</td>
<td><input type="button" value="Remove" class="btn btn-primary" ng-disabled="editorEnabled" ng-click="deleteEmployee(employee.id)"/>
</td>
</tr>
</table>
<!--Pagination Control-->
  <dir-pagination-controls   max-size="pagesize" direction-links="true" boundary-links="true" >
    </dir-pagination-controls>
</div>
</body>
</html>
<script>
var app = angular.module('myApp', ['angularUtils.directives.dirPagination']);

app.controller('personCtrl', function($scope) {
/****Initialisation at start ********/
 $scope.orderByField = 'id';
$scope.reverseSort = false;
$scope.pagesize = 4;
$scope.personGender=3;
$scope.editorEnabled = false;


 $scope.employees = [
        {id:1,name:'Jani',country:'Norway',age:30,email:'aq@b.com', gender:1,department:2},
        {id:2,name:'Hege',country:'Sweden',age:20,email:'aw@b.com',gender:3,department:4},
        {id:3,name:'Kai',country:'Denmark',age:22,email:'ad@b.com',gender:2,department:1},
        {id:4,name:'Raj',country:'India',age:25,email:'aa@b.com',gender:1,department:3},
        {id:5,name:'Rani',country:'Nepal',age:24,email:'as@b.com',gender:2,department:1}
    ];

 $scope.genders =
        [
           {value:1, text: "Male"}, {value:2, text:"Female"}, {value:3, text:"Other"}
        ];

 $scope.departments =
        [
           {value:1, text: "HR"}, {value:2, text:"Admin"}, {value:3, text:"IT"}, {value:4, text:"Finance"}
        ];



/******find gender text from value**********/
 
$scope.getGenderTextFromValue = function(value) { 
  for (i in $scope.genders) {
            if ($scope.genders[i].value==value) {
  return $scope.genders[i].text ;
 }
         }
};



/******find department text from value**********/
 
$scope.getDepartmentTextFromValue = function(value) { 
  for (i in $scope.departments) {
            if ($scope.departments[i].value==value) {
  return $scope.departments[i].text ;
 }
         }
};



  /****** Add a Item to the list**********/
    $scope.addEmployee = function () {

/*finding max id from exiting to generate new max id for new record*/
$scope.maxId=0;
for (i in $scope.employees) {
            if ($scope.employees[i].id >$scope.maxId) {
  $scope.maxId=$scope.employees[i].id ;
 }
}

        $scope.employees.push({
         id:  $scope.maxId+1,
                        name: $scope.name,
                        age: $scope.age,
                        country: $scope.country,
                        email: $scope.email,
                        gender:$scope.personGender,
         department:$scope.department
        });
    $scope.name='';
    $scope.age='';
   $scope.country='';
   $scope.email ='';        
}


/*********Get Item to Edit from list********** */
$scope.id='';
$scope.editEmployee = function(id) {

/*this id is used at the time of sving edited employee records*/
    $scope.id=id;

    $scope.editorEnabled = true;
    $scope.editablename = $scope.employees[id-1].name;
    $scope.editablecountry= $scope.employees[id-1].country;
    $scope.editableage= $scope.employees[id-1].age;
    $scope.editableemail= $scope.employees[id-1].email; 
   $scope.editablepersonGender= $scope.employees[id-1].gender; 
    $scope.editabledepartment= $scope.employees[id-1].department;
}


/*********Save Edited Records***********/
$scope.saveEmployee = function() { 
                $scope.employees[$scope.id-1].name=$scope.editablename;
                $scope.employees[$scope.id-1].age=$scope.editableage;
                $scope.employees[$scope.id-1].country=$scope.editablecountry;
                $scope.employees[$scope.id-1].email=$scope.editableemail;
 $scope.employees[$scope.id-1].gender=$scope.editablepersonGender;
 $scope.employees[$scope.id-1].department=$scope.editabledepartment; 
 
  $scope.editorEnabled = false;
       }


/*******Cacnel edit operation*********/
$scope.CancelEdit=function(){
  $scope.editorEnabled = false;
}


/*********Delete row from list***********/
$scope.deleteEmployee = function (id) {
        for (i in $scope.employees) {
            if ($scope.employees[i].id == id) {
               if( confirm("This Record will get deleted permanently"))
  {
                     $scope.employees.splice(i, 1);                    
 }
            }
        }
    }

});
</script>


</div>

Role based Access to MVC4 Action/Controller using Custom Attribute

noreply@blogger.com (Anonymous) — Mon, 08 Dec 2014 12:19:00 +0000


Custom Attribute in mvc4:
Here I created one Custom Attribute named "CustomUserTypeAttribute"
which is used to check user type. If user type matches with restricted user
type then only this will redirect user to assigned error page.

To pass restricted user type I used one string variable named "UserLevel" and 
implemented it's "get set" property. And then I compared that with the current
user level which is stored in session variable.

Custom Attribute class : 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Routing;
using System.Web.Mvc;

namespace AuthenticationModule.Web.Common
{
    [AttributeUsage(AttributeTargets.Class | AttributeTargets.Method, 
     AllowMultiple = false, Inherited = true)]
    public class CustomUserTypeAttribute : ActionFilterAttribute
    {
    public string UserLevel { get; set; }
   public override void OnActionExecuting(ActionExecutingContext filterContext)
     {             
   try
      {
     if(HttpContext.Current.Session["user_level"].ToString().Equals(UserLevel))
       {
         RouteValueDictionary redirectTargetDictionary =
                               new RouteValueDictionary();

         redirectTargetDictionary.Add("action", "ErrorPage");
         redirectTargetDictionary.Add("controller", "Home");

         filterContext.Result = 
                     new RedirectToRouteResult(redirectTargetDictionary);
        }
       }
   catch(Exception)
    {
     throw;
    }
  }
 }
}


Using following you can apply this action filter on any action or controller.
Here I passed the on string argument named "UserLevel" with value 2 to the 
action filter.


      [CustomUserType(UserLevel = "2")]
        public ActionResult Add()
        {

Json size problem in mvc4

noreply@blogger.com (Anonymous) — Thu, 04 Dec 2014 07:41:00 +0000

Json Size limitation : While using json in mvc4 there is a problem 
when you transfer data using Ajax with JsonResult.

So here is a solution for this. you have to just set the "MaxJsonLength"
property to maxvalue.  


 var jsonResult = Json(result, JsonRequestBehavior.AllowGet);
            jsonResult.MaxJsonLength = int.MaxValue;
            return jsonResult;

Change date formate of Jquery datepicker in mvc4

noreply@blogger.com (Anonymous) — Tue, 02 Dec 2014 09:37:00 +0000


Following Code is used to change jquery date picker formate to accept the 
date as "dd/mm/yy" format instead of any other formate. 



  $(function () {
            $.validator.addMethod('date',
            function (value, element) {
                if (this.optional(element)) {
                    return true;
                }
                var ok = true;
                try {
                    $.datepicker.parseDate('dd/mm/yy', value);
                }
                catch (err) {
                    ok = false;
                }
                return ok;
         });
            $(".date").datepicker({ dateFormat: 'dd/mm/yy', changeYear: true });
        });

Trasnsaction Commit and Rollbcak in SQL Server

noreply@blogger.com (Anonymous) — Tue, 11 Nov 2014 07:33:00 +0000

Trasnsaction Commit and Rollbcak in SQL Server :

Generally Trasnsaction Commit and Rollbcak is used in SQL Server when user want to perform Add, Modify and Delete operation but he don't want to submit changes into the database until last statement execute successfully. Means the situation where either all or nothing. Following store procedure is used to perform Add, Modify and Delete operation on VisitorsPurpose table. Here OperationType 1 is used to perform Add operation. OperationType 2 is used to perform Modify operation and OperationType 3 is used to perform delete operation. Here begin tran is used to begin the transaction. User can give any transaction name but it must start with begin keyword followed by transaction name. Here I given tran as a transaction name. After completion of all the operation successfully if @ErrorCode variable contains zero as a ErrorCode value then commit tran is used which commits all changes into the database. To commit transaction use commit keyword followed transaction name which is begin last. If @ErrorCode variable contains non zero as a ErrorCode value then rollback tran which is used to undo all the operations performed within the trasaction. To rollback transaction use rollback keyword followed by last begin transaction. Also in insert statement I used with (ROWLOCK) keyword it means I want to insert only single record at a time. If more than one records come at the same time then second record has to wait until first records gets inserted. It is used to avoid deadlock conditions but this may degreed performance.

Create procedure [dbo].[SpAmdPurpose] ( @OperationType as int --1. Add Purpose 2. Modify Purpose. 3. Delete Purpose. , @PurposeId int=0 , @PurposeName varchar(250)=null , @CreatedBy varchar(100)=null , @CreatedDate datetime=null , @ModifiedBy varchar(100) = null , @ModifiedDate datetime = null ) as begin set nocount on declare @ErrorCode as int declare @Message as varchar(max) select @ErrorCode=0 , @Message='' begin begin try begin tran --OperationType = 1 is used for adding new purpose. if(@OperationType = 1) begin insert into VisitorsPurpose with (ROWLOCK) ( PurposeName, CreatedBy, CreatedDate ) values ( @PurposeName, @CreatedBy, getdate() ) set @ErrorCode=0 set @Message='Purpose Created Successfully!' end --OperationType = 2 is used for modifying existing Purpose. else if(@OperationType=2) begin update VisitorsPurpose with (ROWLOCK) set PurposeName = @PurposeName , ModifiedBy = @ModifiedBy , ModifiedDate = getdate() where PurposeId=@PurposeId set @ErrorCode=0 set @Message='Purpose Modified Successfully!' end --OperationType = 3 is used for Deleting Purpose else if(@OperationType=3) begin if exists(select 1 from VisitorsPurpose where PurposeId=@PurposeId) begin set @ErrorCode=1 set @Message='Purpose cannot be Deleted! It is already in use.' end else begin delete from VisitorsPurpose where PurposeId=@PurposeId set @ErrorCode=0 set @Message='Purpose Deleted Successfully!' end end else begin set @ErrorCode=1 set @Message='Invalid Operation Type!' end commit tran end try begin catch select @ErrorCode=110, @Message='Operation Failed due to invalid data. Please check details.' rollback tran end catch end select @ErrorCode as [ErrorCode], @Message as [Message] set nocount off end

Crystal report in MVC4

noreply@blogger.com (Anonymous) — Tue, 16 Sep 2014 07:18:00 +0000

Display Crystal Report in MVC4 Razor view: 
Here I am going to explain you the crystal report implementation
in MVC4 razor view. As there is a separate Report Viewer control in 
Asp.Net to display crystal report on the web page.

But in MVC4 there is no report viewer or any HTML helper to display
the report on the web page. Here I am displaying the report inside 
the iframe html element.  

Here I implemented the report viewer in three ways.



web Page Design : 
Following code is used to Design the web page on which I am going
to display the report. 




@using (Html.BeginForm("Index", "myController"))
{
 &lttable align="center"&gt
  &lttr&gt
     &lttd&gt
      Select Year: @Html.DropDownList("Year", new List&ltSelectListItem&gt { },
                   new { Id = "ddlYear", @class = "DropDown" })
     &lt/td&gt
 &lt/tr&gt
 &lttr&gt
    &lttd&gt
    Select Month: @Html.DropDownList("Month", new List&ltSelectListItem&gt { },
                new { Id = "ddlMonth", @class = "DropDown" })
    &lt/td&gt
 &lt/tr&gt
 &lttr&gt
  &lttd&gt
    &lta href="@Url.Action("GenerateReport")"&gtGet Pdf&lt/a&gt
     &ltinput type="submit" value="Show simple" /&gt
     &ltinput type="button" value="Show Report" onclick="SimpleInSameWin()" /&gt
   &lt/td&gt
&lt/tr&gt
 &lt/table&gt
}
&ltiframe name="theFrame" width="100%" height="100%"&gt&lt/iframe&gt





As design shows there are 
two buttons and one link.
Link is used to generate 
the PDF Report. While first 
button i.e. Show Simple is used to 
display report on the same web page.

While Button Show Report is used to display report on the same web page inside 
the iframe element.   

Following script is used to call the controller action and then resultant report
will be get displayed inside the iframe.  



Script which call controller action to display report inside the frame element : 


 function SimpleInSameWin() {
        window.open("../SalarySlip/ShowSimple?year=" + $('#ddlYear').val() + 
"&month=" +   $('#ddlMonth').val(), "theFrame"); // calling action      
    }



Above Script shows that window.open() method opens the crystal report inside the iframe element named theFrame. Also here I passed form elements value as a query string.
Above javscript method is called when user clicks on  show Report button. 



Controller code : 
In side Controller there are lots of method/actions. Following action is used for 
PDF report generation.  


1. Code for PDF generation : 
To generate pdf report must specify the exact path of your crystal report 
and must specify the DataSource value.
Note: As a practice I just passed the "dt" as argument you may call any 
method or write your own code to specify the data source for the crystal report. 




  public ActionResult GenerateReport(DataTable dt)
        {
            SqlConnection con = new
 SqlConnection(ConfigurationManager.ConnectionStrings["HREntities1"].
ConnectionString);
                   

            ReportDocument rd = new ReportDocument();
            rd.Load(Path.Combine(Server.MapPath("~/Report"), "rpt_report.rpt"));
            rd.SetDataSource(dt);

            Response.Buffer = false;
            Response.ClearContent();
            Response.ClearHeaders();

            Stream stream = 
rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
            stream.Seek(0, SeekOrigin.Begin);
            return File(stream, "application/pdf", "rpt_report.pdf");

            
        }

When user clicks on given link then above code gets executed and the PDF will 
be get generated. 



2. Display Report on the Same page inside the iframe element :

Following controller action is used to generate the report and display it 
on the same web page. This action is called from javascript method
SimpleInSameWin(). This action receive arguments which are passed as
querystring from script. 



Controller action To generate report: 


 public void ShowSimple(string year, string month)
        {  
            using (ReportClass rp = new ReportClass())
            {             
                string emp_code = "120";
                rp.FileName = Server.MapPath("~/Report") + "//rpt_Report.rpt";
                rp.Load();
                /*Get data from detatbase using Data layer via business layer*/
                rp.SetDataSource(bizSalarySlip.GetData(month, year, emp_code));
                rp.ExportToHttpResponse(ExportFormatType.PortableDocFormat,
 System.Web.HttpContext.Current.Response, false, "crReport");
            }
        }
      


In above code I passed the argument to the action method and generated the
report.
As a datasource I called one method by passing arguments. That method returns the
DataTable result which is passed as a DataSource. 




3. Display Report on whole web page : 
There may be situation where user want's to display crystal report on the
whole page instead of iframe html element. In this situation user must click
on button "Show simple" that will call the controller action method name Index 
and will display report on the same page.
 


Controller Index action method code : 

         [HttpPost]
        public ActionResult Index(FormCollection formCollection)
        {
            string month = formCollection["Month"];
            string year = formCollection["Year"]; ;
            string emp_code = "120";
            using (ReportClass rp = new ReportClass())
            {
                rp.FileName = Server.MapPath("~/Report") + "//rpt_Report.rpt";

                rp.Load();
                rp.SetDataSource(bizSalarySlip.GetData(month, year, emp_code));
          rp.ExportToHttpResponse(ExportFormatType.PortableDocFormat,
         System.Web.HttpContext.Current.Response, false, "crReport");
            }
            return View();
        }


When user submit the form above action method will be gets called all the 
form data received as FormCollection object.

Left Outer Join in Linq

noreply@blogger.com (Anonymous) — Tue, 19 Aug 2014 09:52:00 +0000

Left Outer Join in Linq to Entites:

So guys here I am going to explain you the Left Outer Join in Linq to entities. Here I performed left outer join on the results of two separate join queries. If left table does not contains value then DefaultIfEmpty() is used to select default value for that record.

Linq Query : var result=(from s in db.schedules join sp in db.programs on s.scheduleId equals sp.scheduleId join sub in ( from pc in db.PersonCategories join fc in db.FilmCrews on pc.PersonCategoryCode equals fc.PersonCategoryCode where (pc.PersonCategoryId == "PC0000001") select new { fc.Name, fc.programmeId } ) on sp.programmeId equals sub.programmeId into eGroup from sub in eGroup.DefaultIfEmpty() where (s.date >= "1 aug 2014") orderby s.date, sp.starttime select new { s.date, sp.starttime, s.programme_name, sub.Name }); Code Explanation :

In above code I performed join operation on schedule and programs table on the basis of scheduleId which is primary key in schedule table and forign key in programs table. Similarly I performed the join on PersonCategories and FilmCrews tables, on the basis of PersonCategoryCode which is primary key in first table and foreign key in second table. Now on the result of these two queries I performed left outer join as there is only join keyword which is used to perform all types of join operations. In above code I performed left outer join on the field programmeId which is present in the both the query results. To perform left outer join I used one Linq method named DefaultIfEmpty(). As you know in left outer join all values from left table are selected and only available values from second table are selected, so here DefaultIfEmpty() method is used for the same reason this method put Default value i.e. null in the place where there is no value for the current record.

Subquery in Linq :

In above code I also performed the subquery operation, i.e. here I performed left outer join on the subquery result. Here I created one alias named sub which holds the result of subquery. Then I performed Left outer join on the result of first join operation and on the result of subquery.

Inner join in linq

noreply@blogger.com (Anonymous) — Tue, 19 Aug 2014 09:41:00 +0000

Inner Join in linq:
Following code shows the inner join using Linq to Entities.
Linq query : 


var result=(from s in db.schedules
join sp in db.programs
   on s.scheduleId equals sp.scheduleId 
join pm in db.programme_data
   on sp.ProgramId equals pm.ProgramId 

where (s.date >= '1 aug 2014')
orderby s.date, sp.starttime

 select new { s.date, sp.starttime,pm.pgm_name});


Code Explanation : 
In above code I performed the inner join operation on three entities named 
schedules, programs and programme_data. Here I performed first join
operation in between schedules and programs entities on the field scheduleId 
i.e. primary key in the table schedules and foreign key in second table i.e.
programs.

Then on I performed join opertion with third table i.e. programme_data on the field 
on the field ProgramId i.e. primary key in the table schedules and foreign key in
 second table.

Pass Javascript object to MVC controller using Ajax

noreply@blogger.com (Anonymous) — Mon, 21 Jul 2014 07:43:00 +0000

To pass javascript object follow following steps.

Step 1. Creating Javascript Object:

  var Person = {   
    Id:$("#Id").val(),
    Name:$('#Name').val()
};

Here I created one javascript object named Person with two properties named
Id and Name. Here I assigned values from form controls to that properties.


Step 2. Ajax Call to pass data to MVC Controller

 $.ajax({
   url: '@Url.Action("getDetail", "Employee")',
   data: JSON.stringify({ PersonDetail:Person }),
   dataType: 'json',
   type: 'POST',
   contentType: "application/json",
   async: true,
   traditional: true,
   success: function (result) {
              alert("result");
              }
    });       


In above code I made ajax call to the controller action named getDetail
then I passed the javascript obejct to controller via data property of the 
ajax.


Step 3.Create Model class with all the person properties

public class Person 
    {
        public string Id{ get; set; }
        public string Name { get; set; }
    }

In above code I created one Model class with all the Person properties that 
will get initialised in javascript code.

Step 4. Write controller action which receives the data which 
sent through ajax.

        [HttpPost]
        public JsonResult getDetail(Person PersonDetail)
        {


Then in controller action the person data is received in person object. Here you 
will get all the values for the person from PersonDetail object.

Confirmation on Action link click in mvc4

noreply@blogger.com (Anonymous) — Mon, 14 Jul 2014 09:17:00 +0000

Confirmation:





Get confirmation on action link click in mvc4. 







@Html.ActionLink("LOG-OUT", "Logout", "Home", new { id = "logout" },
 new { onclick = "return confirm('Are you sure you want Logout?')" })

In above code  @Html.ActionLink()  html helper is used to create an  
action link in mvc4 razore view. There are many overloads for action link so
that the user can use it according to his requirement.

Here I want a client side confirmation i.e. when user clicks on logout ActionLink
then Javascript alert will be gets open as shown inn above image.

Here I called confirm() javascript function inside the html property of 
  @Html.ActionLink()  html helper.

Vertical menubar with submenus using HTML, CSS

noreply@blogger.com (Anonymous) — Fri, 11 Jul 2014 09:27:00 +0000



Vertical MenuBar: Following code is used to Create vertical
menu bar. It is created using plain HTML and CSS. 

Here I used plain HTML/HTML5 and CSS to create the browser compatible vertical
menu bar. also I created the menu , submenu and two level submenus also. Also 
used some css to highlight the selected menu. 

 <html>
<head>
</head>

<!-- STYLE-->
<style>

nav {    
  display: block;
  text-align: center;
}
nav ul {
  margin: 0;
  padding:0;
  list-style: none;
}
.nav a {
  display:block; 
  background: #111; 
  color: #fff; 
  text-decoration: none;
  padding: 0.8em 1.8em;
  text-transform: uppercase;
  font-size: 80%;
  letter-spacing: 2px;
  text-shadow: 0 -1px 0 #000;
  position: relative;
}
.nav{  
  vertical-align: top; 
  display: inline-block;
  box-shadow: 
    1px -1px -1px 1px #000, 
    -1px 1px -1px 1px #fff, 
    0 0 6px 3px #fff;
  border-radius:6px;
}
.nav li {
  position: relative;
}
.nav > li { 
  float: left; 
  border-bottom: 4px #aaa solid; 
  margin-right: 1px; 
} 
.nav > li > a { 
  margin-bottom: 1px;
  box-shadow: inset 0 2em .33em -0.5em #000064; 
}
.nav > li:hover, 
.nav > li:hover > a { 
  border-bottom-color: 33CCFF;
}
.nav li:hover > a { 
  color:33CCFF; 
}
.nav > li:first-child { 
  border-radius: 4px 0 0 4px;
} 
.nav > li:first-child > a { 
  border-radius: 4px 0 0 0;
}
.nav > li:last-child { 
  border-radius: 0 0 4px 0; 
  margin-right: 0;
} 
.nav > li:last-child > a { 
  border-radius: 0 4px 0 0;
}
.nav li li a { 
  margin-top: 1px;
}

.nav li a:first-child:nth-last-child(2):before { 
  content: ""; 
  position: absolute; 
  height: 0; 
  width: 0; 
  border: 5px solid transparent; 
  top: 50% ;
  right:5px;  
 }

/* submenu positioning*/
.nav ul {
  position: absolute;
  white-space: nowrap;
  border-bottom: 5px solid  33CCFF;
  z-index: 1;
  left: -99999em;
}
.nav > li:hover > ul {
  left: auto;
  margin-top: 5px;
  min-width: 100%;
}
.nav > li li:hover > ul { 
  left: 100%;
  margin-left: 1px;
  top: -1px;
}
/* arrow hover styling */
.nav > li > a:first-child:nth-last-child(2):before { 
  border-top-color: #aaa; 
}
.nav > li:hover > a:first-child:nth-last-child(2):before {
  border: 5px solid transparent; 
  border-bottom-color: 33CCFF; 
  margin-top:-5px
}
.nav li li > a:first-child:nth-last-child(2):before {  
  border-left-color: #aaa; 
  margin-top: -5px
}
.nav li li:hover > a:first-child:nth-last-child(2):before {
  border: 5px solid transparent; 
  border-right-color: 33CCFF;
  right: 10px; 
}

</style>

<body>
<nav>
  <ul class="nav">
     <li><a href="#">About</a></li>
      <li><a href="#">Reports</a>
        <ul>
          <li><a href="#">Daily</a></li>
           <li><a href="#">Weekly</a></li>
           <li><a href="#">Monthly</a></li>
        </ul>
     </li>
     <li><a href="#">Resources</a>
        <ul>
          <li><a href="#">Telephone</a></li>
           <li><a href="#">Computer</a>
             <ul>
                <li><a href="#">Keyboard</a></li>
               <li><a href="#">Mouse</a></li>
                 <li><a href="#">Monitor</a></li>
               <li><a href="#">CPU</a></li>
             </ul>
           </li>
           <li><a href="#">Mobiles</a></li>
           <li><a href="#">Resources 3</a></li>
        </ul>
     </li>
     <li><a href="#">Download</a></li>
     <li><a href="#">Rants</a>
        <ul>
          <li><a href="#">item</a></li>
          <li><a href="#">item</a></li>
          <li><a href="#">item</a></li>
          <li><a href="#">item</a></li>
        </ul>
     </li>
     <li><a href="#">Contact</a></li>
  </ul>
</nav></body>
</html>

Connection string encryption and decryption in C#

noreply@blogger.com (Anonymous) — Wed, 25 Jun 2014 11:32:00 +0000

Encryption:
Following code is used to encrypt connection string present in 
the web.config file.
Write below code on page load event or create the function 
when that function gets called the connection string which is
present in the Web.config will be get encrypted. After encryption
normal connection string i.e. plain text connection string will
be replaced by the encrypted coneection string which is not human
readable.



   public void EncryptConnectionString()
        {
Configuration config = WebConfigurationManager.
        OpenWebConfiguration(Request.ApplicationPath);
   ConfigurationSection configSection =
      config.GetSection("connectionStrings");
            
       if (!configSection.SectionInformation.IsProtected)
  {
        configSection.SectionInformation.
        ProtectSection("DataProtectionConfigurationProvider");
        config.Save();
         Response.Write("ConnectionStrings encryted successfully.");
   }
       else
  {
        Response.Write("ConnectionStrings has been encryted, 
    this action has been cancled");
  }
}



In the above code when the EncryptConnectionString() function gets called 
in first line I specified the part of web.config file which I want to encrypt 
i.e."connectionStrings" then in if(!configSection.SectionInformation.IsProtected)
I checked whether connection string already encrypted or not if not then I replaced
normal connection string with the encrypted connection string. (Plain text to 
cipher text)

config.Save(); is used to save the web.config file.

In if condition fails to execute then this means connection string already encrypted. 


Decryption:
Following code is used to decrypt connection string present in the 
web.config file.
Write below code on page load event or or create the
function when that function gets called the connection string which is
present the Web.config will be get updated with the decrypted connection
strings i.e. from cipher text to plain text which is user readable. 


public void DecryptConnectionString()
        {
        Configuration config = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
        ConfigurationSection section = 
          config.GetSection("connectionStrings");
        if (section.SectionInformation.IsProtected)
        {
            section.SectionInformation.UnprotectSection();
            config.Save();
        }
}



In the above code when the DecryptConnectionString() function gets called 
in first line I specified the part of web.config file which I want to decrypt
i.e."connectionStrings" then in if(section.SectionInformation.IsProtected)
I checked whether connection string already encrypted or not if it is encrypted 
then I replaced encrypted connection string with the plain text connection string. 
(Cipher text to Plain text).
config.Save(); is used to save the web.config file.


Following are the two ways of Encryption currently I used second approch. 
To use first approch just change the function call from ProtectSection("DataProtectionConfigurationProvider")
to ProtectSection("RSAProtectedConfigurationProvider").

1) RSAProtectedConfigurationProvider: This is the default provider and uses the RSA Public Key Encryption algorithm to encrypt and decrypt data.

2) DataProtectionConfigurationProvider: This provider uses Windows Data Protection Application Programming Interface (DPAPI) to encrypt and decrypt data.


Another Approch For Encryption:
For encryption you can use following command.
Open Visual studio command prompt as a administrator and fire the command.
 
aspnet_regiis.exe -pe "connectionStrings" -app "/ProjectName"

Note: Please run visual studio as administrator.

Writing datatable into text file

noreply@blogger.com (Anonymous) — Fri, 30 May 2014 06:55:00 +0000

Following function is used to write DataTable into the text file and then download that file. Pass the datatable as an argument to this function.

  public void WriteDataToFile(DataTable submittedDataTable)        
        {
            int i = 0;
           
            MemoryStream ms = new MemoryStream();
            TextWriter tw = new StreamWriter(ms);
          
            foreach (DataRow row in submittedDataTable.Rows)
            {
                object[] array = row.ItemArray;
                for (i = 0; i < array.Length - 1; i++)
                {
                    tw.Write(array[i].ToString() + ";");
                }
                tw.Write(array[i].ToString());
                tw.WriteLine();
            }
            tw.Flush();
            byte[] bytes = ms.ToArray();
            ms.Close(); 
            Response.Clear();
            Response.ContentType = "application/force-download";

            Response.AddHeader("content-disposition", 
                             "attachment;filename=MPBP.txt");

            Response.BinaryWrite(bytes);
            Response.End();     
        }

Json undefined error while using IE

noreply@blogger.com (Anonymous) — Wed, 21 May 2014 07:55:00 +0000


Just copy and paste the following code into the head tag section
of your web page. For reusability you can add this code on your 
Master page.

This code is used to avoid Json related and all the Ajax related problems
that comes while using different types of browsers. 

<meta charset="UTF-8" /> 
   <meta http-equiv="X-UA-Compatible" content="IE=edge;chrome=1" />
<!--[if lt IE 9]>
  <script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<![endif]-->
<!--[if gte IE 9]><!-->
  <script src="http://code.jquery.com/jquery-2.0.3.js"></script>
<!--<![endif]-->

Export HTML Table to Excel file using Jquery

noreply@blogger.com (Anonymous) — Mon, 19 May 2014 11:37:00 +0000

To write HTML table as it is inside the Excel file user must 
first create the html table inside the div element then you
can write that table as it is in Excel file.

Here I created HTML table inside the div whose id is divTable.
Then I exported that div to the Excel using window.open().
In window.open() function I specified data type as 
application/vnd.ms-excel.

Following code is used to write HTML table into the Excel file.
Here on button click HTML table which is present in the div 
whose id is "divTable" will be get printed into the Excel file.


$("#btnExcelExport").click(function(e) {
window.open('data:application/vnd.ms-excel,' + $('#divTable').html());
e.preventDefault();
});

write image into Excel cell

noreply@blogger.com (Anonymous) — Mon, 05 May 2014 10:16:00 +0000

Following code is used to write image into Excel cell without any external
dll's.

To get absolute path of an image VirtualPathUtility.ToAbsolute()
function is used. This function works on local machine as well as
on IIS.

Before that I checked whether code running is on local machine or it is
deployed on IIS by using the function ResolveServerUrl(). This
function takes two arguments first one is image path using the function
VirtualPathUtility.ToAbsolute().

So ResolveServerUrl() is used check whether program is running on 
local(localhost) machine or whether it is running on Server(http) .


Code:
   HttpContext.Response.Write("");
  
string filePath=ResolveServerUrl(
       VirtualPathUtility.ToAbsolute("~/Content/Images/img1.jpg"),
       false);

 string imagepath = string.Format("<img src='{0}'/>", filePath);
                       
 HttpContext.Response.Write("");
 HttpContext.Response.Write(imagepath);
 HttpContext.Response.Write("");
 HttpContext.Response.Write("");

Function for checking:
public static string ResolveServerUrl(string serverUrl, bool forceHttps)
        {
            if (serverUrl.IndexOf("://") > -1)
                return serverUrl;

string newUrl = serverUrl;
Uri originalUri = System.Web.HttpContext.Current.Request.Url;
newUrl = (forceHttps ? "https" : originalUri.Scheme) +
                "://" + originalUri.Authority + newUrl;
 return newUrl;
        }

Add image into excel sheet without any dll

noreply@blogger.com (Anonymous) — Mon, 28 Apr 2014 05:48:00 +0000

Writing image in excel default location is top left corner. To work the same code after deployment on IIS server don't forget to change the Image Url.
Code:

    HttpContext.Response.Clear();
    HttpContext.Response.ClearContent();
    HttpContext.Response.ClearHeaders();
    HttpContext.Response.Buffer = true;
    HttpContext.Response.ContentType = "application/ms-excel";
   
    HttpContext.Response.Write(@"<!DOCTYPE HTML PUBLIC "
             "-//W3C//DTD HTML 4.0 Transitional//EN"">");

  //Set the name of report as per query fired by the user.
 HttpContext.Response.AddHeader("Content-Disposition",
                  "attachment;filename=" + fileName);

HttpContext.Response.Charset = "utf-8";
HttpContext.Response.ContentEncoding = 
System.Text.Encoding.GetEncoding("windows-1250");

 HttpContext.Response.Write("<TR style='font-size:12.0pt;
 text-align:center; font-style:italic; text-decoration:underline;
 font-weight:bold;font-family:Book Antiqua;'>");

 string s = Server.MapPath("~\\Content\\Images\\abcd.jpg");
                     
   string filePath =
   System.Configuration.ConfigurationManager.AppSettings["LogoPath"];
   string imagepath = string.Format("<img src='{0}'/>", s);
                                        
 HttpContext.Response.Write("<Td>");
 HttpContext.Response.Write(imagepath);
 HttpContext.Response.Write("</Td>");
 HttpContext.Response.Write("</TR>");

Adding and Removing item from Dropdown list using Jquery

noreply@blogger.com (Anonymous) — Wed, 16 Apr 2014 07:14:00 +0000

Remove all item from dropdownlist
     $("#selectClient").empty();

Add item to dropdown list
var newOption = "";

$("#selectClient").append(newOption);

Enabling and disabling dropdown list

noreply@blogger.com (Anonymous) — Mon, 14 Apr 2014 07:41:00 +0000

Disabling drodown list

$("#selectAgency").prop("disabled", true).css('background', '#F0F0F0');

Enabling drodown list

$("#selectAgency").prop("disabled", false).css('background', '#F0F0F0');

Set particular item selected in dropdown list using Jquery

noreply@blogger.com (Anonymous) — Mon, 14 Apr 2014 07:25:00 +0000

Using Value Attribute setting dropdown item selected

 $('#selectGraphicsMode').val(graphicsEdit[i].ModeId);

Using text property setting dropdown item selected

   $("#selectAgency option:contains(" + graphicsEdit[i].AgencyId + ")")
     .attr('selected', 'selected');

Client side Validation using Regular Expression

noreply@blogger.com (Anonymous) — Mon, 14 Apr 2014 07:18:00 +0000

Client side Validation using Regular Expression : 

There are situations where user may performs many types of validation
on single field for example while entering email user must check empty 
field as well as email syntax all such validations can be performed in
single line by creating regular expression. 

In javascript there is method called match() which compare regEx
with the input field value.

  var reg = /^[V|v][0-9]{3}$/;
            var x = $("#Version").val();
   if (!x.match(reg)) {
        alert("Version must start with character v followed by 3 digit number");
            }
         
In above code I compared regular expression which is stored in variable reg
with the value entered in the textbox whose id is Version. Then in if 
condition I compared the regEx and value.

Making existing item selected in listbox using Ajax in mvc4

noreply@blogger.com (Anonymous) — Mon, 14 Apr 2014 06:58:00 +0000

Here I am displaying already selected items into listbox which are present into the database. And also I am removing them from orginal item listbox.

Design

In above design there are two listboxes one is showing all items and other is selected item. There are two button which transfer item from left to right and right to left.

Here right hand side listbox showing already selected items. Generally while editing the from data we retrieve already selected values into the form control in such case we are using this feature.

Ajax Action


 public JsonResult Edit(string graphicsId)
        {
 List<string> mappedChannelId = context.ChannelGraphicsMaps.Where
(x => x.GraphicsId == Id).Select(y => y.channel_code).ToList();
            string mappedChannelName = string.Empty;

List<KeyValuePair<string, string>> selectedChannels =
 new List<KeyValuePair<string, string>>();

            foreach (string item in mappedChannelId)
            {
      mappedChannelName=context.channel_master
.Where(a => a.channel_code == item)
.Select(a =>a.channel_name).SingleOrDefault().ToString();
 
selectedChannels.Add(new KeyValuePair<string,
string>(item,mappedChannelName));
            }           

  var result = (from x in graphics select new 
{ 
    SelectedChannels=selectedChannels,                     
});
   return Json(result, JsonRequestBehavior.AllowGet);
        }

Ajax code


  var options = {};
                options.url = '@Url.Action("Edit", "GraphicsMaster")',
                options.type = "POST";
                options.data = JSON.stringify({ graphicsId: Id });
                options.dataType = "json";
                options.contentType = "application/json";
                options.success = function (graphicsEdit) {
            //Code for assigning values to control of Programme
      for (var i = 0; i < graphicsEdit.length; i++)
 {
 /*Getting already selected channels into listbox
       and remove it from all channels list*/
  $('#selectedChannelList').empty();
 for (var j = 0; j < graphicsEdit[i].SelectedChannels.length; j++)
 {
 var listBox = document.getElementById("selectedChannelList");
 $("#selectLeft option[value=" + graphicsEdit[i].SelectedChannels[j].Key + "]").remove();

 move(listBox, graphicsEdit[i].SelectedChannels[j].Key, graphicsEdit[i].SelectedChannels[j].Value);
                        }

}

Design for above code in mvc4


<table>
<tr>
  <td>
     Select Channel
  </td>
  <td valign="top">
     @Html.ListBox("channels", ViewBag.channels as MultiSelectList,
       new { size = "6", id = "selectLeft" })
  </td>
  <td valign="top">
 <input name="btnRight" type="button" id="btnRight" value=">>" onclick="javaScript:moveToRightOrLeft(1);">
    <input name="btnLeft" type="button" id="btnLeft" value="<<" onclick="javaScript:moveToRightOrLeft(2);">
 </td>
<td valign="top">
     @Html.ListBox("channelSelected", new List<SelectListItem>(), 
      new { size = "6", id = "selectedChannelList" })
</td>
</tr>
</table>

Pagination in MVC4

noreply@blogger.com (Anonymous) — Mon, 07 Apr 2014 07:38:00 +0000

Here I am going to show you how to apply pagination in mvc4. Many time while showing list of items from database there may be situation where you want to show only limited number of items at a time in this situation pagination is used.

To apply pagination in mvc4 you need to download PagedList.mvc package from nuget package manager. To download this follow following steps:

1.open your project and click on Tools menu.
2. Tools --> Library Package Manager --> manage nuget packages for solutions
3.Now choose online as option from left hand side list.
4.And in search box type PagedList.Mvc 
5.Now in search result you will get PackgedList.Mvc 
     and install button click install button.
6. After installation in your project reference two references 
        will be get added. And also PagedList.css added into your content 
        directory.
7.Add following reference on your view and controller to this package
a. using PagedList;
   b. using PagedList.Mvc;

Controller Action:

      public ActionResult Index(int? page )
        {
            return View(db.IrdMasters.ToList().ToPagedList(page ?? 1,2));
        }

In above code I passed nullable reference named page this is necessary in case of first page loading. And also added ToPagedList(page ?? 1,2) here I specified number of record i.e. 3 will be displayed at a time.

View:

@using PagedList;
@using PagedList.Mvc;
@model IPagedList<Distribution.Entities.IrdMaster>
@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_Layout.cshtml";
}
<h2>
    Index</h2>
<p>
    @Html.ActionLink("Create New", "Create")
</p>
<table border="1">
    <tr>
        <th>
            @Html.DisplayNameFor(model => model.First().IrdCode)
        </th>
        <th>
        Edit
        </th>
        <th>
        Details
        </th>
        <th>
        Delete
        </th>
    </tr>
    @foreach (var item in Model)
    {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.IrdCode)
            </td>
            <td>@Html.ActionLink("Edit", "Edit", new { id = item.IrdId })
            </td>
            <td>@Html.ActionLink("Details", "Details", new { id = item.IrdId })
            </td>
            <td>
                @Html.ActionLink("Delete", "Delete", new { id = item.IrdId })
            </td>
        </tr>
    }
</table>

@Html.PagedListPager(Model, Page => Url.Action("Index", new { Page }),
new PagedListRenderOptions {Display=PagedListDisplayMode.IfNeeded, DisplayPageCountAndCurrentLocation=true})

In above code I replaced IEnumerable with IPagedList because here we are giving the only that much record that are set into controller action instead of whole list.

Also I added one html helper at the end after the table that shows the Pagination option at bottom of table that is shown into our view. Here in this helper I specified lots of option like where to redirect(Index Action) and passing current clicked pagination option.

Free SMS sending through ASP.NET

noreply@blogger.com (Anonymous) — Sat, 05 Apr 2014 15:44:00 +0000

Here I developed one web application through which you can send free SMS on any mobile number in India.

Note: Messages will not be delivered if receiver mobile number activated with the DND Service

View of a page: To send SMS you have to follow following steps: 1.Create your account on site2sms.com 2.Now using this account credential create one api key which is used in our code. 3.TO generate API key Click Here 4.Also you need to use ASPSnippets.SmsAPI.dll file add this file into your projects references directory. 5.TO get ASPSnippets.SmsAPI.dll file Click Here

Following code is used for design the page using asp.net

Design smssend.aspx


<form id="form1" runat="server">
    <table border="0">
        <tr>
            <td>
                Your Number:
            </td>
            <td>
                <asp:TextBox ID="txtNumber" runat="server"></asp:TextBox>
            </td>
            <td>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" 
                    runat="server" ErrorMessage="Required"
                    ControlToValidate="txtNumber" ForeColor="Red">
</asp:RequiredFieldValidator>
            </td>
        </tr>
        <tr>
            <td>
                Password:
            </td>
            <td>
                <asp:TextBox ID="txtPassword" TextMode="Password"
                 runat="server"></asp:TextBox>
            </td>
            <td>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator2" 
                          runat="server" ErrorMessage="Required"
                    ControlToValidate="txtPassword" ForeColor="Red">
</asp:RequiredFieldValidator>
            </td>
        </tr>
        <tr>
            <td>
                Recepient Number:
            </td>
            <td>
                <asp:TextBox ID="txtRecepientNumber" 
                          runat="server" Width="300" 
                    ontextchanged="txtRecepientNumber_TextChanged">
            </asp:TextBox>
            </td>
            <td>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator3" 
                   runat="server" ErrorMessage="Required"
                  ControlToValidate="txtRecepientNumber" ForeColor="Red">
              </asp:RequiredFieldValidator>
            </td>
        </tr>
        <tr>
            <td>
                Message:
            </td>
            <td>
                <asp:TextBox ID="txtMessage" runat="server"
                       TextMode="MultiLine"></asp:TextBox>
            </td>
            <td>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator5" 
                runat="server" ErrorMessage="Required"
                ControlToValidate="txtMessage" ForeColor="Red">
              </asp:RequiredFieldValidator>
            </td>
        </tr>
        <tr>
            <td>
            </td>
            <td>
                <asp:Button ID="btnSend" runat="server" 
                     Text="Send" OnClick="btnSend_Click" />
            </td>
            <td>
            </td>
        </tr>
    </table>
    </form>

smssend.aspx.cs

  protected void btnSend_Click(object sender, EventArgs e)
        {
            string s = txtRecepientNumber.Text;

            SMS.APIType = SMSGateway.Site2SMS;
            SMS.MashapeKey = "";
            SMS.Username = txtNumber.Text.Trim();
            SMS.Password = txtPassword.Text.Trim();
            if (s.Trim().IndexOf(",") == -1)
            {
                //Single SMS
               
                SMS.SendSms(s.Trim(), txtMessage.Text.Trim());
            }
            else
            {
                //Multiple SMS
                List numbers = s.Trim().Split(',').ToList();
                foreach (string number in numbers)
                {
                 SMS.SendSms(number, txtMessage.Text.Trim());
                }
            }
        }

In above code add your api key. And also import the file 1. using System.Net; 2. using ASPSnippets.SmsAPI;