public void UpdateCustomerByCustomerID(BKCustomerInfo custinfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from customer in db.BKCustomers where customer.Customercode == custinfo.CustomerCode select customer).First(); obj.Contact = custinfo.Contact; obj.Address = custinfo.address; obj.Name = custinfo.Name; obj.TownshipID = custinfo.TownshipID; obj.UpdateDate = DateTime.Now; db.SubmitChanges(); } } catch (Exception ex) { Customer cust = new Customer(); } }
public string insert_customer(BKCustomerInfo custinfo) { try { using (RMSDataContext db = new RMSDataContext()) { BKCustomer custbl = new BKCustomer(); //custbl.CustomerID = custinfo.CustomerID; custbl.Name = custinfo.Name; custbl.Address = custinfo.address; custbl.Contact = custinfo.Contact; custbl.CustomerPassword = custinfo.CustomerPassword; //custbl.TownshipID = custinfo.TownshipID; custbl.InsertDate = custinfo.InsertDate; custbl.UpdateDate = custinfo.UpdateDate; db.BKCustomers.InsertOnSubmit(custbl); db.SubmitChanges(); return(custinfo.Name); } } catch (Exception ex) { return(string.Empty); } }
public List <BKCustomerInfo> selectallBKCustomerInfo() { try { List <BKCustomerInfo> listBKCustomerInfo = new List <BKCustomerInfo>(); { using (RMSDataContext db = new RMSDataContext()) { BKCustomerInfo BKCustomerInfo; var a = (from o in db.BKCustomers select o).ToList(); foreach (var obj in a) { BKCustomerInfo = new BKCustomerInfo(); BKCustomerInfo.CustomerID = obj.CustomerID; BKCustomerInfo.CustomerCode = obj.Customercode; BKCustomerInfo.Name = obj.Name; BKCustomerInfo.TownshipID = obj.TownshipID; BKCustomerInfo.Contact = obj.Contact; BKCustomerInfo.address = obj.Address; BKCustomerInfo.InsertDate = obj.InsertDate; BKCustomerInfo.UpdateDate = obj.UpdateDate; listBKCustomerInfo.Add(BKCustomerInfo); } return(listBKCustomerInfo); } } } catch (Exception ex) { return(new List <BKCustomerInfo>()); } }
protected void btnSubmit_Click(object sender, EventArgs e) { //if(txtpw.Text.Trim() == txtretypepw.Text.Trim()) //{ BKCustomerController bcon = new BKCustomerController(); BKCustomerInfo binfo = new BKCustomerInfo(); int i = bcon.selectBKCustomerInfoByMobile(txtMobileNo.Text.Trim()); if (i == 0) { binfo.Name = txtName.Text.Trim(); binfo.Contact = txtMobileNo.Text.Trim(); binfo.address = txtAddress.Text.Trim(); binfo.CustomerPassword = "******"; binfo.InsertDate = DateTime.UtcNow.AddMinutes(390); binfo.UpdateDate = DateTime.UtcNow.AddMinutes(390); string statusMsg = bcon.InsertCustomer(binfo); if (!string.IsNullOrEmpty(statusMsg)) { string msg = "if (Notification.permission === 'granted') { var notify = new Notification('New Customer' , { body: '" + statusMsg + "',icon: '',} )}" + "else {" + "Notification.requestPermission().then(function (p) {" + " if (p === 'granted') {" + " var notify = new Notification('New Customer'+ Msg, {" + " body: '" + statusMsg + "'," + " icon: ''," + " });" + " } else {" + " console.log('User blocked notifications.');" + " }" + " }).catch(function (err) {" + " console.error(err);" + " });" + "};"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Alert Message", msg, true); initializeControls(); } else { } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Alert Message", @"alert('Mobile No is already used!\n Try another Mobile No')", true); txtMobileNo.Style.Add("border-color", "Orange"); } }
public void DeleteCustomerByCustomerID(BKCustomerInfo custinfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from cust in db.BKCustomers where cust.Customercode == custinfo.CustomerCode select cust).First(); db.BKCustomers.DeleteOnSubmit(obj); db.SubmitChanges(); } } catch (Exception ex) { Customer c = new Customer(); } }
protected void BtnSignIn_Click(object sender, EventArgs e) { BKCustomerController bcon = new BKCustomerController(); BKCustomerInfo bin = new BKCustomerInfo(); bin.Contact = txtmobile.Text.Trim(); bin.CustomerPassword = txtPassword.Text.Trim(); int ret = bcon.LoginStatus(bin); if (ret > 0) { if (customCheck.Checked) { } Response.Redirect("tstProduct.aspx"); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Alert Message", @"alert('Mobile No (or) Password is incorrect!')", true); } }
public int LoginStatus(BKCustomerInfo custInfo) { return(cusdao.Login(custInfo.Contact, custInfo.CustomerPassword)); }
public void DeleteCustomer(BKCustomerInfo custInfo) { cusdao.DeleteCustomerByCustomerID(custInfo); }
public void UpdateCustomer(BKCustomerInfo custInfo) { cusdao.UpdateCustomerByCustomerID(custInfo); }
public string InsertCustomer(BKCustomerInfo custInfo) { return(cusdao.insert_customer(custInfo)); }