public DataTable SaveProduct(List<string> mainProductList)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
DataTable dt = product.SaveProduct(this, db);
//dt.Columns.Add("ProductId");
if (dt.Rows.Count > 0)
{
ProductId = dt.Rows[0][0].ToString();
}
if (mainProductList.Count > 0)
{
product.SaveMainProductOfSubProduct(ProductId, mainProductList, db);
}
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public DataTable GetDeletedProductListByDateRangeAll(string fromDate, string toDate, string search)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = product.GetDeletedProductListByDateRangeAll(fromDate, toDate, search, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public DataTable GetProductList()
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = product.GetProductList(db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public void DeleteProductById(string productId)
{
ProductDAL productDal=new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
productDal.DeleteProductById(productId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
productDal = null;
}
}
public DataTable GetMainProductListWHID(string wareHouseId)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = product.GetMainProductListWHID(wareHouseId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public DataTable GetMainProductsByWareHouseForSales()
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = product.GetMainProductsByWareHouseforSales(this, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public DataTable GetMainProductList()
{
ProductDAL productDal=new ProductDAL();
DataTable dt=new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = productDal.GetMainProductList(this,db);
db.Stop();
}
catch (Exception)
{
throw;
}
return dt;
}
public DataTable GetActiveProductsByWareHouseorSalesCenter(string id)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = product.GetActiveProductsByWareHouseorSalesCenter(id, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public DataTable GetAllProductsByWareHouse(string Id)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = product.GetAllProductsByWareHouse(Id, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public DataTable GetProductNamesBySalesCenter(string id)
{
ProductDAL product = new ProductDAL();
DataTable dt=new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = product.GetProductNamesBySalesCenter(id,db);
db.Stop();
}
catch (Exception)
{
//throw;
}
return dt;
//finally
//{
// product = null;
//}
}
public void UpdateProduct(List<string> mainProductList,string updateCondition)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
DataTable dt=product.UpdateProduct(this, updateCondition, db);
product.SaveMainProductOfSubProduct(ProductId, mainProductList, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public void UpdateProductActivation(string productId, string activationStatus)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
product.UpdateProductActivation(productId, activationStatus, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public bool CheckDuplicateProductByBarcode(string barcode)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
bool status = product.CheckDuplicateProductByBarcode(barcode, db);
db.Stop();
return status;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public bool CheckDuplicateProductByName(string productName,string warehouse,string salescenter)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
bool status = product.CheckDuplicateProductByName(productName,warehouse,salescenter, db);
db.Stop();
return status;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public DataTable GetProductByBarcodeIdName(string productBarcodeIdName)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = product.GetProductByBarcodeIdName(productBarcodeIdName, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}
public DataTable GetAvailableProductListBySalesCenter(string salesCenterId)
{
ProductDAL product = new ProductDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = product.GetAvailableProductListBySalesCenter(salesCenterId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
product = null;
}
}