public int LoginUser()
{
DataTable dt;
// First get the company information
CompanySelect companySelect = new CompanySelect();
companySelect.CompanyName = companyName;
dt = companySelect.Run();
if (dt.Rows[0]["id"].ToString() != "")
{
loginData.ComID = int.Parse(dt.Rows[0]["id"].ToString());
loginData.CompanyName = dt.Rows[0]["name"].ToString();
}
else
{
return LOGIN_COMPANY_NOEXIST;
}
// Now try to get the user login info
UserSelect userSelect = new UserSelect();
userSelect.UserName = userName;
userSelect.Password = password;
dt = userSelect.Run();
// If we have more than 0 rows
if (dt.Rows[0]["id"].ToString() != "")
{
if (bool.Parse(dt.Rows[0]["allowLogin"].ToString()))
{
if (bool.Parse(dt.Rows[0]["active"].ToString()))
{
loginData.UserID = int.Parse(dt.Rows[0]["id"].ToString());
loginData.UserName = dt.Rows[0]["username"].ToString();
loginData.Role = int.Parse(dt.Rows[0]["role"].ToString());
}
else
{
return LOGIN_INACTIVE;
}
}
else
{
return LOGIN_DISALLOWED;
}
}
else
{
return LOGIN_INCORRECT;
}
return LOGIN_SUCCESS;
}
public int Run()
{
DataTable dt;
CompanySelect companySelect = new CompanySelect();
companySelect.CompanyName = companyName;
dt = companySelect.Run();
if (dt.Rows[0]["id"].ToString() != "")
{
companyData.SetData(dt.Rows[0]);
return COMPANY_EXISTS;
}
else
{
return COMPANY_NOEXIST;
}
}