public DataTable getApprovalProductList()
{
newproductionDAL newProductionDal = new newproductionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
DataTable dt = newProductionDal.getApprovalProductList(db, this);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
}
public DataTable getProductionDetailsbyProductionID(string productionID)
{
newproductionDAL NewproductionDAL = new newproductionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
DataTable dt = NewproductionDAL.getProductionDetailsById(db, productionID);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
NewproductionDAL = null;
}
}
public bool SaveProductionDetails(DataTable dtMetarial)
{
bool st = false;
newproductionDAL NewproductionDAL = new newproductionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
st=NewproductionDAL.SaveProductionDetails(db,this,dtMetarial);
db.Stop();
return st;
}
catch (Exception)
{
throw;
}
finally
{
NewproductionDAL = null;
}
}
public DataTable getRawmetarialsbyProductionID(string productionID)
{
newproductionDAL newProductionDll = new newproductionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
DataTable dt = newProductionDll.getRawmetarialsbyProductionID(db, productionID);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
newProductionDll = null;
}
}
public bool saveNewProcutToWarehouse(DataTable productTable)
{
bool status = false;
newproductionDAL newproductionDal = new newproductionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
status = newproductionDal.saveNewProductInformation(this,db,productTable);
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public DataTable getProductDetails(string productId,string WHid)
{
DataTable dt = new DataTable();
newproductionDAL newproductionDal = new newproductionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = newproductionDal.getProductDetails(db, productId,WHid);
db.Stop();
}
catch (Exception)
{
throw;
}
return dt;
}
public bool approveNewProductionwithProductionId(string productionId)
{
bool status = false;
newproductionDAL newProductiondal = new newproductionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
status = newProductiondal.approveProduction(db, productionId);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
newProductiondal = null;
}
return status;
}
public bool rejectProduct(string ProductionID)
{
newproductionDAL newProductionDal = new newproductionDAL();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
status = newProductionDal.rejectProduction(db,ProductionID);
db.Stop();
}
catch (Exception ex)
{
throw;
}
return status;
}