public BE_Json GetUserGeneral(BE_UserFilter bE_UserFilter)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Usuario _blUsuario = new BL_Usuario();
_blUsuario.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(_blUsuario.GetUserGeneral(bE_UserFilter));
objJson = new BE_Json();
objJson.data = objListaAux;
objJson.status = CManager.RESULTADO_WCF.OK;
}
catch (Exception ex)
{
objJson = new BE_Json();
objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
objJson.status = CManager.RESULTADO_WCF.ERROR;
objJson.status = CManager.RESULTADO_WCF.ERROR;
}
finally
{
objListaAux = null;
}
return(objJson);
}
public List <BE_User> getUserGeneral(BE_UserFilter bE_UserFilter)
{
BE_User _BeUser = null;
List <BE_User> _lstUser = new List <BE_User>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_userId", bE_UserFilter.id);
parameters.Add("_userEmailList", bE_UserFilter.UserEmailList);
parameters.Add("_userNameList", bE_UserFilter.UserNameList);
parameters.Add("_searchFilter", bE_UserFilter.SearchFilter);
var rows = _database.QuerySP("sp_getUserGeneral", parameters);
foreach (var row in rows)
{
_BeUser = new BE_User();
_BeUser.id = row["Id"];
_BeUser.accessFailedCount = string.IsNullOrEmpty(row["AccessFailedCount"]) ? 0 : int.Parse(row["AccessFailedCount"]);
_BeUser.concurrencyStamp = row["ConcurrencyStamp"];
_BeUser.configuration = row["Configuration"];
_BeUser.email = row["Email"];
_BeUser.emailConfirmed = string.IsNullOrEmpty(row["EmailConfirmed"]) ? false : row["EmailConfirmed"].Equals("1") ? true : false;
_BeUser.firstName = row["FirstName"];
_BeUser.isEnabled = string.IsNullOrEmpty(row["IsEnabled"]) ? false : row["IsEnabled"].Equals("1") ? true : false;
_BeUser.lastName = row["LastName"];
_BeUser.lockoutEnabled = string.IsNullOrEmpty(row["LockoutEnabled"]) ? false : row["LockoutEnabled"].Equals("1") ? true : false;
_BeUser.lockoutEnd = string.IsNullOrEmpty(row["LockoutEnd"]) ? DateTime.MinValue : DateTime.Parse(row["LockoutEnd"]);
_BeUser.lockoutEndFormat = _BeUser.lockoutEnd.ToShortDateString();
_BeUser.normalizedEmail = row["NormalizedEmail"];
_BeUser.normalizedUserName = row["NormalizedUserName"];
_BeUser.passwordHash = row["PasswordHash"];
_BeUser.phoneNumber = row["PhoneNumber"];
_BeUser.phoneNumberConfirmed = string.IsNullOrEmpty(row["PhoneNumberConfirmed"]) ? false : row["PhoneNumberConfirmed"].Equals("1") ? true : false;
_BeUser.twoFactorEnabled = string.IsNullOrEmpty(row["TwoFactorEnabled"]) ? false : row["TwoFactorEnabled"].Equals("1") ? true : false;
_BeUser.userName = row["UserName"];
_lstUser.Add(_BeUser);
}
return(_lstUser);
}
public List <BE_User> GetUserGeneral(BE_UserFilter bE_UserFilter)
{
_database = new MySQLDatabase(connectionString);
return(new DA_User(_database).getUserGeneral(bE_UserFilter));
}
