28.1.10
14.1.10
EmailMail Query
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
/****** 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
========================
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;
}
}
}
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
IList
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
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.Add(EventId);
IList
//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;
}
}
}
}
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;
}
}
}
}
function Check()
{
if (Page_ClientValidate())
{
if (document.getElementById("ctl00_gbtsContent_chkAgree").checked == false)
{
alert('Please select the checkbox.');
return false;
}
}
}
OnClientClick="return Check();" />
===============================================================================
http://alvinzc.blogspot.com/2006/10/aspnet-requiredfieldvalidator.html
{
if (Page_ClientValidate())
{
if (document.getElementById("ctl00_gbtsContent_chkAgree").checked == false)
{
alert('Please select the checkbox.');
return false;
}
}
}
OnClientClick="return Check();" />
===============================================================================
http://alvinzc.blogspot.com/2006/10/aspnet-requiredfieldvalidator.html
Required field validator on checkbox
==============================================================================
OnClientClick="return Check();" />
===============================================================================
http://alvinzc.blogspot.com/2006/10/aspnet-requiredfieldvalidator.html
Subscribe to:
Posts (Atom)