public void SaveProductVendorsByProductId(string productId, List<string> vendors) { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); vendor.SaveProductVendorsByProductId(productId, vendors, db); db.Stop(); } catch (Exception) { throw; } finally { vendor = null; } }
public DataTable GetVendorList() { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = vendor.GetVendorList(db); db.Stop(); return dt; } catch (Exception) { throw; } finally { vendor = null; } }
public DataTable SaveVendor() { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); DataTable dt = vendor.SaveVendor(this, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { vendor = null; } }
public DataTable GetVendorListByActivationStatus(string isActive) { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = vendor.GetVendorListByActivationStatus(isActive, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { vendor = null; } }
public DataTable GetVendorWisePaymentList(string vendorId, string fromDate, string toDate,string status) { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = vendor.GetVendorWisePaymentList(vendorId, fromDate, toDate,status, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { vendor = null; } }
public void UpdateVendor() { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); vendor.UpdateVendor(this, db); db.Stop(); } catch (Exception) { throw; } finally { vendor = null; } }
public void DeleteVendor(string vendorId) { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); vendor.DeleteVendor(vendorId, db); db.Stop(); } catch (Exception) { throw; } finally { vendor = null; } }
public void UpdateVendorActivation(string vendorId, string activationStatus) { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); vendor.UpdateVendorActivation(vendorId, activationStatus, db); db.Stop(); } catch (Exception) { throw; } finally { vendor = null; } }
public bool CheckDuplicateVendor(string vendorName,string warehouse,string salesCenter) { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); bool status = vendor.CheckDuplicateVendor(vendorName,warehouse,salesCenter, db); db.Stop(); return status; } catch (Exception) { throw; } finally { vendor = null; } }
public DataTable GetProductVendorsByProductId(string productId) { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = vendor.GetProductVendorsByProductId(productId, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { vendor = null; } }
public DataTable GetDeletedVendorListByDateRangeAll(string fromDate, string toDate, string search) { VendorDAL vendor = new VendorDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = vendor.GetDeletedVendorListByDateRangeAll(fromDate, toDate, search, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { vendor = null; } }