protected void Login_Click(object sender, EventArgs e)
{
Validate validate = new Validate();
string user="",password="";
if (validate.isValidInput(UserName, 3))
user = UserName.Text.Trim();
else
showMessage("Invalid User Name");
if (validate.isValidInput(Password, 3))
password = Password.Text.Trim();
else
showMessage("Invalid Password");
int res = new ValidateUser().isValidUser(user,password);
if (res > 0)
{
string strUser = "******"
+ "um_logstat,um_special,um_group_id,um_email,um_lastresetday,datediff(d, um_lastresetday, getdate()) as intDay,"
+ "um_resetpwddays, um_locked, um_poaforpayin,um_status from User_master where um_user_id ='" + user + "'";
DBHelper db = new DBHelper();
DataTable dt = db.executeQuery(strUser);
db.setSessionValue("UserId", user);
db.setSessionValue("Password", password);
db.setSessionValue("UserGroup", db.GetDtValue(dt, "um_group_id"));
Response.Redirect("~/Home.aspx");
db.setSessionValue("LoginPage","~/Login.aspx");
}
else {
showMessage("Invalid User Name / Password");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (string.IsNullOrWhiteSpace(Session["UserId"] as string))
{
Response.Redirect("~/Login.aspx");
}
else {
string code1 = Request.QueryString["code1"];
string code2 = Request.QueryString["code2"];
if (!string.IsNullOrWhiteSpace(code1) && !string.IsNullOrWhiteSpace(code2))
{
string strUser = "******"
+" id_settlementno,id_cc_id,cm_name,id_dqty,id_qty,id_executiondate,id_remarks,id_entrymode"
+" from Interdepository left join Client_master1 on id_cc_id = Client_master1.cm_cd"
+ " where id_instcd=" + code1 + " and id_pri_key=" + code2 ;
DBHelper db = new DBHelper();
DataTable dt = db.executeQuery(strUser);
lbl_set_date.Text = db.GetDtValue(dt, "id_trxdate");
lbl_set_scrollNo.Text = db.GetDtValue(dt, "id_scrollno");
lbl_set_insType.Text = db.GetDtValue(dt, "id_instcd");
lbl_set_avblLot.Text = db.GetDtValue(dt, "id_lotno");
lbl_set_lotSize.Text = db.GetDtValue(dt, "lotsize");
lbl_set_slipNo.Text = db.GetDtValue(dt, "id_settlementno");
lbl_set_clientCode.Text = db.GetDtValue(dt, "id_cc_id");
lbl_set_clientName.Text = db.GetDtValue(dt, "cm_name");
lbl_set_instructions.Text = db.GetDtValue(dt, "id_dqty");
lbl_set_noofcerts.Text = db.GetDtValue(dt, "id_qty");
lbl_set_execDate.Text = db.GetDtValue(dt, "id_executiondate");
lbl_set_charges.Text ="";
lbl_set_remarks.Text = db.GetDtValue(dt, "id_remarks");
lbl_set_mod.Text = db.GetDtValue(dt, "id_entrymode");
}
}
}
}