public ActionResult UploadFile(int pYear, int pMonth)
{
string result = string.Empty;
SedesolServiceClient client = new SedesolServiceClient();
foreach (string fileName in Request.Files)
{
HttpPostedFileBase file = Request.Files[fileName];
if (file != null && file.ContentLength > 0)
{
DataTable dt = new DataTable();
dt = GetDataTableFromSpreadsheet(file.InputStream, false, pYear, pMonth);
dt.TableName = "dtRations";
if (dt.Rows.Count > 1)
{
result = client.SaveRations(DTOSerializer.Serialize(dt).InnerXml);
}
else
{
result = "No se pudo obtener la informaciòn del archivo";
}
}
}
RationModel model = new RationModel();
model = client.GetRationSearch(pYear, pMonth);
client.Close();
string viewContent = ConvertViewToString("RationList", model.ListRation);
return(Json(new { message = result, PartialView = viewContent }));
}
public string SaveRations(string data)
{
DataTable dt = (DataTable)DTOSerializer.Deserialize(data, typeof(DataTable));
RationDAL dal = new RationDAL();
return(dal.SaveRations(dt));
}
public string GetExcel(int pIdState, int pIdMonth, int pIdYear)
{
RationDAO reporting = new RationDAO();
//return reporting.GetAttendanceReport(CaptureId);
return(DTOSerializer.Serialize(reporting.GetExcel(pIdState, pIdMonth, pIdYear)).InnerXml);
}
public string GetAttendanceReport(int CaptureId)
{
ReportDAO reporting = new ReportDAO();
//return reporting.GetAttendanceReport(CaptureId);
return(DTOSerializer.Serialize(reporting.GetAttendanceReport(CaptureId)).InnerXml);
}
public string GetCaptureReport(List <FilterDTO> filterDto)
{
ReportDAO reporting = new ReportDAO();
//return reporting.GetCaptureReport(filterDto);
return(DTOSerializer.Serialize(reporting.GetCaptureReport(filterDto)).InnerXml);
}
public StateContainer(ILogger <StateContainer> logger, HttpClient client, DTOSerializer dtoSerializer)
{
_logger = logger;
_client = client;
_jsonSerializerOptions = dtoSerializer.Options;
_jsonSerializerOptions.ReadCommentHandling = JsonCommentHandling.Skip;
_jsonSerializerOptions.AllowTrailingCommas = true;
}
public TestModlists()
{
var services = new ServiceCollection();
services.AddDTOConverters();
services.AddDTOSerializer();
var serviceProvider = services.BuildServiceProvider();
_dtoSerializer = serviceProvider.GetRequiredService <DTOSerializer>();
}
public ActionResult ExportCapture(int idState = 0, int idSoupK = 0, int idStatus = 0)
{
List <FilterDTO> listFilter = new List <FilterDTO>();
UserDTO userDto = (UserDTO)Session["userData"];
FilterDTO dtoUserType = new FilterDTO {
Name = "Id_UserType", Value = userDto.Id_User_Type.ToString()
};
listFilter.Add(dtoUserType);
FilterDTO dtoUser = new FilterDTO {
Name = "Id_User", Value = userDto.Id.ToString()
};
listFilter.Add(dtoUser);
if (idState > 0)
{
FilterDTO dto = new FilterDTO {
Name = "Id_State", Value = idState.ToString()
};
listFilter.Add(dto);
}
if (idSoupK > 0)
{
FilterDTO dto = new FilterDTO {
Name = "Id_SoupKitchen", Value = idSoupK.ToString()
};
listFilter.Add(dto);
}
if (idStatus > 0)
{
FilterDTO dto = new FilterDTO {
Name = "Id_Status", Value = idStatus.ToString()
};
listFilter.Add(dto);
}
SedesolServiceClient proxy = new SedesolServiceClient();
DataSet ds = (DataSet)DTOSerializer.Deserialize(proxy.GetCaptureReport(listFilter), typeof(DataSet));
GridView gv = new GridView();
#region Create Dt
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[7]
{
new DataColumn("Estado"),
new DataColumn("Descripción"),
new DataColumn("Comedor"),
new DataColumn("Ubicación"),
new DataColumn("Fecha_Creación"),
new DataColumn("Beneficiarios"),
new DataColumn("Asistencia")
});
#endregion
if (ds.Tables.Count > 0)
{
foreach (System.Data.DataRow item in ds.Tables[0].DefaultView.Table.Rows)
{
dt.Rows.Add(item["Estado"],
item["Descripcion"],
item["Comedor"],
item["Location"],
item["CreateDate"],
item["Beneficiarios"],
item["Asistencia"]);
}
}
gv.DataSource = dt;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=Captura.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
string style = @"<style> td { mso-number-format:\@;} </style>";
Response.Output.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Index"));
}
public ActionResult ExportAttendance(int id)
{
string data = string.Empty;
SedesolServiceClient proxy = new SedesolServiceClient();
DataSet ds = (DataSet)DTOSerializer.Deserialize(proxy.GetAttendanceReport(id), typeof(DataSet));
GridView gv = new GridView();
#region Create Dt
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[11]
{
new DataColumn("Curp"),
new DataColumn("Nombre"),
new DataColumn("Apellido_Paterno"),
new DataColumn("Apellido_Materno"),
new DataColumn("Fecha_Nacimiento"),
new DataColumn("Cantidad"),
new DataColumn("Sexo"),
new DataColumn("Condicion"),
new DataColumn("Lugar_Nacimiento"),
new DataColumn("Domicilio"),
new DataColumn("Telefono")
});
#endregion
if (ds.Tables.Count > 0)
{
foreach (System.Data.DataRow item in ds.Tables[0].DefaultView.Table.Rows)
{
dt.Rows.Add(item["Curp"],
item["Nombre"],
item["Apellido_Paterno"],
item["Apellido_Materno"],
item["Fecha_Nacimiento"],
item["Cantidad"],
item["Sexo"],
item["Condicion"],
item["Lugar_Nacimiento"],
item["Domicilio"],
item["Telefono"]);
}
}
gv.DataSource = dt;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=Asistencia.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
string style = @"<style> td { mso-number-format:\@;} </style>";
Response.Output.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("CaptureAttendance"));
}
public ActionResult ExportExcel(int pIdState = 0, int pMonth = 0, int pYear = 0)
{
string data = string.Empty;
SedesolServiceClient proxy = new SedesolServiceClient();
DataSet ds = (DataSet)DTOSerializer.Deserialize(proxy.GetDataExcel(pIdState, pMonth, pYear), typeof(DataSet));
GridView gv = new GridView();
DataTable dt1 = ds.Tables[0];
//DataTable dt2 = ds.Tables[1];
//#region Create Dt
//DataTable dt = new DataTable();
//dt.Columns.Add("Folio Comedor", typeof(string));
//dt.Columns.Add("Entidad", typeof(string));
//dt.Columns.Add("Folio Vale", typeof(string));
//dt.Columns.Add("Fecha de Emision", typeof(string));
//dt.Columns.Add("No.Beneficiarios", typeof(string));
//foreach (DataRow col in dt1.Rows)
//{
// dt.Columns.Add(col[0].ToString(), typeof(string));
//}
//#endregion
//DataRow sampleDataRow;
//foreach (DataRow col in dt2.Rows)
//{
// sampleDataRow = dt.NewRow();
// sampleDataRow["Folio Comedor"] = col[0].ToString();
// sampleDataRow["Entidad"] = "";
// sampleDataRow["Folio Vale"] = col[1].ToString();
// sampleDataRow["Fecha de Emision"] = DateTime.Now.ToShortDateString();
// sampleDataRow["No.Beneficiarios"] = col[2].ToString();
// dt.Rows.Add(sampleDataRow);
//}
gv.DataSource = dt1;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=Consolidado.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
string style = @"<style> td { mso-number-format:\@;} </style>";
Response.Output.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Create"));
}
