public bool getlogin(string username, string password) { try { bool status = false; string code = txtclientcode.Text; LoginBLL obj = new LoginBLL(); LoginModelDLL model = obj.getActiveLogin(username, password); if (model != null) { if (model.RoleID == -1) { Session["admin"] = model.SessionName; Session["displayName"] = model.DisplayName; status = true; } if (model.RoleID == 1) { if (code != "") { int res = obj.getActiveCode(code); if (res != 0) { Session["user"] = model.LoginID; Session["displayName"] = model.DisplayName; status = true; } } else { allowStaticMethods("alertshow('Client code must be required'); enabledSubmit('.logintxt', '.btnLogin');"); } } if (model.RoleID == 0) { if (code != "") { int res = obj.getActiveCode(code); if (res != 0) { Session["poweruser"] = model.LoginID + "," + model.ClientID; Session["displayName"] = model.DisplayName; status = true; } } else { allowStaticMethods("alertshow('Client code must be required'); enabledSubmit('.logintxt', '.btnLogin');"); } } } return(status); } catch (Exception) { return(false); } }
public LoginModelDLL getActiveLogin(string username, string status) { LoginModelDLL model = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@User", username), new SqlParameter("@Status", status) }; using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("uspGET_LoginStatus", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count == 1) { model = new LoginModelDLL(); DataRow row = table.Rows[0]; model.DisplayName = row["DisplayName"].ToString(); model.SessionName = row["SessionName"].ToString(); model.ClientID = row["ClientID"].ToString(); model.RoleID = Convert.ToInt32(row["RoleID"]); model.LoginID = Convert.ToInt32(row["LoginID"]); } } return(model); }