public BE_Json CreateParameter([FromBody] BE_Parameter bE_Parameter) { BE_Json objJson = null; var objListaAux = string.Empty; try { BL_Parameter bL_Parameter = new BL_Parameter(); bL_Parameter.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(bL_Parameter.CreateParameter(bE_Parameter)); 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_Parameter> GetParameter(int idParameter) { BE_Parameter bE_Parameter = null; List <BE_Parameter> bE_Parameters = new List <BE_Parameter>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_idparameter", idParameter == 0 ? DBNull.Value : (object)idParameter); var rows = _database.QuerySP("sp_getParameter", parameters); foreach (var row in rows) { bE_Parameter = new BE_Parameter(); bE_Parameter.idParameter = string.IsNullOrEmpty(row["idparameter"]) ? 0 : int.Parse(row["idparameter"]);; bE_Parameter.initials = row["initials"]; bE_Parameter.name = row["name"]; bE_Parameter.createdBy = row["createdBy"]; bE_Parameter.createdDate = string.IsNullOrEmpty(row["createdDate"]) ? DateTime.MinValue : DateTime.Parse(row["createdDate"]); bE_Parameter.createdDateFormat = bE_Parameter.createdDate.ToShortDateString(); bE_Parameter.updatedBy = row["updatedBy"]; bE_Parameter.updatedDate = string.IsNullOrEmpty(row["updatedDate"]) ? DateTime.MinValue : DateTime.Parse(row["updatedDate"]); bE_Parameter.updatedDateFormat = bE_Parameter.updatedDate.ToShortDateString(); bE_Parameter.isEnabled = string.IsNullOrEmpty(row["isEnabled"]) ? false : row["isEnabled"].Equals("1") ? true : false; bE_Parameters.Add(bE_Parameter); } return(bE_Parameters); }
public BE_Parameter CreateParameter(BE_Parameter bE_Parameter) { Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_initials", bE_Parameter.initials); parameters.Add("_name", bE_Parameter.name); parameters.Add("_createdBy", bE_Parameter.createdBy); parameters.Add("_isEnabled", bE_Parameter.isEnabled); var id = _database.ExecuteSPGetId("sp_createParameter", parameters); bE_Parameter.idParameter = int.Parse(id.ToString()); return(bE_Parameter); }
public BE_Parameter UpdateParameter(BE_Parameter bE_Parameter) { Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_idparameter", bE_Parameter.idParameter); parameters.Add("_initials", bE_Parameter.initials); parameters.Add("_name", bE_Parameter.name); parameters.Add("_updatedBy", bE_Parameter.updatedBy); parameters.Add("_isEnabled", bE_Parameter.isEnabled); var result = _database.ExecuteSP("sp_updateParameter", parameters); if (result > 0) { return(bE_Parameter); } return(null); }
public BE_Parameter UpdateParameter(BE_Parameter bE_Parameter) { _database = new MySQLDatabase(connectionString); return(new DA_Parameter(_database).UpdateParameter(bE_Parameter)); }