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)); }