public BE_Json UpdateRoleGeneral(BE_Roles bE_Roles)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Roles bL_Roles = new BL_Roles();
bL_Roles.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(bL_Roles.UpdateRoleGeneral(bE_Roles));
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_Roles> getRoleName()
{
BE_Roles _BeRoles = null;
List <BE_Roles> _lstRoles = new List <BE_Roles>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
var rows = _database.QuerySP("sp_getRoleName", parameters);
foreach (var row in rows)
{
_BeRoles = new BE_Roles();
_BeRoles.name = row["Name"];
_lstRoles.Add(_BeRoles);
}
return(_lstRoles);
}
public BE_Roles getRoleIdbyRoleName(string roleName)
{
BE_Roles _BeRoles = null;
Dictionary <string, object> parameters = new Dictionary <string, object>()
{
{ "_name", roleName }
};
var rows = _database.QuerySP("sp_getRoleIdbyRoleName", parameters);
foreach (var row in rows)
{
_BeRoles = new BE_Roles();
_BeRoles.roleId = row["Id"];
}
return(_BeRoles);
}
public BE_Roles updateRoleGeneral(BE_Roles bE_Roles)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_roleId", bE_Roles.roleId);
parameters.Add("_concurrencyStamp", bE_Roles.concurrencyStamp);
parameters.Add("_description", bE_Roles.description);
parameters.Add("_limitAmount", bE_Roles.limitAmount);
parameters.Add("_name", bE_Roles.name);
parameters.Add("_normalizedName", bE_Roles.normalizedName);
parameters.Add("_updatedBy", bE_Roles.updatedBy);
filasAfectadas = _database.ExecuteSP("sp_updateRoleGeneral", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(bE_Roles);
}
return(null);
}
public List <BE_Roles> getRoleGeneral(int roleId)
{
BE_Roles bE_Roles = null;
List <BE_Roles> _lstRoles = new List <BE_Roles>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_roleId", roleId);
var rows = _database.QuerySP("sp_getRoleGeneral", parameters);
foreach (var row in rows)
{
bE_Roles = new BE_Roles();
bE_Roles.roleId = row["Id"];
bE_Roles.concurrencyStamp = row["ConcurrencyStamp"];
bE_Roles.description = row["Description"];
bE_Roles.limitAmount = string.IsNullOrEmpty(row["LimitAmount"]) ? 0 : decimal.Parse(row["LimitAmount"]);
bE_Roles.name = row["Name"];
bE_Roles.normalizedName = row["NormalizedName"];
_lstRoles.Add(bE_Roles);
}
return(_lstRoles);
}
public BE_Roles UpdateRoleGeneral(BE_Roles bE_Roles)
{
_database = new MySQLDatabase(connectionString);
return(new DA_Roles(_database).updateRoleGeneral(bE_Roles));
}
