protected void Btnsub_Click(object sender, EventArgs e)
{
try
{
string newpass = Txtpassword.Text.Trim();
string confirmnewpass = Txtcnfrmpass.Text.Trim();
//string userid = Convert.ToString(Session["UserID"]);
var valusrid = (from q in db.Siddeswari_Login
where q.SiddOrgUserID == Txtusrid.Text.Trim()
select new { q.SiddOrgUserID }).SingleOrDefault();
if (newpass == confirmnewpass)
{
var custusrid = (from q in db.Siddeswari_Login
where q.SiddOrgUserID == valusrid.SiddOrgUserID
select new { q }).SingleOrDefault();
custusrid.q.SiddOrgPassword = newpass;
db.SaveChanges();
Emailidn.Visible = false;
cnfmpass.Visible = true;
cnfmnewpass.Visible = true;
Btnsub.Visible = true;
lblmsg.Visible = true;
lblmsg.Text = "New password was set successfully";
lblmsg.ForeColor = System.Drawing.Color.Green;
Txtpassword.Text = string.Empty;
Txtcnfrmpass.Text = string.Empty;
}
} catch (Exception ex)
{
throw (ex);
}
}
protected void removeextcustrecords()
{
try
{
string custid = Convert.ToString(Application["Usercustid"]);
var cartdisplval = db.Siddeswari_Addtocart.Where(x => x.SiddOrgCustID == custid && x.SiddorgTranactvflag == "A").ToList();
foreach (var i in cartdisplval)
{
db.Siddeswari_Addtocart.Remove(i);
}
db.SaveChanges();
Session["accesflag"] = "D";
accessflg = Convert.ToString(Session["accesflag"]);
}
catch (Exception ex)
{
throw (ex);
}
}
protected void Btnsubmit_Click(object sender, EventArgs e)
{
try
{
var duplcont = (from q in db.Siddeswari_Login
where q.SiddOrgUserID == TxtEmail.Text.Trim()
select new { q }).ToList();
if (duplcont.Count == 0)
{
CustAdder.SiddOrgAddrsType = "Customer";
CustAdder.SiddOrgBuldnumber = (TxtBldgNum.Text).Trim();
CustAdder.SiddOrgCityname = (Txtcity.Text).Trim();
CustAdder.SiddOrgStreetnumberone = (Txtstreet.Text).Trim();
CustAdder.SiddOrgStreetnumbertwo = (Txtstreet2.Text).Trim();
CustAdder.SiddOrgState = (Txtstate.Text).Trim();
CustAdder.SiddOrgZipcode = TxtZipcode.Text.Trim();
CustAdder.SiddOrgCountryname = CntryName.SelectedItem.Text;
var addridcnt = (from q in db.Siddeswari_Master_Address
select new { }).ToList();
int lataddrcnt = addridcnt.Count + 1;
CustAdder.SiddOrgAddrsID = "AD" + lataddrcnt;
db.Siddeswari_Master_Address.Add(CustAdder);
db.SaveChanges();
var usrrole = (from q in db.Siddeswari_Admin
where q.SiddOrgRolename == "User"
select new { q.SiddOrgAdminroleID }).SingleOrDefault();
Custlogin.SiddOrgUserID = TxtEmail.Text.Trim();
Custlogin.SiddOrgroleID = usrrole.SiddOrgAdminroleID;
Custlogin.SiddOrgPassword = CreatePassword(7);
Custlogin.Createts = System.DateTime.Now;
db.Siddeswari_Login.Add(Custlogin);
try {
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
Custdetl.SiddOrgCntryCode = Drpcode.SelectedItem.Value;
Custdetl.SiddOrgPhonenumber = TxtTelnumb.Text.Trim();
Custdetl.SiddOrgCustEmailID = TxtEmail.Text.Trim();
Custdetl.SiddOrgCustFirstName = TxtFirstName.Text.Trim();
Custdetl.SiddOrgCustLastName = TxtLastName.Text.Trim();
Custdetl.SiddOrgCreatets = System.DateTime.Now;
Custdetl.SiddOrgAddrsID = CustAdder.SiddOrgAddrsID;
var custcnt = (from q in db.Siddeswari_Master_Customer
select new { }).ToList();
int custcntnumb = custcnt.Count() + 1;
Custdetl.SiddOrgCustomerid = "CU" + custcntnumb;
db.Siddeswari_Master_Customer.Add(Custdetl);
db.SaveChanges();
sendcustomermail();
lblmsg.Visible = true;
lblmsg.Text = "Customer Details Saved Successfully,User Credentials Sent to Mail ID";
lblmsg.ForeColor = System.Drawing.Color.Green;
clearfields();
}
else
{
lblmsg.Visible = true;
lblmsg.Text = "User id has already exists,please choose another mail id ";
lblmsg.ForeColor = System.Drawing.Color.Red;
TxtEmail.Text = string.Empty;
}
}
catch (Exception ex)
{
throw (ex);
}
}
protected void updatepymtdetails()
{
var DbTrans = db.Database.BeginTransaction();
try
{
if (lblpymtsucc.Text == "Y")
{
// update existing customer details
var updtexcustdtls = (from q in db.Siddeswari_Master_Customer
join p in db.Siddeswari_Login on q.SiddOrgCustEmailID equals p.SiddOrgUserID
join r in db.Siddeswari_Master_Address on q.SiddOrgAddrsID equals r.SiddOrgAddrsID
where p.SiddOrgUserID == usrlogid
select new { q, r }).FirstOrDefault();
updtexcustdtls.q.SiddOrgCustFirstName = Txtfirstname.Text.Trim();
updtexcustdtls.q.SiddOrgCustLastName = Txtlastname.Text.Trim();
updtexcustdtls.r.SiddOrgBuldnumber = Txtbuild.Text.Trim();
updtexcustdtls.r.SiddOrgStreetnumberone = Txtstreet.Text.Trim();
updtexcustdtls.r.SiddOrgStreetnumbertwo = Txtstreet2.Text.Trim();
updtexcustdtls.r.SiddOrgCityname = Txtcity.Text.Trim();
updtexcustdtls.r.SiddOrgState = Txtstate.Text.Trim();
updtexcustdtls.r.SiddOrgZipcode = Txtzip.Text.Trim();
db.SaveChanges();
// insert donation details
var donschdetl = (from q in db.Siddeswari_Master_OrgDonationScheme
where q.SiddOrgDonschemename == Drppujlst.SelectedItem.Text
select new { q.SiddOrgDondetails, q.SiddOrgDonschemimagepath, q.SiddOrgOrgdonschemeid }).FirstOrDefault();
var cntdonations = (from q in db.Siddeswari_OrgDonate_Details
select new { }).ToList();
int cntdon = cntdonations.Count();
cntdon = cntdon + 1;
donatedet.SiddOrgOrgdonatedetlid = "DN" + cntdon;
donatedet.SiddOrgCustomerID = usrlogid;
donatedet.SiddOrgDondetails = donschdetl.SiddOrgDondetails.Trim();
donatedet.SiddOrgDonsamount = Txtdonamt.Text.Trim();
donatedet.SiddOrgDonschemimagepath = donschdetl.SiddOrgDonschemimagepath.Trim();
donatedet.SiddOrgOrgdonschemeid = donschdetl.SiddOrgOrgdonschemeid.Trim();
donatedet.SiddOrgCreatets = DateTime.Now;
db.Siddeswari_OrgDonate_Details.Add(donatedet);
db.SaveChanges();
// insert payment transaction details
var custid = (from q in db.Siddeswari_Master_Customer
where q.SiddOrgCustEmailID == usrlogid
select new { q.SiddOrgCustomerid }).FirstOrDefault();
var saletrcnt = (from q in db.Siddeswari_Saletransactions
select new { }).ToList();
int saletrncount = saletrcnt.Count() + 1;
saletrandtl.SiddOrgPujaSaletransID = "S" + saletrncount;
saletrandtl.TypeofMoneytransaction = "Donation";
saletrandtl.SiddOrginvoiceid = "XXXX";
saletrandtl.SiddOrgtransqtyno = 1;
saletrandtl.SiddOrgTranscurrency = "USD";
saletrandtl.SiddOrgTransdate = DateTime.Now;
saletrandtl.SiddOrgTotprice = Txtdonamt.Text.Trim();
saletrandtl.SiddOrgCustomerid = custid.SiddOrgCustomerid;
saletrandtl.SiddOrgTranscdtls = Txtfirstname.Text.Trim() + Txtlastname.Text.Trim() + " Donated" + Environment.NewLine + " a sum of " + Txtdonamt.Text.Trim() + " towards " + Drppujlst.SelectedItem.Text + " Scheme.";
saletrandtl.MastPujaid = "XXXX";
saletrandtl.MastSchemid = donschdetl.SiddOrgOrgdonschemeid;
saletrandtl.SaletranTaxprice = "0";
db.Siddeswari_Saletransactions.Add(saletrandtl);
db.SaveChanges();
DbTrans.Commit();
// send mail to customer and sri siddeswari seva
sendmail();
lblmsg.Text = "Donation done, details sent in a mail";
lblmsg.ForeColor = System.Drawing.Color.Green;
}
else
{
lblmsg.Text = "Paypal Payment was not successful, Please retry";
lblmsg.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
DbTrans.Rollback();
throw (ex);
}
}
//protected void Pay()
//{
// string pujname = Drpmastpuj.SelectedItem.Text;
// originalprice = Txtprice.Text.Trim();
// totalprice = originalprice;
// itemcurrency = Drpprice.SelectedItem.Text;
// RemotePost myremotepost = new RemotePost();
// myremotepost.Url = "https://www.paypal.com/cgi-bin/webscr";
// myremotepost.Add("business", "*****@*****.**");
// myremotepost.Add("cmd", "_xclick");
// myremotepost.Add("item_name", "Ganapathi");
// myremotepost.Add("amount", "300");
// myremotepost.Add("currency_code", "USD");
// myremotepost.Post();
//}
//public class RemotePost
//{
// private System.Collections.Specialized.NameValueCollection Inputs = new System.Collections.Specialized.NameValueCollection();
// public string Url = "";
// public string Method = "post";
// public string FormName = "form1";
// public void Add(string name, string value)
// {
// Inputs.Add(name, value);
// }
// public void Post()
// {
// System.Web.HttpContext.Current.Response.Clear();
// System.Web.HttpContext.Current.Response.Write("<html><head>");
// System.Web.HttpContext.Current.Response.Write(string.Format("</head><body onload=\"document.{0}.submit()\">", FormName));
// System.Web.HttpContext.Current.Response.Write(string.Format("<form name=\"{0}\" method=\"{1}\" action=\"{2}\" >", FormName, Method, Url));
// for (int i = 0; i < Inputs.Keys.Count; i++)
// {
// System.Web.HttpContext.Current.Response.Write(string.Format("<input name=\"{0}\" type=\"hidden\" value=\"{1}\">", Inputs.Keys[i], Inputs[Inputs.Keys[i]]));
// }
// System.Web.HttpContext.Current.Response.Write("</form>");
// System.Web.HttpContext.Current.Response.Write("</body></html>");
// System.Web.HttpContext.Current.Response.End();
// }
//}
protected void updatepymtdetails()
{
var DbTrans = db.Database.BeginTransaction();
string pujname = Drpmastpuj.SelectedItem.Text;
usrlogid = Convert.ToString(Application["Usercustid"]);
Txtemail.Attributes.Remove("disabled");
Txtprice.Attributes.Remove("disabled");
originalprice = Txtprice.Text.Trim();
totalprice = originalprice;
itemcurrency = Drpprice.SelectedItem.Text;
try
{
if (lblpymtsucc.Text == "Y")
{
// update existing customer details
var updtexcustdtls = (from q in db.Siddeswari_Master_Customer
join p in db.Siddeswari_Login on q.SiddOrgCustEmailID equals p.SiddOrgUserID
join r in db.Siddeswari_Master_Address on q.SiddOrgAddrsID equals r.SiddOrgAddrsID
where p.SiddOrgUserID == usrlogid
select new { q, r }).FirstOrDefault();
updtexcustdtls.q.SiddOrgCustFirstName = Txtfirstnam.Text.Trim();
updtexcustdtls.q.SiddOrgCustLastName = Txtlastnam.Text.Trim();
updtexcustdtls.r.SiddOrgBuldnumber = Txrbldnumb.Text.Trim();
updtexcustdtls.r.SiddOrgStreetnumberone = Txtstrt.Text.Trim();
updtexcustdtls.r.SiddOrgStreetnumbertwo = Txtstrt2.Text.Trim();
updtexcustdtls.r.SiddOrgCityname = Txtcity.Text.Trim();
updtexcustdtls.r.SiddOrgState = Txtstate.Text.Trim();
updtexcustdtls.r.SiddOrgZipcode = Txtzipcd.Text.Trim();
db.SaveChanges();
// insert puja schedule details
DateTime datpuj = Convert.ToDateTime(txtdateofpuja.Value);
var cntpujschd = (from q in db.Siddeswari_PujaSchd
select new { }).ToList();
int cntpujshd = cntpujschd.Count();
cntpujshd = cntpujshd + 1;
var mstpujid = (from q in db.Siddeswari_Master_Puja
where q.SiddOrgPujaName == pujname
select new { q.SiddOrgOrgPujaID }).FirstOrDefault();
pujschd.SiddOrgPujaSchdID = "PJ" + cntpujshd;
pujschd.SiddOrgAltPhonenumb = Txtalterphone.Text.Trim();
pujschd.SiddOrgCustGothram = TxtGothram.Text.Trim();
pujschd.SiddOrgFamilydetls = Txtfamildet.Text.Trim();
pujschd.SiddOrgPujadate = datpuj;
pujschd.SiddOrgPujalocation = TxtPujloc.Text.Trim();
pujschd.SiddOrgOrgPujaID = mstpujid.SiddOrgOrgPujaID;
db.Siddeswari_PujaSchd.Add(pujschd);
db.SaveChanges();
// insert payment transaction details
var pujaid = (from q in db.Siddeswari_Master_Puja
where q.SiddOrgPujaName == pujname
select new { q.SiddOrgOrgPujaID }).FirstOrDefault();
var custid = (from q in db.Siddeswari_Master_Customer
where q.SiddOrgCustEmailID == usrlogid
select new { q.SiddOrgCustomerid }).FirstOrDefault();
var saletrcnt = (from q in db.Siddeswari_Saletransactions
select new { }).ToList();
int saletrncount = saletrcnt.Count() + 1;
saletrans.SiddOrgPujaSaletransID = "S" + saletrncount;
saletrans.TypeofMoneytransaction = "Puja/Homam Service";
saletrans.SiddOrginvoiceid = "XXXX";
saletrans.SiddOrgtransqtyno = 1;
saletrans.SiddOrgTranscurrency = Drpprice.SelectedItem.Text;
saletrans.SiddOrgTransdate = DateTime.Now;
saletrans.SiddOrgTotprice = Convert.ToString(totalprice);
saletrans.SiddOrgCustomerid = custid.SiddOrgCustomerid;
saletrans.SiddOrgTranscdtls = Txtfirstnam.Text.Trim() + Txtlastnam.Text.Trim() + " has Scheduled a Puja/Homa" + Environment.NewLine + "For a Total of price" + Drpprice.SelectedItem.Text + " " + totalprice + " at " + TxtPujloc.Text.Trim();
saletrans.MastPujaid = pujschd.SiddOrgPujaSchdID;
saletrans.MastSchemid = "XXXX";
saletrans.SaletranTaxprice = "0";
db.Siddeswari_Saletransactions.Add(saletrans);
db.SaveChanges();
DbTrans.Commit();
sendmail();
lblmsg.Text = "Puja/Homam Scheduled, Details Sent";
lblmsg.ForeColor = System.Drawing.Color.Green;
}
else
{
lblmsg.Text = "Paypal Payment was not successful, Please retry";
lblmsg.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
DbTrans.Rollback();
throw (ex);
}
}
