public static DataSet GetDropDownListAllTreatmentService()
{
DataSet treatmentServices = new DataSet();
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
treatmentServices = sqlTreatmentServiceProvider.GetDropDownLisAllTreatmentService();
return treatmentServices;
}
public static TreatmentService GetTreatmentServiceByTreatmentServiceID(int TreatmentServiceID)
{
TreatmentService treatmentService = new TreatmentService();
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
treatmentService = sqlTreatmentServiceProvider.GetTreatmentServiceByTreatmentServiceID(TreatmentServiceID);
return treatmentService;
}
public static TreatmentService GetTreatmentServiceByTreatmentServiceID(int TreatmentServiceID)
{
TreatmentService treatmentService = new TreatmentService();
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
treatmentService = sqlTreatmentServiceProvider.GetTreatmentServiceByTreatmentServiceID(TreatmentServiceID);
return(treatmentService);
}
public static DataSet GetDropDownListAllTreatmentService()
{
DataSet treatmentServices = new DataSet();
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
treatmentServices = sqlTreatmentServiceProvider.GetDropDownLisAllTreatmentService();
return(treatmentServices);
}
public static void LoadTreatmentServicePage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
DataSet ds = sqlTreatmentServiceProvider.GetTreatmentServicePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
treatmentServicesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static void LoadTreatmentServicePage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
DataSet ds = sqlTreatmentServiceProvider.GetTreatmentServicePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
treatmentServicesPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static bool UpdateTreatmentService(TreatmentService treatmentService)
{
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
return sqlTreatmentServiceProvider.UpdateTreatmentService(treatmentService);
}
public static int InsertTreatmentService(TreatmentService treatmentService)
{
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
return sqlTreatmentServiceProvider.InsertTreatmentService(treatmentService);
}
public static bool DeleteTreatmentService(int treatmentServiceID)
{
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
return sqlTreatmentServiceProvider.DeleteTreatmentService(treatmentServiceID);
}
public static bool DeleteTreatmentService(int treatmentServiceID)
{
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
return(sqlTreatmentServiceProvider.DeleteTreatmentService(treatmentServiceID));
}
public static bool UpdateTreatmentService(TreatmentService treatmentService)
{
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
return(sqlTreatmentServiceProvider.UpdateTreatmentService(treatmentService));
}
public static int InsertTreatmentService(TreatmentService treatmentService)
{
SqlTreatmentServiceProvider sqlTreatmentServiceProvider = new SqlTreatmentServiceProvider();
return(sqlTreatmentServiceProvider.InsertTreatmentService(treatmentService));
}