public static DataSet GetDropDownListAllBilling()
{
DataSet billings = new DataSet();
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
billings = sqlBillingProvider.GetDropDownLisAllBilling();
return billings;
}
public static Billing GetBillingByBillingID(int BillingID)
{
Billing billing = new Billing();
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
billing = sqlBillingProvider.GetBillingByBillingID(BillingID);
return billing;
}
public static DataSet GetBillingByClientID(int ClientID)
{
DataSet billings = new DataSet();
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
billings = sqlBillingProvider.GetBillingByClientID(ClientID);
return billings;
}
public static Billing GetBillingByBillingID(int BillingID)
{
Billing billing = new Billing();
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
billing = sqlBillingProvider.GetBillingByBillingID(BillingID);
return(billing);
}
public static DataSet GetBillingByClientID(int ClientID)
{
DataSet billings = new DataSet();
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
billings = sqlBillingProvider.GetBillingByClientID(ClientID);
return(billings);
}
public static DataSet GetDropDownListAllBilling()
{
DataSet billings = new DataSet();
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
billings = sqlBillingProvider.GetDropDownLisAllBilling();
return(billings);
}
public static void LoadBillingPage(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);
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
DataSet ds = sqlBillingProvider.GetBillingPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
billingsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static bool UpdatePaymnetType(int id, int status, int TreatmentService)
{
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
return sqlBillingProvider.UpdatePaymnetType(id, status, TreatmentService);
}
public static bool UpdateBilling(Billing billing)
{
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
return sqlBillingProvider.UpdateBilling(billing);
}
public static void LoadBillingPage(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);
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
DataSet ds = sqlBillingProvider.GetBillingPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
billingsPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertBilling(Billing billing)
{
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
return sqlBillingProvider.InsertBilling(billing);
}
public static bool DeleteBilling(int billingID)
{
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
return sqlBillingProvider.DeleteBilling(billingID);
}
public static bool UpdatePaymnetType(int id, int status, int TreatmentService)
{
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
return(sqlBillingProvider.UpdatePaymnetType(id, status, TreatmentService));
}
public static bool UpdateBilling(Billing billing)
{
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
return(sqlBillingProvider.UpdateBilling(billing));
}
public static int InsertBilling(Billing billing)
{
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
return(sqlBillingProvider.InsertBilling(billing));
}
public static bool DeleteBilling(int billingID)
{
SqlBillingProvider sqlBillingProvider = new SqlBillingProvider();
return(sqlBillingProvider.DeleteBilling(billingID));
}
