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);
}
