public String InsertMember(BOMemberMaster objMemberMaster)
{
dCmd = objDatabaseHelper.Command;
dCmd.CommandText = "SP_InsertMember";
dCmd.CommandType = CommandType.StoredProcedure;
try
{
objDatabaseHelper.BeginTransaction();
objDatabaseHelper.AddParameter("@PinCode", objMemberMaster.PinCode, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@SponsorID", objMemberMaster.SponsorID, SqlDbType.NVarChar, 50);
//objDatabaseHelper.AddParameter("@OwnerName", objMemberMaster.OwnerName, SqlDbType.NVarChar, 100);
objDatabaseHelper.AddParameter("@ParentID", objMemberMaster.ParentID, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@ConnectingSide", objMemberMaster.ConnectingSide, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@UserName", objMemberMaster.UserName, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@LoginName", objMemberMaster.LoginName, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@LoginPassword", objMemberMaster.LoginPassword, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@TransectionPassword", objMemberMaster.TransectionPassword, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@DOB", objMemberMaster.DOB, SqlDbType.DateTime, 50);
objDatabaseHelper.AddParameter("@Address", objMemberMaster.Address, SqlDbType.NVarChar, 50);
//objDatabaseHelper.AddParameter("@Landmark", objMemberMaster.Landmark, SqlDbType.NVarChar, 50);
//objDatabaseHelper.AddParameter("@District", objMemberMaster.District, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@City", objMemberMaster.city, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@State", objMemberMaster.State, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@Country", objMemberMaster.Country, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@PostalCode", objMemberMaster.PostalCode, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@TelephoneNo", objMemberMaster.TelephoneNo, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@MobileNo", objMemberMaster.MobileNo, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@EMail", objMemberMaster.EMailID, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@PanNo", objMemberMaster.PanNo, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@NomineeName", objMemberMaster.NomineeName, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@NomineeRelation", objMemberMaster.NomineeRelation, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@NomineeContact", objMemberMaster.NomineeContact, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@BankName", objMemberMaster.BankName, SqlDbType.NVarChar, 50);
//objDatabaseHelper.AddParameter("@BranchName", objMemberMaster.BranchName, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@AccountNo", objMemberMaster.AccountNo, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@IFSCCode", objMemberMaster.IFSCCode, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@Pin", objMemberMaster.Pin, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@PinAmount", objMemberMaster.PinAmount, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@Status", objMemberMaster.FatherName, SqlDbType.NVarChar, 100);
objDatabaseHelper.AddParameter("@PanCardProof", objMemberMaster.Pancard, SqlDbType.NVarChar, 500);
objDatabaseHelper.AddParameter("@AddressProof", objMemberMaster.AddressProof, SqlDbType.NVarChar, 500);
returnValue = Convert.ToString(objDatabaseHelper.ExecuteScalar(dCmd.CommandText, dCmd.CommandType, DatabaseHelper.ConnectionState.KeepOpen));
objDatabaseHelper.CommitTransaction();
}
catch (Exception ex)
{
objDatabaseHelper.RollbackTransaction();
}
finally
{
if (objDatabaseHelper.Connection.State == System.Data.ConnectionState.Open)
{
objDatabaseHelper.Connection.Close();
}
}
return(returnValue);
}
protected void Page_Load(object sender, EventArgs e)
{
if (User.Identity.IsAuthenticated == false)
{
Response.Redirect("~/240578/Default.aspx");
}
if (User.IsInRole("Update Profile") == false && User.IsInRole("Admin") == false)
{
Response.Redirect("~/240578/AdminHome.aspx");
}
objMemberMaster = new BOMemberMaster();
objBALMemberMaster = new BALMemberMaster();
if (!Page.IsPostBack)
{
if (Session["Usercode"] == null)
{
Response.Redirect("~/240578/Default.aspx");
}
else if (Session["Usercode"].ToString() == "BI250241")
{
txtMemberCode.Text = "";
InformationPanel.Visible = false;
}
}
}
protected void btnGetInfo_Click(object sender, EventArgs e)
{
objMemberMaster.UserCode = Session["Usercode"].ToString();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
objMemberMaster = objBALMemberMaster.getMemberProfileByMemberCode(objMemberMaster);
Session.Add("UserName", objMemberMaster.UserName);
if (objMemberMaster.DOB.ToString() == "")
{
txtDateOfBirth.Text = "";
}
else
{
txtDateOfBirth.Text = objMemberMaster.DOB.ToString(new CultureInfo("en-GB"));
}
if (txtPanNo.Text.Trim() != "")
{
txtPanNo.Enabled = false;
}
txtName.Text = objMemberMaster.UserName;
txtBAName.Text = objMemberMaster.UserCode;
txtAddress.Text = objMemberMaster.Address;
txtCity.Text = objMemberMaster.city;
txtState.Text = objMemberMaster.State;
txtCountry.Text = objMemberMaster.Country;
txtPinCode.Text = objMemberMaster.PostalCode;
txtMobileNo.Text = objMemberMaster.MobileNo;
//txtTelephoneNo.Text = objMemberMaster.TelephoneNo;
txtEmailID.Text = objMemberMaster.EMailID;
txtPanNo.Text = objMemberMaster.PanNo;
txtAccountNo.Text = objMemberMaster.AccountNo;
txtIFSCCode.Text = objMemberMaster.IFSCCode;
txtBankName.Text = objMemberMaster.BankName;
txtBranchName.Text = objMemberMaster.BranchName;
//txtLandmark.Text = objMemberMaster.Landmark;
txtDistrict.Text = objMemberMaster.District;
usertype.Value = objMemberMaster.UserType;
Hiddenpassword.Value = objMemberMaster.LoginPassword;
status.Value = objMemberMaster.Status;
Fname.Text = objMemberMaster.FatherName;
//PanCard.HRef = objMemberMaster.Pancard;
//AddressP.HRef = objMemberMaster.AddressProof;
txtAadharnumber.Text = objMemberMaster.AadharCard;
//txtOwnerName.Text =objMemberMaster.OwnerName;
InformationPanel.Visible = true;
txtAccountNo.Enabled = txtAccountNo.Text == null || txtAccountNo.Text.Trim() == "";
txtIFSCCode.Enabled = txtIFSCCode.Text == null || txtIFSCCode.Text.Trim() == "";
}
public BOMemberMaster getMemberProfileByMemberCode(BOMemberMaster objMemberMaster)
{
DALMemberMaster objDALMemberMaster = new DALMemberMaster();
try
{
return(objDALMemberMaster.GetMemberProfileByMemberCode(objMemberMaster));
}
catch
{
throw;
}
finally
{
objDALMemberMaster = null;
}
}
public String InsertMember_Admin(BOMemberMaster objMemberMaster)
{
DALMemberMaster objDALMemberMaster = new DALMemberMaster();
try
{
return(objDALMemberMaster.InsertMember_Admin(objMemberMaster));
}
catch
{
throw;
}
finally
{
objDALMemberMaster = null;
}
}
public String updateMemberAdmin(BOMemberMaster objMemberMaster)
{
DALMemberMaster objDALMemberMaster = new DALMemberMaster();
try
{
return(objDALMemberMaster.UpdateMemberAdmin(objMemberMaster));
}
catch
{
throw;
}
finally
{
objDALMemberMaster = null;
}
}
public BOMemberMaster userAuthentication(BOMemberMaster objMemberMaster)
{
DALMemberMaster objDALMemberMaster = new DALMemberMaster();
try
{
return(objDALMemberMaster.UserAuthentication(objMemberMaster));
}
catch
{
throw;
}
finally
{
objDALMemberMaster = null;
}
}
public BOMemberMaster UserAuthentication(BOMemberMaster objMemberMaster)
{
SqlDataReader rdrUserAuthentication = null;
dCmd = objDatabaseHelper.Command;
dCmd.CommandText = "SP_UserAuthentication";
dCmd.CommandType = CommandType.StoredProcedure;
try
{
objDatabaseHelper.BeginTransaction();
objDatabaseHelper.AddParameter("@LoginName", objMemberMaster.LoginName, SqlDbType.NVarChar, 50);
objDatabaseHelper.AddParameter("@LoginPassword", objMemberMaster.LoginPassword, SqlDbType.NVarChar, 50);
rdrUserAuthentication = objDatabaseHelper.ExecuteReader(dCmd.CommandText, dCmd.CommandType, DatabaseHelper.ConnectionState.KeepOpen);
if (rdrUserAuthentication.HasRows)
{
while (rdrUserAuthentication.Read())
{
objMemberMaster.UserCode = rdrUserAuthentication["UserCode"].ToString();
}
rdrUserAuthentication.Close();
}
else
{
rdrUserAuthentication.Close();
}
objDatabaseHelper.CommitTransaction();
}
catch
{
objDatabaseHelper.RollbackTransaction();
}
finally
{
if (objDatabaseHelper.Connection.State == System.Data.ConnectionState.Open)
{
objDatabaseHelper.Connection.Close();
}
}
return(objMemberMaster);
}
protected void btnGetInfo_Click(object sender, EventArgs e)
{
objMemberMaster.UserCode = txtMemberCode.Text;
objMemberMaster = objBALMemberMaster.getMemberProfileByMemberCode(objMemberMaster);
if (objMemberMaster.UserName == "")
{
Label1.Text = "Invalid Member ID";
return;
}
txtname.Text = objMemberMaster.UserName;
if (objMemberMaster.DOB.ToString() == "")
{
txtDateOfBirth.Text = "";
}
else
{
txtDateOfBirth.Text = objMemberMaster.DOB.ToString(new CultureInfo("en-GB"));
}
txtLoginPassword.Text = objMemberMaster.LoginPassword;
//txtTransactionPassword.Text = objMemberMaster.TransectionPassword;
txtAddress.Text = objMemberMaster.Address;
txtcity.Text = objMemberMaster.city;
txtstate.Text = objMemberMaster.State;
txtcountry.Text = objMemberMaster.Country;
txtPinCode.Text = objMemberMaster.PostalCode;
txtMobileNo.Text = objMemberMaster.MobileNo;
//txtTelephoneNo.Text = objMemberMaster.TelephoneNo;
txtEmailID.Text = objMemberMaster.EMailID;
txtAmount.Text = objMemberMaster.Amount;
txtAmount.Text = objMemberMaster.AccountNo;
txtifsc.Text = objMemberMaster.IFSCCode;
txtbranch.Text = objMemberMaster.BranchName;
txtbankname.Text = objMemberMaster.BankName;
txtpanno.Text = objMemberMaster.PanNo;
Fname.Text = objMemberMaster.FatherName;
//PanCard.HRef = objMemberMaster.Pancard;
//AddressP.HRef = objMemberMaster.AddressProof;
//txtLandmark.Text = objMemberMaster.Landmark;
txtDistrict.Text = objMemberMaster.District;
txtAadharnumber.Text = objMemberMaster.AadharCard;
InformationPanel.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (User.Identity.IsAuthenticated == false)
{
Response.Redirect("~/19111973/Default.aspx");
}
if (User.IsInRole("Change User Password") == false && User.IsInRole("Admin") == false)
{
Response.Redirect("~/19111973/AdminHome.aspx");
}
objMemberMaster = new BOMemberMaster();
objBALMemberMaster = new BALMemberMaster();
if (Session["Usercode"] == null)
{
Response.Redirect("~/User/Default.aspx");
}
}
public BOMemberMaster GetMemberProfileByMemberCode(BOMemberMaster objMemberMaster)
{
SqlDataReader rdMember = null;
dCmd = objDatabaseHelper.Command;
dCmd.CommandText = "SP_GetMemberProfileByMemberCode";
dCmd.CommandType = CommandType.StoredProcedure;
try
{
objDatabaseHelper.BeginTransaction();
objDatabaseHelper.AddParameter("@MemberCode", objMemberMaster.UserCode, SqlDbType.NVarChar, 50);
rdMember = objDatabaseHelper.ExecuteReader(dCmd.CommandText, dCmd.CommandType, DatabaseHelper.ConnectionState.KeepOpen);
if (rdMember.HasRows)
{
while (rdMember.Read())
{
objMemberMaster.Status = rdMember["status"].ToString();
objMemberMaster.LoginName = rdMember["LoginName"].ToString();
objMemberMaster.UserName = rdMember["UserName"].ToString();
objMemberMaster.LoginPassword = rdMember["LoginPassword"].ToString();
objMemberMaster.TransectionPassword = rdMember["TransectionPassword"].ToString();
objMemberMaster.UserName = rdMember["UserName"].ToString();
objMemberMaster.DOB = DateTime.Parse(rdMember["DOB"].ToString());
objMemberMaster.Address = rdMember["Address"].ToString();
objMemberMaster.city = rdMember["city"].ToString();
objMemberMaster.State = rdMember["State"].ToString();
objMemberMaster.Country = rdMember["Country"].ToString();
objMemberMaster.PostalCode = rdMember["PostalCode"].ToString();
objMemberMaster.MobileNo = rdMember["MobileNo"].ToString();
objMemberMaster.TelephoneNo = rdMember["TelephoneNo"].ToString();
objMemberMaster.EMailID = rdMember["EMail"].ToString();
objMemberMaster.PanNo = rdMember["PanNo"].ToString();
objMemberMaster.BankName = rdMember["BankName"].ToString();
objMemberMaster.BranchName = rdMember["BranchName"].ToString();
objMemberMaster.AccountNo = rdMember["AccountNo"].ToString();
objMemberMaster.IFSCCode = rdMember["IFSCCode"].ToString();
objMemberMaster.NomineeName = rdMember["NomineeName"].ToString();
objMemberMaster.NomineeContact = rdMember["NomineeContact"].ToString();
objMemberMaster.NomineeRelation = rdMember["NomineeRelation"].ToString();
objMemberMaster.FatherName = rdMember["FatherName"].ToString();
objMemberMaster.OwnerName = rdMember["OwnerName"].ToString();
objMemberMaster.District = rdMember["District"].ToString();
objMemberMaster.Landmark = rdMember["Landmark"].ToString();
objMemberMaster.UserType = rdMember["UserType"].ToString();
objMemberMaster.Rank = rdMember["CurrentRank"].ToString();
objMemberMaster.Cadre = rdMember["Cadre"].ToString();
objMemberMaster.Pancard = rdMember["PanCardProof"].ToString();
objMemberMaster.AddressProof = rdMember["AddressProof"].ToString();
objMemberMaster.AadharCard = rdMember["AadharCard"].ToString();
}
rdMember.Close();
}
else
{
rdMember.Close();
}
objDatabaseHelper.CommitTransaction();
}
catch
{
objDatabaseHelper.RollbackTransaction();
}
finally
{
if (objDatabaseHelper.Connection.State == System.Data.ConnectionState.Open)
{
objDatabaseHelper.Connection.Close();
}
}
return(objMemberMaster);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
objMemberMaster.UserCode = Session["Usercode"].ToString();
objMemberMaster = objBALMemberMaster.getMemberProfileByMemberCode(objMemberMaster);
string AddressProof = "", Pancard = "";
Guid g = Guid.NewGuid();
//if (FileUploadAddressProof.HasFile)
//{
// string fileName = Path.GetFileName(FileUploadAddressProof.PostedFile.FileName);
// FileUploadAddressProof.PostedFile.SaveAs(Server.MapPath("~/upload/") + g + "_AddProof_" + fileName);
// AddressProof = "~/upload/" + g + "_AddProof_" + fileName;
//}
//if (FileUploadPANCard.HasFile)
//{
// string fileName = Path.GetFileName(FileUploadPANCard.PostedFile.FileName);
// FileUploadPANCard.PostedFile.SaveAs(Server.MapPath("~/upload/") + g + "_PAN_" + fileName);
// Pancard = "~/upload/" + g + "_PAN_" + fileName;
//}
if (AddressProof == "")
{
AddressProof = objMemberMaster.AddressProof;
}
if (Pancard == "")
{
Pancard = objMemberMaster.Pancard;
}
objMemberMaster.UserCode = Session["Usercode"].ToString();
objMemberMaster = objBALMemberMaster.getMemberProfileByMemberCode(objMemberMaster);
objMemberMaster.DOB = DateTime.Parse(txtDateOfBirth.Text.Trim(), new CultureInfo("en-GB"));
objMemberMaster.Address = txtAddress.Text;
objMemberMaster.city = txtCity.Text;
objMemberMaster.State = txtState.Text;
objMemberMaster.Country = txtCountry.Text;
objMemberMaster.EMailID = txtEmailID.Text;
objMemberMaster.PostalCode = txtPinCode.Text;
objMemberMaster.TelephoneNo = "";
objMemberMaster.BankName = txtBankName.Text;
objMemberMaster.BranchName = txtBranchName.Text;
objMemberMaster.AccountNo = txtAccountNo.Text;
objMemberMaster.IFSCCode = txtIFSCCode.Text;
objMemberMaster.LoginPassword = Hiddenpassword.Value;
objMemberMaster.Status = status.Value;
objMemberMaster.FatherName = Fname.Text;
//objMemberMaster.OwnerName = "";
objMemberMaster.UserType = usertype.Value;
objMemberMaster.Landmark = "";
objMemberMaster.District = txtDistrict.Text;
objMemberMaster.PanNo = txtPanNo.Text;
objMemberMaster.MobileNo = txtMobileNo.Text;
objMemberMaster.AddressProof = AddressProof;
objMemberMaster.Pancard = Pancard;
objMemberMaster.AadharCard = txtAadharnumber.Text;
String result = objBALMemberMaster.updateMember(objMemberMaster);
if (int.Parse(result) == 1)
{
lblMessage.Text = "Profile Updated";
txtName.Text = "";
txtBAName.Text = "";
txtAddress.Text = "";
txtCity.Text = "";
txtState.Text = "";
txtCountry.Text = "";
txtPinCode.Text = "";
txtMobileNo.Text = "";
txtEmailID.Text = "";
txtPanNo.Text = "";
txtAccountNo.Text = "";
txtIFSCCode.Text = "";
txtBankName.Text = "";
txtBranchName.Text = "";
txtDistrict.Text = "";
usertype.Value = "";
Hiddenpassword.Value = "";
status.Value = "";
Fname.Text = "";
//txtOwnerName.Text ="";
txtDateOfBirth.Text = "";
txtAadharnumber.Text = "";
}
else
{
lblMessage.Text = "Updation Failed";
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
objMemberMaster.UserCode = txtMemberCode.Text;
objMemberMaster = objBALMemberMaster.getMemberProfileByMemberCode(objMemberMaster);
string AddressProof = "", Pancard = "";
Guid g = Guid.NewGuid();
//if (FileUploadAddressProof.HasFile)
//{
// string fileName = Path.GetFileName(FileUploadAddressProof.PostedFile.FileName);
// FileUploadAddressProof.PostedFile.SaveAs(Server.MapPath("~/upload/") + g + "_AddProof_" + fileName);
// AddressProof = "~/upload/" + g + "_AddProof_" + fileName;
//}
//if (FileUploadPANCard.HasFile)
//{
// string fileName = Path.GetFileName(FileUploadPANCard.PostedFile.FileName);
// FileUploadPANCard.PostedFile.SaveAs(Server.MapPath("~/upload/") + g + "_PAN_" + fileName);
// Pancard = "~/upload/" + g + "_PAN_" + fileName;
//}
if (AddressProof == "")
{
AddressProof = objMemberMaster.AddressProof;
}
if (Pancard == "")
{
Pancard = objMemberMaster.Pancard;
}
objMemberMaster.LoginPassword = txtLoginPassword.Text;
objMemberMaster.TransectionPassword = "";
objMemberMaster.UserCode = txtMemberCode.Text;
objMemberMaster.UserName = txtname.Text;
objMemberMaster.DOB = DateTime.Parse(txtDateOfBirth.Text.Trim(), new CultureInfo("en-GB"));
objMemberMaster.Address = txtAddress.Text;
objMemberMaster.city = txtcity.Text.ToString();
objMemberMaster.State = txtstate.Text.ToString();
objMemberMaster.Country = txtcountry.Text.ToString();
objMemberMaster.PostalCode = txtPinCode.Text;
objMemberMaster.MobileNo = txtMobileNo.Text;
objMemberMaster.TelephoneNo = "";
objMemberMaster.EMailID = txtEmailID.Text;
objMemberMaster.PanNo = txtpanno.Text;
objMemberMaster.BankName = txtbankname.Text;
objMemberMaster.AccountNo = txtAmount.Text;
objMemberMaster.IFSCCode = txtifsc.Text;
objMemberMaster.Landmark = "";
objMemberMaster.District = txtDistrict.Text;
objMemberMaster.BranchName = txtbranch.Text;
objMemberMaster.AddressProof = AddressProof;
objMemberMaster.FatherName = Fname.Text;
objMemberMaster.Pancard = Pancard;
objMemberMaster.AadharCard = txtAadharnumber.Text;
String result = objBALMemberMaster.updateMemberAdmin(objMemberMaster);
if (int.Parse(result) == 1)
{
lblMessage.Text = "Profile Updated Successfully";
txtname.Text = "";
txtbankname.Text = "";
txtAddress.Text = "";
txtPinCode.Text = "";
txtMobileNo.Text = "";
txtEmailID.Text = "";
txtDistrict.Text = "";
Fname.Text = "";
txtDateOfBirth.Text = "";
txtbranch.Text = "";
txtLoginPassword.Text = "";
txtMemberCode.Text = "";
txtcity.Text = "";
txtstate.Text = "";
txtAmount.Text = "";
txtpanno.Text = "";
txtcountry.Text = "";
txtifsc.Text = "";
txtAadharnumber.Text = "";
}
else
{
lblMessage.Text = "Updation Failed";
}
}
