public List <InventoryStockReport> GetTodayReport(DateTime fromdate, DateTime todate) { List <Transaction> aTransactions = new List <Transaction>(); TransactionBLL aTransactionBll = new TransactionBLL(); List <InventoryPurchase> aInventoryPurchases = new List <InventoryPurchase>(); InventoryPurchaseBLL aInventoryPurchaseBll = new InventoryPurchaseBLL(); List <InventoryStockReport> aInventoryStockReports = new List <InventoryStockReport>(); StockBLL aStockBll = new StockBLL(); //DateTime todate = DateTime.Today.AddDays(1); //DateTime fromdate = DateTime.Today; //todate = todate.AddSeconds(-1); aTransactions = aTransactionBll.GetTransactionBetweenDate(fromdate, todate); aInventoryPurchases = aInventoryPurchaseBll.GetInventoryPurchaseBetweenDate(fromdate, todate); aInventoryStockReports = aStockBll.GetAllStockForReport(); foreach (InventoryStockReport report in aInventoryStockReports) { double receive1 = 0, receive2 = 0, damage = 0, send = 0; receive1 = (from purchase in aInventoryPurchases where (purchase.Item.ItemId == report.ItemId) select purchase.Quantity).Sum(); receive2 = (from transaction in aTransactions where (transaction.TransactionType == "Return_from_Kitchen" && transaction.Item.ItemId == report.ItemId) select transaction.Stock.Stocks).Sum(); damage = (from transaction in aTransactions where (transaction.TransactionType == "Damage_in_Stock" && transaction.Item.ItemId == report.ItemId) select transaction.Stock.Stocks).Sum(); send = (from transaction in aTransactions where (transaction.TransactionType == "Send_to_Kitchen" && transaction.Item.ItemId == report.ItemId) select transaction.Stock.Stocks).Sum(); report.ReceivedQty = receive1 + receive2; report.SendQty = send; report.DamageQty = damage; report.Date = DateTime.Today; } return(aInventoryStockReports); }
public List<InventoryStockReport> GetTodayReport(DateTime fromdate,DateTime todate) { List<Transaction> aTransactions = new List<Transaction>(); TransactionBLL aTransactionBll = new TransactionBLL(); List<InventoryPurchase> aInventoryPurchases = new List<InventoryPurchase>(); InventoryPurchaseBLL aInventoryPurchaseBll = new InventoryPurchaseBLL(); List<InventoryStockReport> aInventoryStockReports = new List<InventoryStockReport>(); StockBLL aStockBll = new StockBLL(); //DateTime todate = DateTime.Today.AddDays(1); //DateTime fromdate = DateTime.Today; //todate = todate.AddSeconds(-1); aTransactions = aTransactionBll.GetTransactionBetweenDate(fromdate, todate); aInventoryPurchases = aInventoryPurchaseBll.GetInventoryPurchaseBetweenDate(fromdate, todate); aInventoryStockReports = aStockBll.GetAllStockForReport(); foreach (InventoryStockReport report in aInventoryStockReports) { double receive1 = 0, receive2 = 0, damage = 0, send = 0; receive1 = (from purchase in aInventoryPurchases where (purchase.Item.ItemId == report.ItemId) select purchase.Quantity).Sum(); receive2 = (from transaction in aTransactions where (transaction.TransactionType == "Return_from_Kitchen" && transaction.Item.ItemId == report.ItemId) select transaction.Stock.Stocks).Sum(); damage = (from transaction in aTransactions where (transaction.TransactionType == "Damage_in_Stock" && transaction.Item.ItemId == report.ItemId) select transaction.Stock.Stocks).Sum(); send = (from transaction in aTransactions where (transaction.TransactionType == "Send_to_Kitchen" && transaction.Item.ItemId == report.ItemId) select transaction.Stock.Stocks).Sum(); report.ReceivedQty = receive1 + receive2; report.SendQty = send; report.DamageQty = damage; report.Date = DateTime.Today; } return aInventoryStockReports; }
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"); } }
private void showButton_Click(object sender, EventArgs e) { DateTime fromdate = fromdateTimePicker.Value; DateTime todate = todateTimePicker.Value; todate = todate.AddDays(1); // todate = todate.AddSeconds(-1); fromdate = fromdate.Date; todate = todate.Date; todate = todate.AddSeconds(-1); List<Transaction> aTransactions=new List<Transaction>(); TransactionBLL aTransactionBll=new TransactionBLL(); aTransactions = aTransactionBll.GetTransactionBetweenDate(fromdate,todate); // inventoryTransactionDataGridView.DataSource = aTransactions; ShowReport(aTransactions); }
private void printTransactionReportbutton_Click(object sender, EventArgs e) { TransactionBLL aTransactionBll = new TransactionBLL(); List<TransationReport> aReports = new List<TransationReport>(); aReports = (List<TransationReport>)inventoryTransactionDataGridView.DataSource; if (aReports== null) { MessageBox.Show("No data Available Into GridView"); return; } int printlenght = aReports.Count; PrintDocument doc = new TextDocument(aTransactionBll.PrintTransactionReport(aReports), printlenght); //ViewReport aReport = new ViewReport(); printReportLogoType = 1; doc.PrintPage += this.Doc_PrintPage; doc.DefaultPageSettings.Landscape = true; PrintDialog dlgSettings = new PrintDialog(); dlgSettings.UseEXDialog = true; dlgSettings.Document = doc; if (dlgSettings.ShowDialog() == DialogResult.OK) { doc.Print(); } }