protected void ButtonLogin_Click(object sender, EventArgs e) { try { if(txtLoginCustomerID.Text == string.Empty || txtLoginCustomerPass.Text == string.Empty) { return; } LoginCustomerInfo objLoginCustomer = new LoginCustomerInfo(); objLoginCustomer = getCustomerLoginInfo(txtLoginCustomerID.Text, txtLoginCustomerPass.Text); if(objLoginCustomer ==null) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("TITLE_ERROR"), "" + GetResource("MSG_LOGIN_CUSTOMER_WRONG") + "") + "\");"); return; } if(objLoginCustomer.Delete_flag=="True"||objLoginCustomer.Expiration_date.Date<DateTime.Today.Date) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("TITLE_ERROR"), "" + GetResource("MSG_LOGIN_CUSTOMER_INVALID") + "") + "\");"); return; } else { Session["customer"] = objLoginCustomer.Customer_id; if (objLoginCustomer.Mode_code == 1) { Server.Transfer("UploadCustomer.aspx?customerId="+objLoginCustomer.Customer_id+""); } else { Server.Transfer("DownloadCustomer.aspx?customerId=" + objLoginCustomer.Customer_id + ""); } } } catch (ThreadAbortException) { // do nothing } catch(Exception ex) { logger.Error("Login custmer fail",ex); RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("TITLE_ERROR"), "" + ex.Message + "") + "\");"); } }
private LoginCustomerInfo getCustomerLoginInfo(string ID, string Pass) { try { LoginCustomerInfo objCustomerInfo = new LoginCustomerInfo(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DDV_GetLoginCustomerInfo"; cmd.Parameters.Add(new SqlParameter("@customer_id", ID)); cmd.Parameters.Add(new SqlParameter("@customer_password", Pass)); cnn.Open(); DataTable dt = new DataTable(); SqlDataAdapter adt = new SqlDataAdapter(cmd); adt.Fill(dt); if (dt.Rows.Count == 0) { objCustomerInfo = null; } else { foreach (DataRow r in dt.Rows) { objCustomerInfo.Customer_id = r["customer_id"].ToString(); objCustomerInfo.Customer_password = r["customer_password"].ToString(); objCustomerInfo.Mode_code = int.Parse(r["Mode_code"].ToString()); objCustomerInfo.Delete_flag = r["delete_flag"].ToString(); objCustomerInfo.Expiration_date = DateTime.Parse(r["Expiration_date"].ToString()); } } return objCustomerInfo; } catch(Exception ex) { logger.Error("Load Database fail ",ex); RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("TITLE_ERROR"), "" + ex.Message + "") + "\");"); return null; } finally { cnn.Close(); } }