예제 #1
0
        public string SaveRetailSales(DataTable dtPrdList)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                string Id = salesOrder.SaveRetailSales(this, dtPrdList, db);
                db.Stop();

                return Id;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
                dtPrdList = null;
            }
        }
예제 #2
0
        public bool RejectRetailSales()
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                bool status = salesOrder.RejectRetailSales(this, db);
                db.Stop();

                return status;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
                
            }
        }
예제 #3
0
        public string ApproveSalesRecordRetailSubproducs(DataTable dt)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                string Id = salesOrder.ApproveSalesRecordRetailSubproducs(this, dt, db);
                db.Stop();

                return Id;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
                dt = null;
            }
        }
예제 #4
0
        public DataTable GetSalesRecordMainProductListById(string salesRecordId)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                DataTable dt = salesOrder.GetSalesRecordMainProductListById(salesRecordId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
                
            }
        }
예제 #5
0
 public bool rejectProduct(string SOID)
 {
     SalesOrderDAL newSalesDal = new SalesOrderDAL();
     bool status = false;
     try
     {
         LumexDBPlayer db = LumexDBPlayer.Start();
         status = newSalesDal.rejectProduction(db, SOID);
         db.Stop();
     }
     catch (Exception ex)
     {
         throw;
     }
     return status;
 }
예제 #6
0
 public bool UpdateSalesOrderOnApproved(string salesRecordId,string salesOrderId)
 {
     SalesOrderDAL newSalesDal = new SalesOrderDAL();
     bool status = false;
     try
     {
         LumexDBPlayer db = LumexDBPlayer.Start();
         status = newSalesDal.UpdateSalesOrderOnApproved(db, salesRecordId,salesOrderId);
         db.Stop();
     }
     catch (Exception ex)
     {
         throw;
     }
     return status;
 }
예제 #7
0
        public DataTable SaveSalesReturn(DataTable dtPrdList)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                DataTable dt = salesOrder.SaveSalesReturn(this, dtPrdList, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
                dtPrdList = null;
            }
        }
예제 #8
0
        public void SaveUncollectableAmountBySalesRecordId(string salesRecordId, string uncollectableAmount)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                salesOrder.SaveUncollectableAmountBySalesRecordId(salesRecordId, uncollectableAmount, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
            }
        }
예제 #9
0
        public DataTable GetDamageRecordById(string damageRecordId)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = salesOrder.GetDamageRecordById(damageRecordId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
            }
        }
예제 #10
0
        public DataTable SaveCustomerPaymentBySales()
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = salesOrder.SaveCustomerPaymentBySales(this, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
            }
        }
예제 #11
0
        public DataTable GetSalesReturnsListBySalesCenterDateRangeAndStatus(string salesCenterId, string fromDate, string toDate, string status)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = salesOrder.GetSalesReturnsListBySalesCenterDateRangeAndStatus(salesCenterId, fromDate, toDate, status, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
            }
        }
예제 #12
0
        public DataTable GetDamageRecordsListByWarehouseDateRangeAndStatus(string warehouseId, string fromDate, string toDate, string status)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = salesOrder.GetDamageRecordsListByWarehouseDateRangeAndStatus(warehouseId, fromDate, toDate, status, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
            }
        }
예제 #13
0
        public void UpdateSalesOrderOnDelivered(string salesOrderId)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                salesOrder.UpdateSalesOrderOnDelivered(salesOrderId, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
            }
        }
예제 #14
0
        public void CancelSalesOrderById(string salesOrderId)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                salesOrder.CancelSalesOrderById(salesOrderId, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
            }
        }
예제 #15
0
        public DataTable GetPendingSalesOrdersListBySalesCenter(string salesCenterId)
        {
            SalesOrderDAL salesOrder = new SalesOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = salesOrder.GetPendingSalesOrdersListBySalesCenter(salesCenterId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesOrder = null;
            }
        }