public FileResult Export(IngredientGroupFilter filter)
{
var responseIngredientGroup = _ingredientGroupService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "COLOR,GRUPO DE INGREDIENTE,INGREDIENTES,ESTADO");
foreach (var ingredientGroup in responseIngredientGroup.IngredientGroups)
{
var responseIngredient = _ingredientService.Filter(new IngredientFilter {
IngredientGroupId = ingredientGroup.Id, OnlyStatusActivated = true
});
var rowIngredientGroup = String.Format("{0},{1},,{2}", ingredientGroup.Color, ingredientGroup.Name, ingredientGroup.Status);
csv.ConcatRow(0, rowIngredientGroup);
foreach (var ingredient in responseIngredient.Ingredients)
{
var rowIngredient = String.Format(",,{0},{1}", ingredient.Name, ingredient.Status);
csv.ConcatRow(0, rowIngredient);
}
}
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Grupo de ingredientes"));
}
public FileResult Export(WorkerFilter filter)
{
var response = _workerService.Filter(filter);
var branches = _branchService.Filter(new BranchFilter()).Branches;
var csv = new CsvExport();
if (filter.IsReport)
{
csv.ConcatRow(0, "COMPAÑÍA,ID SUCURSAL,SUCURSAL,DEPARTAMENTO,PUESTO,CÓDIGO,NOMBRE,GÉNERO,NSS,FECHA CONSUMO,CONSUMIDO,RECOMENDADO");
foreach (var worker in response.Workers)
{
var today = DateTimeExtensions.Today();
var startDate = filter.Month.IsGreaterThanZero() ? new DateTime(today.Year, today.Month, 1).ConvertToString() : "";
var endDate = filter.Month.IsGreaterThanZero() ? new DateTime(today.Year, today.Month, DateTime.DaysInMonth(today.Year, today.Month)).ConvertToString() : "";;
var responseCalories = _reservationService.Report(new ReservationReport {
WorkerId = worker.Id, StartDate = startDate, EndDate = endDate
});
var currentCompany = branches.First(branch => branch.Id.IsEqualTo(worker.BranchId)).Company.Name;
//var responseCalories = new ReservationReportResponse
//{
// Calories = new List<ReservationCalorieReportResponse>
//{
// new ReservationCalorieReportResponse{Date = DateTimeExtensions.Today().AddDays(-7).ConvertToString(),Dinner = 200, Lunch = 1000, BreakFast = 150},
// new ReservationCalorieReportResponse{Date = DateTimeExtensions.Today().AddDays(-6).ConvertToString(),Dinner = 164, Lunch = 1000, BreakFast = 150},
// new ReservationCalorieReportResponse{Date = DateTimeExtensions.Today().AddDays(-5).ConvertToString(),Dinner = 195, Lunch = 1000, BreakFast = 150},
// new ReservationCalorieReportResponse{Date = DateTimeExtensions.Today().AddDays(-4).ConvertToString(),Dinner = 109, Lunch = 1000, BreakFast = 203},
// new ReservationCalorieReportResponse{Date = DateTimeExtensions.Today().AddDays(-3).ConvertToString(),Dinner = 287, Lunch = 1000, BreakFast = 343},
// new ReservationCalorieReportResponse{Date = DateTimeExtensions.Today().AddDays(-2).ConvertToString(),Dinner = 207, Lunch = 1000, BreakFast = 150},
// new ReservationCalorieReportResponse{Date = DateTimeExtensions.Today().AddDays(-1).ConvertToString(),Dinner = 218, Lunch = 1000, BreakFast = 145}
//}
//};
foreach (var calorie in responseCalories.Calories)
{
var sumCalories = calorie.BreakFast + calorie.Dinner + calorie.Lunch;
var row = string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11}", currentCompany, worker.BranchId, worker.Branch.Name, worker.Department.Name, worker.Job.Name, worker.Code, worker.FullName, EnumResolver.Gender(worker.Gender.GetValue()), worker.Imss, calorie.Date, sumCalories.RoundDecimal(), worker.LimitEnergy);
csv.ConcatRow(0, row);
}
}
}
else
{
csv.ConcatRow(0, "CÓDIGO,NOMBRE,APELLIDO,EMAIL,IMSS,GÉNERO,GAFFETE,INGESTA CALÓRICA,SUCURSAL,DEPARTAMENTO,PUESTO,ROL,ESTADO");
csv.ConcatRows(0, "Code,FirstName,LastName,Email,Imss,GenderLabel,Badge,LimitEnergy,Branch,Department,Job,Role,Status", response.Workers);
}
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Ingesta calórica por colaborador"));
}
public FileResult Export(DealerFilter filter)
{
var response = _dealerService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "CONCESIONARIO,ESTADO");
csv.ConcatRows(0, "Name,Status", response.Dealers);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Concesionarios"));
}
public FileResult Export(UserFilter filter)
{
var response = _userService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "USUARIO,ALIAS,CONCESIONARIO,ROL,ESTADO");
csv.ConcatRows(0, "Name,UserName,Dealer,Role,Status", response.Users);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Usuarios"));
}
public FileResult Export(WarningFilter filter)
{
var response = _warningService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "CÓDIGO,ADVERTENCIA,ENFERMEDAD,ESTADO");
csv.ConcatRows(0, "Code,Name,Disease,Status", response.Warnings);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Advertencias"));
}
public FileResult Export(IngredientFilter filter)
{
var response = _ingredientService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "INGREDIENTE,GRUPO,UNIDAD,PESO NETO,ENERGÍA,PROTEÍNAS,CARBOHIDRATOS,AZÚCAR,LÍPIDOS,SODIO,ESTADO");
csv.ConcatRows(0, "Name,IngredientGroup,UnitLabel,NetWeight,Energy,Protein,Carbohydrate,Sugar,Lipid,Sodium,Status", response.Ingredients);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Ingredientes"));
}
public FileResult Export(DiseaseFilter filter)
{
var response = _diseaseService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "CÓDIGO,ENFERMEDAD,ESTADO");
csv.ConcatRows(0, "Code,Name,Status", response.Diseases);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Enfermedades"));
}
public FileResult Export(JobFilter filter)
{
var response = _jobService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "PUESTO,ESTADO");
csv.ConcatRows(0, "Name,Status", response.Jobs);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Puestos"));
}
public FileResult Export(RegionFilter filter)
{
var response = _regionService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "REGIÓN,ESTADO");
csv.ConcatRows(0, "Name,Status", response.Regions);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Regiones"));
}
public FileResult Export(MenuFilter filter)
{
var response = _menuService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "TIPO,DÍA,FECHA INICIO,FECHA FIN,PLATILLO,CONCESIONARIO,COMENTARIO,ESTADO");
csv.ConcatRows(0, "MealTypeLabel,DayWeekLabel,StartDate,EndDate,Saucer,Dealer,Comment,Status", response.Menus);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Menús"));
}
public FileResult Export(DepartmentFilter filter)
{
var response = _departmentService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "DEPARTAMENTO,ESTADO");
csv.ConcatRows(0, "Name,Status", response.Departments);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Departamentos"));
}
public FileResult Export(CompanyFilter filter)
{
var response = _companyService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "COMPAÑÍA,ESTADO");
csv.ConcatRows(0, "Name,Status", response.Companies);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Compañías"));
}
public FileResult Export(TipFilter filter)
{
var response = _tipService.Filter(filter);
var csv = new CsvExport();
csv.ConcatRow(0, "CONSEJO,ESTADO");
csv.ConcatRows(0, "Name,Status", response.Tips);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Consejos"));
}
public FileResult Export(BranchFilter filter)
{
var response = _branchService.Filter(filter);
foreach (var branch in response.Branches)
{
branch.Dealers = _dealerService.OnlyWithBranchId(branch.Id);
}
var csv = new CsvExport();
csv.ConcatRow(0, "CÓDIGO,SUCURSAL,REGIÓN,COMPAÑÍA,CONCESIONARIOS,ESTADO");
csv.ConcatRows(0, "Code,Name,Region,Company,Dealers,Status", response.Branches);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Sucursales"));
}
public FileResult Export(SaucerFilter filter)
{
var response = _saucerService.Filter(filter);
foreach (var saucer in response.Saucers)
{
saucer.SaucerConfigurations = _saucerConfigurationService.OnlyWithSaucerId(saucer.Id);
}
var csv = new CsvExport();
csv.ConcatRow(0, "PLATILLO,TIPO,INGREDIENTES,ESTADO");
csv.ConcatRows(0, "Name,TypeLabel,SaucerConfigurations,Status", response.Saucers);
var stream = csv.RetrieveFile();
return(new StreamFactory().Csv(stream, "Platillos"));
}
