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); } }