protected void btnSave_Click(object sender, EventArgs e) { cnum = cnumlbl.Text; firstName = fnamebox.Text; lastName = lnamebox.Text; address = addressbox.Text; city = citybox.Text; province = provincelist.SelectedValue.ToString(); postalCode = pcodebox.Text; phonenumber = phonebox.Text; emailAddress = emailbox.Text; notes = notebox.Text; CsCustomer oldCustomerInfo = new CsCustomer(cnum, firstName, lastName, address, city, province, postalCode, phonenumber, emailAddress, notes, registerDate, levels); try { ConnectionClass.UpdateCustomerDetail(oldCustomerInfo); ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Updated!');</script>"); } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Update failed');</script>"); } finally { DisableTextBoxes(Page); provincelist.Enabled = false; } }
// Get Province list into dropdownlist // 032 customer_seedetail.aspx page open public static void GetCustomerDetail(CsCustomer thecustomer) { string eQuery = string.Format(@"SELECT * FROM tblCustomer WHERE customerID = ('{0}');", thecustomer.cNumber); cmdString = new SqlCommand(eQuery, cntString); try { cntString.Open(); SqlDataAdapter da = new SqlDataAdapter(cmdString); DataTable dt = new DataTable(); DataSet ds = new DataSet(); da.Fill(dt); ds.Tables.Add(dt); thecustomer.cFirstName = dt.Rows[0]["fName"].ToString(); thecustomer.cLastName = dt.Rows[0]["lName"].ToString(); thecustomer.cAddress = dt.Rows[0]["Address"].ToString(); thecustomer.cCity = dt.Rows[0]["City"].ToString(); thecustomer.cProvince = dt.Rows[0]["Province"].ToString(); thecustomer.cPhone = dt.Rows[0]["Phone"].ToString(); thecustomer.cEmail = dt.Rows[0]["Email"].ToString(); thecustomer.cNote = dt.Rows[0]["Note"].ToString(); thecustomer.cRegisterDate = dt.Rows[0]["RegisterDate"].ToString(); thecustomer.cPostalCode = dt.Rows[0]["PostalCode"].ToString(); } finally { cntString.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["ONUM"] != null && Session["CNAME"] != null && !IsPostBack) { lblONum.Text = Session["ONUM"].ToString(); lblCName.Text = Session["CNAME"].ToString(); lblCNum.Text = Session["CNUM"].ToString(); Cnum = Session["CNUM"].ToString(); orderNum = lblONum.Text; try { CsReceipt recept = new CsReceipt(orderNum, reTable, toTable); ConnectionClass.DisplayReceipt(recept); GridView1.DataSource = recept.ReceiptTable; GridView1.DataBind(); CsCustomer thisCustomer = new CsCustomer(Cnum, CFname, CLname, CAddress, Ccity, Cprovince, CPcode, CPhone, CEmail, CNote, CRDate, Clv); ConnectionClass.GetCustomerDetail(thisCustomer); lblCEmail.Text = thisCustomer.cEmail; lblOrderDate.Text = recept.TotalTable.Rows[0][4].ToString(); lblTQty.Text = recept.TotalTable.Rows[0][0].ToString(); lblTAmt.Text = recept.TotalTable.Rows[0][1].ToString(); lblTTax.Text = recept.TotalTable.Rows[0][2].ToString(); lblGTotal.Text = recept.TotalTable.Rows[0][3].ToString(); } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('error');</script>"); } finally { } } else { //ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('No Order');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["customerNum"] != null && !IsPostBack) { cnumlbl.Text = Session["customerNum"].ToString(); cnum = cnumlbl.Text; DisableTextBoxes(Page); try { CsCustomer thatCustomer = new CsCustomer(cnum, firstName, lastName, address, city, province, postalCode, phonenumber, emailAddress, notes, registerDate, levels); ConnectionClass.GetCustomerDetail(thatCustomer); fnamebox.Text = thatCustomer.cFirstName; lnamebox.Text = thatCustomer.cLastName; addressbox.Text = thatCustomer.cAddress; citybox.Text = thatCustomer.cCity; emailbox.Text = thatCustomer.cEmail; phonebox.Text = thatCustomer.cPhone; pcodebox.Text = thatCustomer.cPostalCode; notebox.Text = thatCustomer.cNote; provincelist.SelectedItem.Text = thatCustomer.cProvince; //provincelist.Enabled = false; } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('error');</script>"); } finally { } } else if (Session["customerNum"] != null && IsPostBack) { //provincelist.Enabled = true; } }
protected void btnSubmit_Click(object sender, EventArgs e) { firstname = fnamebox.Text; lastname = lnamebox.Text; email = emailbox.Text; phone = phonebox.Text; address = addressbox.Text; city = citybox.Text; province = provincelist.SelectedValue.ToString(); postalcode = postalcodebox.Text; note = notebox.Text; CsCustomer newcustomer = new CsCustomer(customernum, firstname, lastname, address, city, province, postalcode, phone, email, note, registerdate, level); subject = "Thank you for registering, " + fnamebox.Text; content = @"<h2 style='color:blue;'> Hello " + fnamebox.Text + " ," + " Your account is created successfully. </h2> "; CsRegisterEmail newemail = new CsRegisterEmail(subject, content, email); try { ConnectionClass.RegistrationCustomer(newcustomer); ConnectionClass.SendRegisterEmail(newemail); ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('New Customer Registered successfully and Confirmation email sent out.');</script>"); ClearTextBoxes(Page); provincelist.ClearSelection(); } catch { Response.Write("<script type='text/javascript'>"); Response.Write("alert('please fill out all required fields ');"); Response.Write("</script>"); } finally { } }
public static void RegistrationCustomer(CsCustomer customer) { string cQuery = string.Format(@"INSERT INTO tblCustomer (customerID,fName,lName,Email,Phone,Address,City,Province,PostalCode,Note,RegisterDate) VALUES(NEXT VALUE FOR SQcustomer,(N'{0}'),(N'{1}'),('{2}'),('{3}'),(N'{4}'),(N'{5}'),('{6}'),('{7}'),(N'{8}'),GETDATE());", customer.cFirstName, customer.cLastName, customer.cEmail, customer.cPhone, customer.cAddress, customer.cCity, customer.cProvince, customer.cPostalCode, customer.cNote); cmdString = new SqlCommand(cQuery, cntString); try { cntString.Open(); cmdString.ExecuteNonQuery(); } finally { cntString.Close(); } }
// Get Province list into dropdownlist // 032 customer_seedetail.aspx press save button public static void UpdateCustomerDetail(CsCustomer thiscustomer) { string fQuery = string.Format(@"UPDATE tblCustomer SET fName=(N'{0}'),lName=(N'{1}'), Address=(N'{2}'),City=(N'{3}'),Province=('{4}'),Phone=('{5}'),Email=('{6}'),PostalCode=('{7}'),Note=(N'{8}') WHERE customerID=('{9}');", thiscustomer.cFirstName, thiscustomer.cLastName, thiscustomer.cAddress, thiscustomer.cCity, thiscustomer.cProvince, thiscustomer.cPhone, thiscustomer.cEmail, thiscustomer.cPostalCode, thiscustomer.cNote, thiscustomer.cNumber); cmdString = new SqlCommand(fQuery, cntString); try { cntString.Open(); cmdString.ExecuteNonQuery(); } finally { cntString.Close(); } }