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;
}
}
public void invoke()
{
try
{
CompanySelect _company;
if (_comID == -1) {
_company = new CompanySelect();
} else {
_company = new CompanySelect(_comID);
}
_company.selectCompany();
this._ds = _company.Ds;
}
catch (Exception ex)
{
throw new Exception("ProcessCompanyQueries::invoke(): " + ex.Message);
}
finally
{
}
}
