public string GenerateSO(LP_GenerateTransNumber_Property objtransno) { string TransactionNumber = ""; _objPurchaseDAL = new LP_SalesOrder_DAL(); DataTable dt = _objPurchaseDAL.GenerateSONo(objtransno); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { TransactionNumber = dr["TransNumber"].ToString(); TransactionNumber = "SO-00" + (int.Parse(TransactionNumber) + 1) + "-" + objtransno.userid; } return(TransactionNumber); } else { TransactionNumber = "SO-001-" + objtransno.userid; return(TransactionNumber); } }
public DataTable SelectSIByDate(LP_Voucher_ViewModel objvoucherinvoice) { _objPurchaseDAL = new LP_SalesOrder_DAL(); return(_objPurchaseDAL.SelectSIBYDate(objvoucherinvoice)); }
public DataTable SelectOne(int productIdx) { _objPurchaseDAL = new LP_SalesOrder_DAL(_objSOMasterProperty); return(_objPurchaseDAL.SelectOne()); }
public DataTable SelectAllSalesInvoiceDetails(int id) { _objPurchaseDAL = new LP_SalesOrder_DAL(_objSOMasterProperty); return(_objPurchaseDAL.SelectAllInvoiceDetails(id)); }
public DataTable GetStockandPrice(int productid) { _objPurchaseDAL = new LP_SalesOrder_DAL(); return(_objPurchaseDAL.GetStockandPrice(productid)); }
public DataTable SelectAll() { _objPurchaseDAL = new LP_SalesOrder_DAL(); return(_objPurchaseDAL.SelectAll()); }
public bool Insert() { _objPurchaseDAL = new LP_SalesOrder_DAL(_objSOMasterProperty); return(_objPurchaseDAL.Insert()); }
public bool ProcessSalesInvoice() { _objPurchaseDAL = new LP_SalesOrder_DAL(_objSOMasterProperty); return(_objPurchaseDAL.ProcessSalesInvoice()); }
public DataSet SelectSIWithDetailData(int id) { _objPurchaseDAL = new LP_SalesOrder_DAL(); return(_objPurchaseDAL.SelectAllSIDetailsDataById(id)); }
public DataTable CheckProductInInventory(int salesIdx) { _objPurchaseDAL = new LP_SalesOrder_DAL(); return(_objPurchaseDAL.getSalesForReturn(salesIdx)); }
public DataTable SelectSalesForSalesReturn(int salesIdx) { _objPurchaseDAL = new LP_SalesOrder_DAL(); return(_objPurchaseDAL.getSalesForReturn(salesIdx)); }