private void FillData()
{
try
{
int PageCount = 0;
tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp = new tbl_MatrimonialMemberProp();
Objtbl_MatrimonialMemberProp.MemberCode = 0;
Objtbl_MatrimonialMemberProp.PageNo = Convert.ToInt32(1);
Objtbl_MatrimonialMemberProp.RecordCount = Convert.ToInt32(20);
tbl_MatrimonialMemberBAL Objtbl_MatrimonialMemberBAL = new tbl_MatrimonialMemberBAL();
DataSet dsData = Objtbl_MatrimonialMemberBAL.Select_Data(Objtbl_MatrimonialMemberProp, ref PageCount);
rptData.DataSource = dsData.Tables[0];
rptData.DataBind();
for (int i = 0; i < dsData.Tables[0].Columns.Count; i++)
{
ddlSelect.Items.Add(dsData.Tables[0].Columns[i].ColumnName);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp = new tbl_MatrimonialMemberProp();
Objtbl_MatrimonialMemberProp.EmailID = txtEmailID.Text;
tbl_MatrimonialMemberBAL Objtbl_MatrimonialMemberBAL = new tbl_MatrimonialMemberBAL();
DataSet dsData = Objtbl_MatrimonialMemberBAL.CheckLogin(Objtbl_MatrimonialMemberProp);
if (dsData.Tables[0].Rows.Count > 0)
{
Encrypting ObjEncrypting = new Encrypting();
string DataPassword = ObjEncrypting.Encrypt(Convert.ToString(dsData.Tables[0].Rows[0]["Password"]));
if (txtPassword.Text == DataPassword)
{
Session["LoginName"] = Convert.ToString(dsData.Tables[0].Rows[0]["MemberName"]);
Session["LoginID"] = Convert.ToString(dsData.Tables[0].Rows[0]["MemberCode"]);
//memberlist.Visible = true;
matrimonialmemberlist.Visible = true;
Welcome.Visible = true;
LoginForm.Visible = false;
lblUserName.Text = Convert.ToString(dsData.Tables[0].Rows[0]["MemberName"]);
}
else
{
Response.Redirect("MatrimonialSignUp.aspx?msg=invalidpwd");
}
}
else
{
Response.Redirect("MatrimonialSignUp.aspx?msg=invalidid");
}
}
public int InsertUpdate_Data(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_MatrimonialMember");
DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_MatrimonialMemberProp.MemberCode);
DB.AddInParameter(DBCmd, "@MemberName", DbType.String, Objtbl_MatrimonialMemberProp.MemberName);
DB.AddInParameter(DBCmd, "@DOB", DbType.DateTime, Objtbl_MatrimonialMemberProp.DOB);
DB.AddInParameter(DBCmd, "@Gender", DbType.Int32, Objtbl_MatrimonialMemberProp.Gender);
DB.AddInParameter(DBCmd, "@Gotra", DbType.String, Objtbl_MatrimonialMemberProp.Gotra);
DB.AddInParameter(DBCmd, "@LivingIn", DbType.Int32, Objtbl_MatrimonialMemberProp.LivingIn);
DB.AddInParameter(DBCmd, "@EmailID", DbType.String, Objtbl_MatrimonialMemberProp.EmailID);
DB.AddInParameter(DBCmd, "@ContactNo", DbType.String, Objtbl_MatrimonialMemberProp.ContactNo);
DB.AddInParameter(DBCmd, "@Password", DbType.String, Objtbl_MatrimonialMemberProp.Password);
DB.AddInParameter(DBCmd, "@MemberPhoto", DbType.String, Objtbl_MatrimonialMemberProp.MemberPhoto);
DB.AddOutParameter(DBCmd, "@RetVal", DbType.Int32, 18);
DB.ExecuteNonQuery(DBCmd);
return(Convert.ToInt32(DBCmd.Parameters["@RetVal"].Value));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp)
{
try
{
tbl_MatrimonialMemberDAL Objtbl_MatrimonialMemberDAL = new tbl_MatrimonialMemberDAL();
return(Objtbl_MatrimonialMemberDAL.Search_Data(Objtbl_MatrimonialMemberProp));
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp)
{
try
{
tbl_MatrimonialMemberDAL Objtbl_MatrimonialMemberDAL = new tbl_MatrimonialMemberDAL();
return(Objtbl_MatrimonialMemberDAL.Delete_Data(Objtbl_MatrimonialMemberProp));
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp = new tbl_MatrimonialMemberProp();
Objtbl_MatrimonialMemberProp.EmailID = txtLoginEmailID.Text;
tbl_MatrimonialMemberBAL Objtbl_MatrimonialMemberBAL = new tbl_MatrimonialMemberBAL();
DataSet dsData = Objtbl_MatrimonialMemberBAL.CheckLogin(Objtbl_MatrimonialMemberProp);
if (dsData.Tables[0].Rows.Count > 0)
{
Encrypting ObjEncrypting = new Encrypting();
string DataPassword = ObjEncrypting.Encrypt(Convert.ToString(dsData.Tables[0].Rows[0]["Password"]));
if (txtLoginPassword.Text == DataPassword)
{
Session["LoginName"] = Convert.ToString(dsData.Tables[0].Rows[0]["MemberName"]);
Session["LoginID"] = Convert.ToString(dsData.Tables[0].Rows[0]["MemberCode"]);
Master.FindControl("memberlist").Visible = true;
Master.FindControl("matrimonialmemberlist").Visible = true;
Master.FindControl("Welcome").Visible = true;
Master.FindControl("LoginForm").Visible = false;
if (Convert.ToString(Request.QueryString["msg"]) == "MatrimonialList")
{
Response.Redirect("MatrimonialMembersList.aspx");
}
else if (Convert.ToString(Request.QueryString["msg"]) == "MemberList")
{
Response.Redirect("MembersList.aspx");
}
else
{
Response.Redirect("Default.aspx");
}
//memberlist.Visible = true;
//matrimonialmemberlist.Visible = true;
//Welcome.Visible = true;
//LoginForm.Visible = false;
}
else
{
Response.Redirect("MatrimonialSignUp.aspx?msg=invalidpwd");
}
}
else
{
Response.Redirect("MatrimonialSignUp.aspx?msg=invalidid");
}
}
public DataSet CheckLogin(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp)
{
try
{
tbl_MatrimonialMemberDAL Objtbl_MatrimonialMemberDAL = new tbl_MatrimonialMemberDAL();
DataSet dsData = Objtbl_MatrimonialMemberDAL.CheckLogin(Objtbl_MatrimonialMemberProp);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_MatrimonialMember");
DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_MatrimonialMemberProp.MemberCode);
return(DB.ExecuteNonQuery(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_MatrimonialMember");
DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_MatrimonialMemberProp.SearchBy);
DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_MatrimonialMemberProp.SearchVal);
return(DB.ExecuteDataSet(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet CheckLogin(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Check_MatrimonialMember_Login");
DB.AddInParameter(DBCmd, "@EmailID", DbType.String, Objtbl_MatrimonialMemberProp.EmailID);
DataSet dsData = DB.ExecuteDataSet(DBCmd);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp, ref int TotalCount)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_MatrimonialMember");
DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_MatrimonialMemberProp.MemberCode);
DB.AddInParameter(DBCmd, "@PageNo", DbType.Int32, Objtbl_MatrimonialMemberProp.PageNo);
DB.AddInParameter(DBCmd, "@RecordCount", DbType.Int32, Objtbl_MatrimonialMemberProp.RecordCount);
DB.AddOutParameter(DBCmd, "@TotalCount", DbType.Int32, 18);
DataSet dsData = DB.ExecuteDataSet(DBCmd);
TotalCount = Convert.ToInt32(DBCmd.Parameters["@TotalCount"].Value);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp, ref int PageCount)
{
try
{
if (Objtbl_MatrimonialMemberProp.MemberCode != 0)
{
Objtbl_MatrimonialMemberProp.PageNo = 1;
Objtbl_MatrimonialMemberProp.RecordCount = 1;
}
int RecordCount = 0;
tbl_MatrimonialMemberDAL Objtbl_MatrimonialMemberDAL = new tbl_MatrimonialMemberDAL();
DataSet dsData = Objtbl_MatrimonialMemberDAL.Select_Data(Objtbl_MatrimonialMemberProp, ref RecordCount);
double Page = Convert.ToDouble(RecordCount) / Convert.ToDouble(Objtbl_MatrimonialMemberProp.RecordCount);
if (dsData.Tables[0].Rows.Count > 0)
{
string[] PageDecimal = Page.ToString().Split('.');
if (PageDecimal.Length > 1 && Convert.ToInt32(PageDecimal[1]) > 0)
{
PageCount = Convert.ToInt32(Page.ToString().Split('.')[0]) + 1;
}
else
{
PageCount = Convert.ToInt32(Page);
}
}
else
{
PageCount = 0;
}
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSignup_Click(object sender, EventArgs e)
{
string sSavePath = "";
string sFilename = "";
try
{
//if (chkDeleteFilePath.Checked == false)
//{
// Set constant values
sSavePath = "MembersPhotos/";
// If file field isn’t empty
if (flFilePath.PostedFile != null && flFilePath.PostedFile.ContentLength > 0)
{
// Check file size (mustn’t be 0)
HttpPostedFile myFile = flFilePath.PostedFile;
int nFileLen = myFile.ContentLength;
if (nFileLen == 0)
{
ShowGuidMessage(0, new Exception("No file was uploaded."));
return;
}
// Check file extension (must be JPG or pdf)
if (System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".jpg")
{
ShowGuidMessage(0, new Exception("The file must have an extension of JPG or pdf"));
return;
}
// Read file into a data stream
byte[] myData = new Byte[nFileLen];
myFile.InputStream.Read(myData, 0, nFileLen);
// Make sure a duplicate file doesn’t exist. If it does, keep on appending an
// incremental numeric until it is unique
sFilename = System.IO.Path.GetFileName(myFile.FileName);
int file_append = 0;
while (System.IO.File.Exists(Server.MapPath(sSavePath + sFilename)))
{
file_append++;
sFilename = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName)
+ file_append.ToString() + System.IO.Path.GetExtension(myFile.FileName).ToLower();
}
// Save the stream to disk
System.IO.FileStream newFile = new System.IO.FileStream(Server.MapPath(sSavePath + sFilename),
System.IO.FileMode.Create);
newFile.Write(myData, 0, myData.Length);
newFile.Close();
// Check whether the file is really a JPEG by opening it
//System.Drawing.Image.GetThumbnailImageAbort myCallBack =
// new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback);
//Bitmap myBitmap;
//try
//{
// myBitmap = new Bitmap(Server.MapPath(sSavePath + sFilename));
// tdUploadedFile.Visible = true;
// tdUploadedFile.InnerHtml = "<a href=\"" + sSavePath + sFilename + "\">Download Attachment</a>";
// // Displaying success information
// //tdError.InnerText = "File uploaded successfully!";
// // Destroy objects
// myBitmap.Dispose();
//}
//catch
//{
// // The file wasn't a valid jpg file
// System.IO.File.Delete(Server.MapPath(sSavePath + sFilename));
// ShowGuidMessage(0, new Exception("The file wasn't a valid jpg file"));
// return;
//}
}
//}
if (sFilename == "" && Convert.ToInt32(ViewState["EditCode"]) > 0)
{
sFilename = Convert.ToString(ViewState["PhotoPath"]);
}
else if (sFilename == "" && Convert.ToInt32(ViewState["EditCode"]) <= 0)
{
sFilename = "noimage.jpg";
}
//else if (chkDeleteFilePath.Checked == true)
//{
// if (Convert.ToInt32(ViewState["EditCode"]) > 0)
// {
// System.IO.File.Delete(Server.MapPath(sSavePath + Convert.ToString(ViewState["PhotoPath"])));
// }
// sFilename = "noimage.jpg";
//}
tbl_MatrimonialMemberProp Objtbl_MatrimonialMemberProp = new tbl_MatrimonialMemberProp();
Objtbl_MatrimonialMemberProp.MemberName = Convert.ToString(txtMemberName.Text);
Objtbl_MatrimonialMemberProp.DOB = new DateTime(Convert.ToInt32(txtDOB.Text.Split('/')[2]), Convert.ToInt32(txtDOB.Text.Split('/')[1]), Convert.ToInt32(txtDOB.Text.Split('/')[0]));
Objtbl_MatrimonialMemberProp.Gender = Convert.ToInt32(rdbtnGender.SelectedValue);
Objtbl_MatrimonialMemberProp.Gotra = Convert.ToString(ddlGotra.SelectedItem.Text);
Objtbl_MatrimonialMemberProp.LivingIn = Convert.ToInt32(ddlLivingIn.SelectedValue);
Objtbl_MatrimonialMemberProp.EmailID = txtEmailID.Text;
Objtbl_MatrimonialMemberProp.ContactNo = txtContactNo.Text;
Encrypting ObjEncrypting = new Encrypting();
string DataPassword = ObjEncrypting.Encrypt(Convert.ToString(txtPassword.Text));
Objtbl_MatrimonialMemberProp.Password = DataPassword;
Objtbl_MatrimonialMemberProp.MemberPhoto = sFilename;
tbl_MatrimonialMemberBAL Objtbl_MatrimonialMemberBAL = new tbl_MatrimonialMemberBAL();
Objtbl_MatrimonialMemberBAL.InsertUpdate_Data(Objtbl_MatrimonialMemberProp);
CommonClass ObjCommonClass = new CommonClass();
ObjCommonClass.SendMail(txtEmailID.Text, txtPassword.Text, MailMessage());
ClearPageData();
}
catch (Exception ex)
{
ShowGuidMessage(0, ex);
}
}