Asp.net, MVC, C#,Jquery, Angularjs, WebAPI, HTML,Wcf, SQL: January 2010

28.1.10

sql website

http://www.sqlservercentral.com/Articles/Video

14.1.10

GO
/****** Object: StoredProcedure [dbo].[Mail]
10:16:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[Usp_MailHeadersGetAll]
@MessageType Char(3)='INB'
,@User_FK BIGINT=0
,@Email_FK BIGINT=0
,@datefrom varchar(15)=''
,@dateto varchar(15)=''
,@PageIndex int=1
,@RowsPerPage int=99999
,@HasAttachments Bit=0
,@IsRead bit=0
,@IsUnread bit =0
,@OrderBY smallint=4
,@Order smallint=2

as
BEGIN

Declare @strpaging as nvarchar(4000)
Declare @strqry as nvarchar(4000)

if(len(@MessageType)=3)
BEGIN

--PagingData
set @strpaging = 'SELECT count(header_pk) as ''TotalRecords'''
set @strpaging = @strpaging + ' FROM crm_mail_headers (nolock) INNER JOIN'
set @strpaging = @strpaging + ' crm_Mail_Action (nolock) ON crm_mail_headers.action_fk = crm_Mail_Action.action_pk '
set @strpaging = @strpaging + ' where crm_mail_headers.User_FK ='+ CAST(@User_FK as varchar) +' and crm_mail_headers.Email_FK ='+ CAST(@Email_FK as varchar)
if(@HasAttachments=1)
set @strpaging = @strpaging + ' and crm_mail_headers.HasAttachment =1 '
if(@IsRead=1)
set @strpaging = @strpaging + ' and crm_mail_headers.IsRead =1 '
if(@IsUnread=1)
set @strpaging = @strpaging + ' and crm_mail_headers.IsRead =0 '

if(@MessageType='INB')
set @strpaging = @strpaging + ' and crm_mail_headers.IsInbox =1 '
if(@MessageType='SNT')
set @strpaging = @strpaging + ' and crm_mail_headers.IsSent =1 '
if(@MessageType='DRA')
set @strpaging = @strpaging + ' and crm_mail_headers.IsDraft =1 '
if(@MessageType='SPA')
set @strpaging = @strpaging + ' and crm_mail_headers.IsSpam =1 '
if(@MessageType='TRA')
set @strpaging = @strpaging + ' and crm_mail_headers.IsDeleted =1 '

--ListData

set @strqry = 'SELECT * FROM '
set @strqry = @strqry + ' ( '
set @strqry = @strqry + ' SELECT ROW_NUMBER() OVER(ORDER BY header_pk desc) as RowNum ,header_pk,user_Fk,UniqueId,ReceivedDate,MessageId,HasAttachment,IsBodySaved,IsRead,ActionComment,'
set @strqry = @strqry + ' MessageFrom As Sender,Subject as Sub,action_fk,'
set @strqry = @strqry + ' Case IsRead When 0 then ''Images/new.jpg'' else ''Images/old.gif'' ENd as ''EMailStatus'','
set @strqry = @strqry + ' Case IsRead When 0 then ''''+MessageFrom+'''' else MessageFrom END as ''MessageFrom'','
set @strqry = @strqry + ' Case IsRead When 0 then ''''+isnull(MessageTo,'''')+'''' else isnull(MessageTo,'''') END as ''MessageTo'','
set @strqry = @strqry + ' Case HasAttachment When 1 then ''

'' else '' '' ENd as ''AttchmentStatus'','
set @strqry = @strqry + ' Case IsRead When 0 then ''''+Subject+'''' else Subject END as ''Subject'','
set @strqry = @strqry + ' Case IsRead When 0 then ''''+Action+'''' else Action END as ''Action'''

set @strqry = @strqry + ' FROM crm_mail_headers (nolock) INNER JOIN'
set @strqry = @strqry + ' crm_Mail_Action (nolock) ON crm_mail_headers.action_fk = crm_Mail_Action.action_pk '
set @strqry = @strqry + ' where crm_mail_headers.User_FK ='+ CAST(@User_FK as varchar) +' and crm_mail_headers.Email_FK ='+ CAST(@Email_FK as varchar)
if(@HasAttachments=1)
set @strqry = @strqry + ' and crm_mail_headers.HasAttachment =1 '
if(@IsRead=1)
set @strqry = @strqry + ' and crm_mail_headers.IsRead =1 '
if(@IsUnread=1)
set @strqry = @strqry + ' and crm_mail_headers.IsRead =0 '

if(@MessageType='INB')
set @strqry = @strqry + ' and crm_mail_headers.IsInbox =1 '
if(@MessageType='SNT')
set @strqry = @strqry + ' and crm_mail_headers.IsSent =1 '
if(@MessageType='DRA')
set @strqry = @strqry + ' and crm_mail_headers.IsDraft =1 '
if(@MessageType='SPA')
set @strqry = @strqry + ' and crm_mail_headers.IsSpam =1 '
if(@MessageType='TRA')
set @strqry = @strqry + ' and crm_mail_headers.IsDeleted =1 '

set @strqry = @strqry + ' ) as Mails'

set @strqry = @strqry + ' WHERE RowNum BETWEEN '+ cast(@PageIndex as varchar(100)) +' AND '+ cast( ((@PageIndex + @RowsPerPage) - 1) as varchar(100))
--Order By [Field]
if(@OrderBY=1)
set @strqry = @strqry + ' Order By ReceivedDate '
else if(@OrderBY=2)
set @strqry = @strqry + ' Order By Sender '
else if(@OrderBY=3)
set @strqry = @strqry + ' Order By Sub '
else if(@OrderBY=4)
set @strqry = @strqry + ' Order By ReceivedDate '
else if(@OrderBY=5)
set @strqry = @strqry + ' Order By Action '
else
set @strqry = @strqry + ' Order By header_pk '

--- OrderBy

if(@Order=1)
set @strqry = @strqry + ' ASC'
if(@Order=2)
set @strqry = @strqry + ' DESC'

END

EXECUTE sp_executesql @strpaging
EXECUTE sp_executesql @strqry
-- select @strqry

END

Useful c#

classes,Overloading,Properties::

http://www.codeguru.com/csharp/csharp/cs_syntax/anandctutorials/article.php/c5829
=====================================================================================

Properties in c#:

http://www.devarticles.com/c/a/C-Sharp/Understanding-Properties-in-C-Sharp/

==============================================================================
http://www.devarticles.com/c/a/C-Sharp/Inheritance-and-Polymorphism/
http://www.devarticles.com/c/a/C-Sharp/Introduction-to-Objects-and-Classes-in-C-sharp/6/

http://www.sitepoint.com/article/dataset-datareader/

=========
Convert a DataReader to DataTable in ASP.NET

http://www.dotnetcurry.com/ShowArticle.aspx?ID=143

===========
Static Method::
http://forums.asp.net/t/1445372.aspx

Static CLass:;
http://msdn.microsoft.com/en-us/library/79b3xss3(VS.80).aspx

===========

abstract"

http://www.javacoffeebreak.com/faq/faq0084.html
================
difference between abstract class and interface::

http://www.codeproject.com/KB/cs/abstractsvsinterfaces.aspx

========================

Facebook asp.net

Event Master:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using Facebook.Rest;
using Facebook.Schema;
using Facebook.Session;
using Facebook.Utility;

public partial class EventMaster : System.Web.UI.MasterPage
{
private const string FACEBOOK_API_KEY = "d768a2201d05348eef79b3dfcded6e8c";
private const string FACEBOOK_SECRET = "30efc267bdf2f8675a33d3920129dfbc";
private Api FacebookAPI;
private ConnectSession ConnectSession;

protected void Page_Load(object sender, EventArgs e)
{
ConnectSession = new ConnectSession(FACEBOOK_API_KEY, FACEBOOK_SECRET);
}
protected void lnkEventPermission_Click(object sender, EventArgs e)
{
Response.Redirect(string.Format("http://www.facebook.com/authorize.php?api_key={0}&v=1.0&ext_perm={1}", "d768a2201d05348eef79b3dfcded6e8c", Enums.ExtendedPermissions.create_event));
}
}
====================================

create Event:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Facebook.Rest;
using Facebook.Schema;
using Facebook.Session;
using Facebook.Utility;

public partial class CreateEvent : System.Web.UI.Page
{
private const string FACEBOOK_API_KEY = "d768a2201d05348eef79b3dfcded6e8c";
private const string FACEBOOK_SECRET = "30efc267bdf2f8675a33d3920129dfbc";
private Api FacebookAPI;
private ConnectSession ConnectSession;

protected void Page_Load(object sender, EventArgs e)
{
ConnectSession = new ConnectSession(FACEBOOK_API_KEY, FACEBOOK_SECRET);
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
try
{
DateTime CurrentDate = System.DateTime.Now;
DateTime ChkStartDate = Convert.ToDateTime(txtStartDate.Text);
if (ChkStartDate < CurrentDate)
{
lblMsg.Text = "Start date Should be greater than or eqaual to current date";
return;
}

lblMsg.Text = txtEndDate.Text;
FacebookAPI = new Api(ConnectSession);
DateTime StartDate = new DateTime();
StartDate = Convert.ToDateTime(txtStartDate.Text);
DateTime EndDate = new DateTime();
EndDate = Convert.ToDateTime(txtEndDate.Text);
var NewEvent = new facebookevent
{
name = txtname.Text,
description = txtdescription.Text,
location = txtLocation.Text,
host = txtHost.Text,
event_type = txtType.Text,
event_subtype = txtSubType.Text

};
//AddHours(8) is in below line because of the difference in time between my server and Facebook server you can adjust it as per requirement.
NewEvent.start_time = DateHelper.ConvertDateToFacebookDate(new DateTime(StartDate.Year, StartDate.Month, StartDate.Day, Convert.ToInt32(drpStartSession.SelectedItem.Value) + Convert.ToInt32(drpStartTime.SelectedItem.Value) , Convert.ToInt32(DrpMinuteStart.SelectedItem.Value), 0).AddHours(8));
NewEvent.end_time = DateHelper.ConvertDateToFacebookDate(new DateTime(EndDate.Year, EndDate.Month, EndDate.Day, Convert.ToInt32(drpEndSession.SelectedItem.Value) + Convert.ToInt32(drpEndTime.SelectedItem.Value) , Convert.ToInt32(drpMinuteEnd.SelectedItem.Value), 0).AddHours(8));

long NewEventId = FacebookAPI.Events.Create(NewEvent);
lblMsg.Text = string.Format("Event ({0}) Created Successfully.", NewEventId);
}
catch (Exception err)
{
lblMsg.Text = err.Message;
}

}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
txtEndDate.Text = "";
txtdescription.Text = "";
txtHost.Text = "";
txtLocation.Text = "";
txtname.Text = "";
txtStartDate.Text = "";
txtSubType.Text = "";
txtType.Text = "";
}
protected void imgBack_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("Default.aspx");
}
}
=======================================
edit Event:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using Facebook.Rest;
using Facebook.Schema;
using Facebook.Session;
using Facebook.Utility;
using System.Collections;

public partial class EditEvent : System.Web.UI.Page
{
private const string FACEBOOK_API_KEY = "d768a2201d05348eef79b3dfcded6e8c";
private const string FACEBOOK_SECRET = "30efc267bdf2f8675a33d3920129dfbc";
private Api FacebookAPI;
long EventId;
private ConnectSession ConnectSession;
protected void Page_Load(object sender, EventArgs e)
{

ConnectSession = new ConnectSession(FACEBOOK_API_KEY, FACEBOOK_SECRET);
if (!IsPostBack)
{
//Function to get information about the current information about selected event for editing
GetEventAsperEid();
}
}

private void GetEventAsperEid()
{
try
{
Hashtable EventInfo = new Hashtable();
EventInfo = (Hashtable)(Session["SesEventInfo"]);
lbEid.Text = EventInfo["EventId"].ToString();
lblname.Text = EventInfo["Name"].ToString();
txtStartDate.Text = EventInfo["StartTime"].ToString();
txtEndDate.Text = EventInfo["EndTime"].ToString();
txtdescription.Text = EventInfo["Description"].ToString();
txtLocation.Text = EventInfo["Location"].ToString();
txtHost.Text = EventInfo["Host"].ToString();
}
catch
{
}
}
protected void imgCreate_Click(object sender, ImageClickEventArgs e)
{
try
{
DateTime CurrentDate = System.DateTime.Now;
DateTime ChkStartDate = Convert.ToDateTime(txtStartDate.Text);
if (ChkStartDate < CurrentDate)
{
lblMsg.Text = "Start date Should be greater than or eqaual to current date";
return;
}

Hashtable EventInfo = new Hashtable();
EventInfo = (Hashtable)(Session["SesEventInfo"]);
EventId = Convert.ToInt64(EventInfo["EventId"].ToString());
FacebookAPI = new Api(ConnectSession);
DateTime StartDate = new DateTime();
StartDate = Convert.ToDateTime(txtStartDate.Text);
DateTime EndDate = new DateTime();
EndDate = Convert.ToDateTime(txtEndDate.Text);
var NewEvent = new facebookevent
{
name = lblname.Text,
description = txtdescription.Text,
location = txtLocation.Text,
host = txtHost.Text,
event_type = txtType.Text,
event_subtype = txtSubType.Text
};
//AddHours(8) is in below line because of the difference in time between my server and Facebook server you can adjust it as per requirement.
NewEvent.start_time = DateHelper.ConvertDateToFacebookDate(new DateTime(StartDate.Year, StartDate.Month, StartDate.Day, Convert.ToInt32(drpStartSession.SelectedItem.Value)+ Convert.ToInt32( drpStartTime.SelectedItem.Value), Convert.ToInt32(DrpMinuteStart.SelectedItem.Value), 0).AddHours(8));
NewEvent.end_time = DateHelper.ConvertDateToFacebookDate(new DateTime(EndDate.Year, EndDate.Month, EndDate.Day, Convert.ToInt32(drpEndSession.SelectedItem.Value) + Convert.ToInt32(drpEndTime.SelectedItem.Value), Convert.ToInt32(drpMinuteEnd.SelectedItem.Value), 0).AddHours(8));

bool NewEventId = FacebookAPI.Events.Edit(EventId, NewEvent);
lblMsg.Text = string.Format("Event ({0}) Updated Successfully.", NewEventId);
}
catch (Exception err)
{
lblMsg.Text = err.Message;
}
}
protected void imgRefresh_Click(object sender, ImageClickEventArgs e)
{
lbEid.Text = "";
txtEndDate.Text = "";
txtdescription.Text = "";
txtHost.Text = "";
txtLocation.Text = "";
lblname.Text = "";
txtStartDate.Text = "";
txtSubType.Text = "";
txtType.Text = "";
}
protected void imgBack_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("Default.aspx");
}
}

=======================================

Default page:;

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Collections;
using Facebook;
using Facebook.Rest;
using Facebook.Schema;
using Facebook.Session;
using Facebook.Utility;

public partial class Default : Facebook.Web.CanvasFBMLBasePage
{

private const string FACEBOOK_API_KEY = "d768a2201d05348eef79b3dfcded6e8c";
private const string FACEBOOK_SECRET = "30efc267bdf2f8675a33d3920129dfbc";
private Api FacebookAPI;
user FaceBookUser;
string AuthToken;
private ConnectSession ConnectSession;
protected void Page_Load(object sender, EventArgs e)
{
ConnectSession = new ConnectSession(FACEBOOK_API_KEY, FACEBOOK_SECRET);
AuthToken = Request.QueryString["auth_token"];
if (String.IsNullOrEmpty(AuthToken))
{
Response.Redirect(@"http://www.Facebook.com/login.php?api_key=" + "d768a2201d05348eef79b3dfcded6e8c" + @"&v=0.4\");
}
else
{
try
{
FacebookAPI = new Api(ConnectSession);

if (!IsPostBack)
{
//Functoin to get current user information.
FaceBookCurrentUser();
//Function to get events
FaceBookEvents();
//Function to get friend list
FacebookFriends();
}
}
catch(Exception err)
{
lblMessage.Text = "Please click connect button.";
}
}
}

private void FaceBookCurrentUser()
{
long uid = FacebookAPI.Users.GetLoggedInUser();
FaceBookUser = FacebookAPI.Users.GetInfo(uid);
lblUserFName.Text = FaceBookUser.first_name;
lblUserLName.Text = FaceBookUser.last_name;
lblDob.Text = FaceBookUser.birthday;
}
private void FaceBookEvents()
{
List LstPrpEventObj = new List();
IList EventList = FacebookAPI.Events.Get();
int i = 1;
foreach (facebookevent EventInList in EventList)
{
prpEvents ObjPrpevents = new prpEvents();
ObjPrpevents.EventId = EventInList.eid;
ObjPrpevents.EventNo = i.ToString();
ObjPrpevents.Name = EventInList.name.ToString();
ObjPrpevents.StartDate = EventInList.start_date.ToString();
ObjPrpevents.StartTime = DateHelper.ConvertUnixTimeToDateTime(EventInList.start_time).ToString();
ObjPrpevents.EndTime = DateHelper.ConvertUnixTimeToDateTime(EventInList.end_time).ToString();
ObjPrpevents.EndDate = EventInList.end_date.ToString();
ObjPrpevents.Description = EventInList.description.ToString();
ObjPrpevents.Location = EventInList.location.ToString();
ObjPrpevents.Host = EventInList.host.ToString();
i++;
LstPrpEventObj.Add(ObjPrpevents);
}
GrdEvent.DataSource = LstPrpEventObj;
GrdEvent.DataBind();
}
private void FacebookFriends()
{
IList MyFriendList = FacebookAPI.Friends.GetUserObjects();
List LstPrpFriendsObj = new List();
foreach (var Friend in MyFriendList)
{
prpfriends ObjPrpFriends = new prpfriends();
ObjPrpFriends.Dob = Friend.birthday;
ObjPrpFriends.Name = Friend.name;
ObjPrpFriends.RelationshipStatus = Friend.relationship_status;
ObjPrpFriends.Sex = Friend.sex;
LstPrpFriendsObj.Add(ObjPrpFriends);
}
rptrFriends.DataSource = LstPrpFriendsObj;
rptrFriends.DataBind();
lblrptrfriendsCount.Text = rptrFriends.Items.Count.ToString();
}
protected void GrdEvent_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
GrdEvent.PageIndex = e.NewPageIndex;
FaceBookEvents();
}
catch (Exception err)
{
lblMessage.Text = err.Message;
}
}
protected void btnCreateEvent_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("CreateEvent.aspx");
}
protected void GrdEvent_SelectedIndexChanged(object sender, EventArgs e)
{
long EventId = Convert.ToInt64(GrdEvent.SelectedDataKey.Value);
try
{
List LstEid = new List();
LstEid.Add(EventId);
IList EventList = FacebookAPI.Events.Get(LstEid);
//selected event Information saved in session "SesEventInfo" to get it on edit page.
foreach (facebookevent EventInList in EventList)
{
string[] StrStartTime = DateHelper.ConvertUnixTimeToDateTime(EventInList.start_time).ToString().Split(' ');
string[] StrEndTime = DateHelper.ConvertUnixTimeToDateTime(EventInList.end_time).ToString().Split(' ');
Hashtable EventInfo = new Hashtable();
EventInfo.Add("EventId", EventId);
EventInfo.Add("Name", EventInList.name);
EventInfo.Add("StartTime", StrStartTime[0].ToString());
EventInfo.Add("EndTime", StrEndTime[0].ToString());
EventInfo.Add("Description", EventInList.description.ToString());
EventInfo.Add("Location", EventInList.location.ToString());
EventInfo.Add("Host", EventInList.host.ToString());
Session["SesEventInfo"] = EventInfo;
}
}
catch (Exception err)
{
lblMessage.Text = err.Message;
}

Response.Redirect("EditEvent.aspx?Eid=" + EventId );
}
protected void GrdEvent_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
long EventId = Convert.ToInt64(GrdEvent.DataKeys[e.RowIndex].Value);
FacebookAPI.Events.Cancel(EventId, "Cancel this message");
lblMessage.Text = "Event Canceled";
FaceBookEvents();
}
catch
{
}
}
}
//Property class for "FacebookFriends" function.
public class prpfriends
{
private String prpName, prpDob, prpRelationshipStatus,prpSex;
public string Name
{
get
{
return prpName;
}
set
{
prpName = value;
}
}
public string Dob
{
get
{
return prpDob;
}
set
{
prpDob = value;
}
}

public string RelationshipStatus
{
get
{
return prpRelationshipStatus;
}
set
{
prpRelationshipStatus = value;
}
}
public string Sex
{
get
{
return prpSex;
}
set
{
prpSex = value;
}
}
}
//Property class for "FaceBookEvents" function.
public class prpEvents
{
private String prpName, prpHost, prpStartDate, prpStartTime, prpEndDate, prpEndTime, prpEventNo, prpDescription,prpLocation;
private long prpEventId;
public long EventId
{
get
{
return prpEventId;
}
set
{
prpEventId = value;
}
}
public string EventNo
{
get
{
return prpEventNo;
}
set
{
prpEventNo = value;
}
}
public string Name
{
get
{
return prpName;
}
set
{
prpName = value;
}
}
public string Host
{
get
{
return prpHost;
}
set
{
prpHost = value;
}
}

public string StartDate
{
get
{
return prpStartDate;
}
set
{
prpStartDate = value;
}
}
public string StartTime
{
get
{
return prpStartTime;
}
set
{
prpStartTime = value;
}
}
public string EndDate
{
get
{
return prpEndDate;
}
set
{
prpEndDate = value;
}
}
public string EndTime
{
get
{
return prpEndTime;
}
set
{
prpEndTime = value;
}
}
public string Description
{
get
{
return prpDescription;
}
set
{
prpDescription = value;
}
}
public string Location
{
get
{
return prpLocation;
}
set
{
prpLocation = value;
}
}
}

Login BOL ,BLL, DAL with application block

1.)BOL

using System;

namespace Customer.Login
{
public class LoggedInUser
{
String _Regi_PK, _ITR_PK;
String _User_Name;
String _PrefferredName;
String _EmailAddress;
String _Address, _SSN;
Boolean _IsJointStatement,_HaveDependents,_IsLocked;
Int16 _Step ;
String _Year;
Int32 _NewMessages;

public String Regi_PK
{
get { return _Regi_PK; }
set { _Regi_PK = value; }
}
public String ITR_PK
{
get { return _ITR_PK; }
set { _ITR_PK = value; }
}
public String User_Name
{
get { return _User_Name; }
set { _User_Name = value; }
}
public String PrefferredName
{
get { return _PrefferredName; }
set { _PrefferredName = value; }
}
public String EmailAddress
{
get { return _EmailAddress; }
set { _EmailAddress = value; }
}
public String Address
{
get { return _Address; }
set { _Address = value; }
}

public String SSN
{
get { return _SSN; }
set { _SSN = value; }
}

public String Year
{
get { return _Year; }
set { _Year = value; }
}

public Boolean IsJointStatement
{
get { return _IsJointStatement; }
set { _IsJointStatement = value; }
}

public Boolean HaveDependents
{
get { return _HaveDependents; }
set { _HaveDependents = value; }
}
public Boolean IsLocked
{
get { return _IsLocked; }
set { _IsLocked = value; }
}

public Int16 Step
{
get { return _Step; }
set { _Step = value; }
}

public Int32 NewMessages
{
get { return _NewMessages; }
set { _NewMessages = value; }
}

public LoggedInUser(String Regi_PK, String ITR_PK, String User_Name, String EmailAddress, String Address, String PreferredName)
{
this.Regi_PK = Regi_PK;
this.ITR_PK = ITR_PK;
this.User_Name = User_Name;
this.PrefferredName = PreferredName;
this.EmailAddress = EmailAddress;
this.Address = Address;
this.SSN = "";
this.NewMessages = 0;
this.Step = 0;
this.Year = "All";

}
public LoggedInUser(String Regi_PK, String ITR_PK, String User_Name, String EmailAddress, String Address, String SSN, String PreferredName,Int32 NewMessages)
{
this.Regi_PK = Regi_PK;
this.ITR_PK = ITR_PK;
this.User_Name = User_Name;
this.PrefferredName = PreferredName;
this.EmailAddress = EmailAddress;
this.Address = Address;
this.SSN = SSN;
this.NewMessages = NewMessages;
this.Step = 0;
this.Year = "All";
}

}

}

2.)BLL

using System;
using System.Collections.Generic;

namespace Customer.Login
{
public class LoginBOL : LoginDAL
{
String _LoginMessage;
public String LoginMessage
{
get { return _LoginMessage; }
set { _LoginMessage = value; }
}

public LoggedInUser UpdatePassword(String Regi_PK, String Email, String Pwd, String NewPwd)
{
String Message = "";
String Regi_Id = "";
String FullName = "";
String Address = "";
String ITR_PK = "";
String PreferredName="";

base.UpdatePassword(Regi_PK, Email, Pwd, NewPwd, out Message, out Regi_Id, out ITR_PK, out FullName, out Address, out PreferredName);
this.LoginMessage = Message;
return new LoggedInUser(Regi_Id, ITR_PK, FullName, Email, Address, PreferredName);

}
public LoggedInUser ValidateUser(String Email, String Pwd)
{
String Message = "";
String Regi_Id = "";
String FullName = "";
String Address = "";
String SSN = "";
String ITR_PK = "";
String PreferredName = "";
Int32 NewEmails = 0;
base.ValidateUser(Email, Pwd, out Message, out Regi_Id, out FullName, out Address, out SSN, out PreferredName, out NewEmails);
this.LoginMessage = Message;
return new LoggedInUser(Regi_Id, ITR_PK, FullName, Email, Address, SSN, PreferredName, NewEmails);

}

public void ChangePassword(String Regi_PK, String Email, String Pwd, String NewPwd)
{
String Message = "";
base.ChangePassword(Regi_PK, Email, Pwd, NewPwd, out Message);
this.LoginMessage = Message;

}

public LoggedInUser ForgotPassword(String Email)
{
String Message = "";
String Regi_Id = "";
String ITR_PK = "";
String FullName = "";
String Password = "";
String SSN = "";
String PreferredName = "";
base.ForgotPassword(Email, out Message, out Regi_Id, out FullName, out Password, out PreferredName);

this.LoginMessage = Message;
return new LoggedInUser(Regi_Id, ITR_PK,FullName, Email, Password, PreferredName);

}

}
}

3.)DAL

using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

namespace Customer.Login
{
public class LoginDAL : AppConfig
{
protected void UpdatePassword(String Regi_PK, String Email, String Pwd, String NewPwd, out String Message, out String Regi_Id, out String ITR_PK, out String FullName, out String Address, out String PreferredName)
{
SqlParameter[] Param;
Param = new SqlParameter[11];
Param[0] = new SqlParameter("@Flag", SqlDbType.SmallInt);
Param[0].Value = 1;
Param[1] = new SqlParameter("@Regi_PK", SqlDbType.NVarChar);
Param[1].Value = Regi_PK;
Param[2] = new SqlParameter("@UserName", SqlDbType.NVarChar);
Param[2].Value = Email;
Param[3] = new SqlParameter("@Password", SqlDbType.NVarChar);
Param[3].Value = Pwd;
Param[4] = new SqlParameter("@NewPassword", SqlDbType.NVarChar);
Param[4].Value = NewPwd;
Param[5] = new SqlParameter("@ITR_PK", SqlDbType.NVarChar, 36);
Param[5].Direction = ParameterDirection.Output;
Param[6] = new SqlParameter("@Regi_Id", SqlDbType.NVarChar, 36);
Param[6].Direction = ParameterDirection.Output;
Param[7] = new SqlParameter("@fullName", SqlDbType.NVarChar, 500);
Param[7].Direction = ParameterDirection.Output;
Param[8] = new SqlParameter("@Address", SqlDbType.NVarChar, 500);
Param[8].Direction = ParameterDirection.Output;
Param[9] = new SqlParameter("@msgout", SqlDbType.NVarChar, 100);
Param[9].Direction = ParameterDirection.Output;
Param[10] = new SqlParameter("@preferred", SqlDbType.NVarChar, 200);
Param[10].Direction = ParameterDirection.Output;

SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "usp_Customer_ValidateUser", Param);
Message = Param[9].Value.ToString();
if (Message == "OK")
{
ITR_PK = Param[5].Value.ToString();
Regi_Id = Param[6].Value.ToString();
FullName = Param[7].Value.ToString();
Address = Param[8].Value.ToString();
PreferredName = Param[10].Value.ToString();
}
else
{
ITR_PK = String.Empty;
Regi_Id = String.Empty;
FullName = String.Empty;
Address = String.Empty;
PreferredName = String.Empty;

}

}
protected void ValidateUser(String Email, String Pwd, out String Message, out String Regi_Id, out String FullName, out String Address, out String SSN, out String PreferredName, out Int32 NewMessages)
{
SqlParameter[] Param;
Param = new SqlParameter[12];
Param[0] = new SqlParameter("@Flag", SqlDbType.SmallInt);
Param[0].Value = 4;
Param[1] = new SqlParameter("@Regi_PK", SqlDbType.NVarChar);
Param[1].Value = String.Empty;
Param[2] = new SqlParameter("@UserName", SqlDbType.NVarChar);
Param[2].Value = Email;
Param[3] = new SqlParameter("@Password", SqlDbType.NVarChar);
Param[3].Value = Pwd;
Param[4] = new SqlParameter("@NewPassword", SqlDbType.NVarChar);
Param[4].Value = String.Empty;
Param[5] = new SqlParameter("@Regi_Id", SqlDbType.NVarChar, 36);
Param[5].Direction = ParameterDirection.Output;
Param[6] = new SqlParameter("@fullName", SqlDbType.NVarChar, 500);
Param[6].Direction = ParameterDirection.Output;
Param[7] = new SqlParameter("@Address", SqlDbType.NVarChar, 500);
Param[7].Direction = ParameterDirection.Output;
Param[8] = new SqlParameter("@msgout", SqlDbType.NVarChar, 100);
Param[8].Direction = ParameterDirection.Output;

Param[9] = new SqlParameter("@SSN", SqlDbType.NVarChar, 100);
Param[9].Direction = ParameterDirection.Output;

Param[10] = new SqlParameter("@preferred", SqlDbType.NVarChar, 200);
Param[10].Direction = ParameterDirection.Output;

Param[11] = new SqlParameter("@newMessages", SqlDbType.Int);
Param[11].Direction = ParameterDirection.Output;

SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "usp_Customer_ValidateUser", Param);
Message = Param[8].Value.ToString();
if (Message == "OK")
{

Regi_Id = Param[5].Value.ToString();
FullName = Param[6].Value.ToString();
Address = Param[7].Value.ToString();
PreferredName = Param[10].Value.ToString();
try
{
SSN = Convert.ToInt64(Param[9].Value).ToString("###-##-####");

}
catch
{
SSN = String.Empty;

}
NewMessages = Convert.ToInt32(Param[11].Value);
}
else
{
Regi_Id = String.Empty;
FullName = String.Empty;
Address = String.Empty;
SSN = String.Empty;
PreferredName = String.Empty;
NewMessages = 0;
}

}
protected void ChangePassword(String Regi_PK, String Email, String Pwd, String NewPwd, out String Message)
{
SqlParameter[] Param;
Param = new SqlParameter[6];
Param[0] = new SqlParameter("@Flag", SqlDbType.SmallInt);
Param[0].Value = 2;
Param[1] = new SqlParameter("@Regi_PK", SqlDbType.NVarChar);
Param[1].Value = Regi_PK;
Param[2] = new SqlParameter("@UserName", SqlDbType.NVarChar);
Param[2].Value = Email;
Param[3] = new SqlParameter("@Password", SqlDbType.NVarChar);
Param[3].Value = Pwd;
Param[4] = new SqlParameter("@NewPassword", SqlDbType.NVarChar);
Param[4].Value = NewPwd;
Param[5] = new SqlParameter("@msgout", SqlDbType.NVarChar, 100);
Param[5].Direction = ParameterDirection.Output;

SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "usp_Customer_ValidateUser", Param);
Message = Param[5].Value.ToString();

}
protected void ForgotPassword(String Email, out String Message, out String Regi_Id, out String FullName, out String Password, out String PreferredName)
{
SqlParameter[] Param;
Param = new SqlParameter[7];
Param[0] = new SqlParameter("@Flag", SqlDbType.SmallInt);
Param[0].Value = 3;
Param[1] = new SqlParameter("@UserName", SqlDbType.NVarChar);
Param[1].Value = Email;
Param[2] = new SqlParameter("@Regi_Id", SqlDbType.NVarChar, 36);
Param[2].Direction = ParameterDirection.Output;
Param[3] = new SqlParameter("@fullName", SqlDbType.NVarChar, 500);
Param[3].Direction = ParameterDirection.Output;
Param[4] = new SqlParameter("@Address", SqlDbType.NVarChar, 500);
Param[4].Direction = ParameterDirection.Output;
Param[5] = new SqlParameter("@msgout", SqlDbType.NVarChar, 100);
Param[5].Direction = ParameterDirection.Output;
Param[6] = new SqlParameter("@preferred", SqlDbType.NVarChar, 200);
Param[6].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "usp_Customer_ValidateUser", Param);
Message = Param[5].Value.ToString();

if (Message == "OK")
{
Regi_Id = Param[2].Value.ToString();
FullName = Param[3].Value.ToString();
Password = Param[4].Value.ToString();
PreferredName = Param[5].Value.ToString();
}
else
{
Regi_Id = String.Empty;
FullName = String.Empty;
Password = String.Empty;
PreferredName = String.Empty;
}
}
}
}

Required field validator on checkbox

==============================================================================
CssClass="MenuButtonlink" ValidationGroup="Save" OnClick="btnSave_Click"
OnClientClick="return Check();" />

===============================================================================

http://alvinzc.blogspot.com/2006/10/aspnet-requiredfieldvalidator.html

Google Checkout code

window.parent.document.getElementById('lblPageHead').innerHTML = '<% =page_title %>'
function ClToolTip() {

var tooltip1 = $find("<%=RadDependent.ClientID%>");
tooltip1.hide();

}
==========================
gc notification:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gc_notification.aspx.cs"
Inherits="customer_gc_notification" %>

Untitled Page

=============
using System;
using System.Collections;
using System.Web;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using GCheckout;
using GCheckout.AutoGen;
using GCheckout.Util;
using GCheckout.OrderProcessing;
using Customer.order;
using System.IO;
using emailclient;
using settings.templates;
public partial class customer_gc_notification : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GetNotification();
}

}
private void GetNotification()
{
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
string RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
OrderBOL objBll;
Orders objBol;
switch (EncodeHelper.GetTopElement(RequestXml))
{
case "new-order-notification":
NewOrderNotification objNewOrd = (NewOrderNotification)EncodeHelper.Deserialize(RequestXml, typeof(NewOrderNotification));
objBll = new OrderBOL();
objBol = new Orders();
objBol.Googleorder_id = objNewOrd.googleordernumber;
objBol.Customer_Id = objNewOrd.buyerid.ToString();
objBol.CustomerName = objNewOrd.buyerbillingaddress.contactname.ToString();
objBol.BillingName = objNewOrd.buyerbillingaddress.contactname.ToString();
objBol.BillingCompanyName = objNewOrd.buyerbillingaddress.companyname.ToString();
objBol.BillingEmail = objNewOrd.buyerbillingaddress.email.ToString();
objBol.BillingPhone = objNewOrd.buyerbillingaddress.phone.ToString();
objBol.BillingFax = objNewOrd.buyerbillingaddress.fax.ToString();
objBol.BillingAddress1 = objNewOrd.buyerbillingaddress.address1.ToString();
objBol.BillingAddress2 = objNewOrd.buyerbillingaddress.address2.ToString();
objBol.BillingCity = objNewOrd.buyerbillingaddress.city.ToString();
objBol.BillingCountry = objNewOrd.buyerbillingaddress.countrycode.ToString();
objBol.BillingRegion = objNewOrd.buyerbillingaddress.region.ToString();
objBol.BillingPostalCode = objNewOrd.buyerbillingaddress.postalcode.ToString();
objBol.OrderTotal = Convert.ToDecimal(objNewOrd.ordertotal.Value);
objBol.UpdatedDate = Convert.ToDateTime(objNewOrd.timestamp);
objBol.Status = false;
objBol.Discount = 0;
objBol.DiscountType = "Discount";
objBol.advertiser_fk = 0;
objBol.Tax = 0;
foreach (Item ThisItem in objNewOrd.shoppingcart.items)
{
if (ThisItem.unitprice.Value > 0)
{
Order_Item objItem = new Order_Item();
objItem.Name = ThisItem.itemname;
objItem.quantity = ThisItem.quantity;
objItem.Price = ThisItem.unitprice.Value;
objItem.Googleorder_id = objBol.Googleorder_id;
string[] st = ThisItem.itemdescription.Split(',');
objBol.Itr_Fk = st[0];
objItem.RetrunDocId =Convert .ToInt64 ( st[1]);
objItem.Service_fk = Convert.ToInt16(st[2]);
hdnItrId.Value = objBol.Itr_Fk;
hdnReturnId.Value = objItem.RetrunDocId.ToString();
objBll.save_Orders_Items(objItem);
objItem = null;

}
else
{
//Use This area for save discount
objBol.DiscountType = ThisItem.itemname.ToString();
objBol.Discount = Convert.ToDecimal(ThisItem.unitprice.Value);
objBol.advertiser_fk = Convert.ToInt16(ThisItem.itemdescription);
}
}
string retval= objBll.save_Orders(objBol);
SendMail(objBol, retval);
objBol = null;
objBll = null;
break;
case "risk-information-notification":
objBll = new OrderBOL();
objBol = new Orders();
RiskInformationNotification objNewOrd1 = (RiskInformationNotification)EncodeHelper.Deserialize(RequestXml, typeof(RiskInformationNotification));
// This notification tells us that Google has authorized the order and it has passed the fraud check.
// Use the data below to determine if you want to accept the order, then start processing it.
objBol.Googleorder_id = objNewOrd1.googleordernumber;
objBol.AVS = objNewOrd1.riskinformation.avsresponse;
objBol.CVN = objNewOrd1.riskinformation.cvnresponse;
bool SellerProtection = objNewOrd1.riskinformation.eligibleforprotection;
objBol.Status = false;
objBol.charge_amount = 0;
objBll.UpdateOrderStatus(objBol);
objBol = null;
objBll = null;
break;
case "order-state-change-notification":
OrderStateChangeNotification N3 = (OrderStateChangeNotification)EncodeHelper.Deserialize(RequestXml, typeof(OrderStateChangeNotification));
// The order has changed either financial or fulfillment state in Google's system.
string OrderNumber3 = N3.googleordernumber;
string NewFinanceState = N3.newfinancialorderstate.ToString();
string NewFulfillmentState = N3.newfulfillmentorderstate.ToString();
string PrevFinanceState = N3.previousfinancialorderstate.ToString();
string PrevFulfillmentState = N3.previousfulfillmentorderstate.ToString();
break;
case "charge-amount-notification":
objBll = new OrderBOL();
objBol = new Orders();
ChargeAmountNotification objNewOrd3 = (ChargeAmountNotification)EncodeHelper.Deserialize(RequestXml, typeof(ChargeAmountNotification));
// Google has successfully charged the customer's credit card.
objBol.Googleorder_id = objNewOrd3.googleordernumber;
objBol.Status = true;
objBol.CVN = "";
objBol.AVS = "";

decimal ChargedAmount = objNewOrd3.latestchargeamount.Value;
objBol.charge_amount = ChargedAmount;
objBll.UpdateOrderStatus(objBol);
objBll = null;
objBol = null;
break;
case "refund-amount-notification":
RefundAmountNotification N5 = (RefundAmountNotification)EncodeHelper.Deserialize(RequestXml, typeof(RefundAmountNotification));
// Google has successfully refunded the customer's credit card.
string OrderNumber5 = N5.googleordernumber;
decimal RefundedAmount = N5.latestrefundamount.Value;
break;
case "chargeback-amount-notification":
ChargebackAmountNotification N6 = (ChargebackAmountNotification)EncodeHelper.Deserialize(RequestXml, typeof(ChargebackAmountNotification));
// A customer initiated a chargeback with his credit card company to get her money back.
string OrderNumber6 = N6.googleordernumber;
decimal ChargebackAmount = N6.latestchargebackamount.Value;
break;
}

}
#region Mail Sent
public void SendMail(Orders objOrder,string EmailAddress)
{
try
{
TemplateManager objTemp = new TemplateManager();
string emailfromName, emailfromId, emailpassword, emailSubject, body;
objTemp.TemplateType = "CUST_ORD";
objTemp = objTemp.fnDisplaySaleTemplateById(objTemp);
emailfromName = objTemp.FromName;
emailfromId = objTemp.FromEmail;
emailpassword = objTemp.Password;
emailSubject = objTemp.TemplateSubject;
body = objTemp.TemplateBody;
body = body.Replace("[Title]", "");
body = body.Replace("[FirstName]", objOrder.CustomerName);
body = body.Replace("[MiddleName]", "");
body = body.Replace("[LastName]", "");
body = body.Replace("[Address]", objOrder.BillingAddress1 + objOrder.BillingAddress2);
body = body.Replace("[City]", objOrder.BillingCity);
body = body.Replace("[State]", "");
body = body.Replace("[Country]", objOrder.BillingCountry);
body = body.Replace("[ZipCode]", objOrder.BillingPostalCode);
body = body.Replace("[Email]", objOrder.BillingEmail);
body = body.Replace("[MobilePhone]", "");
body = body.Replace("[Phone]", objOrder.BillingPhone);
#region Sent Mail

smtpsettings objsmtpsettings = new smtpsettings(objTemp.OutMail[0].OutMailServer, Convert.ToInt32(objTemp.OutMail[0].OutMailPort), emailfromId, emailpassword, true);
SMTPClient objSMTPClient = new SMTPClient(objsmtpsettings);
objSMTPClient.Recepients = EmailAddress;
if (!string.IsNullOrEmpty(objTemp.BCCEmail))
{
objSMTPClient.BCC = objTemp.BCCEmail;
}
if (!string.IsNullOrEmpty(objTemp.CCEmail))
{
objSMTPClient.CC = objTemp.CCEmail;
}
objSMTPClient.SenderName = emailfromName;
objSMTPClient.Subject = emailSubject;
objSMTPClient.Content = body;
objSMTPClient.SendMessage(objSMTPClient);
objsmtpsettings = null;
objSMTPClient = null;
#endregion
SendAdminMail(objOrder);
}
catch
{
}

}
public void SendAdminMail(Orders objOrder)
{
try
{
TemplateManager objTemp = new TemplateManager();
string emailfromName, emailfromId, emailpassword, emailSubject, body;
objTemp.TemplateType = "ADM_ORD";
objTemp = objTemp.fnDisplaySaleTemplateById(objTemp);
emailfromName = objTemp.FromName;
emailfromId = objTemp.FromEmail;
emailpassword = objTemp.Password;
emailSubject = objTemp.TemplateSubject;
body = objTemp.TemplateBody;
body = body.Replace("[Title]", "");
body = body.Replace("[FirstName]", objOrder.CustomerName);
body = body.Replace("[MiddleName]", "");
body = body.Replace("[LastName]", "");
body = body.Replace("[Address]", objOrder.BillingAddress1 + objOrder.BillingAddress2);
body = body.Replace("[City]", objOrder.BillingCity);
body = body.Replace("[State]", "");
body = body.Replace("[Country]", objOrder.BillingCountry);
body = body.Replace("[ZipCode]", objOrder.BillingPostalCode);
body = body.Replace("[Email]", objOrder.BillingEmail);
body = body.Replace("[MobilePhone]", "");
body = body.Replace("[Phone]", objOrder.BillingPhone);
#region Sent Mail
if (objTemp.ToEmai != null)
{
for (int icount = 0; icount < objTemp.ToEmai.Count; icount++)
{
smtpsettings objsmtpsettings = new smtpsettings(objTemp.OutMail[0].OutMailServer, Convert.ToInt32(objTemp.OutMail[0].OutMailPort), emailfromId, emailpassword, true);
SMTPClient objSMTPClient = new SMTPClient(objsmtpsettings);
objSMTPClient.Recepients = objTemp.ToEmai[icount].Email;

objSMTPClient.SenderName = emailfromName;
objSMTPClient.Subject = emailSubject;
objSMTPClient.Content = body;

objSMTPClient.SendMessage(objSMTPClient);
objsmtpsettings = null;
objSMTPClient = null;
}
}

#endregion
}
catch
{
}

}
#endregion
}

===============================
public Boolean fnActive(string Module, string Role)
{
string ret = "false";
string resourcefile = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, "Resources/Roles.xml");
XPathDocument objdoc = new XPathDocument(resourcefile);
XPathNavigator objnav;
objnav = objdoc.CreateNavigator();
XPathNodeIterator objitr;
XPathExpression objexp;
objexp = objnav.Compile("//Table[Name='" + Module + "' and Role='" + Role + "']/Active");
objitr = objnav.Select(objexp);
while (objitr.MoveNext())
{
ret = objitr.Current.ToString();
}

return Convert.ToBoolean(ret);
}

Write three Tier with Microsoft Application block

1.)BOL

using System;
using System.Text;

namespace Customer.Registration
{
public class Registration
{
#region Customer Registration variable
//Customer Registration variable
String _Salutation;
String _Regi_PK;
String _User_Name;
String _User_Pwd;
String _FirstName;

#endregion

#region Customer Registration Properties
// Customer Registration Properties

public String Salutation
{
get { return _Salutation; }
set { _Salutation = value; }
}

public String Regi_PK
{
get { return _Regi_PK; }
set { _Regi_PK = value; }
}
public String SSN
{
get { return _SSN; }
set { _SSN = value; }
}
public String User_Name
{
get { return _User_Name; }
set { _User_Name = value; }
}
public String User_Pwd
{
get { return _User_Pwd; }
set { _User_Pwd = value; }
}
public String FirstName
{
get { return _FirstName; }
set { _FirstName = value; }
}

#endregion
}
}

2.)BLL

using System;
using System.Collections.Generic;

namespace Customer.Registration
{
public class RegistrationBOL : RegistrationDAL
{
#region Public Function

public void saveRegistartion(Registration objRegistration)
{
base.saveRegistartion(objRegistration);
}
public Boolean UpdateRegistartion(Registration objRegistration)
{
Boolean Status = false;
base.UpdateRegistartion(objRegistration,out Status);
return Status;
}
public void UpdateRegistration(Registration objRegistration)
{
base.UpdateRegistration(objRegistration);
}
public Registration GetRegistrationInfoById(String RegID)
{
return base.GetRegistrationInfoById(RegID);
}

public List RegistrationInfoGetAll(int UserId)
{
return base.RegistrationInfoGetAll(UserId);
}
#endregion

}
}

3.)DAL

using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
using System.Collections.Generic;
namespace Customer.Registration
{
public class RegistrationDAL : AppConfig
{
protected void saveRegistartion(Registration objRegistration)
{
SqlParameter[] Param;
Param = new SqlParameter[14];
Param[0] = new SqlParameter("@FirstName", SqlDbType.NVarChar);
Param[0].Value = objRegistration.FirstName;
Param[1] = new SqlParameter("@LastName", SqlDbType.NVarChar);
Param[1].Value = objRegistration.LastName;
Param[2] = new SqlParameter("@Address1", SqlDbType.NVarChar);
Param[2].Value = objRegistration.Address1;
Param[3] = new SqlParameter("@Address2", SqlDbType.NVarChar);
Param[3].Value = objRegistration.Address2;
Param[4] = new SqlParameter("@Address3", SqlDbType.NVarChar);
Param[4].Value = objRegistration.Address3;
Param[5] = new SqlParameter("@Country", SqlDbType.NVarChar);
Param[5].Value = objRegistration.Country;
Param[6] = new SqlParameter("@PostCode", SqlDbType.NVarChar);
Param[6].Value = objRegistration.PostCode;
Param[7] = new SqlParameter("@EmailAddress", SqlDbType.NVarChar);
Param[7].Value = objRegistration.EmailAddress;
Param[8] = new SqlParameter("@Phone", SqlDbType.NVarChar);
Param[8].Value = objRegistration.Phone;
Param[9] = new SqlParameter("@InfoMode", SqlDbType.NVarChar);
Param[9].Value = objRegistration.InfoMode;
Param[10] = new SqlParameter("@InfoMode_Other", SqlDbType.NVarChar);
Param[10].Value = objRegistration.InfoModeOther;
Param[11] = new SqlParameter("@Resi_ID", SqlDbType.NVarChar, 36);
Param[11].Direction = ParameterDirection.Output;
Param[12] = new SqlParameter("@Services", SqlDbType.NVarChar);
Param[12].Value = objRegistration.Services;
Param[13] = new SqlParameter("@PreferredName", SqlDbType.NVarChar);
Param[13].Value = objRegistration.PreferredName;

SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "usp_Customer_RegistrationAdd", Param);
objRegistration.Regi_PK = Param[11].Value.ToString();
}

protected void UpdateRegistartion(Registration objRegistration, out Boolean Status)
{
SqlParameter[] Param;
Param = new SqlParameter[20];
Param[0] = new SqlParameter("@Regi_PK", SqlDbType.NVarChar);
Param[0].Value = objRegistration.Regi_PK;
Param[1] = new SqlParameter("@Salutation", SqlDbType.NVarChar);
Param[1].Value = objRegistration.Salutation;
Param[2] = new SqlParameter("@FirstName", SqlDbType.NVarChar);
Param[2].Value = objRegistration.FirstName;
Param[3] = new SqlParameter("@MiddleName", SqlDbType.NVarChar);
Param[3].Value = objRegistration.MiddleName;
Param[4] = new SqlParameter("@LastName", SqlDbType.NVarChar);
Param[4].Value = objRegistration.LastName;
Param[5] = new SqlParameter("@PreferredName", SqlDbType.NVarChar);
Param[5].Value = objRegistration.PreferredName;
Param[6] = new SqlParameter("@DateofBirth", SqlDbType.DateTime);
Param[6].Value = objRegistration.DateOfBirth;
Param[7] = new SqlParameter("@Occupation", SqlDbType.NVarChar);
Param[7].Value = objRegistration.Occupation;
Param[8] = new SqlParameter("@SSNNo", SqlDbType.NVarChar);
Param[8].Value = objRegistration.SSN;

Param[9] = new SqlParameter("@Address1", SqlDbType.NVarChar);
Param[9].Value = objRegistration.Address1;
Param[10] = new SqlParameter("@Address2", SqlDbType.NVarChar);
Param[10].Value = objRegistration.Address2;
Param[11] = new SqlParameter("@Address3", SqlDbType.NVarChar);
Param[11].Value = objRegistration.Address3;
Param[12] = new SqlParameter("@City", SqlDbType.NVarChar);
Param[12].Value = objRegistration.City;
Param[13] = new SqlParameter("@State", SqlDbType.NVarChar);
Param[13].Value = objRegistration.State;

Param[14] = new SqlParameter("@Country", SqlDbType.NVarChar);
Param[14].Value = objRegistration.Country;
Param[15] = new SqlParameter("@PostCode", SqlDbType.NVarChar);
Param[15].Value = objRegistration.PostCode;
Param[16] = new SqlParameter("@EmailAddress", SqlDbType.NVarChar);
Param[16].Value = objRegistration.EmailAddress;
Param[17] = new SqlParameter("@Phone", SqlDbType.NVarChar);
Param[17].Value = objRegistration.Phone;
Param[18] = new SqlParameter("@Message", SqlDbType.NVarChar);
Param[18].Value = objRegistration.Message;
Param[19] = new SqlParameter("@Status", SqlDbType.Bit);
Param[19].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "[usp_Customer_RegistrationUpdate]", Param);
Status = Convert.ToBoolean(Param[19].Value);
}
protected void UpdateRegistration(Registration objRegistration)
{
SqlParameter[] Param;
Param = new SqlParameter[11];
Param[0] = new SqlParameter("@Regi_PK", SqlDbType.NVarChar);
Param[0].Value = objRegistration.Regi_PK;

Param[1] = new SqlParameter("@FirstName", SqlDbType.NVarChar);
Param[1].Value = objRegistration.FirstName;

Param[2] = new SqlParameter("@LastName", SqlDbType.NVarChar);
Param[2].Value = objRegistration.LastName;
Param[3] = new SqlParameter("@PreferredName", SqlDbType.NVarChar);
Param[3].Value = objRegistration.PreferredName;
Param[4] = new SqlParameter("@Address1", SqlDbType.NVarChar);
Param[4].Value = objRegistration.Address1;
Param[5] = new SqlParameter("@Address2", SqlDbType.NVarChar);
Param[5].Value = objRegistration.Address2;
Param[6] = new SqlParameter("@Address3", SqlDbType.NVarChar);
Param[6].Value = objRegistration.Address3;

Param[7] = new SqlParameter("@Country", SqlDbType.NVarChar);
Param[7].Value = objRegistration.Country;
Param[8] = new SqlParameter("@PostCode", SqlDbType.NVarChar);
Param[8].Value = objRegistration.PostCode;
Param[9] = new SqlParameter("@EmailAddress", SqlDbType.NVarChar);
Param[9].Value = objRegistration.EmailAddress;
Param[10] = new SqlParameter("@Phone", SqlDbType.NVarChar);
Param[10].Value = objRegistration.Phone;

SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "[usp_Customer_RegistrationUpdate1]", Param);
}

protected Registration GetRegistrationInfoById(String RegID)
{
Registration objRegistration = new Registration();
SqlParameter[] Param;
Param = new SqlParameter[2];
Param[0] = new SqlParameter("@ITR_Fk", SqlDbType.NVarChar, 36);
Param[0].Value = RegID;
Param[1] = new SqlParameter("@step", SqlDbType.SmallInt);
Param[1].Value = 2;

SqlDataReader Dr = SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "usp_Customer_GetStepWiseDataByITRID", Param);

if (Dr.HasRows)
{
Dr.Read();
objRegistration.Regi_PK = Dr["Regi_PK"].ToString();
objRegistration.FirstName = DBNull.Value.Equals(Dr["FirstName"]) ? "" : Dr["FirstName"].ToString();
objRegistration.MiddleName = DBNull.Value.Equals(Dr["MiddleName"]) ? "" : Dr["MiddleName"].ToString();
objRegistration.LastName = DBNull.Value.Equals(Dr["LastName"]) ? "" : Dr["LastName"].ToString();
objRegistration.Address1 = DBNull.Value.Equals(Dr["Address1"]) ? "" : Dr["Address1"].ToString();
objRegistration.Address2 = DBNull.Value.Equals(Dr["Address2"]) ? "" : Dr["Address2"].ToString();
objRegistration.Address3 = DBNull.Value.Equals(Dr["Address3"]) ? "" : Dr["Address3"].ToString();
objRegistration.Phone = DBNull.Value.Equals(Dr["Phone"]) ? "" : Dr["Phone"].ToString();
objRegistration.SSN = DBNull.Value.Equals(Dr["SSNNo"]) ? "" : Dr["SSNNo"].ToString();
objRegistration.Country = DBNull.Value.Equals(Dr["Country"]) ? "" : Dr["Country"].ToString();
objRegistration.PostCode = DBNull.Value.Equals(Dr["PostCode"]) ? "" : Dr["PostCode"].ToString();
objRegistration.PreferredName = DBNull.Value.Equals(Dr["PreferredName"]) ? "" : Dr["PreferredName"].ToString();

objRegistration.City = DBNull.Value.Equals(Dr["City"]) ? "" : Dr["City"].ToString();
objRegistration.State = DBNull.Value.Equals(Dr["State"]) ? "" : Dr["State"].ToString();
try
{
objRegistration.DateOfBirth = Convert.ToDateTime(Dr["DateOfBirth"]);
}
catch
{
objRegistration.DateOfBirth = DateTime.Today;
}
objRegistration.RegisteredOn = Convert.ToDateTime(Dr["RegisteredOn"]);
objRegistration.Message = DBNull.Value.Equals(Dr["Message"]) ? "" : Dr["Message"].ToString();
objRegistration.Salutation = DBNull.Value.Equals(Dr["Salutation"]) ? "" : Dr["Salutation"].ToString();
objRegistration.Occupation = DBNull.Value.Equals(Dr["Occupation"]) ? "" : Dr["Occupation"].ToString();
objRegistration.UpdatedOn = Convert.ToDateTime(Dr["UpdatedOn"]);
objRegistration.EmailAddress = DBNull.Value.Equals(Dr["User_Name"]) ? "" : Dr["User_Name"].ToString();
objRegistration.User_Pwd = DBNull.Value.Equals(Dr["User_Pwd"]) ? "" : Dr["User_Pwd"].ToString();

}
return objRegistration;
}
protected List RegistrationInfoGetAll(int UserId)
{

SqlParameter[] Param;
Param = new SqlParameter[1];
Param[0] = new SqlParameter("@UserId", SqlDbType.Int);
Param[0].Value = UserId;

List objList = new List();
SqlDataReader Dr = SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "Usp_Control_CustomerRegisterationGetAll", Param);
while (Dr.Read())
{
Registration objRegistration = new Registration();

objRegistration.Regi_PK = Dr["Regi_PK"].ToString();
objRegistration.SSN = Convert.ToInt64(Dr["SSNNo"]).ToString("###-##-####");
objRegistration.FirstName = DBNull.Value.Equals(Dr["FirstName"]) ? "" : Dr["FirstName"].ToString();
objRegistration.LastName = DBNull.Value.Equals(Dr["LastName"]) ? "" : Dr["LastName"].ToString();
objRegistration.PreferredName = DBNull.Value.Equals(Dr["PreferredName"]) ? "" : Dr["PreferredName"].ToString();
objRegistration.EmailAddress = DBNull.Value.Equals(Dr["EmailAddress"]) ? "" : Dr["EmailAddress"].ToString();
objRegistration.UpdatedOn = Convert.ToDateTime(Dr["UpdatedOn"]);
objRegistration.InfoMode = DBNull.Value.Equals(Dr["InfoMode"]) ? "" : Dr["InfoMode"].ToString();
objList.Add(objRegistration);
objRegistration = null;
}
return objList;
}

protected RegistrationSearch RegistrationInfoGetAll(RegistrationSearch objRegistrationSearch)
{

SqlParameter[] Param;
Param = new SqlParameter[10];

Param[0] = new SqlParameter("@PageIndex", SqlDbType.Int);
Param[0].Value = objRegistrationSearch.PageIndex;
Param[1] = new SqlParameter("@RowsPerPage", SqlDbType.Int);
Param[1].Value = objRegistrationSearch.RecordperPage;
Param[2] = new SqlParameter("@OrderBY", SqlDbType.SmallInt);
Param[2].Value = objRegistrationSearch.OrderBy;
Param[3] = new SqlParameter("@Order", SqlDbType.SmallInt);
Param[3].Value = objRegistrationSearch.Order;

Param[4] = new SqlParameter("@UserId", SqlDbType.Int);
Param[4].Value = objRegistrationSearch.UserId;
Param[5] = new SqlParameter("@datefrom", SqlDbType.VarChar, 10);
Param[5].Value = objRegistrationSearch.DateFrom;
Param[6] = new SqlParameter("@dateto", SqlDbType.VarChar, 10);
Param[6].Value = objRegistrationSearch.DateTo;
Param[7] = new SqlParameter("@SSNNo", SqlDbType.VarChar, 100);
Param[7].Value = objRegistrationSearch.SSNo;
Param[8] = new SqlParameter("@Name", SqlDbType.VarChar, 100);
Param[8].Value = objRegistrationSearch.CustomerName;
Param[9] = new SqlParameter("@EmailId", SqlDbType.VarChar, 100);
Param[9].Value = objRegistrationSearch.EmailAddress;

SqlDataReader Dr = SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "Usp_Control_CustomerRegisterationGetAll", Param);
while (Dr.Read())
{
objRegistrationSearch.TotalRecords = Convert.ToInt32(Dr["TotalRecords"]);
}
Dr.NextResult();

while (Dr.Read())
{
Registration objRegistration = new Registration();

objRegistration.Regi_PK = Dr["Regi_PK"].ToString();
try
{
objRegistration.SSN = Convert.ToInt64(Dr["SSNNo"]).ToString("###-##-####");
}
catch { objRegistration.SSN = ""; }
objRegistration.FirstName = DBNull.Value.Equals(Dr["FirstName"]) ? "" : Dr["FirstName"].ToString();
objRegistration.LastName = DBNull.Value.Equals(Dr["LastName"]) ? "" : Dr["LastName"].ToString();
objRegistration.PreferredName = DBNull.Value.Equals(Dr["PreferredName"]) ? "" : Dr["PreferredName"].ToString();
objRegistration.EmailAddress = DBNull.Value.Equals(Dr["EmailAddress"]) ? "" : Dr["EmailAddress"].ToString();
objRegistration.UpdatedOn = Convert.ToDateTime(Dr["UpdatedOn"]);
objRegistration.InfoMode = DBNull.Value.Equals(Dr["InfoMode"]) ? "" : Dr["InfoMode"].ToString();
objRegistrationSearch.Registrations.Add(objRegistration);
objRegistration = null;
}
return objRegistrationSearch;
}
protected RegistrationSearch RegistrationInfoGetAll_reminderEmail(RegistrationSearch objRegistrationSearch)
{

SqlParameter[] Param;
Param = new SqlParameter[11];

Param[0] = new SqlParameter("@PageIndex", SqlDbType.Int);
Param[0].Value = objRegistrationSearch.PageIndex;
Param[1] = new SqlParameter("@RowsPerPage", SqlDbType.Int);
Param[1].Value = objRegistrationSearch.RecordperPage;
Param[2] = new SqlParameter("@OrderBY", SqlDbType.SmallInt);
Param[2].Value = objRegistrationSearch.OrderBy;
Param[3] = new SqlParameter("@Order", SqlDbType.SmallInt);
Param[3].Value = objRegistrationSearch.Order;
Param[4] = new SqlParameter("@UserId", SqlDbType.Int);
Param[4].Value = objRegistrationSearch.UserId;
Param[5] = new SqlParameter("@SSNNo", SqlDbType.VarChar, 100);
Param[5].Value = objRegistrationSearch.SSNo;
Param[6] = new SqlParameter("@Name", SqlDbType.VarChar, 100);
Param[6].Value = objRegistrationSearch.CustomerName;
Param[7] = new SqlParameter("@EmailId", SqlDbType.VarChar, 100);
Param[7].Value = objRegistrationSearch.EmailAddress;
Param[8] = new SqlParameter("@ReminderPeriod", SqlDbType.VarChar, 200);
Param[8].Value = objRegistrationSearch.ReminderPeriod;
Param[9] = new SqlParameter("@datefrom", SqlDbType.VarChar, 10);
Param[9].Value = objRegistrationSearch.DateFrom;
Param[10] = new SqlParameter("@dateto", SqlDbType.VarChar, 10);
Param[10].Value = objRegistrationSearch.DateTo;

//Param[10] = new SqlParameter("@FinancialYear", SqlDbType.VarChar, 100);
//Param[10].Value = objRegistrationSearch.financialYear;

SqlDataReader Dr = SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "[Usp_Control_reminderEmail_CustomerRegisterationGetAll]", Param);
while (Dr.Read())
{
objRegistrationSearch.TotalRecords = Convert.ToInt32(Dr["TotalRecords"]);
}
Dr.NextResult();

while (Dr.Read())
{
Registration objRegistration = new Registration();

objRegistration.Regi_PK = Dr["Regi_PK"].ToString();
try
{
objRegistration.SSN = Convert.ToInt64(Dr["SSNNo"]).ToString("###-##-####");
}
catch { objRegistration.SSN = ""; }
objRegistration.FirstName = DBNull.Value.Equals(Dr["FirstName"]) ? "" : Dr["FirstName"].ToString();
objRegistration.LastName = DBNull.Value.Equals(Dr["LastName"]) ? "" : Dr["LastName"].ToString();
objRegistration.PreferredName = DBNull.Value.Equals(Dr["PreferredName"]) ? "" : Dr["PreferredName"].ToString();
objRegistration.EmailAddress = DBNull.Value.Equals(Dr["EmailAddress"]) ? "" : Dr["EmailAddress"].ToString();
objRegistration.UpdatedOn = Convert.ToDateTime(Dr["UpdatedOn"]);
objRegistration.InfoMode = DBNull.Value.Equals(Dr["InfoMode"]) ? "" : Dr["InfoMode"].ToString();
objRegistrationSearch.Registrations.Add(objRegistration);
objRegistration = null;
}
return objRegistrationSearch;
}
protected RegistrationSearch RegistrationInfoGetAll_dateSpecificEmail(RegistrationSearch objRegistrationSearch)
{

SqlParameter[] Param;
Param = new SqlParameter[12];

Param[0] = new SqlParameter("@PageIndex", SqlDbType.Int);
Param[0].Value = objRegistrationSearch.PageIndex;
Param[1] = new SqlParameter("@RowsPerPage", SqlDbType.Int);
Param[1].Value = objRegistrationSearch.RecordperPage;
Param[2] = new SqlParameter("@OrderBY", SqlDbType.SmallInt);
Param[2].Value = objRegistrationSearch.OrderBy;
Param[3] = new SqlParameter("@Order", SqlDbType.SmallInt);
Param[3].Value = objRegistrationSearch.Order;
Param[4] = new SqlParameter("@UserId", SqlDbType.Int);
Param[4].Value = objRegistrationSearch.UserId;
Param[5] = new SqlParameter("@SSNNo", SqlDbType.VarChar, 100);
Param[5].Value = objRegistrationSearch.SSNo;
Param[6] = new SqlParameter("@Name", SqlDbType.VarChar, 100);
Param[6].Value = objRegistrationSearch.CustomerName;
Param[7] = new SqlParameter("@EmailId", SqlDbType.VarChar, 100);
Param[7].Value = objRegistrationSearch.EmailAddress;
Param[8] = new SqlParameter("@MailDate", SqlDbType.VarChar, 200);
Param[8].Value = objRegistrationSearch.MailDate;
Param[9] = new SqlParameter("@FinancialYear", SqlDbType.VarChar, 100);
Param[9].Value = objRegistrationSearch.financialYear;

Param[10] = new SqlParameter("@datefrom", SqlDbType.VarChar, 10);
Param[10].Value = objRegistrationSearch.DateFrom;
Param[11] = new SqlParameter("@dateto", SqlDbType.VarChar, 10);
Param[11].Value = objRegistrationSearch.DateTo;

SqlDataReader Dr = SqlHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, "[Usp_Control_dateSpecific_CustomerRegisterationGetAll]", Param);
while (Dr.Read())
{
objRegistrationSearch.TotalRecords = Convert.ToInt32(Dr["TotalRecords"]);
}
Dr.NextResult();

while (Dr.Read())
{
Registration objRegistration = new Registration();

objRegistration.Regi_PK = Dr["Regi_PK"].ToString();
try
{
objRegistration.SSN = Convert.ToInt64(Dr["SSNNo"]).ToString("###-##-####");
}
catch { objRegistration.SSN = ""; }
objRegistration.FirstName = DBNull.Value.Equals(Dr["FirstName"]) ? "" : Dr["FirstName"].ToString();
objRegistration.LastName = DBNull.Value.Equals(Dr["LastName"]) ? "" : Dr["LastName"].ToString();
objRegistration.PreferredName = DBNull.Value.Equals(Dr["PreferredName"]) ? "" : Dr["PreferredName"].ToString();
objRegistration.EmailAddress = DBNull.Value.Equals(Dr["EmailAddress"]) ? "" : Dr["EmailAddress"].ToString();
objRegistration.UpdatedOn = Convert.ToDateTime(Dr["UpdatedOn"]);
objRegistration.InfoMode = DBNull.Value.Equals(Dr["InfoMode"]) ? "" : Dr["InfoMode"].ToString();
objRegistrationSearch.Registrations.Add(objRegistration);
objRegistration = null;
}
return objRegistrationSearch;
}
}
}

4.)Search

using System;
using System.Collections.Generic;
using System.Text;

namespace Customer.Registration
{
public class RegistrationSearch : RegistrationDAL
{
#region private variable

private Int32 _pageindex;
private Int32 _recordperpage;
private Int16 _orderby;
private Int16 _order;
private Int32 _totalrecords;

private Int32 _UserId;
private String _ssno;
private String _customername;
private String _emailid;
private String _datefrom;
private String _dateto;
private int _financialYear;
private String _ReminderPeriod;
private string _MailDate;

private List _Registrations = new List();
#endregion

#region Public Properties
public Int32 UserId
{
get
{
return this._UserId;
}
set
{
if ((this._UserId != value))
{
this._UserId = value;
}
}
}
public Int32 PageIndex
{
get
{
return this._pageindex;
}
set
{
if ((this._pageindex != value))
{
this._pageindex = value;
}
}
}
public Int32 RecordperPage
{
get
{
return this._recordperpage;
}
set
{
if ((this._recordperpage != value))
{
this._recordperpage = value;
}
}
}
public Int32 TotalRecords
{
get
{
return this._totalrecords;
}
set
{
if ((this._totalrecords != value))
{
this._totalrecords = value;
}
}
}
public Int16 OrderBy
{
get
{
return this._orderby;
}
set
{
if ((this._orderby != value))
{
this._orderby = value;
}
}
}
public Int16 Order
{
get
{
return this._order;
}
set
{
if ((this._order != value))
{
this._order = value;
}
}
}

public String SSNo
{
get { return _ssno; }
set { _ssno = value; }
}
public String CustomerName
{
get { return _customername; }
set { _customername = value; }
}
public String EmailAddress
{
get { return _emailid; }
set { _emailid = value; }
}
public String DateFrom
{
get { return _datefrom; }
set { _datefrom = value; }
}
public String DateTo
{
get { return _dateto; }
set { _dateto = value; }
}
public String ReminderPeriod
{
get { return _ReminderPeriod; }
set { _ReminderPeriod = value; }
}
public String MailDate
{
get { return _MailDate; }
set { _MailDate = value; }
}
public int financialYear
{
get { return _financialYear; }
set { _financialYear = value; }
}

public List Registrations
{
get
{
return this._Registrations;
}
set
{
if ((this._Registrations != value))
{
this._Registrations = value;
}
}

}
#endregion

#region Public Function

public RegistrationSearch RegistrationInfoGetAll(RegistrationSearch objRegistrationSearch)
{
return base.RegistrationInfoGetAll(objRegistrationSearch);
}
public RegistrationSearch RegistrationInfoGetAll_reminderEmail(RegistrationSearch objRegistrationSearch)
{
return base.RegistrationInfoGetAll_reminderEmail(objRegistrationSearch);
}
public RegistrationSearch RegistrationInfoGetAll_dateSpecificEmail(RegistrationSearch objRegistrationSearch)
{
return base.RegistrationInfoGetAll_dateSpecificEmail(objRegistrationSearch);
}
#endregion
}
}

Asp.net, MVC, C#,Jquery, Angularjs, WebAPI, HTML,Wcf, SQL