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();
}
}
