public bool InsertMaternalCareReport(string MaternalData, int NumberOfPatients, int BarangayID,
int Month, int Year)
{
data = new DataAccess();
mc = new MonthConverter();
data.ConnectToDatabase();
SqlCommand cmdTxt = new SqlCommand("INSERT INTO MaternalCare (MaternalData,NumberOfPatients,InputDate,BarangayID,Month,Year,Quarter)"
+ "VALUES (@MaternalData,@NumberOfPatients,@InputDate,@BarangayID,@Month,@Year,@Quarter)", data.Connection);
cmdTxt.Parameters.Add("@MaternalData", SqlDbType.VarChar).Value = MaternalData;
cmdTxt.Parameters.Add("@NumberOfPatients", SqlDbType.Int).Value = NumberOfPatients;
cmdTxt.Parameters.Add("@InputDate", SqlDbType.DateTime).Value = DateTime.Now;
cmdTxt.Parameters.Add("@BarangayID", SqlDbType.Int).Value = BarangayID;
cmdTxt.Parameters.Add("@Month", SqlDbType.Int).Value = Month;
cmdTxt.Parameters.Add("@Year", SqlDbType.Int).Value = Year;
//cmdTxt.Parameters.Add("@Accomplishment", SqlDbType.VarChar).Value = Accomplishment;
//cmdTxt.Parameters.Add("@Percent", SqlDbType.Decimal).Value = percent;
cmdTxt.Parameters.Add("@Quarter", SqlDbType.Int).Value = mc.DetermineQuarter(Month.ToString());
int checker = cmdTxt.ExecuteNonQuery();
data.CloseDatabase();
if (checker > 0)
{
return(true);
}
else
{
return(false);
}
}
public void InsertLeprosyReport(string LeprosyData, int Male, int Female, int BarangayID,
int Month, int Year)
{
data = new DataAccess();
mc = new MonthConverter();
data.ConnectToDatabase();
SqlCommand cmdTxt = new SqlCommand("INSERT INTO Leprosy (LeprosyData,Male,Female,InputDate,BarangayID,Month,Year,Quarter)"
+ "VALUES (@LeprosyData,@Male,@Female,@InputDate,@BarangayID,@Month,@Year,@Quarter)", data.Connection);
cmdTxt.Parameters.Add("@LeprosyData", SqlDbType.VarChar).Value = LeprosyData;
cmdTxt.Parameters.Add("@Male", SqlDbType.Int).Value = Male;
cmdTxt.Parameters.Add("@Female", SqlDbType.Int).Value = Female;
cmdTxt.Parameters.Add("@InputDate", SqlDbType.DateTime).Value = DateTime.Now;
cmdTxt.Parameters.Add("@BarangayID", SqlDbType.Int).Value = BarangayID;
cmdTxt.Parameters.Add("@Month", SqlDbType.Int).Value = Month;
cmdTxt.Parameters.Add("@Year", SqlDbType.Int).Value = Year;
cmdTxt.Parameters.Add("@Quarter", SqlDbType.Int).Value = mc.DetermineQuarter(Month.ToString());
cmdTxt.ExecuteNonQuery();
data.CloseDatabase();
}
public void InsertFPReport(string FPData, int SU, int New, int Others, int DO,
int EU, int BarangayID, int Month, int Year)
{
data = new DataAccess();
mc = new MonthConverter();
data.ConnectToDatabase();
SqlCommand cmdTxt = new SqlCommand("INSERT INTO FamilyPlanning (FPData,StartUser,New,Others,DropOut,EndUser,InputDate,BarangayID,Month,Year,Quarter)"
+ "VALUES (@FPData,@SU,@New,@Others,@DO,@EU,@InputDate,@BarangayID,@Month,@Year,@Quarter)", data.Connection);
cmdTxt.Parameters.Add("@FPData", SqlDbType.VarChar).Value = FPData;
cmdTxt.Parameters.Add("@SU", SqlDbType.Int).Value = SU;
cmdTxt.Parameters.Add("@New", SqlDbType.Int).Value = New;
cmdTxt.Parameters.Add("@Others", SqlDbType.Int).Value = Others;
cmdTxt.Parameters.Add("@DO", SqlDbType.Int).Value = DO;
cmdTxt.Parameters.Add("@EU", SqlDbType.Int).Value = EU;
cmdTxt.Parameters.Add("@InputDate", SqlDbType.DateTime).Value = DateTime.Now;
cmdTxt.Parameters.Add("@BarangayID", SqlDbType.Int).Value = BarangayID;
cmdTxt.Parameters.Add("@Month", SqlDbType.Int).Value = Month;
cmdTxt.Parameters.Add("@Year", SqlDbType.Int).Value = Year;
cmdTxt.Parameters.Add("@Quarter", SqlDbType.Int).Value = mc.DetermineQuarter(Month.ToString());
cmdTxt.ExecuteNonQuery();
data.CloseDatabase();
}
public bool InsertMaternalCareReport(string MaternalData, int NumberOfPatients, int BarangayID,
int Month, int Year)
{
data = new DataAccess();
mc = new MonthConverter();
data.ConnectToDatabase();
SqlCommand cmdTxt = new SqlCommand("INSERT INTO MaternalCare (MaternalData,NumberOfPatients,InputDate,BarangayID,Month,Year,Quarter)"
+ "VALUES (@MaternalData,@NumberOfPatients,@InputDate,@BarangayID,@Month,@Year,@Quarter)",data.Connection);
cmdTxt.Parameters.Add("@MaternalData", SqlDbType.VarChar).Value = MaternalData;
cmdTxt.Parameters.Add("@NumberOfPatients", SqlDbType.Int).Value = NumberOfPatients;
cmdTxt.Parameters.Add("@InputDate", SqlDbType.DateTime).Value = DateTime.Now;
cmdTxt.Parameters.Add("@BarangayID", SqlDbType.Int).Value = BarangayID;
cmdTxt.Parameters.Add("@Month", SqlDbType.Int).Value = Month;
cmdTxt.Parameters.Add("@Year", SqlDbType.Int).Value = Year;
//cmdTxt.Parameters.Add("@Accomplishment", SqlDbType.VarChar).Value = Accomplishment;
//cmdTxt.Parameters.Add("@Percent", SqlDbType.Decimal).Value = percent;
cmdTxt.Parameters.Add("@Quarter", SqlDbType.Int).Value = mc.DetermineQuarter(Month.ToString());
int checker = cmdTxt.ExecuteNonQuery();
data.CloseDatabase();
if (checker > 0)
return true;
else
return false;
}
public void InsertLeprosyReport(string LeprosyData, int Male, int Female, int BarangayID,
int Month, int Year)
{
data = new DataAccess();
mc = new MonthConverter();
data.ConnectToDatabase();
SqlCommand cmdTxt = new SqlCommand("INSERT INTO Leprosy (LeprosyData,Male,Female,InputDate,BarangayID,Month,Year,Quarter)"
+ "VALUES (@LeprosyData,@Male,@Female,@InputDate,@BarangayID,@Month,@Year,@Quarter)",data.Connection);
cmdTxt.Parameters.Add("@LeprosyData", SqlDbType.VarChar).Value = LeprosyData;
cmdTxt.Parameters.Add("@Male", SqlDbType.Int).Value = Male;
cmdTxt.Parameters.Add("@Female", SqlDbType.Int).Value = Female;
cmdTxt.Parameters.Add("@InputDate", SqlDbType.DateTime).Value = DateTime.Now;
cmdTxt.Parameters.Add("@BarangayID", SqlDbType.Int).Value = BarangayID;
cmdTxt.Parameters.Add("@Month", SqlDbType.Int).Value = Month;
cmdTxt.Parameters.Add("@Year", SqlDbType.Int).Value = Year;
cmdTxt.Parameters.Add("@Quarter", SqlDbType.Int).Value = mc.DetermineQuarter(Month.ToString());
cmdTxt.ExecuteNonQuery();
data.CloseDatabase();
}
public void InsertFPReport(string FPData, int SU, int New, int Others, int DO,
int EU, int BarangayID, int Month, int Year)
{
data = new DataAccess();
mc = new MonthConverter();
data.ConnectToDatabase();
SqlCommand cmdTxt = new SqlCommand("INSERT INTO FamilyPlanning (FPData,StartUser,New,Others,DropOut,EndUser,InputDate,BarangayID,Month,Year,Quarter)"
+ "VALUES (@FPData,@SU,@New,@Others,@DO,@EU,@InputDate,@BarangayID,@Month,@Year,@Quarter)",data.Connection);
cmdTxt.Parameters.Add("@FPData", SqlDbType.VarChar).Value = FPData;
cmdTxt.Parameters.Add("@SU", SqlDbType.Int).Value = SU;
cmdTxt.Parameters.Add("@New", SqlDbType.Int).Value = New;
cmdTxt.Parameters.Add("@Others", SqlDbType.Int).Value = Others;
cmdTxt.Parameters.Add("@DO", SqlDbType.Int).Value = DO;
cmdTxt.Parameters.Add("@EU", SqlDbType.Int).Value = EU;
cmdTxt.Parameters.Add("@InputDate", SqlDbType.DateTime).Value = DateTime.Now;
cmdTxt.Parameters.Add("@BarangayID", SqlDbType.Int).Value = BarangayID;
cmdTxt.Parameters.Add("@Month", SqlDbType.Int).Value = Month;
cmdTxt.Parameters.Add("@Year", SqlDbType.Int).Value = Year;
cmdTxt.Parameters.Add("@Quarter", SqlDbType.Int).Value = mc.DetermineQuarter(Month.ToString());
cmdTxt.ExecuteNonQuery();
data.CloseDatabase();
}
