//string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString();
#endregion
/// <summary>
/// Valida si el usuario que ingresa al sistema es válido
/// </summary>
/// <param name="userLogin"></param>
/// <param name="userPassword"></param>
/// <returns></returns>
public MessageDTO GetValidUser(string userLogin, string userPassword)
{
DataTable dataTable = new DataTable();
MessageDTO message = new MessageDTO();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
List <object> users = new List <object>();
try
{
//Todos los registros
object[] parameters = new object[] { userLogin, userPassword };
connector.FillDataTable(dataTable, CommandType.StoredProcedure, "GetValidUser", parameters);
if (dataTable.Rows.Count > 0)
{
foreach (DataRow row in dataTable.Rows)
{
UserDTO user = new UserDTO
{
Company = new CompanyDTO
{
CompanyId = Convert.ToInt32(row["COMPANY_ID"]),
CompanyName = row["COMPANY_NAME"].ToString(),
CompanyShortName = row["COMPANY_SHORT_NAME"].ToString()
},
UserId = Convert.ToInt32(row["USR_ID"]),
Employee = new EmployeeDTO
{
EmployeeId = Convert.ToInt32(row["EMPLOYEE_ID"]),
IdentificationNumber = row["EMPLOYEE_IDNUMBER"].ToString(),
EmployeeName = row["EMPLOYEE_NAME"].ToString()
},
Role = new RoleDTO {
RoleId = Convert.ToInt32(row["ROLE_ID"])
},
UserLogin = row["USR_LOGIN"].ToString(),
UserPassword = row["USR_PASSWORD"].ToString(),
UserStatus = row["USR_STATUS"].ToString(),
UserSupervisor = row["USR_SUPERVISOR"].ToString()
};
users.Add(user);
}
message.ErrorCode = "OK";
message.ErrorMessage = "";
message.ListObject = users;
}
else
{
message.ErrorCode = "-1";
message.ErrorMessage = "Usuario y/o contraseña incorrecta";
message.ListObject = null;
}
}
catch (Exception exception)
{
message.ErrorCode = "-1";
message.ErrorMessage = exception.Message.ToString();
users = null;
message.ListObject = null;
}
finally
{
connector.Dispose();
}
return(message);
}
