public BE_Option UpdateOptionGeneral(BE_Option bE_Option)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_idoption", bE_Option.idOption);
parameters.Add("_title", bE_Option.title);
parameters.Add("_ismenu", bE_Option.ismenu);
parameters.Add("_url", bE_Option.url);
parameters.Add("_idoptionparent", bE_Option.idOptionParent);
parameters.Add("_order", bE_Option.order);
parameters.Add("_description", bE_Option.description);
filasAfectadas = _database.ExecuteSP("sp_updateOptionGeneral", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(bE_Option);
}
return(null);
}
public List <BE_Option> GetOptionGeneral(BE_Option bE_Option)
{
BE_Option _bE_Option = null;
List <BE_Option> _lstOption = new List <BE_Option>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_idoption", bE_Option.idOption);
parameters.Add("_idoptionparent", bE_Option.idOptionParent);
var rows = _database.QuerySP("sp_getOptionGeneral", parameters);
foreach (var row in rows)
{
_bE_Option = new BE_Option();
_bE_Option.idOption = string.IsNullOrEmpty(row["idoption"]) ? 0 : int.Parse(row["idoption"]);
_bE_Option.title = row["title"];
_bE_Option.ismenu = string.IsNullOrEmpty(row["ismenu"]) ? 0 : int.Parse(row["ismenu"]);
_bE_Option.url = row["url"];
_bE_Option.idOptionParent = string.IsNullOrEmpty(row["Idoptionparent"]) ? 0 : int.Parse(row["Idoptionparent"]);
_bE_Option.order = string.IsNullOrEmpty(row["order"]) ? 0 : int.Parse(row["order"]);
_bE_Option.description = row["description"];
_lstOption.Add(_bE_Option);
}
return(_lstOption);
}
public BE_Json UpdateOptionGeneral([FromBody] BE_Option bE_Option)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Option bL_Option = new BL_Option(AppConfig.DbConnection);
// bL_Option.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(bL_Option.UpdateOptionGeneral(bE_Option));
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 BE_Option UpdateOptionGeneral(BE_Option bE_Option)
{
_database = new MySQLDatabase(connectionString);
return(new DA_Option(_database).UpdateOptionGeneral(bE_Option));
}
public List <BE_Option> GetOptionGeneral(BE_Option bE_Option)
{
_database = new MySQLDatabase(connectionString);
return(new DA_Option(_database).GetOptionGeneral(bE_Option));
}
