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