public DataSet EIDTestedSummary(int facility, int user_id, string role, string ReceiveFrom, string ReceiveTo, string CollectFrom, string CollectTo, string TestedFrom, string TestedTo, string ProvinceId, string FacilityType1, string LabCode)
{
string connstring = TechnicalSettings.Decrypt(TechnicalConfig.GetConfiguration()["ConnectionString"].ToString());
using (SqlConnection cn = new SqlConnection(connstring))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRptEIDTestedSummary";
cmd.Parameters.AddWithValue("@facility", facility);
cmd.Parameters.AddWithValue("@type", role);
cmd.Parameters.AddWithValue("@user_id", user_id);
cmd.Parameters.AddWithValue("@provinceIDs", ProvinceId);
cmd.Parameters.AddWithValue("@facilityTypes", FacilityType1);
cmd.Parameters.AddWithValue("@ReceiveFrom", ReceiveFrom);
cmd.Parameters.AddWithValue("@ReceiveTo", ReceiveTo);
cmd.Parameters.AddWithValue("@CollectFrom", CollectFrom);
cmd.Parameters.AddWithValue("@CollectTo", CollectTo);
cmd.Parameters.AddWithValue("@TestedFrom", TestedFrom);
cmd.Parameters.AddWithValue("@TestedTo", TestedTo);
cmd.Parameters.AddWithValue("@LabCode", LabCode);
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
cn.Close();
return(ds);
}
}
public DataSet GetRptARTMonthlyByIndicators(int user_id, string role, int year, int month, string ProvinceId, string FacilityType1, string LabCode)
{
string connstring = TechnicalSettings.Decrypt(TechnicalConfig.GetConfiguration()["ConnectionString"].ToString());
using (SqlConnection cn = new SqlConnection(connstring))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRptARTMonthlyByIndicators";
cmd.Parameters.AddWithValue("@type", role);
cmd.Parameters.AddWithValue("@user_id", user_id);
cmd.Parameters.AddWithValue("@provinceIDs", ProvinceId);
cmd.Parameters.AddWithValue("@facilityTypes", FacilityType1);
cmd.Parameters.AddWithValue("@Year", year);
cmd.Parameters.AddWithValue("@Month", month);
cmd.Parameters.AddWithValue("@LabCode", LabCode);
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
cn.Close();
return(ds);
}
}
