public DataSet GetIncomeDetails(MISBalanceSheet DoctorWiseModel) { Connect(); DataSet dsDoctorWiseCollection = null; try { SqlCommand cmd = new SqlCommand("GetIncomeDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@DateFrom", DoctorWiseModel.DateFrom); cmd.Parameters.AddWithValue("@DateTo", DoctorWiseModel.DateTo); cmd.Parameters.AddWithValue("@ScheduleID", DoctorWiseModel.ScheduleID); cmd.Parameters.AddWithValue("@ScheduleName", DoctorWiseModel.ScheduleName); cmd.Parameters.AddWithValue("@Type", DoctorWiseModel.Type); con.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; dsDoctorWiseCollection = new DataSet(); da.Fill(dsDoctorWiseCollection); con.Close(); return(dsDoctorWiseCollection); } catch (Exception) { return(dsDoctorWiseCollection); } }
public DataSet GetLiabilitiesDetails(MISBalanceSheet DoctorWiseModel) { Connect(); DataSet ds = new DataSet(); try { SqlCommand cmd = new SqlCommand("GetLiabilitiesDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@DateFrom", DoctorWiseModel.DateFrom); cmd.Parameters.AddWithValue("@DateTo", DoctorWiseModel.DateTo); cmd.Parameters.AddWithValue("@ScheduleID", DoctorWiseModel.ScheduleID); cmd.Parameters.AddWithValue("@ScheduleName", DoctorWiseModel.ScheduleName); cmd.Parameters.AddWithValue("@Type", DoctorWiseModel.Type); con.Open(); SqlDataAdapter ad = new SqlDataAdapter(cmd); con.Close(); ad.Fill(ds); } catch (Exception ex) { } return(ds); }