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