public void GetPIRSummaryDetails(DataSet _dataset, PIRModel _PIR, string PIRQuestion)
{
if (_dataset != null)
{
if (_dataset.Tables[0].Rows.Count > 0)
{
List <PIRModel> PIRList = new List <PIRModel>();
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
PIRList.Add(new PIRModel
{
clientName = Convert.ToString(dr["ChildName"]),
DOB = Convert.ToString(dr["DOB"]),
center = Convert.ToString(dr["CenterID"]),
classroom = Convert.ToString(dr["ClassroomID"]),
piratenrollment = Convert.ToString(dr["pirquest"]),
pirafterenrollment = Convert.ToString(dr["pirquest2"]),
clientStatus = Convert.ToString(dr["Status"])
});
_PIR.piratenrollmentDesc = Convert.ToString(dr["Description"]);
_PIR.pirafterenrollmentDesc = Convert.ToString(dr["Description2"]);
}
_PIR.PIRlst = PIRList;
_PIR.pirQuestion = PIRQuestion;
}
}
}
public PIRModel GetPIRDetails(string UserID, string AgencyID, string pirquestion, string Program)
{
PIRModel _PIR = new PIRModel();
_PIR.program = Program;
command.Parameters.Add(new SqlParameter("@AgencyID", AgencyID));
command.Parameters.Add(new SqlParameter("@ProgramType", Program));
command.Parameters.Add(new SqlParameter("@Quest_ID", pirquestion));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "PIR_Reporting";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
GetPIRSummaryDetails(_dataset, _PIR, pirquestion);
return(_PIR);
}
public PIRModel ExportData(string question, string AgencyID, string programtype)
{
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyID", AgencyID));
command.Parameters.Add(new SqlParameter("@ProgramType", programtype));
command.Parameters.Add(new SqlParameter("@Quest_ID", question));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "[PIR_Reporting]";
SqlDataAdapter DataAdapter1 = null;
DataAdapter1 = new SqlDataAdapter(command);
DataSet _dataset1 = null;
_dataset1 = new DataSet();
DataAdapter1.Fill(_dataset1);
string FileName = "attachment; filename = PIRExportReport.xlsx";
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(_dataset1);
wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
wb.Style.Font.Bold = true;
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.Buffer = true;
// System.Web.HttpContext.Current.Response.Charset = "";
System.Web.HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
System.Web.HttpContext.Current.Response.AddHeader("content-disposition", FileName);
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(System.Web.HttpContext.Current.Response.OutputStream);
System.Web.HttpContext.Current.Response.Flush();
System.Web.HttpContext.Current.Response.End();
}
}
PIRModel _PIRM = new PIRModel();
return(_PIRM);
}
public PIRModel GetPIR(string UserID, string AgencyID)
{
PIRModel _PIR = new PIRModel();
command.Parameters.Add(new SqlParameter("@AgencyID", AgencyID));
command.Parameters.Add(new SqlParameter("@UserID", UserID));
command.Parameters.Add(new SqlParameter("@ProgramType", "HS"));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_getPIR";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
GetPIRSummary(_dataset, _PIR);
GetDisabilityChildren(AgencyID, UserID, _PIR);
return(_PIR);
}
public PIRModel GetPIR(string UserID, string AgencyID, string Program, string Refresh)
{
PIRModel _PIR = new PIRModel();
if (Program == null)
{
Program = "HS";
}
_PIR.program = Program;
if (Refresh == "1")
{
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyID", AgencyID));
command.Parameters.Add(new SqlParameter("@UserID", UserID));
command.Parameters.Add(new SqlParameter("@ProgramType", Program));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 500;
command.CommandText = "SP_GENERATE_PIR";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
}
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyID", AgencyID));
command.Parameters.Add(new SqlParameter("@UserID", UserID));
command.Parameters.Add(new SqlParameter("@ProgramType", Program));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_getPIR";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
GetPIRSummary(_dataset, _PIR);
return(_PIR);
}
public void GetPIRSummary(DataSet _dataset, PIRModel _PIR)
{
if (_dataset != null)
{
if (_dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
_PIR.Gen_Agency = dr["AgencyName"].ToString();
_PIR.Gen_Address = dr["Address1"].ToString();
_PIR.Gen_Delegate = dr["Delegate"].ToString();
_PIR.Gen_Grantee = dr["GranteeNo"].ToString();
_PIR.Gen_FName = dr["Firstname"].ToString();
_PIR.Gen_LName = dr["Lastname"].ToString();
_PIR.Gen_Phone1 = dr["Phone1"].ToString();
_PIR.Gen_Fax = dr["Fax"].ToString();
_PIR.Gen_Zip = dr["ZipCode"].ToString();
_PIR.Gen_Email = dr["EmailAddress"].ToString();
_PIR.A_ProgramStartDate = dr["ProgramStartDate"].ToString();
_PIR.A_ProgramEndDate = dr["ProgramEndDate"].ToString();
_PIR.A_Slots = dr["ServiceQty"].ToString();
_PIR.A_SlotsOther = dr["ServiceQtyOther"].ToString();
_PIR.A_FundQ1 = dr["FundQ1"].ToString();
_PIR.A_FundQ2 = dr["FundQ2"].ToString();
_PIR.A_FundQ3 = dr["FundQ3"].ToString();
_PIR.A_FundQ4 = dr["FundQ4"].ToString();
_PIR.A_FundQ5 = dr["FundQ5"].ToString();
_PIR.A_FundQ6 = dr["FundQ6"].ToString();
_PIR.A_FundQ7 = dr["FundQ7"].ToString();
_PIR.A_FundQ8 = dr["FundQ8"].ToString();
_PIR.A_FundQ9 = dr["FundQ9"].ToString();
_PIR.A_FundQ10 = dr["FundQ10"].ToString();
_PIR.A_FundQ11 = dr["FundQ11"].ToString();
_PIR.A_FundQ12 = dr["FundQ12"].ToString();
_PIR.A_FundQ13 = dr["FundQ13"].ToString();
_PIR.A_FundQ14 = dr["FundQ14"].ToString();
_PIR.A_FundQ15 = dr["FundQ15"].ToString();
_PIR.A_FundQ16 = dr["FundQ16"].ToString();
_PIR.A_11 = dr["A11"].ToString();
_PIR.A_12 = dr["A12"].ToString();
_PIR.A_12a = dr["A12a"].ToString();
_PIR.A_13_0 = dr["A13_0"].ToString();
_PIR.A_13_1 = dr["A13_1"].ToString();
_PIR.A_13_2 = dr["A13_2"].ToString();
_PIR.A_13_3 = dr["A13_3"].ToString();
_PIR.A_13_4 = dr["A13_4"].ToString();
_PIR.A_13_5 = dr["A13_5"].ToString();
_PIR.A_14_Preg = dr["A14_Preg"].ToString();
_PIR.A_15 = dr["A15Total"].ToString();
_PIR.A_16A = dr["A16A"].ToString();
_PIR.A_16B = dr["A16B"].ToString();
_PIR.A_16C = dr["A16C"].ToString();
_PIR.A_16D = dr["A16D"].ToString();
_PIR.A_16E = dr["A16E"].ToString();
_PIR.A_16F = dr["A16F"].ToString();
_PIR.A_18A = dr["A18_SECOND"].ToString();
_PIR.A_18B = dr["A18_THREE"].ToString();
_PIR.A_19 = dr["A19_LEFT"].ToString();
_PIR.A_19A = dr["A19A_45DAYS"].ToString();
_PIR.A_19B = dr["A19_KINDERGARTEN"].ToString();
_PIR.A_20 = dr["A20"].ToString();
_PIR.A_20A = dr["A20A_45DAYS"].ToString();
_PIR.A_20B = dr["A20B"].ToString();
_PIR.A_20B_1 = dr["A20B_1"].ToString();
_PIR.A_20B_2 = dr["A20B_2"].ToString();
_PIR.A_20B_3 = dr["A20B_3"].ToString();
_PIR.A_21 = dr["A21"].ToString();
_PIR.A_22 = dr["A22"].ToString();
_PIR.A_22_A = dr["A22A"].ToString();
_PIR.A_22_B = dr["A22B"].ToString();
_PIR.A_24 = dr["A24"].ToString();
_PIR.A_25a1 = dr["A25a1"].ToString();
_PIR.A_25a2 = dr["A25a2"].ToString();
_PIR.A_25b1 = dr["A25b1"].ToString();
_PIR.A_25b2 = dr["A25b2"].ToString();
_PIR.A_25c1 = dr["A25c1"].ToString();
_PIR.A_25c2 = dr["A25c2"].ToString();
_PIR.A_25d1 = dr["A25d1"].ToString();
_PIR.A_25d2 = dr["A25d2"].ToString();
_PIR.A_25e1 = dr["A25e1"].ToString();
_PIR.A_25e2 = dr["A25e2"].ToString();
_PIR.A_25f1 = dr["A25f1"].ToString();
_PIR.A_25f2 = dr["A25f2"].ToString();
_PIR.A_25g1 = dr["A25g1"].ToString();
_PIR.A_25g2 = dr["A25g2"].ToString();
_PIR.A_25h1 = dr["A25h1"].ToString();
_PIR.A_25h2 = dr["A25h2"].ToString();
_PIR.A_26a = dr["A26a"].ToString();
_PIR.A_26b = dr["A26b"].ToString();
_PIR.A_26c = dr["A26c"].ToString();
_PIR.A_26d = dr["A26d"].ToString();
_PIR.A_26e = dr["A26e"].ToString();
_PIR.A_26f = dr["A26f"].ToString();
_PIR.A_26g = dr["A26g"].ToString();
_PIR.A_26h = dr["A26h"].ToString();
_PIR.A_26i = dr["A26i"].ToString();
_PIR.A_26j = dr["A26j"].ToString();
_PIR.A_26k = dr["A26k"].ToString();
_PIR.A_27 = dr["ChildTransport"].ToString();
_PIR.A_27A = dr["A27A"].ToString();
_PIR.C_1_1 = dr["C1_AtEnroll"].ToString();
_PIR.C_1_2 = dr["C1_EndEnroll"].ToString();
_PIR.C_A_1 = dr["C1A_AtEnroll"].ToString();
_PIR.C_A_2 = dr["C1A_EndEnroll"].ToString();
_PIR.C_B_1 = dr["C1B_AtEnroll"].ToString();
_PIR.C_B_2 = dr["C1B_EndEnroll"].ToString();
_PIR.C_C_1 = dr["C1C_AtEnroll"].ToString();
_PIR.C_C_2 = dr["C1C_EndEnroll"].ToString();
_PIR.C_D_1 = dr["C1D_AtEnroll"].ToString();
_PIR.C_D_2 = dr["C1D_EndEnroll"].ToString();
_PIR.C_2_1 = dr["C2_AtEnroll"].ToString();
_PIR.C_2_2 = dr["C2_EndEnroll"].ToString();
_PIR.C_3_1 = dr["C3_AtEnroll"].ToString();
_PIR.C_3_2 = dr["C3_EndEnroll"].ToString();
_PIR.C_3A_1 = dr["C3A_AtEnroll"].ToString();
_PIR.C_3A_2 = dr["C3A_EndEnroll"].ToString();
_PIR.C_3B_1 = dr["C3B_AtEnroll"].ToString();
_PIR.C_3B_2 = dr["C3B_EndEnroll"].ToString();
_PIR.C_3C_1 = dr["C3C_AtEnroll"].ToString();
_PIR.C_3C_2 = dr["C3C_EndEnroll"].ToString();
_PIR.C_3D_1 = dr["C3D_AtEnroll"].ToString();
_PIR.C_3D_2 = dr["C3D_EndEnroll"].ToString();
_PIR.C_4_1 = dr["C4_1"].ToString();
_PIR.C_4_2 = dr["C4_2"].ToString();
_PIR.C_5_1 = dr["C5_1"].ToString();
_PIR.C_5_2 = dr["C5_2"].ToString();
_PIR.C_8_1 = dr["C8_1"].ToString();
_PIR.C_8_2 = dr["C8_2"].ToString();
_PIR.C_8_A = dr["C8_A"].ToString();
_PIR.C_8_A_1 = dr["C8_A_1"].ToString();
_PIR.C_9_A = dr["C9_A"].ToString();
_PIR.C_9_B = dr["C9_B"].ToString();
_PIR.C_9_C = dr["C9_C"].ToString();
_PIR.C_9_D = dr["C9_D"].ToString();
_PIR.C_9_E = dr["C9_E"].ToString();
_PIR.C_9_F = dr["C9_F"].ToString();
_PIR.C_10_A = dr["C10_A"].ToString();
_PIR.C_10_B = dr["C10_B"].ToString();
_PIR.C_10_C = dr["C10_C"].ToString();
_PIR.C_10_D = dr["C10_D"].ToString();
_PIR.C_11_1 = dr["C11_1"].ToString();
_PIR.C_11_2 = dr["C11_2"].ToString();
_PIR.C_12_1 = dr["C12_1"].ToString();
_PIR.C_12_2 = dr["C12_2"].ToString();
_PIR.C_13_1 = dr["C13_1"].ToString();
_PIR.C_13_2 = dr["C13_2"].ToString();
_PIR.C_14_A = dr["C14A"].ToString();
_PIR.C_14_B = dr["C14B"].ToString();
_PIR.C_14_C = dr["C14C"].ToString();
_PIR.C_14_D = dr["C14D"].ToString();
_PIR.C_14_E = dr["C14E"].ToString();
_PIR.C_14_F = dr["C14F"].ToString();
_PIR.C_14_G = dr["C14G"].ToString();
_PIR.C_15_A = dr["C15A"].ToString();
_PIR.C_15_B = dr["C15B"].ToString();
_PIR.C_15_C = dr["C15C"].ToString();
_PIR.C_16 = dr["C16"].ToString();
_PIR.C_17_1 = dr["C17_1"].ToString();
_PIR.C_17_2 = dr["C17_2"].ToString();
_PIR.C_18 = dr["C18"].ToString();
_PIR.C_19 = dr["C19"].ToString();
_PIR.C_19_A = dr["C19_A"].ToString();
_PIR.C_19_A_1 = dr["C19_A_1"].ToString();
_PIR.C_20 = dr["C20"].ToString();
_PIR.C_21 = dr["C21"].ToString();
_PIR.C_25 = dr["C25"].ToString();
_PIR.C_26 = dr["C26"].ToString();
_PIR.C_27_1 = dr["C27_1"].ToString();
_PIR.C_27_2 = dr["C27_2"].ToString();
_PIR.C_27_A_1 = dr["C27A_AtEnroll_1"].ToString();
_PIR.C_27_A_2 = dr["C27A_AtEnroll_2"].ToString();
_PIR.C_27_B_1 = dr["C27B_AtEnroll_1"].ToString();
_PIR.C_27_B_2 = dr["C27B_AtEnroll_2"].ToString();
_PIR.C_27_C_1 = dr["C27C_AtEnroll_1"].ToString();
_PIR.C_27_C_2 = dr["C27C_AtEnroll_2"].ToString();
_PIR.C_27_D_1 = dr["C27D_AtEnroll_1"].ToString();
_PIR.C_27_D_2 = dr["C27D_AtEnroll_2"].ToString();
_PIR.C_27_E_1 = dr["C27E_AtEnroll_1"].ToString();
_PIR.C_27_E_2 = dr["C27E_AtEnroll_2"].ToString();
_PIR.C_27_F_1 = dr["C27F_AtEnroll_1"].ToString();
_PIR.C_27_F_2 = dr["C27F_AtEnroll_2"].ToString();
_PIR.C_27_G_1 = dr["C27G_AtEnroll_1"].ToString();
_PIR.C_27_G_2 = dr["C27G_AtEnroll_2"].ToString();
_PIR.C_27_H_1 = dr["C27H_AtEnroll_1"].ToString();
_PIR.C_27_H_2 = dr["C27H_AtEnroll_2"].ToString();
_PIR.C_27_I_1 = dr["C27I_AtEnroll_1"].ToString();
_PIR.C_27_I_2 = dr["C27I_AtEnroll_2"].ToString();
_PIR.C_27_J_1 = dr["C27J_AtEnroll_1"].ToString();
_PIR.C_27_J_2 = dr["C27J_AtEnroll_2"].ToString();
_PIR.C_27_K_1 = dr["C27K_AtEnroll_1"].ToString();
_PIR.C_27_K_2 = dr["C27K_AtEnroll_2"].ToString();
_PIR.C_27_L_1 = dr["C27L_AtEnroll_1"].ToString();
_PIR.C_27_L_2 = dr["C27L_AtEnroll_2"].ToString();
_PIR.C_27_M_1 = dr["C27M_AtEnroll_1"].ToString();
_PIR.C_27_M_2 = dr["C27M_AtEnroll_2"].ToString();
_PIR.C_35 = dr["C35"].ToString();
_PIR.C_35_A = dr["C35A"].ToString();
_PIR.C_35_B = dr["C35B"].ToString();
_PIR.C_36_A = dr["C36A"].ToString();
_PIR.C_36_B = dr["C36B"].ToString();
_PIR.C_36_C = dr["C36C"].ToString();
_PIR.C_36_D = dr["C36D"].ToString();
_PIR.C_36_E = dr["C36E"].ToString();
_PIR.C_37_A = dr["C37A"].ToString();
_PIR.C_37_B = dr["C37B"].ToString();
_PIR.C_37_C = dr["C37C"].ToString();
_PIR.C_37_D = dr["C37D"].ToString();
_PIR.C_37_E = dr["C37E"].ToString();
_PIR.C_37_F = dr["C37F"].ToString();
_PIR.C_38_A = dr["C38A"].ToString();
_PIR.C_38_B = dr["C38B"].ToString();
_PIR.C_38_C = dr["C38C"].ToString();
_PIR.C_39_A = dr["C39A"].ToString();
_PIR.C_39_B = dr["C39B"].ToString();
_PIR.C_40_A = dr["C40A"].ToString();
_PIR.C_40_B = dr["C40B"].ToString();
_PIR.C_41_1 = dr["C41_1"].ToString();
_PIR.C_41_2 = dr["C41_2"].ToString();
_PIR.C_42_1 = dr["C42_1"].ToString();
_PIR.C_42_2 = dr["C42_2"].ToString();
_PIR.C_43_1 = dr["C43_1"].ToString();
_PIR.C_43_2 = dr["C43_2"].ToString();
_PIR.C_44_1 = dr["C44_1"].ToString();
_PIR.C_44_2 = dr["C44_2"].ToString();
_PIR.C_45_A = dr["C45A"].ToString();
_PIR.C_45_B = dr["C45B"].ToString();
_PIR.C_45_C = dr["C45C"].ToString();
_PIR.C_46_A = dr["C46A"].ToString();
_PIR.C_46_B = dr["C46B"].ToString();
_PIR.C_47_A = dr["C47A"].ToString();
_PIR.C_47_B = dr["C47B"].ToString();
_PIR.C_47_C = dr["C47C"].ToString();
_PIR.C_47_D = dr["C47D"].ToString();
_PIR.C_48 = dr["C48"].ToString();
_PIR.C_49_A = dr["C49A"].ToString();
_PIR.C_49_B = dr["C49B"].ToString();
_PIR.C_49_C = dr["C49C"].ToString();
_PIR.C_49_D = dr["C49D"].ToString();
_PIR.C_50_A_1 = dr["C50A_1"].ToString();
_PIR.C_50_A_2 = dr["C50A_2"].ToString();
_PIR.C_50_B_1 = dr["C50B_1"].ToString();
_PIR.C_50_B_2 = dr["C50B_2"].ToString();
_PIR.C_50_C_1 = dr["C50C_1"].ToString();
_PIR.C_50_C_2 = dr["C50C_2"].ToString();
_PIR.C_50_D_1 = dr["C50D_1"].ToString();
_PIR.C_50_D_2 = dr["C50D_2"].ToString();
_PIR.C_50_E_1 = dr["C50E_1"].ToString();
_PIR.C_50_E_2 = dr["C50E_2"].ToString();
_PIR.C_50_F_1 = dr["C50F_1"].ToString();
_PIR.C_50_F_2 = dr["C50F_2"].ToString();
_PIR.C_50_G_1 = dr["C50G_1"].ToString();
_PIR.C_50_G_2 = dr["C50G_2"].ToString();
_PIR.C_50_H_1 = dr["C50H_1"].ToString();
_PIR.C_50_H_2 = dr["C50H_2"].ToString();
_PIR.C_50_I_1 = dr["C50I_1"].ToString();
_PIR.C_50_I_2 = dr["C50I_2"].ToString();
_PIR.C_50_J_1 = dr["C50J_1"].ToString();
_PIR.C_50_J_2 = dr["C50J_2"].ToString();
_PIR.C_50_K_1 = dr["C50K_1"].ToString();
_PIR.C_50_K_2 = dr["C50K_2"].ToString();
_PIR.C_50_L_1 = dr["C50L_1"].ToString();
_PIR.C_50_L_2 = dr["C50L_2"].ToString();
_PIR.C_50_M_1 = dr["C50M_1"].ToString();
_PIR.C_50_M_2 = dr["C50M_2"].ToString();
_PIR.C_50_N_1 = dr["C50N_1"].ToString();
_PIR.C_50_N_2 = dr["C50N_2"].ToString();
_PIR.C_50_O_1 = dr["C50O_1"].ToString();
_PIR.C_50_O_2 = dr["C50O_2"].ToString();
_PIR.C_50_P_1 = dr["C50P_1"].ToString();
_PIR.C_50_P_2 = dr["C50P_2"].ToString();
_PIR.C_51_1 = dr["C51_1"].ToString();
_PIR.C_51_2 = dr["C51_2"].ToString();
_PIR.C_52_A = dr["C52A"].ToString();
_PIR.C_52_B = dr["C52B"].ToString();
_PIR.C_52_C = dr["C52C"].ToString();
_PIR.C_52_D = dr["C52D"].ToString();
_PIR.C_52_E = dr["C52E"].ToString();
_PIR.C_53 = dr["C53"].ToString();
_PIR.C_54 = dr["C54"].ToString();
_PIR.C_55 = dr["C55"].ToString();
_PIR.C_56 = dr["C56"].ToString();
_PIR.C_57 = dr["C57"].ToString();
_PIR.B1_1 = dr["B1_1"].ToString();
_PIR.B1_2 = dr["B1_2"].ToString();
_PIR.B1A_1 = dr["B1A_1"].ToString();
_PIR.B1A_2 = dr["B1A_2"].ToString();
_PIR.B1B_1 = dr["B1B_1"].ToString();
_PIR.B1B_2 = dr["B1B_2"].ToString();
_PIR.B1B_1_1 = dr["B1B_1_1"].ToString();
_PIR.B1B_1_2 = dr["B1B_1_2"].ToString();
_PIR.B3A_1 = dr["B3A_1"].ToString();
_PIR.B3A_2 = dr["B3A_2"].ToString();
_PIR.B3B_1 = dr["B3B_1"].ToString();
_PIR.B3B_2 = dr["B3B_2"].ToString();
_PIR.B3C_1 = dr["B3C_1"].ToString();
_PIR.B3C_2 = dr["B3C_2"].ToString();
_PIR.B3D_1 = dr["B3D_1"].ToString();
_PIR.B3D_2 = dr["B3D_2"].ToString();
_PIR.B3E_1 = dr["B3E_1"].ToString();
_PIR.B3E_2 = dr["B3E_2"].ToString();
_PIR.B3F_1 = dr["B3F_1"].ToString();
_PIR.B3F_2 = dr["B3F_2"].ToString();
_PIR.B3G_1 = dr["B3G_1"].ToString();
_PIR.B3G_2 = dr["B3G_2"].ToString();
_PIR.B5_1 = dr["B5_1"].ToString();
_PIR.B5_2 = dr["B5_2"].ToString();
_PIR.B5A_1_1 = dr["B5A_1_1"].ToString();
_PIR.B5A_1_2 = dr["B5A_1_2"].ToString();
_PIR.B5A_2_1 = dr["B5A_2_1"].ToString();
_PIR.B5A_2_2 = dr["B5A_2_2"].ToString();
_PIR.B5B_1_1 = dr["B5B_1_1"].ToString();
_PIR.B5B_1_2 = dr["B5B_1_2"].ToString();
_PIR.B5B_2_1 = dr["B5B_2_1"].ToString();
_PIR.B5B_2_2 = dr["B5B_2_2"].ToString();
_PIR.B5B_3_1 = dr["B5B_3_1"].ToString();
_PIR.B5B_3_2 = dr["B5B_3_2"].ToString();
_PIR.B5B_4_1 = dr["B5B_4_1"].ToString();
_PIR.B5B_4_2 = dr["B5B_4_2"].ToString();
_PIR.B5C_1_1 = dr["B5C_1_1"].ToString();
_PIR.B5C_1_2 = dr["B5C_1_2"].ToString();
_PIR.B5C_2_1 = dr["B5C_2_1"].ToString();
_PIR.B5C_2_2 = dr["B5C_2_2"].ToString();
_PIR.B5C_3_1 = dr["B5C_3_1"].ToString();
_PIR.B5C_3_2 = dr["B5C_3_2"].ToString();
_PIR.B5D_1 = dr["B5D_1"].ToString();
_PIR.B5D_2 = dr["B5D_2"].ToString();
_PIR.B5D_1_1 = dr["B5D_1_1"].ToString();
_PIR.B5D_1_2 = dr["B5D_1_2"].ToString();
_PIR.B5D_2_1 = dr["B5D_2_1"].ToString();
_PIR.B5D_2_2 = dr["B5D_2_2"].ToString();
_PIR.B5D_3_1 = dr["B5D_3_1"].ToString();
_PIR.B5D_3_2 = dr["B5D_3_2"].ToString();
_PIR.B5E_1_1 = dr["B5E_1_1"].ToString();
_PIR.B5E_1_2 = dr["B5E_1_2"].ToString();
_PIR.B5E_2_1 = dr["B5E_2_1"].ToString();
_PIR.B5E_2_2 = dr["B5E_2_2"].ToString();
_PIR.B5E_3_1 = dr["B5E_3_1"].ToString();
_PIR.B5E_3_2 = dr["B5E_3_2"].ToString();
_PIR.B6 = dr["B6"].ToString();
_PIR.B7 = dr["B7"].ToString();
_PIR.B8_1 = dr["B8_1"].ToString();
_PIR.B8_2 = dr["B8_2"].ToString();
_PIR.B8A_1_1 = dr["B8A_1_1"].ToString();
_PIR.B8A_1_2 = dr["B8A_1_2"].ToString();
_PIR.B8A_2_1 = dr["B8A_2_1"].ToString();
_PIR.B8A_2_2 = dr["B8A_2_2"].ToString();
_PIR.B8B_1_1 = dr["B8B_1_1"].ToString();
_PIR.B8B_1_2 = dr["B8B_1_2"].ToString();
_PIR.B8B_2_1 = dr["B8B_2_1"].ToString();
_PIR.B8B_2_2 = dr["B8B_2_2"].ToString();
_PIR.B8B_3_1 = dr["B8B_3_1"].ToString();
_PIR.B8B_3_2 = dr["B8B_3_2"].ToString();
_PIR.B8B_4_1 = dr["B8B_4_1"].ToString();
_PIR.B8B_4_2 = dr["B8B_4_2"].ToString();
_PIR.B8C_1_1 = dr["B8C_1_1"].ToString();
_PIR.B8C_1_2 = dr["B8C_1_2"].ToString();
_PIR.B8C_2_1 = dr["B8C_2_1"].ToString();
_PIR.B8C_2_2 = dr["B8C_2_2"].ToString();
_PIR.B8C_3_1 = dr["B8C_3_1"].ToString();
_PIR.B8C_3_2 = dr["B8C_3_2"].ToString();
_PIR.B8D_1 = dr["B8D_1"].ToString();
_PIR.B8D_2 = dr["B8D_2"].ToString();
_PIR.B8D_1_1 = dr["B8D_1_1"].ToString();
_PIR.B8D_1_2 = dr["B8D_1_2"].ToString();
_PIR.B8D_2_1 = dr["B8D_2_1"].ToString();
_PIR.B8D_2_2 = dr["B8D_2_2"].ToString();
_PIR.B8D_3_1 = dr["B8D_3_1"].ToString();
_PIR.B8D_3_2 = dr["B8D_3_2"].ToString();
_PIR.B8E_1_1 = dr["B8E_1_1"].ToString();
_PIR.B8E_1_2 = dr["B8E_1_2"].ToString();
_PIR.B8E_2_1 = dr["B8E_2_1"].ToString();
_PIR.B8E_2_2 = dr["B8E_2_2"].ToString();
_PIR.B8E_3_1 = dr["B8E_3_1"].ToString();
_PIR.B8E_3_2 = dr["B8E_3_2"].ToString();
_PIR.B9_1 = dr["B9_1"].ToString();
_PIR.B9_2 = dr["B9_2"].ToString();
_PIR.B9_3 = dr["B9_3"].ToString();
_PIR.B9_4 = dr["B9_4"].ToString();
_PIR.B9A_1_1 = dr["B9A_1_1"].ToString();
_PIR.B9A_1_2 = dr["B9A_1_2"].ToString();
_PIR.B9A_1_3 = dr["B9A_1_3"].ToString();
_PIR.B9A_1_4 = dr["B9A_1_4"].ToString();
_PIR.B9A_2_1 = dr["B9A_2_1"].ToString();
_PIR.B9A_2_2 = dr["B9A_2_2"].ToString();
_PIR.B9A_2_3 = dr["B9A_2_3"].ToString();
_PIR.B9A_2_4 = dr["B9A_2_4"].ToString();
_PIR.B9A_3_1 = dr["B9A_3_1"].ToString();
_PIR.B9A_3_2 = dr["B9A_3_2"].ToString();
_PIR.B9A_3_3 = dr["B9A_3_3"].ToString();
_PIR.B9A_3_4 = dr["B9A_3_4"].ToString();
_PIR.B9A_4_1 = dr["B9A_4_1"].ToString();
_PIR.B9A_4_2 = dr["B9A_4_2"].ToString();
_PIR.B9A_4_3 = dr["B9A_4_3"].ToString();
_PIR.B9A_4_4 = dr["B9A_4_4"].ToString();
_PIR.B9A_5_1 = dr["B9A_5_1"].ToString();
_PIR.B9A_5_2 = dr["B9A_5_2"].ToString();
_PIR.B9A_5_3 = dr["B9A_5_3"].ToString();
_PIR.B9A_5_4 = dr["B9A_5_4"].ToString();
_PIR.B9A_6_1 = dr["B9A_6_1"].ToString();
_PIR.B9A_6_2 = dr["B9A_6_2"].ToString();
_PIR.B9A_6_3 = dr["B9A_6_3"].ToString();
_PIR.B9A_6_4 = dr["B9A_6_4"].ToString();
_PIR.B9A_7_1 = dr["B9A_7_1"].ToString();
_PIR.B9A_7_2 = dr["B9A_7_2"].ToString();
_PIR.B9A_7_3 = dr["B9A_7_3"].ToString();
_PIR.B9A_7_4 = dr["B9A_7_4"].ToString();
_PIR.B9A_8_1 = dr["B9A_8_1"].ToString();
_PIR.B9A_8_2 = dr["B9A_8_2"].ToString();
_PIR.B9A_8_3 = dr["B9A_8_3"].ToString();
_PIR.B9A_8_4 = dr["B9A_8_4"].ToString();
_PIR.B9B_1_1 = dr["B9B_1_1"].ToString();
_PIR.B9B_1_2 = dr["B9B_1_2"].ToString();
_PIR.B9B_1_3 = dr["B9B_1_3"].ToString();
_PIR.B9B_1_4 = dr["B9B_1_4"].ToString();
_PIR.B9B_2_1 = dr["B9B_2_1"].ToString();
_PIR.B9B_2_2 = dr["B9B_2_2"].ToString();
_PIR.B9B_2_3 = dr["B9B_2_3"].ToString();
_PIR.B9B_2_4 = dr["B9B_2_4"].ToString();
_PIR.B9B_3_1 = dr["B9B_3_1"].ToString();
_PIR.B9B_3_2 = dr["B9B_3_2"].ToString();
_PIR.B9B_3_3 = dr["B9B_3_3"].ToString();
_PIR.B9B_3_4 = dr["B9B_3_4"].ToString();
_PIR.B9B_4_1 = dr["B9B_4_1"].ToString();
_PIR.B9B_4_2 = dr["B9B_4_2"].ToString();
_PIR.B9B_4_3 = dr["B9B_4_3"].ToString();
_PIR.B9B_4_4 = dr["B9B_4_4"].ToString();
_PIR.B9B_5_1 = dr["B9B_5_1"].ToString();
_PIR.B9B_5_2 = dr["B9B_5_2"].ToString();
_PIR.B9B_5_3 = dr["B9B_5_3"].ToString();
_PIR.B9B_5_4 = dr["B9B_5_4"].ToString();
_PIR.B9B_6_1 = dr["B9B_6_1"].ToString();
_PIR.B9B_6_2 = dr["B9B_6_2"].ToString();
_PIR.B9B_6_3 = dr["B9B_6_3"].ToString();
_PIR.B9B_6_4 = dr["B9B_6_4"].ToString();
_PIR.B9B_7_1 = dr["B9B_7_1"].ToString();
_PIR.B9B_7_2 = dr["B9B_7_2"].ToString();
_PIR.B9B_7_3 = dr["B9B_7_3"].ToString();
_PIR.B9B_7_4 = dr["B9B_7_4"].ToString();
_PIR.B9C_1_1 = dr["B9C_1_1"].ToString();
_PIR.B9C_1_2 = dr["B9C_1_2"].ToString();
_PIR.B9C_1_3 = dr["B9C_1_3"].ToString();
_PIR.B9C_1_4 = dr["B9C_1_4"].ToString();
_PIR.B9C_2_1 = dr["B9C_2_1"].ToString();
_PIR.B9C_2_2 = dr["B9C_2_2"].ToString();
_PIR.B9C_2_3 = dr["B9C_2_3"].ToString();
_PIR.B9C_2_4 = dr["B9C_2_4"].ToString();
_PIR.B9C_3_1 = dr["B9C_3_1"].ToString();
_PIR.B9C_3_2 = dr["B9C_3_2"].ToString();
_PIR.B9C_3_3 = dr["B9C_3_3"].ToString();
_PIR.B9C_3_4 = dr["B9C_3_4"].ToString();
_PIR.B9C_4_1 = dr["B9C_4_1"].ToString();
_PIR.B9C_4_2 = dr["B9C_4_2"].ToString();
_PIR.B9C_4_3 = dr["B9C_4_3"].ToString();
_PIR.B9C_4_4 = dr["B9C_4_4"].ToString();
_PIR.B9C_5_1 = dr["B9C_5_1"].ToString();
_PIR.B9C_5_2 = dr["B9C_5_2"].ToString();
_PIR.B9C_5_3 = dr["B9C_5_3"].ToString();
_PIR.B9C_5_4 = dr["B9C_5_4"].ToString();
_PIR.B9C_6_1 = dr["B9C_6_1"].ToString();
_PIR.B9C_6_2 = dr["B9C_6_2"].ToString();
_PIR.B9C_6_3 = dr["B9C_6_3"].ToString();
_PIR.B9C_6_4 = dr["B9C_6_4"].ToString();
_PIR.B9C_7_1 = dr["B9C_7_1"].ToString();
_PIR.B9C_7_2 = dr["B9C_7_2"].ToString();
_PIR.B9C_7_3 = dr["B9C_7_3"].ToString();
_PIR.B9C_7_4 = dr["B9C_7_4"].ToString();
_PIR.B9D_1_1 = dr["B9D_1_1"].ToString();
_PIR.B9D_1_2 = dr["B9D_1_2"].ToString();
_PIR.B9D_1_3 = dr["B9D_1_3"].ToString();
_PIR.B9D_1_4 = dr["B9D_1_4"].ToString();
_PIR.B9D_2_1 = dr["B9D_2_1"].ToString();
_PIR.B9D_2_2 = dr["B9D_2_2"].ToString();
_PIR.B9D_2_3 = dr["B9D_2_3"].ToString();
_PIR.B9D_2_4 = dr["B9D_2_4"].ToString();
_PIR.B9D_3_1 = dr["B9D_3_1"].ToString();
_PIR.B9D_3_2 = dr["B9D_3_2"].ToString();
_PIR.B9D_3_3 = dr["B9D_3_3"].ToString();
_PIR.B9D_3_4 = dr["B9D_3_4"].ToString();
_PIR.B9D_4_1 = dr["B9D_4_1"].ToString();
_PIR.B9D_4_2 = dr["B9D_4_2"].ToString();
_PIR.B9D_4_3 = dr["B9D_4_3"].ToString();
_PIR.B9D_4_4 = dr["B9D_4_4"].ToString();
_PIR.B9D_5_1 = dr["B9D_5_1"].ToString();
_PIR.B9D_5_2 = dr["B9D_5_2"].ToString();
_PIR.B9D_5_3 = dr["B9D_5_3"].ToString();
_PIR.B9D_5_4 = dr["B9D_5_4"].ToString();
_PIR.B9E_1 = dr["B9E_1"].ToString();
_PIR.B9E_2 = dr["B9E_2"].ToString();
_PIR.B9E_3 = dr["B9E_3"].ToString();
_PIR.B9E_4 = dr["B9E_4"].ToString();
_PIR.B9E_1_1 = dr["B9E_1_1"].ToString();
_PIR.B9E_1_2 = dr["B9E_1_2"].ToString();
_PIR.B9E_1_3 = dr["B9E_1_3"].ToString();
_PIR.B9E_1_4 = dr["B8E_3_2"].ToString();
_PIR.B9E_2_1 = dr["B9E_1_4"].ToString();
_PIR.B9E_2_2 = dr["B9E_2_2"].ToString();
_PIR.B9E_2_3 = dr["B9E_2_3"].ToString();
_PIR.B9E_2_4 = dr["B9E_2_4"].ToString();
_PIR.B9E_3_1 = dr["B9E_3_1"].ToString();
_PIR.B9E_3_2 = dr["B9E_3_2"].ToString();
_PIR.B9E_3_3 = dr["B9E_3_3"].ToString();
_PIR.B9E_3_4 = dr["B9E_3_4"].ToString();
_PIR.B9E_4_1 = dr["B9E_4_1"].ToString();
_PIR.B9E_4_2 = dr["B9E_4_2"].ToString();
_PIR.B9E_4_3 = dr["B9E_4_3"].ToString();
_PIR.B9E_4_4 = dr["B9E_4_4"].ToString();
}
}
}
}
public void GetPIRSummary(DataSet _dataset, PIRModel _PIR)
{
if (_dataset != null)
{
if (_dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
_PIR.Gen_Agency = dr["AgencyName"].ToString();
_PIR.Gen_Address = dr["Address1"].ToString();
_PIR.Gen_Delegate = dr["Delegate"].ToString();
_PIR.Gen_Grantee = dr["GranteeNo"].ToString();
_PIR.Gen_FName = dr["Firstname"].ToString();
_PIR.Gen_LName = dr["Lastname"].ToString();
_PIR.Gen_Phone1 = dr["Phone1"].ToString();
_PIR.Gen_Fax = dr["Fax"].ToString();
_PIR.Gen_Zip = dr["ZipCode"].ToString();
_PIR.Gen_Email = dr["EmailAddress"].ToString();
_PIR.A_ProgramStartDate = dr["ProgramStartDate"].ToString();
_PIR.A_ProgramEndDate = dr["ProgramEndDate"].ToString();
_PIR.A_Slots = dr["ServiceQty"].ToString();
_PIR.A_SlotsOther = dr["ServiceQtyOther"].ToString();
_PIR.A_FundQ1 = dr["FundQ1"].ToString();
_PIR.A_FundQ2 = dr["FundQ2"].ToString();
_PIR.A_FundQ3 = dr["FundQ3"].ToString();
_PIR.A_FundQ4 = dr["FundQ4"].ToString();
_PIR.A_FundQ5 = dr["FundQ5"].ToString();
_PIR.A_FundQ6 = dr["FundQ6"].ToString();
_PIR.A_FundQ7 = dr["FundQ7"].ToString();
_PIR.A_FundQ8 = dr["FundQ8"].ToString();
_PIR.A_FundQ9 = dr["FundQ9"].ToString();
_PIR.A_FundQ10 = dr["FundQ10"].ToString();
_PIR.A_FundQ11 = dr["FundQ11"].ToString();
_PIR.A_FundQ12 = dr["FundQ12"].ToString();
_PIR.A_FundQ13 = dr["FundQ13"].ToString();
_PIR.A_FundQ14 = dr["FundQ14"].ToString();
_PIR.A_FundQ15 = dr["FundQ15"].ToString();
_PIR.A_FundQ16 = dr["FundQ16"].ToString();
_PIR.A_11 = dr["A11"].ToString();
_PIR.A_12 = dr["A12"].ToString();
_PIR.A_12a = dr["A12a"].ToString();
_PIR.A_13_0 = dr["A13_0"].ToString();
_PIR.A_13_1 = dr["A13_1"].ToString();
_PIR.A_13_2 = dr["A13_2"].ToString();
_PIR.A_13_3 = dr["A13_3"].ToString();
_PIR.A_13_4 = dr["A13_4"].ToString();
_PIR.A_13_5 = dr["A13_5"].ToString();
_PIR.A_14_Preg = dr["A14_Preg"].ToString();
_PIR.A_15 = dr["A15Total"].ToString();
_PIR.A_16A = dr["A16A"].ToString();
_PIR.A_16B = dr["A16B"].ToString();
_PIR.A_16C = dr["A16C"].ToString();
_PIR.A_16D = dr["A16D"].ToString();
_PIR.A_16E = dr["A16E"].ToString();
_PIR.A_16F = dr["A16F"].ToString();
_PIR.A_18A = dr["A18_SECOND"].ToString();
_PIR.A_18B = dr["A18_THREE"].ToString();
_PIR.A_19 = dr["A19_LEFT"].ToString();
_PIR.A_19A = dr["A19A_45DAYS"].ToString();
_PIR.A_19B = dr["A19_KINDERGARTEN"].ToString();
_PIR.A_20 = dr["A20"].ToString();
_PIR.A_20A = dr["A20A_45DAYS"].ToString();
_PIR.A_25a1 = dr["A25a1"].ToString();
_PIR.A_25a2 = dr["A25a2"].ToString();
_PIR.A_25b1 = dr["A25b1"].ToString();
_PIR.A_25b2 = dr["A25b2"].ToString();
_PIR.A_25c1 = dr["A25c1"].ToString();
_PIR.A_25c2 = dr["A25c2"].ToString();
_PIR.A_25d1 = dr["A25d1"].ToString();
_PIR.A_25d2 = dr["A25d2"].ToString();
_PIR.A_25e1 = dr["A25e1"].ToString();
_PIR.A_25e2 = dr["A25e2"].ToString();
_PIR.A_25f1 = dr["A25f1"].ToString();
_PIR.A_25f2 = dr["A25f2"].ToString();
_PIR.A_25g1 = dr["A25g1"].ToString();
_PIR.A_25g2 = dr["A25g2"].ToString();
_PIR.A_25h1 = dr["A25h1"].ToString();
_PIR.A_25h2 = dr["A25h2"].ToString();
_PIR.A_26a = dr["A26a"].ToString();
_PIR.A_26b = dr["A26b"].ToString();
_PIR.A_26c = dr["A26c"].ToString();
_PIR.A_26d = dr["A26d"].ToString();
_PIR.A_26e = dr["A26e"].ToString();
_PIR.A_26f = dr["A26f"].ToString();
_PIR.A_26g = dr["A26g"].ToString();
_PIR.A_26h = dr["A26h"].ToString();
_PIR.A_26i = dr["A26i"].ToString();
_PIR.A_26j = dr["A26j"].ToString();
_PIR.A_26k = dr["A26k"].ToString();
_PIR.A_27 = dr["ChildTransport"].ToString();
_PIR.C_1_1 = dr["C1_AtEnroll"].ToString();
_PIR.C_1_2 = dr["C1_EndEnroll"].ToString();
_PIR.C_A_1 = dr["C1A_AtEnroll"].ToString();
_PIR.C_A_2 = dr["C1A_EndEnroll"].ToString();
_PIR.C_B_1 = dr["C1B_AtEnroll"].ToString();
_PIR.C_B_2 = dr["C1B_EndEnroll"].ToString();
_PIR.C_C_1 = dr["C1C_AtEnroll"].ToString();
_PIR.C_C_2 = dr["C1C_EndEnroll"].ToString();
_PIR.C_D_1 = dr["C1D_AtEnroll"].ToString();
_PIR.C_D_2 = dr["C1D_EndEnroll"].ToString();
_PIR.C_2_1 = dr["C2_AtEnroll"].ToString();
_PIR.C_2_2 = dr["C2_EndEnroll"].ToString();
_PIR.C_3_1 = dr["C3_AtEnroll"].ToString();
_PIR.C_3_2 = dr["C3_EndEnroll"].ToString();
_PIR.C_3A_1 = dr["C3A_AtEnroll"].ToString();
_PIR.C_3A_2 = dr["C3A_EndEnroll"].ToString();
_PIR.C_3B_1 = dr["C3B_AtEnroll"].ToString();
_PIR.C_3B_2 = dr["C3B_EndEnroll"].ToString();
_PIR.C_3C_1 = dr["C3C_AtEnroll"].ToString();
_PIR.C_3C_2 = dr["C3C_EndEnroll"].ToString();
_PIR.C_3D_1 = dr["C3D_AtEnroll"].ToString();
_PIR.C_3D_2 = dr["C3D_EndEnroll"].ToString();
/* _PIR.C_4_1 = dr["C4_AtEnroll"].ToString();
* _PIR.C_4_2 = dr["C4_EndEnroll"].ToString();
* _PIR.C_5_1 = dr["C5_AtEnroll"].ToString();
* _PIR.C_5_2 = dr["C5_EndEnroll"].ToString();
* _PIR.C_6_1 = dr["C6_AtEnroll"].ToString();
* _PIR.C_6_2 = dr["C6_EndEnroll"].ToString();
* _PIR.C_8_1 = dr["C8_AtEnroll"].ToString();
* _PIR.C_8_2 = dr["C8_EndEnroll"].ToString();
**/
}
}
if (_dataset.Tables[1].Rows.Count > 0)
{
_PIR.C52A = _dataset.Tables[1].Rows[0]["C52A"].ToString();
_PIR.C52B = _dataset.Tables[1].Rows[0]["C52B"].ToString();
_PIR.C52C = _dataset.Tables[1].Rows[0]["C52C"].ToString();
_PIR.C52D = _dataset.Tables[1].Rows[0]["C52D"].ToString();
_PIR.C52E = _dataset.Tables[1].Rows[0]["C52E"].ToString();
}
if (_dataset.Tables[2].Rows.Count > 0)
{
_PIR.C52A1 = _dataset.Tables[2].Rows[0]["C52A"].ToString();
_PIR.C52B1 = _dataset.Tables[2].Rows[0]["C52B"].ToString();
_PIR.C52C1 = _dataset.Tables[2].Rows[0]["C52C"].ToString();
_PIR.C52D1 = _dataset.Tables[2].Rows[0]["C52D"].ToString();
_PIR.C52E1 = _dataset.Tables[2].Rows[0]["C52E"].ToString();
}
}
}
public void GetDisabilityChildren(string AgencyId, string UserId, PIRModel _disPIR)
{
List <DisabilityPIR> pirDisability = new List <DisabilityPIR>();
DisabilityPIR pirchild = new DisabilityPIR();
List <DisabilitiesType> disTypeList = new List <DisabilitiesType>();
DisabilitiesType type = new DisabilitiesType();
try
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyID", AgencyId));
command.Parameters.Add(new SqlParameter("@UserID", UserId));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "USP_GetDisabilityChildrenPIR";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
if (_dataset != null)
{
if (_dataset.Tables[0] != null)
{
disTypeList = (from DataRow dr in _dataset.Tables[0].Rows
select new DisabilitiesType
{
ID = dr["ID"].ToString(),
DisabilityType = dr["DisablitiesType"].ToString(),
QualifiedChildrenCount = dr["QualifiedChildrenCount"].ToString(),
ServiceReceivedChildrenCount = dr["ServiceReceivedChildrenCount"].ToString()
}
).ToList();
_disPIR.C_27_a_1 = disTypeList.Where(x => x.DisabilityType == c_27_a).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_a_2 = disTypeList.Where(x => x.DisabilityType == c_27_a).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_b_1 = disTypeList.Where(x => x.DisabilityType == c_27_b).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_b_2 = disTypeList.Where(x => x.DisabilityType == c_27_b).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_c_1 = disTypeList.Where(x => x.DisabilityType == c_27_c).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_c_2 = disTypeList.Where(x => x.DisabilityType == c_27_c).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_d_1 = disTypeList.Where(x => x.DisabilityType == c_27_d).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_d_2 = disTypeList.Where(x => x.DisabilityType == c_27_d).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_e_1 = disTypeList.Where(x => x.DisabilityType == c_27_e).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_e_2 = disTypeList.Where(x => x.DisabilityType == c_27_e).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_f_1 = disTypeList.Where(x => x.DisabilityType == c_27_f).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_f_2 = disTypeList.Where(x => x.DisabilityType == c_27_f).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_g_1 = disTypeList.Where(x => x.DisabilityType == c_27_g).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_g_2 = disTypeList.Where(x => x.DisabilityType == c_27_g).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_h_1 = disTypeList.Where(x => x.DisabilityType == c_27_h).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_h_2 = disTypeList.Where(x => x.DisabilityType == c_27_h).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_i_1 = disTypeList.Where(x => x.DisabilityType == c_27_i).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_i_2 = disTypeList.Where(x => x.DisabilityType == c_27_i).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_j_1 = disTypeList.Where(x => x.DisabilityType == c_27_j).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_j_2 = disTypeList.Where(x => x.DisabilityType == c_27_j).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_k_1 = disTypeList.Where(x => x.DisabilityType == c_27_k).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_k_2 = disTypeList.Where(x => x.DisabilityType == c_27_k).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_l_1 = disTypeList.Where(x => x.DisabilityType == c_27_l).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_l_2 = disTypeList.Where(x => x.DisabilityType == c_27_l).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_m_1 = disTypeList.Where(x => x.DisabilityType == c_27_m).Select(x => x.QualifiedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_m_2 = disTypeList.Where(x => x.DisabilityType == c_27_m).Select(x => x.ServiceReceivedChildrenCount).FirstOrDefault().ToString();
_disPIR.C_27_ChildDisabilityCount = disTypeList.Sum(x => int.Parse(x.QualifiedChildrenCount)).ToString();
_disPIR.C_27_ReceivedServiceCount = disTypeList.Sum(x => int.Parse(x.ServiceReceivedChildrenCount)).ToString();
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
}
