public List<Transaction> GetTransactionBetweenDate(DateTime fromdate, DateTime todate) { List<Transaction> aTransactions= new List<Transaction>(); try { this.OpenConnection(); string sqlComm = String.Format(SqlQueries.GetQuery(Query.GetTransactionBetweenDate), fromdate, todate); IDataReader aReader = this.ExecuteReader(sqlComm); if (aReader != null) { while (aReader.Read()) { Transaction aTransaction=new Transaction(); aTransaction = ReaderToReadInventoryTransaction(aReader); aTransactions.Add(aTransaction); } } } catch (Exception ex) { throw new Exception("GetTransactionBetweenDate()", ex); } finally { this.CloseConnection(); } return aTransactions; }
public string DamageInStock(Transaction aTransaction) { string sr = string.Empty; try { TransactionDAO aDao=new TransactionDAO(); aDao.InsertTransactionForReport(aTransaction); StockBLL aStockBll = new StockBLL(); aStockBll.UpdateStockForDamage(aTransaction.Stock); sr = "Save Successfully"; } catch { sr = "Please Try Again"; } return sr; }
public void InsertTransactionForReport(Transaction aTransaction) { try { this.OpenConnection(); string sqlComm = String.Format(SqlQueries.GetQuery(Query.InsertTransactionForReport),aTransaction.Category.CategoryId, aTransaction.Category.CategoryName,aTransaction.Item.ItemId,aTransaction.Item.ItemName,aTransaction.Stock.Stocks, aTransaction.Item.UnitName, aTransaction.Stock.UnitPrice, aTransaction.Stock.Stocks * aTransaction.Stock.UnitPrice, aTransaction.TransactionDate,aTransaction.TransactionType,aTransaction.UserInfo.UserName,aTransaction.DamageReport); this.ExecuteNonQuery(sqlComm); } catch (Exception ex) { throw ex; } finally { this.CloseConnection(); } }
private Transaction ReaderToReadInventoryTransaction(IDataReader aReader) { Transaction aTransaction=new Transaction(); InventoryCategory aCategory = new InventoryCategory(); InventoryItem aItem = new InventoryItem(); Unit aUnit = new Unit(); CUserInfo aCUserInfo = new CUserInfo(); Stock aStock = new Stock(); try { aTransaction.TransactionId = Convert.ToInt32(aReader["transaction_id"]); } catch { } try { aTransaction.TransactionType = (aReader["transaction_type"]).ToString(); } catch { } try { aTransaction.TransactionDate = Convert.ToDateTime((aReader["date"])); } catch { } try { aTransaction.TransactionAmount = Convert.ToDouble(aReader["total_price"]); } catch { } try { aTransaction.DamageReport = (aReader["damage_report"]).ToString(); } catch { } try { aCategory.CategoryId = Convert.ToInt32(aReader["category_id"]); } catch { } try { aCategory.CategoryName = aReader["category_name"].ToString(); } catch { } try { aItem.ItemId = Convert.ToInt32(aReader["item_id"]); } catch { } try { aItem.ItemName = (aReader["item_name"]).ToString(); } catch { } try { aUnit.UnitName = (aReader["unit"]).ToString(); } catch { } try { aCUserInfo.UserName = ((aReader["user_name"])).ToString(); } catch { } try { aCUserInfo.UserName = ((aReader["user_name"])).ToString(); } catch { } try { aStock.Stocks = Convert.ToDouble(aReader["quantity"]); } catch { } try { aStock.UnitPrice = Convert.ToDouble(aReader["unit_price"]); } catch { } aTransaction.Category = aCategory; aTransaction.Item = aItem; aTransaction.Unit = aUnit; aTransaction.UserInfo = aCUserInfo; aTransaction.Stock = aStock; return aTransaction; }
private void TransactionWhenProfessionalPackageIsActive() { InventoryItem aItem = new InventoryItem(); aItem = (InventoryItem)itemNamecomboBox.SelectedItem; InventoryCategory aInventoryCategory = new InventoryCategory(); aInventoryCategory = (InventoryCategory)categoryNamecomboBox.SelectedItem; Stock aStock = new Stock(); StockBLL aStockBll = new StockBLL(); string transactiontype = transactionTypecomboBox.SelectedItem.ToString(); Transaction aTransaction = new Transaction(); aTransaction.TransactionDate = DateTime.Now; aTransaction.Item = aItem; aTransaction.Category = aInventoryCategory; aTransaction.TransactionType = transactiontype; CUserInfo aUserInfo = new CUserInfo(); aUserInfo.UserName = RMSGlobal.LogInUserName; aTransaction.UserInfo = aUserInfo; string sr = string.Empty; if (transactiontype == "Damage_in_Stock") { if (danmagetextBox.Text.Length > 0) { aStock = aStockBll.GetStockByItemid(aItem.ItemId); if ((aStock.Stocks >= Convert.ToDouble(quantitytextBox.Text)) && (Convert.ToDouble(quantitytextBox.Text) != 0)) { aStock.Stocks = Convert.ToDouble(quantitytextBox.Text); aStock.Item = aItem; aStock.Category = aInventoryCategory; aTransaction.Stock = aStock; aTransaction.DamageReport = danmagetextBox.Text.Replace("'", "''"); TransactionBLL aBll = new TransactionBLL(); sr = aBll.DamageInStock(aTransaction); ShowAndClear(sr); } else MessageBox.Show("Your Quantity Must be Greater than 0 and less than or equal to " + aStock.Stocks + " " + unittypelabel.Text); } else MessageBox.Show("Please Check Your Damage Report Field It's Never Empty"); } if (transactiontype == "Send_to_Kitchen") { aStock = aStockBll.GetStockByItemid(aItem.ItemId); if ((aStock.Stocks >= Convert.ToDouble(quantitytextBox.Text)) && (Convert.ToDouble(quantitytextBox.Text) != 0)) { aStock.Stocks = Convert.ToDouble(quantitytextBox.Text); aStock.Item = aItem; aStock.Category = aInventoryCategory; aTransaction.Stock = aStock; TransactionBLL aBll = new TransactionBLL(); sr = aBll.SendToKitchen(aTransaction); ShowAndClear(sr); } else MessageBox.Show("Your Quantity Must be Greater than 0 and less than or equal to " + aStock.Stocks + " " + unittypelabel.Text); } //aStock = aStockBll.GetStockByItemidFrominventory_kitchen_stock(aItem); if (transactiontype == "Return_from_Kitchen") { aStock = aStockBll.GetStockByItemidFrominventory_kitchen_stock(aItem); if ((aStock.Stocks >= Convert.ToDouble(quantitytextBox.Text)) && (Convert.ToDouble(quantitytextBox.Text) != 0)) { aStock.Stocks = Convert.ToDouble(quantitytextBox.Text); aStock.Item = aItem; aStock.Category = aInventoryCategory; aTransaction.Stock = aStock; TransactionBLL aBll = new TransactionBLL(); sr = aBll.ReturnFromKitchen(aTransaction); ShowAndClear(sr); } else MessageBox.Show("Your Quantity Must be Greater than 0 and less than or equal to " + aStock.Stocks + " " + unittypelabel.Text); } if (transactiontype == "Damage_in_kitchen") { if (danmagetextBox.Text.Length > 0) { aStock = aStockBll.GetStockByItemidFrominventory_kitchen_stock(aItem); if ((aStock.Stocks >= Convert.ToDouble(quantitytextBox.Text)) && (Convert.ToDouble(quantitytextBox.Text) != 0)) { aStock.Stocks = Convert.ToDouble(quantitytextBox.Text); aStock.Item = aItem; aStock.Category = aInventoryCategory; aTransaction.Stock = aStock; aTransaction.DamageReport = danmagetextBox.Text.Replace("'", "''"); TransactionBLL aBll = new TransactionBLL(); sr = aBll.DamageInKitchen(aTransaction); ShowAndClear(sr); } else MessageBox.Show("Your Quantity Must be Greater than 0 and less than or equal to " + aStock.Stocks + " " + unittypelabel.Text); } else MessageBox.Show("Please Check Your Damage Report Field It's Never Empty"); } if (transactiontype == "Stock_Out_In_Kitchen") { if (danmagetextBox.Text.Length > 0) { aStock = aStockBll.GetStockByItemidFrominventory_kitchen_stock(aItem); if ((aStock.Stocks >= Convert.ToDouble(quantitytextBox.Text)) && (Convert.ToDouble(quantitytextBox.Text) != 0)) { aStock.Stocks = Convert.ToDouble(quantitytextBox.Text); aStock.Item = aItem; aStock.Category = aInventoryCategory; aTransaction.Stock = aStock; aTransaction.DamageReport = danmagetextBox.Text.Replace("'", "''"); TransactionBLL aBll = new TransactionBLL(); sr = aBll.SendOutInKitchen(aTransaction); StockDAO aStockDao=new StockDAO(); aStockDao.InsertOrUpdateSaleRawmaterialsReport(aTransaction.Item.ItemId, Convert.ToDouble(quantitytextBox.Text),aStock.UnitPrice); ShowAndClear(sr); } else MessageBox.Show("Your Quantity Must be Greater than 0 and less than or equal to " + aStock.Stocks + " " + unittypelabel.Text); } else MessageBox.Show("Please Check Your Damage Report Field It's Never Empty"); } }
public string SendToKitchen(Transaction aTransaction) { string sr = string.Empty; TransactionDAO aDao=new TransactionDAO(); Stock aStock=new Stock(); StockBLL aBll=new StockBLL(); aStock = aBll.GetStockByItemidFrominventory_kitchen_stock(aTransaction.Item); if(aStock.StockId==0) { aStock = aTransaction.Stock; aStock.Category = aTransaction.Category; aStock.Item = aTransaction.Item; sr = aBll.InsertKitchenStock(aStock); } else if (aStock.StockId > 0) { Stock stock=new Stock(); stock = aTransaction.Stock; double pricePrevious = stock.Stocks * stock.UnitPrice; double priceNow = aStock.Stocks * aStock.UnitPrice; double totalStocks = stock.Stocks + aStock.Stocks; double totalPrice = priceNow + pricePrevious; aStock.Stocks = totalStocks; if (totalStocks != 0 && totalPrice != 0) { aStock.UnitPrice = totalPrice / totalStocks; } else aStock.UnitPrice = 0; // aStock.StockId = stock.StockId; sr=aBll.UpdateKitchenStock(aStock); } if (sr == "Insert Sucessfully") { aDao.InsertTransactionForReport(aTransaction); } if (sr == "Insert Sucessfully") { Stock aaStock=new Stock(); aaStock = aTransaction.Stock; aaStock.Stocks *= -1; aBll.UpdateStockByStockId(aaStock); } return sr; }
public string ReturnFromKitchen(Transaction aTransaction) { string sr=""; try { TransactionDAO aDao = new TransactionDAO(); aDao.InsertTransactionForReport(aTransaction); StockBLL aBll = new StockBLL(); Stock dStock=new Stock(); dStock = aTransaction.Stock; aBll.InsertStockOrUpdate(dStock); Stock cStock = new Stock(); cStock = aTransaction.Stock; cStock.Stocks *= -1; aBll.UpdateKitchenStockByStockId(cStock); sr = "Insert Successfully"; } catch { sr = "Plz Try again"; } return sr; }