public void VoidTableDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (VoidTableDataGridView.Columns[e.ColumnIndex].Name == "ActionButtonColumn" && e.RowIndex >= 0 && VoidTableDataGridView.Rows[e.RowIndex].Cells["OrderIDColumn"].Value != null)
{
DialogResult tempDialogResult = MessageBox.Show("Are you sure you want to void this order?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (tempDialogResult.Equals(DialogResult.No)) return;
//ItemInfo c = new ItemInfo();
//c.ShowDialog();
//c.Close();
//DialogResult tempDialogResult1 = MessageBox.Show("Ok Done", "Confirm", MessageBoxButtons.OK, MessageBoxIcon.Question);
//if (tempDialogResult1.Equals(DialogResult.No)) return;
else
{
String tempOldOrderID = VoidTableDataGridView.Rows[e.RowIndex].Cells["OrderIDColumn"].Value.ToString();
int tempOldTableNumber = int.Parse(VoidTableDataGridView.Rows[e.RowIndex].Cells["TableNumberColumn"].Value.ToString());
String tempOldTableType = VoidTableDataGridView.Rows[e.RowIndex].Cells["TableTypeColumn"].Value.ToString();
// add by mithu
OrderVoid aOrderVoid=new OrderVoid();
aOrderVoid.OrderId = Convert.ToInt32(VoidTableDataGridView.Rows[e.RowIndex].Cells["OrderIDColumn"].Value);
COrderDetailsDAO aDao = new COrderDetailsDAO();
List<COrderDetails> aList = new List<COrderDetails>();
CResult aResult = new CResult();
aResult = aDao.OrderDetailsGetByOrderID(aOrderVoid.OrderId);
aList = (List<COrderDetails>)aResult.Data;
aOrderVoid.TableNumber = tempOldTableNumber;
aOrderVoid.RemoverId = RMS.RMSGlobal.m_iLoginUserID;
aOrderVoid.VoidDate = DateTime.Now;
COrderDetailsDAO aCOrderDetailsDAO=new COrderDetailsDAO();
aOrderVoid.OrderAmount = aCOrderDetailsDAO.GetOrderAmount(aOrderVoid.OrderId);
COrderInfo aInfo=new COrderInfo();
COrderInfoDAO aCOrderInfoDao=new COrderInfoDAO();
aInfo = aCOrderInfoDao.GetOrderInfoByOrderID(aOrderVoid.OrderId);
aOrderVoid.OrderDate = aInfo.OrderTime;
aOrderVoid.Creator_Id = aInfo.UserID;
ReasonForm aReasonForm=new ReasonForm();
aReasonForm.ShowDialog();
aOrderVoid.Reason = aReasonForm.reason;
OrderVoidDAO aOrderVoidDao=new OrderVoidDAO();
aOrderVoidDao.InsertOrderForVoid(aOrderVoid);
DataSet tempStockDataSet = new DataSet();
tempStockDataSet.ReadXml("Config/StockSetting.xml");
bool isAllowedToOrder = Convert.ToBoolean(tempStockDataSet.Tables[0].Rows[0]["AllowedtoOrder"].ToString());
if (!isAllowedToOrder)
{
UpdateRawMaterial(aList);
}
COrderManager tempVoidTableManager = new COrderManager();
CResult tempResult = tempVoidTableManager.UpdateForVoidTable(tempOldOrderID, tempOldTableNumber, tempOldTableType, false);
if (tempResult.IsSuccess)
{
this.PopulateVoidTableDataGridView();
}
}
}
}
catch (Exception ex)
{
}
}
private void functionalButton1_Click_2(object sender, EventArgs e)
{
CResult aCResult = new CResult();
CUserInfoDAO aUserInfoDao = new CUserInfoDAO();
CUserInfo aUserInfo = new CUserInfo();
aUserInfo.UserID = RMSGlobal.m_iLoginUserID;
aCResult = aUserInfoDao.GetUser(aUserInfo);
aUserInfo = (CUserInfo)aCResult.Data;
if (aUserInfo.Type != 0)
{
MessageBox.Show("You are not correct person to give Item Complementory Opportunity");
return;
}
CDiscountForm tempDiscountForm = new CDiscountForm();
tempDiscountForm.ShowDialog();
if (CDiscountForm.discountType.Equals("Cancel"))
return;
double discountAmount = Convert.ToDouble(CDiscountForm.discountAmount);
string discountType = CDiscountForm.discountType;
COrderDetailsDAO aOrderInfoDao = new COrderDetailsDAO();
foreach (DataGridViewRow row in g_FoodDataGridView.Rows)
{
if (Convert.ToBoolean(row.Cells["complementoryfood"].Value) == true)
{
COrderDetails aCOrderDetails = new COrderDetails();
aCOrderDetails.OrderDetailsID = Convert.ToInt64(row.Cells["Order_details_id"].Value);
aCOrderDetails = aOrderInfoDao.OrderDetailsGetByOrderDetailID(aCOrderDetails.OrderDetailsID);
double totalAmount = aCOrderDetails.UnitPrice*aCOrderDetails.OrderQuantity;
double discount=0;
if (discountType == "Fixed")
{
discount = discountAmount;
} else
{
discount = (totalAmount*discountAmount)/100.0;
}
aCOrderDetails.DiscountAmount = discount;
string result = aOrderInfoDao.UpdateItemWiseDiscountForItem(aCOrderDetails);
}
}
foreach (DataGridViewRow row in g_BeverageDataGridView.Rows)
{
if (Convert.ToBoolean(row.Cells["complementorynonfood"].Value) == true)
{
COrderDetails aCOrderDetails = new COrderDetails();
aCOrderDetails.OrderDetailsID = Convert.ToInt64(row.Cells["dataGridViewTextBoxColumn5"].Value);
aCOrderDetails = aOrderInfoDao.OrderDetailsGetByOrderDetailID(aCOrderDetails.OrderDetailsID);
double totalAmount = aCOrderDetails.UnitPrice * aCOrderDetails.OrderQuantity;
double discount = 0;
if (discountType == "Fixed")
{
discount = discountAmount;
}
else
{
discount = (totalAmount * discountAmount) / 100.0;
}
aCOrderDetails.DiscountAmount = discount;
string result = aOrderInfoDao.UpdateItemWiseDiscountForItem(aCOrderDetails);
}
}
CResult oResult1 = aOrderInfoDao.OrderDetailsGetByOrderID(orderID);
List<COrderDetails> aOrderDetailses = oResult1.Data as List<COrderDetails>;
double totalItemDiscount = 0;
if (aOrderDetailses != null)
{
totalItemDiscount = aOrderDetailses.Sum(a => a.DiscountAmount);
}
COrderManager tempOrderManager = new COrderManager();
COrderDiscount tempOrderDiscount = new COrderDiscount();
CResult oResult = tempOrderManager.OrderDiscountGetByOrderID(orderID);
if (oResult.IsSuccess && oResult.Data != null)
{
tempOrderDiscount = (COrderDiscount)oResult.Data;
tempOrderDiscount.TotalItemDiscount = totalItemDiscount;
tempOrderManager.UpdateOrderDiscount(tempOrderDiscount);
}
else
{
//insert
tempOrderDiscount.OrderID = orderID;
tempOrderDiscount.TotalItemDiscount = totalItemDiscount;
tempOrderManager.InsertOrderDiscount(tempOrderDiscount);
}
LoadOrderDetails();
}
private double GetTotalCost(long mIOrderId)
{
COrderDetailsDAO aDetailsDao=new COrderDetailsDAO();
List<COrderDetails> aDetailses=new List<COrderDetails>();
aDetailses = (List<COrderDetails>)aDetailsDao.OrderDetailsGetByOrderID(mIOrderId).Data;
CCategory3DAO aCCategory3Dao=new CCategory3DAO();
List<CCategory3> aCCategory3s=new List<CCategory3>();
aCCategory3s = aCCategory3Dao.GetAllCategory3();
double totalcost = 0;
foreach (COrderDetails order in aDetailses)
{
foreach (CCategory3 category3 in aCCategory3s)
{
if(category3.Category3ID==order.ProductID)
{
totalcost += (category3.TableCost*order.OrderQuantity);
}
}
}
return totalcost;
}