public static DataSet GetAllACC_VouchersWithRelation()
{
DataSet aCC_Vouchers = new DataSet();
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
aCC_Vouchers = sqlACC_VoucherProvider.GetAllACC_Vouchers();
return aCC_Vouchers;
}
public static ACC_Voucher GetACC_VoucherByVoucherID(int VoucherID)
{
ACC_Voucher aCC_Voucher = new ACC_Voucher();
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
aCC_Voucher = sqlACC_VoucherProvider.GetACC_VoucherByVoucherID(VoucherID);
return aCC_Voucher;
}
public static ACC_Voucher GetACC_RowStatusByRowStatusID(int RowStatusID)
{
ACC_Voucher aCC_Voucher = new ACC_Voucher();
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
aCC_Voucher = sqlACC_VoucherProvider.GetACC_VoucherByRowStatusID(RowStatusID);
return aCC_Voucher;
}
public static ACC_Voucher GetACC_HeadByHeadID(int HeadID)
{
ACC_Voucher aCC_Voucher = new ACC_Voucher();
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
aCC_Voucher = sqlACC_VoucherProvider.GetACC_VoucherByHeadID(HeadID);
return aCC_Voucher;
}
public static void LoadACC_VoucherPage(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);
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
DataSet ds = sqlACC_VoucherProvider.GetACC_VoucherPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
aCC_VouchersPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertACC_Voucher(ACC_Voucher aCC_Voucher)
{
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
return sqlACC_VoucherProvider.InsertACC_Voucher(aCC_Voucher);
}
public static DataSet GetDropDownListAllACC_Voucher()
{
DataSet aCC_Vouchers = new DataSet();
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
aCC_Vouchers = sqlACC_VoucherProvider.GetDropDownLisAllACC_Voucher();
return aCC_Vouchers;
}
public static bool DeleteACC_Voucher(int aCC_VoucherID)
{
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
return sqlACC_VoucherProvider.DeleteACC_Voucher(aCC_VoucherID);
}
public static bool UpdateACC_Voucher(ACC_Voucher aCC_Voucher)
{
SqlACC_VoucherProvider sqlACC_VoucherProvider = new SqlACC_VoucherProvider();
return sqlACC_VoucherProvider.UpdateACC_Voucher(aCC_Voucher);
}
