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;
}
}
