protected void btnsubmit_Click(object sender, EventArgs e) { if (txtpassword2.Text == "" || txtpassword1.Text == "") { message.Visible = true; message.Text = "請輸入密碼"; } else { if (txtpassword1.Text == txtpassword2.Text) { logincheckDataContext lc = new logincheckDataContext(); var Accounttable = from row in lc.Account where row.account1.Equals(Session[CDictionary.SESSION_COMPANYACCOUNT].ToString()) select row; foreach (Account cust in Accounttable) { cust.password = txtpassword1.Text; } lc.SubmitChanges(); } else { message.Visible = true; message.Text = "新密碼與確認密碼不相符"; } } Response.Write("<script>alert('更改密碼成功!請使用新密碼再重新登入,謝謝!')</script>"); Response.Write("<script>location.href='../Sign.aspx'</script>"); //Response.Redirect("~/Sign.aspx"); }
protected void drdtype_SelectedIndexChanged(object sender, EventArgs e) { logincheckDataContext lc = new logincheckDataContext(); var classtype = from row in lc.Classfication where row.item.Equals(drdtype.Text) select row; Classfication t = lc.Classfication.FirstOrDefault(m => m.item == drdtype.Text); if (t != null) { classifyID = t.classifyID; } }
private void excuteNonQuery() { logincheckDataContext lc = new logincheckDataContext(); Promotions news_add = new Promotions(); news_add.title = titleInput.Text; news_add.classifyID = classifyID; news_add.startDate = Convert.ToDateTime(startDate.Text); news_add.endDate = Convert.ToDateTime(endDate.Text); news_add.onShelfDate = DateTime.Now.ToUniversalTime().AddHours(8); news_add.picPath = path.ToString(); news_add.content = txtNewsContent.Text; news_add.statusID = 1; news_add.companyID = "C0001"; news_add.comment = null; lc.Promotions.InsertOnSubmit(news_add); lc.SubmitChanges(); }
protected void btnsubmit_Click(object sender, EventArgs e) { bool acc = false, pwd = false; if (txtPasswordCheck.Text == "") { message.Visible = true; message.Text = "請輸入密碼"; } else { logincheckDataContext lc = new logincheckDataContext(); var Accounttable = from row in lc.Account select row; foreach (Account cust in Accounttable) { if (cust.account1.Equals(Session[CDictionary.SESSION_COMPANYACCOUNT].ToString())) { acc = true; if (cust.password.Equals(txtPasswordCheck.Text)) { pwd = true; } } if (acc && pwd) { Session[CDictionary.SESSION_PASSWORDCHECK] = txtPasswordCheck.Text; Response.Redirect("~/windowCompany/companyDetail.aspx"); } else { message.Visible = true; message.Text = "輸入密碼有誤"; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Session[CDictionary.SESSION_ADMIN] == null) { Response.Redirect("~/Sign.aspx"); } logincheckDataContext lc = new logincheckDataContext(); var classtype = from row in lc.Classfication select row; foreach (Classfication cust in classtype) { if (cust.classifyID != 2) //Admin has no Company Promotion option { drdtype.Items.Add(cust.item); } } } }
protected void submit_Click(object sender, EventArgs e) { bool acc = false, pwd = false; if (txtaccount.Text == "" || txtpassword.Text == "") { message.Visible = true; message.Text = "請輸入帳號及密碼"; message.ForeColor = System.Drawing.Color.FromName("#35998E"); } else { logincheckDataContext lc = new logincheckDataContext(); var Accounttable = from row in lc.Account select row; foreach (Account cust in Accounttable) { if (cust.account1.Equals(txtaccount.Text)) { acc = true; if (cust.password.Equals(txtpassword.Text)) { pwd = true; } } if (acc && pwd) { if ((bool)cust.authority) { Session[CDictionary.SESSION_ADMIN] = txtaccount.Text; Response.Redirect("~/windowAdmin/companyCheckforAdmin.aspx"); } else { getcompanyID(); } } else { if (acc) { message.Visible = true; message.Text = "登入密碼有誤"; message.ForeColor = System.Drawing.Color.FromName("#35998E"); } else { message.Visible = true; message.Text = "登入帳號有誤"; message.ForeColor = System.Drawing.Color.FromName("#35998E"); } } } } }
private void getcompanyID() { logincheckDataContext lc = new logincheckDataContext(); var Companytable = from row in lc.Company where row.email.Contains(txtaccount.Text) select row; foreach (Company cust2 in Companytable) { Session[CDictionary.SESSION_COMPANY] = cust2.companyID; Session[CDictionary.SESSION_COMPANYACCOUNT] = txtaccount.Text; Response.Redirect("~/windowCompany/companyCheck.aspx"); } }