public TestRibbon()
: base(Globals.Factory.GetRibbonFactory())
{
InitializeComponent();
try
{
System.Data.DataTable dt = new DBCall().GetData(); //Get all menu in word tmenu tab and bind them using following code
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
RibbonButton Field = this.Factory.CreateRibbonButton();
Field.Label = dt.Rows[i][1].ToString();
Field.Tag = i;
Field.ControlSize =
Microsoft.Office.Core.RibbonControlSize.RibbonControlSizeLarge;
Field.Click += Field_Click;
menu1.Items.Add(Field);
}
}
else
{
System.Windows.Forms.MessageBox.Show("No Fields are available in database");
}
}
catch (Exception exception)
{
}
}
public ResCommon DeleteUserHsn(ReqUserHsn reqUserHsn)
{
ResCommon resCommon = new ResCommon();
return(DBCall.DeleteUserHsn(reqUserHsn, ExtensionMethods.GetStoreProcHsnOrHsv(reqUserHsn.HsnOrHsc, StaticConst.SPDELETEUSERHSNCODE, StaticConst.SPDELETEUSERHSCCODE)));
//return Common<ReqUserHsn, ResCommon>.Serialize_Deserialize(reqUserHsn, resCommon, ExtensionMethods.GetStoreProcHsnOrHsv(reqUserHsn.HsnOrHsc, StaticConst.SPDELETEUSERHSNCODE, StaticConst.SPDELETEUSERHSCCODE));
}
public ResCompanyListCA GetListCACompany(ReqUserId reqParentId)
{
return(DBCall.GetListCompanyCA(reqParentId, StaticConst.SPGETLIST_CA_COMPANY));
}
public ResrefIdList GetBillRef(ReqUserId reqUserId)
{
return(DBCall.GetBillRef(reqUserId, StaticConst.SPGETBILLREF));
}
public CResponse.ResDashBoard GetDashBoardContentExpense(ReqDashBoardContentTax reqDashBoardContentTax)
{
return(DBCall.GetDashBoardContentExpense(reqDashBoardContentTax, StaticConst.SPGETEXPENSETAX));
}
public ResGetPaymentTermList GetPaymentTerm(ReqUserId reqUserId)
{
return(DBCall.GetPaymentTermList(reqUserId, StaticConst.SPGETPAYMENTTERM));
}
public ResTdsList GetTdsList(ReqUserId reqUserId)
{
return(DBCall.GetTdsList(reqUserId, StaticConst.SPGetTds));
}
public ReqBill GetBillDetail(ReqId reqId)
{
return(DBCall.GetBillDetail(reqId, StaticConst.SPGETUSERBILLDETAIL));
}
public ResBillList GetUserOverDueList(ReqUserId reqUserId)
{
return(DBCall.GetUserOverDueList(reqUserId, StaticConst.SPGETUSERBILLOVERDUE));
}
public ResGetExpenseList GetExpense(ReqUserId reqUserId)
{
return(DBCall.GetExpenseList(reqUserId, StaticConst.SPGETEXPENSETYPE));
}
public ResVendorList GetVendorList(ReqUserId reqUserId)
{
return(DBCall.GetVendorList(reqUserId, StaticConst.SPGETUSERVENDORLIST));
}
public ResListHsnCodeGoods UserHsnDetail(ReqUserHsnDetail reqUserHsnDetail)
{
return(DBCall.GetUserHsnDetail(reqUserHsnDetail.UserId, ExtensionMethods.GetStoreProcHsnOrHsv(reqUserHsnDetail.HsnOrHsc, StaticConst.SPGETUSERHSNCODE, StaticConst.SPGETUSERHSCCODE)));
}
public ResListHsnCodeGoods HsnDetailSearch(ReqHsnCode reqHsnCode)
{
return(DBCall.GetListHsnCode(reqHsnCode, ExtensionMethods.GetStoreProcHsnOrHsv(reqHsnCode.HsnOrHsc, StaticConst.SPSEARCHHSNCODE, StaticConst.SPSEARCHHSCCODE)));
}
public ResCommon InsertUserHSNCode(ReqInsertUserHsn reqInsertUserHsn)
{
ResCommon resCommon = new ResCommon();
return(DBCall.InsertUserHSNCode(reqInsertUserHsn, ExtensionMethods.GetStoreProcHsnOrHsv(reqInsertUserHsn.HsnOrHsc, StaticConst.SPINSERTUSERHSNCODE, StaticConst.SPINSERTUSERHSCCODE)));
}
public ResUserHsnHscCode GetUserHsnHscCode(ReqUserId reqUserId)
{
return(DBCall.GetUserHsn_HscCode(reqUserId, StaticConst.SPGETUSERHSNHSCCODE));
}
public ResCommon BulkInsertRecurringBill(ReqBill_BillItem reqBill)
{
return(DBCall.BulkInsertRecurringBill(reqBill, StaticConst.SPBULKINSERTBILL));
}
public ResBillList GetUserFutureBillList(ReqUserId reqUserId)
{
return(DBCall.GetUserBillList(reqUserId, StaticConst.SPGETUSERFUTUREBILL));
}
public ResCommon InsertPurchase(ReqPurchase reqPurchase)
{
return(DBCall.InsertPurchase(reqPurchase, StaticConst.SPINSERTPURCHASE));
}
public ResCommon UpdateBill(ReqBill reqBill)
{
return(DBCall.UpdateBill(reqBill, StaticConst.SPUPDATEBILL));
}
public ResCommon UpdatePurchase(ReqPurchase reqUpdatePurchase)
{
return(DBCall.UpdatePurchase(reqUpdatePurchase, StaticConst.SPUPDATEPURCHASE));
}
public ResUserItemsList GetUserItemList(ReqUserId reqUserId)
{
return(DBCall.GetUserItemList(reqUserId, StaticConst.SPGETUSERITEM));
}
public ReqPurchaseList GetPurchaseList(ReqUserId reqUserId)
{
return(DBCall.GetPurchaseList(reqUserId, StaticConst.SPGETPURCHASELIST));
}
public ResCommon BulkInsertVendor(ReqVendorList reqVendorList)
{
return(DBCall.BulkInsertVendor(reqVendorList, StaticConst.SPBULKINSERTVENDOR));
}
public ResPurchase_PurchaseItem GetPurchaseDetail(ReqId reqId)
{
return(DBCall.GetPurchaseDetail(reqId, StaticConst.SPGETPURCHASEDETAIL));
}
//public ResDashBoard GetDashBoardContent(ReqUserId reqUserId)
//{
// return DBCall.GetDashBoardContent(reqUserId, StaticConst.SPGETDASHBOARDCONTENT);
//}
public CResponse.ResDashBoard GetDashBoardContentInvoice(ReqDashBoardContentTax reqDashBoardContentTax)
{
return(DBCall.GetDashBoardContentInvoice(reqDashBoardContentTax, StaticConst.SPGETINVOICETAX));
}
public ResCommon BulkInsertPurchase(ResPurchase_PurchaseItemList resPurchase_PurchaseItemList)
{
return(DBCall.BulkInsertPurchase(resPurchase_PurchaseItemList, StaticConst.SPBULKINSERTPURCHASE));
}
public ResrefIdList GetInvoiceRef(ReqUserId reqUserId)
{
return(DBCall.GetInvoiceRef(reqUserId, StaticConst.SPGETINVOICEREF));
}
public ResAllUserList GetAllUser()
{
return(DBCall.GetAllUser("sp_GetAllUser"));
}
public ResCustomerList GetCustomerList(ReqUserId reqUserId)
{
return(DBCall.GetCustomerList(reqUserId, StaticConst.SPGETUSERCUSTOMERLIST));
}
public ResCommon InsertBill(ReqBill reqBill)
{
return(DBCall.InsertBill(reqBill, StaticConst.SPINSERTBILL));
}
