public List <BE_Programation> GetProgramationGeneral(int programationId, int month, int headquartersId, int dietId)
{
BE_Programation _bE_Programation = null;
List <BE_Programation> _lstProgramation = new List <BE_Programation>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_programationId", (programationId == 0) ? DBNull.Value : (object)programationId);
parameters.Add("_headquartersId", (headquartersId == 0) ? DBNull.Value : (object)headquartersId);
parameters.Add("_dietId", (dietId == 0) ? DBNull.Value : (object)dietId);
parameters.Add("_month", (month == 0) ? DBNull.Value : (object)month);
var rows = _database.QuerySP("sp_getProgramationGeneral", parameters);
foreach (var row in rows)
{
_bE_Programation = new BE_Programation();
_bE_Programation.programationId = string.IsNullOrEmpty(row["programationId"]) ? 0 : int.Parse(row["programationId"]);
_bE_Programation.date = string.IsNullOrEmpty(row["date"]) ? DateTime.Now : DateTime.Parse(row["date"]);
_bE_Programation.dateFormat = _bE_Programation.date.ToShortDateString();
_bE_Programation.costTotal = string.IsNullOrEmpty(row["costTotal"]) ? 0 : decimal.Parse(row["costTotal"]);
_bE_Programation.feedingTimeId = string.IsNullOrEmpty(row["feedingTimeId"]) ? 0 : int.Parse(row["feedingTimeId"]);
_bE_Programation.kcalTotal = string.IsNullOrEmpty(row["kcalTotal"]) ? 0 : int.Parse(row["kcalTotal"]);
_bE_Programation.isEnabled = string.IsNullOrEmpty(row["isEnabled"]) ? false : row["isEnabled"].Equals("1") ? true : false;
_lstProgramation.Add(_bE_Programation);
}
return(_lstProgramation);
}
public BE_Json UpdateProgramation([FromBody] BE_Programation bE_Programation)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Programation bL_Programation = new BL_Programation();
bL_Programation.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(bL_Programation.UpdateProgramation(bE_Programation));
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_Programation CreateProgramation(BE_Programation bE_Programation)
{
_database = new MySQLDatabase(connectionString);
var newProgramation = new DA_Programation(_database).CreateProgramation(bE_Programation);
if (newProgramation.detail != null)
{
foreach (var detail in newProgramation.detail)
{
detail.programationId = newProgramation.programationId;
CreateProgramationDetail(detail);
}
}
return(newProgramation);
}
public BE_Programation UpdateProgramation(BE_Programation bE_Programation)
{
_database = new MySQLDatabase(connectionString);
var updatedProgramation = new DA_Programation(_database).UpdateProgramation(bE_Programation);
if (updatedProgramation.detail != null)
{
DeleteProgramationDetailByProgramationId(updatedProgramation.programationId);
foreach (var detail in updatedProgramation.detail)
{
detail.programationId = updatedProgramation.programationId;
CreateProgramationDetail(detail);
}
}
return(updatedProgramation);
}
public BE_Programation CreateProgramation(BE_Programation bE_Programation)
{
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_date", (bE_Programation.date == null) ? DBNull.Value : (object)bE_Programation.date);
parameters.Add("_costTotal", bE_Programation.costTotal);
parameters.Add("_feedingTimeId", bE_Programation.feedingTimeId);
parameters.Add("_kcalTotal", (bE_Programation.kcalTotal == 0) ? DBNull.Value : (object)bE_Programation.kcalTotal);
var programationId = _database.ExecuteSPGetId("sp_createProgramation", parameters);
boResultado = (programationId != null);
if (boResultado)
{
bE_Programation.programationId = int.Parse(programationId.ToString());
return(bE_Programation);
}
return(null);
}
public BE_Programation UpdateProgramation(BE_Programation bE_Programation)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_programationId", (bE_Programation.programationId == 0) ? DBNull.Value : (object)bE_Programation.programationId);
parameters.Add("_date", bE_Programation.date);
parameters.Add("_costTotal", bE_Programation.costTotal);
parameters.Add("_feedingTimeId", bE_Programation.feedingTimeId);
parameters.Add("_kcalTotal", (bE_Programation.kcalTotal == 0) ? DBNull.Value : (object)bE_Programation.kcalTotal);
filasAfectadas = _database.ExecuteSP("sp_updateProgramation", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(bE_Programation);
}
return(null);
}
public BE_Programation GetProgramationByDateAndFeedingTimeId(DateTime date, int feedingTimeId)
{
BE_Programation _bE_Programation = null;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_date", date);
parameters.Add("_feedingTimeId", feedingTimeId);
var rows = _database.QuerySP("sp_getProgramationByDateAndFeedingTimeId", parameters);
foreach (var row in rows)
{
_bE_Programation = new BE_Programation();
_bE_Programation.programationId = string.IsNullOrEmpty(row["programationId"]) ? 0 : int.Parse(row["programationId"]);
_bE_Programation.date = string.IsNullOrEmpty(row["date"]) ? DateTime.Now : DateTime.Parse(row["date"]);
_bE_Programation.dateFormat = _bE_Programation.date.ToShortDateString();
_bE_Programation.costTotal = string.IsNullOrEmpty(row["costTotal"]) ? 0 : decimal.Parse(row["costTotal"]);
_bE_Programation.feedingTimeId = string.IsNullOrEmpty(row["feedingTimeId"]) ? 0 : int.Parse(row["feedingTimeId"]);
_bE_Programation.kcalTotal = string.IsNullOrEmpty(row["kcalTotal"]) ? 0 : int.Parse(row["kcalTotal"]);
_bE_Programation.isEnabled = string.IsNullOrEmpty(row["isEnabled"]) ? false : row["isEnabled"].Equals("1") ? true : false;
}
return(_bE_Programation);
}