protected void Page_Load(object sender, EventArgs e)
{
if (Request["IDU"] != null &&
Request["IDP"] != null &&
Request["Y"] != null &&
Request["M"] != null &&
Request["DS"] != null &&
Request["DE"] != null &&
Request["HS"] != null &&
Request["HE"] != null)
{
int IDU = int.Parse(Request["IDU"].ToString());
int IDP = int.Parse(Request["IDP"].ToString());
int Y = int.Parse(Request["Y"].ToString());
int M = int.Parse(Request["M"].ToString());
int DS = int.Parse(Request["DS"].ToString());
int DE = int.Parse(Request["DE"].ToString());
int HS = int.Parse(Request["HS"].ToString());
int HE = int.Parse(Request["HE"].ToString());
DateTime DateStart = new DateTime(Y, M, DS, HS, 0, 0);
DateTime DateEnd = new DateTime(Y, M, DE, HE, 0, 0);
System.Collections.Generic.List <Turno> LT = Turno.GetTurnosByPeriod(DateStart, DateEnd, IDU, "Finalizado");
if (LT != null)
{
Session.Add("result", LT);
}
else
{
Session.Remove("result");
}
UserController UC = new UserController();
UserInfo UI = UC.GetUser(IDP, IDU);
Establecimiento.Text = "___________________________________________________";
IndependenciaNro.Text = "________________";
Departamento.Text = "________________";
if (UI != null)
{
NombreMedico.Text = UI.FirstName + " " + UI.LastName;
if (UI.Profile.GetPropertyValue("Puesto") != "")
{
Servicio.Text = UI.Profile.GetPropertyValue("Puesto");
}
else
{
Servicio.Text = "No definido";
}
Mes.Text = DateTime.Now.ToString("MMMM", CultureInfo.CreateSpecificCulture("es"));
Año.Text = DateTime.Now.Year.ToString();
}
else
{
}
}
}
protected void GenerateC2()
{
RV.LocalReport.ReportPath = MapPath("/DesktopModules/Planillas/Reports/ReportC2.rdlc");
List <ConnectionDispensario.Modelos.Reporting.C2Item> itemsC2 = new List <ConnectionDispensario.Modelos.Reporting.C2Item>();
int Month = int.Parse(Request["month"].ToString());
int year = int.Parse(Request["year"].ToString());
//Buscar dentro de los usuarios que cumplan con el servicio
string nombreservicio = "";
if (Request["service"] != null)
{
//DotNetNuke.Entities.Portals.PortalController PC = new DotNetNuke.Entities.Portals.PortalController();
ConnectionDispensario.Modelos.Servicio Service = ConnectionDispensario.Modelos.Servicio.ObtenerServicioById(int.Parse(Request["service"].ToString()));
nombreservicio = Service.NOMBRE;
for (int dia = 0; dia < DateTime.DaysInMonth(year, Month); dia++)
{
itemsC2.Add(new ConnectionDispensario.Modelos.Reporting.C2Item());
itemsC2[dia].Dia = dia + 1;
List <Jornada> ListaJornadas = Jornada.SelectClosedJornadasByDateAndIdService(year, Month, dia + 1, Service.ID);
decimal horasdeconsulta = 0;
if (ListaJornadas != null)
{
foreach (Jornada j in ListaJornadas)
{
List <Turno> T = Turno.GetTurnosByPeriod(j.Start, j.End.Value, j.USERID.Value, "Finalizado");
horasdeconsulta += (decimal)((j.End.Value - j.Start).TotalMinutes / 60);
itemsC2[dia].HorasAtencion += horasdeconsulta;
if (T != null)
{
foreach (Turno t in T)
{
if (t.Pac != null)
{
Paciente p = t.Pac;
int age = ConnectionDispensario.Utils.Conversiones.getAge(p.FECHA_NACIMIENTO);
string sex = "";
if (p.SEXO == "Masculino")
{
sex = "m";
}
else
{
sex = "f";
}
itemsC2[dia].TotalTotal++;
if (sex == "m")
{
itemsC2[dia].Totalm++;
if (age < 1)
{
itemsC2[dia].Menor1m++;
}
if (age == 1)
{
itemsC2[dia].Ano1m++;
}
if (age > 1 && age < 5)
{
itemsC2[dia].Ano2a4m++;
}
if (age > 4 && age < 10)
{
itemsC2[dia].Ano5a9m++;
}
if (age > 9 && age < 15)
{
itemsC2[dia].Ano10a14m++;
}
if (age > 14 && age < 50)
{
itemsC2[dia].Ano15a49m++;
}
if (age > 49)
{
itemsC2[dia].Ano50ymasm++;
}
}
else
{
itemsC2[dia].Totalf++;
if (age < 1)
{
itemsC2[dia].Menor1f++;
}
if (age == 1)
{
itemsC2[dia].Ano1f++;
}
if (age > 1 && age < 5)
{
itemsC2[dia].Ano2a4f++;
}
if (age > 4 && age < 10)
{
itemsC2[dia].Ano5a9f++;
}
if (age > 9 && age < 15)
{
itemsC2[dia].Ano10a14f++;
}
if (age > 14 && age < 50)
{
itemsC2[dia].Ano15a49f++;
}
if (age > 49)
{
itemsC2[dia].Ano50ymasf++;
}
}
if (t.ControlEmbarazo == true)
{
itemsC2[dia].TotalPregnant++;
}
}
}
}
}
}
}
}
ReportDataSource RDS = new ReportDataSource("DataSetC2", itemsC2);
RV.LocalReport.DataSources.Add(RDS);
RV.LocalReport.SetParameters(new ReportParameter[] {
new ReportParameter("Establecimiento", "Dispensario Municipal \"Dr. H Weihmuller\""),
new ReportParameter("Departamento", "Gral. San Martin"),
new ReportParameter("NombreServicio", nombreservicio),
new ReportParameter("CodigoEstablecimiento", "4200026"),
new ReportParameter("CodigoServicio", "..."),
new ReportParameter("Mes", Month.ToString()),
new ReportParameter("Anio", year.ToString())
});
}
