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); } }