public List <VE_ProgramationDetail> GetProgramationDetailByDateAndFeedingTimeId(DateTime date, int feedingTimeId)
{
VE_ProgramationDetail _vE_ProgramationDetail = null;
List <VE_ProgramationDetail> _lstProgramationDetail = new List <VE_ProgramationDetail>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_date", date);
parameters.Add("_feedingTimeId", feedingTimeId);
var rows = _database.QuerySP("sp_getProgramationDetailByDateAndFeedingTimeId", parameters);
foreach (var row in rows)
{
_vE_ProgramationDetail = new VE_ProgramationDetail();
_vE_ProgramationDetail.programationId = string.IsNullOrEmpty(row["programationId"]) ? 0 : int.Parse(row["programationId"]);
_vE_ProgramationDetail.productCost = string.IsNullOrEmpty(row["productCost"]) ? 0 : decimal.Parse(row["productCost"]);
_vE_ProgramationDetail.productId = string.IsNullOrEmpty(row["productId"]) ? 0 : int.Parse(row["productId"]);
_vE_ProgramationDetail.quantity = string.IsNullOrEmpty(row["quantity"]) ? 0 : decimal.Parse(row["quantity"]);
_vE_ProgramationDetail.productKcal = string.IsNullOrEmpty(row["productKcal"]) ? 0 : int.Parse(row["productKcal"]);
_vE_ProgramationDetail.productName = row["productName"];
_lstProgramationDetail.Add(_vE_ProgramationDetail);
}
return(_lstProgramationDetail);
}
public List <VE_ProgramationDetail> GetProgramationDetailResumen(int year, int month, int headquartersId, int dietId)
{
VE_ProgramationDetail _vE_ProgramationDetail = null;
List <VE_ProgramationDetail> _lstProgramationDetail = new List <VE_ProgramationDetail>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
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);
parameters.Add("_year", (year == 0) ? DBNull.Value : (object)year);
util _util = new util();
var rows = _database.QuerySP("sp_getProgramationDetailResumen", parameters);
foreach (var row in rows)
{
_vE_ProgramationDetail = new VE_ProgramationDetail();
_vE_ProgramationDetail.programationId = string.IsNullOrEmpty(row["programationId"]) ? 0 : int.Parse(row["programationId"]);
_vE_ProgramationDetail.date = string.IsNullOrEmpty(row["date"]) ? DateTime.Now : DateTime.Parse(row["date"]);
_vE_ProgramationDetail.dateFormat = _vE_ProgramationDetail.date.ToShortDateString();
_vE_ProgramationDetail.dayOfWeek = _vE_ProgramationDetail.date.DayOfWeek;
_vE_ProgramationDetail.dayOfMonth = _vE_ProgramationDetail.date.Day;
_vE_ProgramationDetail.weekOfMonth = _util.GetWeekOfMonth(_vE_ProgramationDetail.date).WeekOfMonth;
_vE_ProgramationDetail.productCost = string.IsNullOrEmpty(row["productCost"]) ? 0 : decimal.Parse(row["productCost"]);
_vE_ProgramationDetail.productId = string.IsNullOrEmpty(row["productId"]) ? 0 : int.Parse(row["productId"]);
_vE_ProgramationDetail.productKcal = string.IsNullOrEmpty(row["productKcal"]) ? 0 : int.Parse(row["productKcal"]);
_vE_ProgramationDetail.productCategoryId = string.IsNullOrEmpty(row["productCategoryId"]) ? 0 : int.Parse(row["productCategoryId"]);
_vE_ProgramationDetail.productCategoryName = row["productCategoryName"];
_vE_ProgramationDetail.productName = row["productName"];
_vE_ProgramationDetail.headquartersName = row["headquartersName"];
_vE_ProgramationDetail.dietName = row["dietName"];
_vE_ProgramationDetail.quantity = string.IsNullOrEmpty(row["quantity"]) ? 0 : decimal.Parse(row["quantity"]);
_lstProgramationDetail.Add(_vE_ProgramationDetail);
}
return(_lstProgramationDetail);
}
public List <VE_ProgramationDetail> GetProgramationDetailByProgramationId(int programationId)
{
VE_ProgramationDetail _vE_ProgramationDetail = null;
List <VE_ProgramationDetail> _lstProgramationDetail = new List <VE_ProgramationDetail>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_programationId", (programationId == 0) ? DBNull.Value : (object)programationId);
var rows = _database.QuerySP("sp_getProgramationDetailByProgramationId", parameters);
foreach (var row in rows)
{
_vE_ProgramationDetail = new VE_ProgramationDetail();
_vE_ProgramationDetail.programationId = string.IsNullOrEmpty(row["programationId"]) ? 0 : int.Parse(row["programationId"]);
_vE_ProgramationDetail.productCost = string.IsNullOrEmpty(row["productCost"]) ? 0 : decimal.Parse(row["productCost"]);
_vE_ProgramationDetail.productId = string.IsNullOrEmpty(row["productId"]) ? 0 : int.Parse(row["productId"]);
_vE_ProgramationDetail.quantity = string.IsNullOrEmpty(row["quantity"]) ? 0 : decimal.Parse(row["quantity"]);
_vE_ProgramationDetail.productKcal = string.IsNullOrEmpty(row["productKcal"]) ? 0 : int.Parse(row["productKcal"]);
_vE_ProgramationDetail.productName = row["productName"];
_lstProgramationDetail.Add(_vE_ProgramationDetail);
}
return(_lstProgramationDetail);
}
