protected void btnNext_Click(object sender, EventArgs e)
{
rep = new Reports();
bar = new Barangay();
mc = new MonthConverter();
bool inserted = false;
if (txtPopulation.Text != "")
{
if (Int32.Parse(txtPopulation.Text) > 0)
{
if (rep.HasDataForTheYear(Int32.Parse(ddlYear.Text), ddlMonth.Text, bar.GetBarangayID(ddlBarangay.Text)))
{
Response.Write("<script> window.alert('Barangay: " + ddlBarangay.Text + " of the Year: " +
ddlYear.Text + " has data in the database. Please Try Other Year for the Barangay')</script>");
}
else
{
inserted = rep.InsertPopulation(bar.GetBarangayID(ddlBarangay.Text), Int32.Parse(txtPopulation.Text),
Int32.Parse("0"), mc.MonthNameToIndex(ddlMonth.Text), Int32.Parse(ddlYear.Text));
if (inserted)
{
Response.Redirect("~/Reports/Templates/xAllProgram.aspx?&month=" + Server.UrlEncode(ddlMonth.Text) +
"&year=" + Server.UrlEncode(ddlYear.Text) +
"&barangay=" + Server.UrlEncode(ddlBarangay.Text) +
"&population=" + Server.UrlEncode(txtPopulation.Text));
}
else
{
Response.Write("<script> window.alert('Population Insertion has failed, Please try Again.')</script>");
}
}
}
else
{
Response.Write("<script> window.alert('Population should be greater than zero.')</script>");
}
}
else
{
Response.Write("<script> window.alert('Please Fill the Population Field.')</script>");
}
}
protected void btnNext_Click(object sender, EventArgs e)
{
rep = new Reports();
bar = new Barangay();
mc = new MonthConverter();
bool inserted = false;
if (txtPopulation.Text != "")
{
if (Int32.Parse(txtPopulation.Text) > 0)
{
if (rep.HasDataForTheYear(Int32.Parse(ddlYear.Text), ddlMonth.Text,bar.GetBarangayID(ddlBarangay.Text)))
{
Response.Write("<script> window.alert('Barangay: "+ddlBarangay.Text+" of the Year: "+
ddlYear.Text+" has data in the database. Please Try Other Year for the Barangay')</script>");
}
else
{
inserted = rep.InsertPopulation(bar.GetBarangayID(ddlBarangay.Text), Int32.Parse(txtPopulation.Text),
Int32.Parse("0"), mc.MonthNameToIndex(ddlMonth.Text), Int32.Parse(ddlYear.Text));
if (inserted)
{
Response.Redirect("~/Reports/Templates/xAllProgram.aspx?&month=" + Server.UrlEncode(ddlMonth.Text) +
"&year=" + Server.UrlEncode(ddlYear.Text) +
"&barangay=" + Server.UrlEncode(ddlBarangay.Text) +
"&population=" + Server.UrlEncode(txtPopulation.Text));
}
else
{
Response.Write("<script> window.alert('Population Insertion has failed, Please try Again.')</script>");
}
}
}
else
Response.Write("<script> window.alert('Population should be greater than zero.')</script>");
}
else
Response.Write("<script> window.alert('Please Fill the Population Field.')</script>");
}
protected void Button1_Click(object sender, EventArgs e)
{
//string noPerIndicator = "";
//string indicatorData = "";
//string pregnant = "";
//string male = "";
//string female = "";
//string startUser = "";
//string endUser = "";
//string _new = "";
//string others = "";
//string dropOut = "";
data = new DataAccess();
mc = new MonthConverter();
bar = new Barangay();
rep = new Reports();
if (rep.HasDataForTheYear(year,monthName, bar.GetBarangayID(barangay)))
Response.Write("<script type='text/javascript'>" + "alert(\"Month " + lbl_month.Text + " and Year " +
year + " exists in the database. Please Try other Month and Year.\");</script>");
else
{
string noPerIndicator = "";
string indicatorData = "";
string pregnant = "";
string male = "";
string female = "";
string startUser = "";
string endUser = "";
string _new = "";
string others = "";
string dropOut = "";
//Maternal Care ----------------------------------------------------------------------->
for (int c = 0; c < pro.CountIndicatorPerProgram("Maternal Care"); c++)
{
TextBox tempNo = tblMaternal.FindControl("txtMaternalNo_" + c.ToString()) as TextBox;
noPerIndicator = tempNo.Text;
Label tempIndicator = tblMaternal.FindControl("lblMaternalIndicator" + c.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertMaternalCareReport(indicatorData, Int32.Parse(noPerIndicator),
bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
//Dental Care ------------------------------------------------------------------------->
for (int h = 0; h < pro.CountIndicatorPerProgram("Dental Care"); h++)
{
TextBox tempMale = tblDynamic.FindControl("txtDentalCareMale_" + h.ToString()) as TextBox;
male = tempMale.Text;
TextBox tempFemale = tblDynamic.FindControl("txtDentalCareFemale_" + h.ToString()) as TextBox;
female = tempFemale.Text;
Label tempIndicator = tblDynamic.FindControl("lblDentalCareIndicator" + h.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertDentalCareReport(indicatorData, Int32.Parse(male), Int32.Parse(female),
bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
//Child Care ------------------------------------_------------------------------------->
for (int r = 0; r < pro.CountIndicatorPerProgram("Child Care"); r++)
{
TextBox tempMale = tblDynamic.FindControl("txtChildCareMale_" + r.ToString()) as TextBox;
male = tempMale.Text;
TextBox tempFemale = tblDynamic.FindControl("txtChildCareFemale_" + r.ToString()) as TextBox;
female = tempFemale.Text;
Label tempIndicator = tblDynamic.FindControl("lblChildCareIndicator" + r.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertChildReport(indicatorData, Int32.Parse(male), Int32.Parse(female),
bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
//Filariasis ------------------------------------_------------------------------------->
for (int i = 0; i < pro.CountIndicatorPerProgram("Filariasis"); i++)
{
TextBox tempMale = tblDynamic.FindControl("txtFilariasisMale_" + i.ToString()) as TextBox;
male = tempMale.Text;
TextBox tempFemale = tblDynamic.FindControl("txtFilariasisFemale_" + i.ToString()) as TextBox;
female = tempFemale.Text;
Label tempIndicator = tblDynamic.FindControl("lblFilariasisIndicator" + i.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertFilariasisReport(indicatorData, Int32.Parse(male), Int32.Parse(female),
bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
//Leprosy ------------------------------------_----------------------------------------->
for (int z = 0; z < pro.CountIndicatorPerProgram("Leprosy"); z++)
{
TextBox tempMale = tblDynamic.FindControl("txtLeprosyMale_" + z.ToString()) as TextBox;
male = tempMale.Text;
TextBox tempFemale = tblDynamic.FindControl("txtLeprosyFemale_" + z.ToString()) as TextBox;
female = tempFemale.Text;
Label tempIndicator = tblDynamic.FindControl("lblLeprosyIndicator" + z.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertLeprosyReport(indicatorData, Int32.Parse(male), Int32.Parse(female),
bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
//Malaria ------------------------------------_----------------------------------------->
for (int z = 0; z < pro.CountIndicatorPerProgram("Malaria"); z++)
{
TextBox tempPregnant = tblMalaria.FindControl("txtMalariaPregnant_" + z.ToString()) as TextBox;
pregnant = tempPregnant.Text;
TextBox tempMale = tblMalaria.FindControl("txtMalariaMale_" + z.ToString()) as TextBox;
male = tempMale.Text;
TextBox tempFemale = tblMalaria.FindControl("txtMalariaFemale_" + z.ToString()) as TextBox;
female = tempFemale.Text;
Label tempIndicator = tblMalaria.FindControl("lblMalariaIndicator" + z.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertMalariaReport(indicatorData, Int32.Parse(pregnant), Int32.Parse(male), Int32.Parse(female),
bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
//Schisto ------------------------------------_----------------------------------------->
for (int i = 0; i < pro.CountIndicatorPerProgram("Schistomiasis"); i++)
{
TextBox tempMale = tblDynamic.FindControl("txtSchistomiasisMale_" + i.ToString()) as TextBox;
male = tempMale.Text;
TextBox tempFemale = tblDynamic.FindControl("txtSchistomiasisFemale_" + i.ToString()) as TextBox;
female = tempFemale.Text;
Label tempIndicator = tblDynamic.FindControl("lblSchistomiasisIndicator" + i.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertSchisReport(indicatorData, Int32.Parse(male), Int32.Parse(female),
bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
//Tuberculosis ---------------------------------------------------------------------------->
for (int i = 0; i < pro.CountIndicatorPerProgram("Tuberculosis"); i++)
{
TextBox tempMale = tblDynamic.FindControl("txtTuberculosisMale_" + i.ToString()) as TextBox;
male = tempMale.Text;
TextBox tempFemale = tblDynamic.FindControl("txtTuberculosisFemale_" + i.ToString()) as TextBox;
female = tempFemale.Text;
Label tempIndicator = tblDynamic.FindControl("lblTuberculosisIndicator" + i.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertTbReport(indicatorData, Int32.Parse(male), Int32.Parse(female),
bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
//Family Planning ---------------------------------------------------------------------------->
for (int i = 0; i < pro.CountIndicatorPerProgram("Family Planning"); i++)
{
TextBox temp1 = tblFamilyPlanning.FindControl("txtFamilyPlanningStartUser_" + i.ToString()) as TextBox;
startUser = temp1.Text;
TextBox temp2 = tblFamilyPlanning.FindControl("txtFamilyPlanningNew_" + i.ToString()) as TextBox;
_new = temp2.Text;
TextBox temp3 = tblFamilyPlanning.FindControl("txtFamilyPlanningOthers_" + i.ToString()) as TextBox;
others = temp3.Text;
TextBox temp4 = tblFamilyPlanning.FindControl("txtFamilyPlanningDropOut_" + i.ToString()) as TextBox;
dropOut = temp4.Text;
TextBox temp5 = tblFamilyPlanning.FindControl("txtFamilyPlanningEndUser_" + i.ToString()) as TextBox;
endUser = temp5.Text;
Label tempIndicator = tblFamilyPlanning.FindControl("lblFamilyPlanningIndicator" + i.ToString()) as Label;
indicatorData = tempIndicator.Text;
rep.InsertFPReport(indicatorData, Int32.Parse(startUser), Int32.Parse(_new), Int32.Parse(others),
Int32.Parse(dropOut), Int32.Parse(endUser), bar.GetBarangayID(lbl_Barangay.Text), month, year);
}
Response.Write("<script type='text/javascript'>" + "alert(\"Inserted Successfully\");</script>");
}
}