public BE_Json GetCostCenterGeneral([FromBody] BE_CostCenter bE_CostCenter) { BE_Json objJson = null; var objListaAux = string.Empty; try { BL_CostCenter bL_CostCenter = new BL_CostCenter(); bL_CostCenter.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(bL_CostCenter.GetCostCenterGeneral(bE_CostCenter.costCenterId)); 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_CostCenter> getCostCenterGeneral(string costCenterId) { BE_CostCenter bE_CostCenter = null; List <BE_CostCenter> bE_CostCenters = new List <BE_CostCenter>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_costCenterId", costCenterId); var rows = _database.QuerySP("sp_getCostCenterGeneral", parameters); foreach (var row in rows) { bE_CostCenter = new BE_CostCenter(); bE_CostCenter.costCenterId = row["costcenterId"]; bE_CostCenter.description = row["description"]; bE_CostCenters.Add(bE_CostCenter); } return(bE_CostCenters); }