private void frmViewOrderInfo_Load(object sender, EventArgs e)
{
try
{
// viewClass.viewOrderInfo(dataGridView1);
//dateFrom.Format = DateTimePickerFormat.Custom;
//dateFrom.CustomFormat = "dd-MM-yyyy";
//dateTo.Format = DateTimePickerFormat.Custom;
//dateTo.CustomFormat = "dd-MM-yyyy";
dataGridView1.AutoGenerateColumns = false;
_entities = new KBBQEntities();
List <OrderInfoVM> modelList = new List <OrderInfoVM>();
var data = _entities.tblOrderInfoes.OrderBy(x => x.id).ToList();
if (data != null)
{
foreach (var item in data)
{
OrderInfoVM model = new OrderInfoVM();
model.KOT = item.KOT;
model.orderType = item.orderType;
model.tableNo = item.tableNo;
model.ordDate = item.ordDate;
model.ordTime = item.ordTime;
model.guests = item.fname + " " + item.lname;
model.adultNo = item.adultNo;
model.childrenNo = item.childrenNo;
model.mode = _entities.billAndSettlements.Where(x => x.kot == item.KOT).FirstOrDefault().mode;
var empName = _entities.tblEmployees.Where(x => x.empID == item.empID).FirstOrDefault();
if (empName != null)
{
model.empName = empName.fname;
}
modelList.Add(model);
}
dataGridView1.DataSource = modelList;
foreach (DataGridViewColumn item in dataGridView1.Columns)
{
dataGridView1.Sort(dataGridView1.Columns[item.Name], System.ComponentModel.ListSortDirection.Ascending);
}
}
}
catch (Exception x)
{
}
}
public IActionResult GetAllPharmacytsbyArea(OrderInfoVM orderInfoVM)
{
IncomeVM vM = new IncomeVM(this.Context);
if (ModelState.IsValid)
{
Order checkExistOrder = Context.Order.FirstOrDefault(o => o.Date.Hour == DateTime.Now.Hour && o.CustomerID == GetLoginCustomer());
string uniqueFileName = null;
if (checkExistOrder != null)
{
OrderInformation checkExistOrderInfo = Context.OrderInformation.FirstOrDefault(o => o.PlaceID == orderInfoVM.PlaceID && o.OrderID == checkExistOrder.ID);
if (checkExistOrderInfo == null)
{
if (orderInfoVM.Image != null)
{
string uploadsFolder = Path.Combine(_environment.WebRootPath, "images");
uniqueFileName = Guid.NewGuid().ToString() + "_" + orderInfoVM.Image.FileName;
string filePath = Path.Combine(uploadsFolder, uniqueFileName);
orderInfoVM.Image.CopyTo(new FileStream(filePath, FileMode.Create));
}
OrderInformation newOrder = new OrderInformation();
newOrder.PlaceID = orderInfoVM.PlaceID;
newOrder.OrderImage = uniqueFileName;
newOrder.DelivaryCost = vM.DelivaryPlaceCost(newOrder.PlaceID, vM.GetCustomerArea(GetLoginCustomer()).ID);
newOrder.OrderID = checkExistOrder.ID;
Context.OrderInformation.Add(newOrder);
Context.SaveChanges();
}
}
else
{
if (orderInfoVM.Image != null)
{
string uploadsFolder = Path.Combine(_environment.WebRootPath, "images");
uniqueFileName = Guid.NewGuid().ToString() + "_" + orderInfoVM.Image.FileName;
string filePath = Path.Combine(uploadsFolder, uniqueFileName);
orderInfoVM.Image.CopyTo(new FileStream(filePath, FileMode.Create));
}
checkExistOrder = SetNewOrder();
Context.Order.Add(checkExistOrder);
Context.SaveChanges();
OrderInformation newOrderInfo = SetNewOrderInfo(orderInfoVM.PlaceID, checkExistOrder.ID, uniqueFileName);
Context.OrderInformation.Add(newOrderInfo);
Context.SaveChanges();
}
//updateTotalcost(checkExistOrder.ID);
return(RedirectToAction("ShoppingCard", "Customer"));
}
return(View());
}
private void button2_Click(object sender, EventArgs e)
{
try
{
//DateTime fromdate = DateTime.ParseExact(dateFrom.Text, "dd-MM-yyyy", null);
//DateTime todate = DateTime.ParseExact(dateTo.Text, "dd-MM-yyyy", null);
viewClass.viewOrderInfoByDates(dataGridView1, Convert.ToDateTime(dateFrom.Text).ToString("yyyy-MM-dd"), Convert.ToDateTime(dateTo.Text).ToString("yyyy-MM-dd"));
dataGridView1.AutoGenerateColumns = false;
_entities = new KBBQEntities();
List <OrderInfoVM> modelList = new List <OrderInfoVM>();
DateTime fromDate = Convert.ToDateTime(dateFrom.Text);
DateTime toDate = Convert.ToDateTime(dateTo.Text);
var data = _entities.tblOrderInfoes.Where(x => x.ordDate >= fromDate && x.ordDate <= toDate).OrderBy(x => x.KOT).ToList();
if (data != null)
{
foreach (var item in data)
{
OrderInfoVM model = new OrderInfoVM();
model.KOT = item.KOT;
model.orderType = item.orderType;
model.tableNo = item.tableNo;
model.ordDate = item.ordDate;
model.ordTime = item.ordTime;
model.guests = item.fname + " " + item.lname;
model.adultNo = item.adultNo;
model.childrenNo = item.childrenNo;
model.mode = _entities.billAndSettlements.Where(x => x.kot == item.KOT).FirstOrDefault().mode;
var empName = _entities.tblEmployees.Where(x => x.empID == item.empID).FirstOrDefault();
if (empName != null)
{
model.empName = empName.fname;
}
modelList.Add(model);
}
dataGridView1.DataSource = modelList;
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void getTableNo()
{
_entities = new KBBQEntities();
var data = _entities.billAndSettlements.Where(x => x.mode == "UNPAID").OrderBy(x => x.kot).ToList();
List <OrderInfoVM> modelList = new List <OrderInfoVM>();
if (data != null)
{
foreach (var item in data)
{
var dataTableNo = _entities.tblOrderInfoes.Where(x => x.KOT == item.kot).FirstOrDefault();
if (dataTableNo != null)
{
var datas = _entities.tblOrderInfoes.ToList();
foreach (var itemss in modelList)
{
if (itemss.tableNo == dataTableNo.tableNo)
{
count = 1;
}
}
if (count == 1)
{
count = 0;
}
else
{
OrderInfoVM model = new OrderInfoVM();
model.KOT = dataTableNo.KOT;
model.tableNo = dataTableNo.tableNo;
modelList.Add(model);
tabl = model.tableNo;
count = 0;
//cmbTableNo.Items.Add(tabl);
}
}
}
cmbTableNo.ValueMember = "KOT";
cmbTableNo.DisplayMember = "tableNo";
cmbTableNo.DataSource = modelList.OrderBy(x => x.tableNo).ToList();
}
}
private void button3_Click(object sender, EventArgs e)
{
dataGridView1.AutoGenerateColumns = false;
_entities = new KBBQEntities();
List <OrderInfoVM> modelList = new List <OrderInfoVM>();
var data = _entities.tblOrderInfoes.OrderBy(x => x.KOT).ToList();
if (data != null)
{
foreach (var item in data)
{
OrderInfoVM model = new OrderInfoVM();
model.KOT = item.KOT;
model.orderType = item.orderType;
model.tableNo = item.tableNo;
model.ordDate = item.ordDate;
model.ordTime = item.ordTime;
model.guests = item.fname + " " + item.lname;
model.adultNo = item.adultNo;
model.childrenNo = item.childrenNo;
model.mode = _entities.billAndSettlements.Where(x => x.kot == item.KOT).FirstOrDefault().mode;
var empName = _entities.tblEmployees.Where(x => x.empID == item.empID).FirstOrDefault();
if (empName != null)
{
model.empName = empName.fname;
}
modelList.Add(model);
}
dataGridView1.DataSource = modelList;
}
}
