public BE_Json UpdateMeasuredUnit([FromBody] BE_MeasuredUnit bE_MeasuredUnit) { BE_Json objJson = null; var objListaAux = string.Empty; try { BL_MeasuredUnit bL_MeasuredUnit = new BL_MeasuredUnit(); bL_MeasuredUnit.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(bL_MeasuredUnit.UpdateMeasuredUnit(bE_MeasuredUnit)); objJson = new BE_Json(); objJson.data = (objListaAux == "null") ? "No se pudo editar el producto: El código ya existe" : objListaAux; objJson.status = (objListaAux == "null") ? CManager.RESULTADO_WCF.ERROR : 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_Json GetMeasuredUnit([FromBody] BE_MeasuredUnit BE_MeasuredUnit) { BE_Json objJson = null; var objListaAux = string.Empty; try { BL_MeasuredUnit bL_MeasuredUnit = new BL_MeasuredUnit(); bL_MeasuredUnit.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(bL_MeasuredUnit.GetMeasuredUnitGeneral(BE_MeasuredUnit)); 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_MeasuredUnit> GetMeasuredUnitByName(string name) { BE_MeasuredUnit bE_MeasuredUnit = new BE_MeasuredUnit(); bE_MeasuredUnit.name = name; _database = new MySQLDatabase(connectionString); return(GetMeasuredUnitGeneral(bE_MeasuredUnit)); }
public List <BE_MeasuredUnit> GetMeasuredUnitById(int measuredUnitId) { BE_MeasuredUnit bE_MeasuredUnit = new BE_MeasuredUnit(); bE_MeasuredUnit.measuredUnitId = measuredUnitId; _database = new MySQLDatabase(connectionString); return(GetMeasuredUnitGeneral(bE_MeasuredUnit)); }
public List <BE_MeasuredUnit> GetMeasuredUnit() { BE_MeasuredUnit bE_MeasuredUnit = new BE_MeasuredUnit() { isEnabled = true }; _database = new MySQLDatabase(connectionString); return(GetMeasuredUnitGeneral(bE_MeasuredUnit)); }
public List <BE_MeasuredUnit> GetMeasuredUnitGeneral(BE_MeasuredUnit bE_MeasuredUnit) { BE_MeasuredUnit _bE_MeasuredUnit = null; List <BE_MeasuredUnit> _lstMeasuredUnit = new List <BE_MeasuredUnit>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_measuredUnitId", (bE_MeasuredUnit.measuredUnitId == 0) ? DBNull.Value : (object)bE_MeasuredUnit.measuredUnitId); parameters.Add("_name", string.IsNullOrWhiteSpace(bE_MeasuredUnit.name) ? DBNull.Value : (object)bE_MeasuredUnit.name); parameters.Add("_isBase", (bE_MeasuredUnit.isBase == null) ? DBNull.Value : (object)bE_MeasuredUnit.isBase); parameters.Add("_isEnabled", (bE_MeasuredUnit.isEnabled == null) ? DBNull.Value : (object)bE_MeasuredUnit.isEnabled); var rows = _database.QuerySP("sp_getMeasuredUnitGeneral", parameters); foreach (var row in rows) { _bE_MeasuredUnit = new BE_MeasuredUnit(); _bE_MeasuredUnit.measuredUnitId = string.IsNullOrEmpty(row["measuredUnitId"]) ? 0 : int.Parse(row["measuredUnitId"]); _bE_MeasuredUnit.name = row["name"]; _bE_MeasuredUnit.conversionFactor = string.IsNullOrEmpty(row["conversionFactor"]) ? 0 : decimal.Parse(row["conversionFactor"]); _bE_MeasuredUnit.isBase = string.IsNullOrEmpty(row["isBase"]) ? false : row["isBase"].Equals("1") ? true : false; _bE_MeasuredUnit.isEnabled = string.IsNullOrEmpty(row["isEnabled"]) ? false : row["isEnabled"].Equals("1") ? true : false; _bE_MeasuredUnit.baseMeasureUnit = new BE_MeasuredUnit() { measuredUnitId = string.IsNullOrEmpty(row["baseMeasuredUnitId"]) ? 0 : int.Parse(row["baseMeasuredUnitId"]) , name = string.IsNullOrEmpty(row["baseName"]) ? string.Empty : row["baseName"] , conversionFactor = string.IsNullOrEmpty(row["baseConversionFactor"]) ? 0 : decimal.Parse(row["baseConversionFactor"]) , isBase = string.IsNullOrEmpty(row["baseIsBase"]) ? false : row["baseIsBase"].Equals("1") ? true : false , isEnabled = string.IsNullOrEmpty(row["baseIsEnabled"]) ? false : row["baseIsEnabled"].Equals("1") ? true : false }; //_bE_MeasuredUnit.baseMeasuredUnitId = string.IsNullOrEmpty(row["baseMeasuredUnitId"]) ? 0 : int.Parse(row["baseMeasuredUnitId"]); _lstMeasuredUnit.Add(_bE_MeasuredUnit); } return(_lstMeasuredUnit); }
public BE_MeasuredUnit CreateMeasuredUnit(BE_MeasuredUnit bE_MeasuredUnit) { string strError_Mensaje = string.Empty; bool boResultado = false; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_name", bE_MeasuredUnit.name); parameters.Add("_conversionFactor", bE_MeasuredUnit.conversionFactor); parameters.Add("_isBase", bE_MeasuredUnit.isBase); parameters.Add("_baseMeasuredUnitId", bE_MeasuredUnit.baseMeasuredUnitId); var measuredUnitId = _database.ExecuteSPGetId("sp_createMeasuredUnit", parameters); boResultado = (measuredUnitId != null); if (boResultado) { bE_MeasuredUnit.measuredUnitId = int.Parse(measuredUnitId.ToString()); return(bE_MeasuredUnit); } return(null); }
public BE_MeasuredUnit UpdateMeasuredUnit(BE_MeasuredUnit bE_MeasuredUnit) { string strError_Mensaje = string.Empty; bool boResultado = false; int filasAfectadas = 0; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_measuredUnitId", bE_MeasuredUnit.measuredUnitId); parameters.Add("_name", bE_MeasuredUnit.name); parameters.Add("_conversionFactor", (bE_MeasuredUnit.conversionFactor == 0) ? DBNull.Value : (object)bE_MeasuredUnit.conversionFactor); parameters.Add("_isBase", bE_MeasuredUnit.isBase); parameters.Add("_baseMeasuredUnitId", (bE_MeasuredUnit.baseMeasuredUnitId == 0) ? DBNull.Value : (object)bE_MeasuredUnit.baseMeasuredUnitId); filasAfectadas = _database.ExecuteSP("sp_updateMeasuredUnit", parameters); boResultado = (filasAfectadas > 0); if (boResultado) { return(bE_MeasuredUnit); } return(null); }
public BE_MeasuredUnit UpdateMeasuredUnit(BE_MeasuredUnit bE_MeasuredUnit) { _database = new MySQLDatabase(connectionString); return(new DA_MeasuredUnit(_database).UpdateMeasuredUnit(bE_MeasuredUnit)); }
public List <BE_MeasuredUnit> GetMeasuredUnitGeneral(BE_MeasuredUnit bE_MeasuredUnit) { _database = new MySQLDatabase(connectionString); return(new DA_MeasuredUnit(_database).GetMeasuredUnitGeneral(bE_MeasuredUnit)); }