public KitchenStock GetStockByItemidFrominventory_kitchen_stock(int itemId)
{
KitchenStock stock = new KitchenStock();
try
{
this.OpenConnection();
string sqlComm = String.Format(SqlQueries.GetQuery(Query.GetStockByItemidFrominventory_kitchen_stock), itemId);
IDataReader oReader = this.ExecuteReader(sqlComm);
if (oReader != null)
{
while (oReader.Read())
{
stock = ReaderToKitchenStock(oReader);
}
}
// else stock.StockId = 0;
}
catch (Exception ex)
{
throw new Exception("GetStockByItemidFrominventory_kitchen_stock()",ex);
}
finally
{
this.CloseConnection();
}
return stock;
}
private KitchenStock ReaderToKitchenStock(IDataReader oReader)
{
KitchenStock aStock=new KitchenStock();
try
{
aStock.KitchenStockId = Convert.ToInt32(oReader["kitchen_stock_id"]);
}
catch
{
}
try
{
aStock.ItemId = Convert.ToInt32(oReader["item_id"]);
}
catch
{
}
try
{
aStock.Stocks = Convert.ToDouble(oReader["stock"]);
}
catch
{
}
try
{
aStock.ItemName = (oReader["item_name"]).ToString();
}
catch
{
}
//unit_price
try
{
aStock.UnitPrice = Convert.ToDouble(oReader["unit_price"]);
}
catch
{
}
return aStock;
}
public void InsertOrUpdateSaleRawmaterialsReport(IEnumerable<COrderDetails> check)
{
FinishedRawProductListDAO finishedRawProductListDao = new FinishedRawProductListDAO();
KitchenStockDAO aKitchenStockDao=new KitchenStockDAO();
try
{
this.OpenConnection();
foreach (COrderDetails cOrderDetailse in check)
{
List<CFinishedRawProductList> finishedRawProductList =
finishedRawProductListDao.GetFinishedRawProductListByProductID(
Convert.ToInt32(cOrderDetailse.ProductID));
//aKitchenStockDao.UpdateStock(Convert.ToInt32(finishedRawProduct.RawProductID),
// finishedRawProduct.Qnty * (orderDetails.OrderQuantity - orderDetails.KitchenQuantity));
foreach (CFinishedRawProductList finishedRawProduct in finishedRawProductList)
{
int flag = 0;
KitchenStock aKitchenStock=new KitchenStock();
aKitchenStock = aKitchenStockDao.GetStockByItemidFrominventory_kitchen_stock((int)finishedRawProduct.RawProductID);
string sqlComm = String.Format(SqlQueries.GetQuery(Query.ExitOrNot), aKitchenStock.ItemId,
DateTime.Now.Date);
IDataReader aReader = this.ExecuteReader(sqlComm);
if(aReader!=null)
{
while(aReader.Read())
{
flag = Convert.ToInt32(aReader["sale_id"]);
}
aReader.Close();
}
if(flag==0)
{
sqlComm = String.Format(SqlQueries.GetQuery(Query.InsertSalereport), aKitchenStock.ItemId,
cOrderDetailse.OrderQuantity*finishedRawProduct.Qnty,aKitchenStock.UnitPrice*cOrderDetailse.OrderQuantity*finishedRawProduct.Qnty,
DateTime.Now.Date);
this.ExecuteNonQuery(sqlComm);
}
if (flag > 0)
{
sqlComm = String.Format(SqlQueries.GetQuery(Query.UpdateSalereport),
cOrderDetailse.OrderQuantity * finishedRawProduct.Qnty,
aKitchenStock.UnitPrice * cOrderDetailse.OrderQuantity * finishedRawProduct.Qnty, flag);
this.ExecuteNonQuery(sqlComm);
}
}
}
}
catch (Exception ex)
{
throw new Exception("InsertOrUpdateSaleRawmaterialsReport()",ex);
}
finally
{
this.CloseConnection();
}
}
private bool CheckRawProduct(List<COrderDetails> tempOrderDetailsList)
{
CCategory3DAO cCategory3Dao = new CCategory3DAO();
FinishedRawProductListDAO finishedRawProductListDao = new FinishedRawProductListDAO();
string stockMessage = "Stock is unavailable ";
bool isStockAvailable = true;
KitchenStockDAO aKitchenStockDao = new KitchenStockDAO();
foreach (COrderDetails orderDetail in tempOrderDetailsList)
{
List<CFinishedRawProductList> finishedRawProductList = finishedRawProductListDao.GetFinishedRawProductListByProductID(Convert.ToInt32(orderDetail.ProductID));
foreach (CFinishedRawProductList finishedRawProduct in finishedRawProductList)
{
// CCategory3 cCategory3 = cCategory3Dao.GetAllCategory3ByCategory3ID(Convert.ToInt32(finishedRawProduct.RawProductID));
KitchenStock aKitchenStock = new KitchenStock();
// KitchenStockDAO aKitchenStockDao=new KitchenStockDAO();
aKitchenStock = aKitchenStockDao.GetStockByItemidFrominventory_kitchen_stock((int)finishedRawProduct.RawProductID);
//List<CCategory3> aList = cCategory3Dao.GetAllCategory3();
//var temp = from acategory in aList where acategory.Category2ID == cCategory3.Category2ID select acategory;
if (finishedRawProduct.Qnty * (orderDetail.OrderQuantity - orderDetail.KitchenQuantity) > aKitchenStock.Stocks)
{
stockMessage += "\n " + finishedRawProduct.RawProductName + ": Needed: " + finishedRawProduct.Qnty *
(orderDetail.OrderQuantity - orderDetail.KitchenQuantity) + "\n " + " But Have: " + (aKitchenStock.Stocks);
isStockAvailable = false;
}
}
}
if(!isStockAvailable)
{
CUserInfoDAO aUserInfoDao=new CUserInfoDAO();
CUserInfo aUserInfo=new CUserInfo();
aUserInfo = aUserInfoDao.GetUserInfoByUsername(RMSGlobal.LoginUserName);
if (aUserInfo.Type == 0)
{
DialogResult dialogResult = MessageBox.Show("Do You Proceed", "Stock Alert", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
isStockAvailable = true;
}
else if (dialogResult == DialogResult.No)
{
}
}
}
if (!isStockAvailable)
{
CMessageBox cMessageBox = new CMessageBox("Raw Product", stockMessage);
cMessageBox.ShowDialog();
return false;
}
else
{
foreach (COrderDetails orderDetails in tempOrderDetailsList)
{
List<CFinishedRawProductList> finishedRawProductList =
finishedRawProductListDao.GetFinishedRawProductListByProductID(
Convert.ToInt32(orderDetails.ProductID));
foreach (CFinishedRawProductList finishedRawProduct in finishedRawProductList)
{
aKitchenStockDao.UpdateStock(Convert.ToInt32(finishedRawProduct.RawProductID),
finishedRawProduct.Qnty * (orderDetails.OrderQuantity - orderDetails.KitchenQuantity));
}
COrderDetailsDAO cOrderDetailsDao = new COrderDetailsDAO();
cOrderDetailsDao.UpdateKitchenQuantity(orderDetails);
}
}
return true;
}
