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