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;
}
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 void UpdateRawMaterial(List<COrderDetails> details)
{
foreach (COrderDetails objDetails in details)
{
//Add for raw materials update
if (objDetails.KitchenQuantity > 0)
{
double quantity = objDetails.KitchenQuantity;
FinishedRawProductListDAO aDao = new FinishedRawProductListDAO();
List<CFinishedRawProductList> aList =
aDao.GetFinishedRawProductListByProductID(objDetails.ProductID);
foreach (CFinishedRawProductList list in aList)
{
aDao.FinishedRawProductUpdate(list, quantity);
}
}
}
}
public CResult VoidPrintedItems(System.Collections.SortedList slPrintedList, long orderID)
{
DataSet tempStockDataSet = new DataSet();
tempStockDataSet.ReadXml("Config/StockSetting.xml");
bool isAllowedToOrder = Convert.ToBoolean(tempStockDataSet.Tables[0].Rows[0]["AllowedtoOrder"].ToString());
CResult oResult = new CResult();
string sqlCommand = "";
try
{
this.OpenConnection();
foreach (COrderDetails objDetails in slPrintedList.Values)
{
COrderDetails aDetails = new COrderDetails();
aDetails = GetAll(objDetails); // Add for Vat and Cost find out
if (objDetails.OrderQuantity > 0) //If item is rest.
{
sqlCommand = string.Format(SqlQueries.GetQuery(Query.UpdateLocalVoidItems),
aDetails.OrderQuantity, aDetails.PrintedQuantity,
aDetails.OrderDetailsID, aDetails.OrderAmount,
aDetails.Amount_with_vat, aDetails.VatTotal);
}
else
{
sqlCommand = string.Format(SqlQueries.GetQuery(Query.OrderDetailsDelete),
objDetails.OrderDetailsID);
}
this.ExecuteNonQuery(sqlCommand);
//Add for raw materials update
if (!isAllowedToOrder)
{
if (objDetails.KitchenQuantity - objDetails.OrderQuantity >= 0)
{
double quantity = objDetails.KitchenQuantity - objDetails.OrderQuantity;
//if (objDetails.OrderQuantity == 0)
//{
// quantity = 1;
//}
COrderDetailsDAO cOrderDetailsDao = new COrderDetailsDAO();
cOrderDetailsDao.UpdateKitchenQuantity(aDetails);
FinishedRawProductListDAO aDao = new FinishedRawProductListDAO();
List<CFinishedRawProductList> aList =
aDao.GetFinishedRawProductListByProductID(objDetails.ProductID);
foreach (CFinishedRawProductList list in aList)
{
string command = string.Format(SqlQueries.GetQuery(Query.UpdateRawMaterialsByRawProductID),
list.RawProductID, (list.Qnty * quantity));
this.ExecuteNonQuery(command);
}
}
}
}
oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in VoidPrintedItems()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return oResult;
}
private void LoadDataGrid()
{
try
{
// dgvRawProductList.Rows.Clear();
// dgvRawProductList.Refresh();
//if (this.dgvRawProductList.DataSource != null)
//{
// this.dgvRawProductList.DataSource = null;
//}
//else
//{
// this.dgvRawProductList.Rows.Clear();
//}
FinishedRawProductListDAO finishedRawProductListDao = new FinishedRawProductListDAO();
List<CFinishedRawProductList> finishedRawProductList = new List<CFinishedRawProductList>();
finishedRawProductList = finishedRawProductListDao.GetFinishedRawProductListByProductID(m_iCat3ID);
var data = (from c in finishedRawProductList
select new { RawProductID = c.RawProductID, RawProductName = c.RawProductName, Qnty = c.Qnty, obj = c }).ToList();
dgvRawProductList.DataSource = data;
txtRawProductQnty.Text = finishedRawProductList.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
try
{
if (cFinishedProductList != null)
{
FinishedRawProductListDAO finishedRawProductListDao = new FinishedRawProductListDAO();
finishedRawProductListDao.FinishedRawProductListDelete(cFinishedProductList);
}
cFinishedProductList = null;
LoadDataGrid();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void AddFinishedtoRawProductList()
{
try
{
// FinishedRawProductListDAO finishedRawProductDAO = new FinishedRawProductListDAO();
FinishedRawProductListDAO finishedRawProductDAO = new FinishedRawProductListDAO();
// CFinishedRawProductList cfinishedproduct = new CFinishedRawProductList();
if (isModifyRawProduct && txtRawQnty.Tag != null)
{
cFinishedProductList = txtRawQnty.Tag as CFinishedRawProductList;
}
else
{
cFinishedProductList = new CFinishedRawProductList();
}
InventoryItem aInventoryItem = new InventoryItem();
aInventoryItem = (InventoryItem)cmbProductName.SelectedItem;
// cFinishedProductList.FinishedProductID = m_iCat3ID;
// cFinishedProductList.RawProductID = cCategory3sList[cmbProductName.SelectedIndex].Category3ID;
// cFinishedProductList.RawProductName = cCategory3sList[cmbProductName.SelectedIndex].Category3Name;
cFinishedProductList.FinishedProductID = m_iCat3ID;
cFinishedProductList.RawProductID = aInventoryItem.ItemId;
cFinishedProductList.RawProductName = aInventoryItem.ItemName;
//try { cFinishedProductList.Qnty = Convert.ToInt32(txtRawQnty.Text); }
//catch (Exception e)
//{
//}
try { cFinishedProductList.Qnty = Convert.ToDouble(txtRawQnty.Text); }
catch (Exception e)
{
}
cFinishedProductList.Remarks = "";
if (isModifyRawProduct)
{
finishedRawProductDAO.FinishedRawProductListUpdate(cFinishedProductList);
}
else
{
try
{
finishedRawProductDAO.FinishedRawProductListInsert(cFinishedProductList);
}
catch { }
}
RefreshFinishedRawProduct();
LoadDataGrid();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}