public bool SaveResOrder(ResOrderDto resOrderDto) { try { ResOrder resOrder = new ResOrder() { Id = resOrderDto.Id, MenuId = resOrderDto.MenuId, BillId = resOrderDto.BillId, Amount = resOrderDto.Amount, Discount = resOrderDto.Discount, CreatedBy = resOrderDto.CreatedBy, CreatedDate = DateTime.Now, UpdatedBy = resOrderDto.UpdatedBy, UpdatedDate = DateTime.Now }; m_PersistenceManager.Save <ResOrder>(resOrder); return(true); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } }
private void btnThemMonAn_Click(object sender, EventArgs e) { if (!IsValidInputData()) { return; } var resOrderDto = new ResOrderDto(); resOrderDto.MenuId = long.Parse(MControlUtil.GetValueFromCombobox(cboMonAn)); resOrderDto.BillId = GetSelectedBillId(); resOrderDto.Amount = long.Parse(txtSoLuong.Text); var disCount = 0.0f; if (!"".Equals(txtChietKhau.Text)) { disCount = long.Parse(txtChietKhau.Text) / 100.0f; } resOrderDto.Discount = disCount; string currentUserName = _danhSachUser.GetCurrentUserName(); resOrderDto.CreatedBy = currentUserName; resOrderDto.UpdatedBy = currentUserName; _billingDao.AddNewResOrder(resOrderDto); dgvHoaDon_SelectionChanged(null, null); }
public List <ResOrderDto> GetAllResOrderBy(long billId) { using (ISession session = m_SessionFactory.OpenSession()) { var query = session.CreateQuery("select new ResOrder(o.Id, m.Name, o.Amount, o.Discount, u.Name, m.Price)" + " from ResOrder o, Menu m, Unit u where o.MenuId = m.Id and m.UnitId = u.Id and o.BillId = :billId"); query.SetParameter("billId", billId); // Get the matching objects var allResOrders = query.List(); // Update Role info var listResOrderDtos = new List <ResOrderDto>(); foreach (ResOrder resOrder in allResOrders) { var resOrderDto = new ResOrderDto() { Id = resOrder.Id, MenuName = resOrder.MenuName, Amount = resOrder.Amount, Discount = resOrder.Discount, UnitName = resOrder.UnitName, MenuPrice = resOrder.MenuPrice }; listResOrderDtos.Add(resOrderDto); } return(listResOrderDtos); } }
private void AddOneSellRow(ResOrderDto dto) { int index = sellDataGridView.Rows.Add(); var r = sellDataGridView.Rows[index]; r.Cells["menu"].Value = dto.MenuName; r.Cells["unit"].Value = dto.UnitName; r.Cells["amount"].Value = dto.Amount; r.Cells["total"].Value = dto.Total.ToString("#,###,###"); }
private void AddOneResOrderRow(ResOrderDto dto, out float oneTotal) { oneTotal = dto.Amount * dto.MenuPrice * (1 - dto.Discount); int index = dgvThucDon.Rows.Add(); var r = dgvThucDon.Rows[index]; r.Cells["MON_AN"].Value = dto.MenuName; r.Cells["SO_LUONG"].Value = dto.Amount; r.Cells["DON_VI"].Value = dto.UnitName; r.Cells["DON_GIA"].Value = dto.MenuPrice.ToString("#,###,###") + " VNĐ"; r.Cells["CHIET_KHAU"].Value = (dto.Discount * 100) + "%"; r.Cells["THANH_TIEN"].Value = oneTotal.ToString("#,###,###") + " VNĐ"; r.Cells["ResOrderId"].Value = dto.Id; }
public bool AddNewResOrder(ResOrderDto resOrderDto) { return(_controller.SaveResOrder(resOrderDto)); }
public List <ResOrderDto> GetAllResOrderDto(StatisticMenuSearchDto dto) { using (ISession session = m_SessionFactory.OpenSession()) { string sqlQuery = "select new ResOrder(o.Id, m.Name, o.Amount, o.Discount, u.Name, m.Price)" + " from ResOrder o, Menu m, Unit u where o.MenuId = m.Id and m.UnitId = u.Id"; var mapParams = new Hashtable(); if (!String.IsNullOrEmpty(dto.FromDate)) { sqlQuery += " and o.CreatedDate >= :fromDate"; mapParams.Add("fromDate", DateUtil.GetDateTime(dto.FromDate)); } if (!String.IsNullOrEmpty(dto.ToDate)) { sqlQuery += " and o.CreatedDate < :toDate"; mapParams.Add("toDate", ((DateTime)DateUtil.GetDateTime(dto.ToDate)).AddDays(1)); } if (!String.IsNullOrEmpty(dto.Thang)) { DateTime fromDate = (DateTime)DateUtil.GetDateTime("01/" + dto.Thang); sqlQuery += " and o.CreatedDate >= :fromDate"; mapParams.Add("fromDate", fromDate); DateTime toDate = fromDate.AddMonths(1); sqlQuery += " and o.CreatedDate < :toDate"; mapParams.Add("toDate", toDate); } if (!String.IsNullOrEmpty(dto.Nam)) { DateTime fromDate = (DateTime)DateUtil.GetDateTime("01/01/" + dto.Nam); sqlQuery += " and o.CreatedDate >= :fromDate"; mapParams.Add("fromDate", fromDate); DateTime toDate = fromDate.AddYears(1); sqlQuery += " and o.CreatedDate < :toDate"; mapParams.Add("toDate", toDate); } if (!String.IsNullOrEmpty(dto.Quy)) { var quater = int.Parse(dto.Quy.Substring(0, 1)); var year = dto.Quy.Substring(2); DateTime fromDate; switch (quater) { case 1: fromDate = (DateTime)DateUtil.GetDateTime("01/01/" + year); break; case 2: fromDate = (DateTime)DateUtil.GetDateTime("01/04/" + year); break; case 3: fromDate = (DateTime)DateUtil.GetDateTime("01/07/" + year); break; default: fromDate = (DateTime)DateUtil.GetDateTime("01/10/" + year); break; } sqlQuery += " and o.CreatedDate >= :fromDate"; mapParams.Add("fromDate", fromDate); DateTime toDate = fromDate.AddMonths(3); sqlQuery += " and o.CreatedDate < :toDate"; mapParams.Add("toDate", toDate); } var query = session.CreateQuery(sqlQuery); foreach (DictionaryEntry param in mapParams) { query.SetParameter(param.Key.ToString(), param.Value); } // Get the matching objects var allResOrders = query.List(); // Update Role info var listResOrderDtos = new List <ResOrderDto>(); var mapResOrder = new Hashtable(); foreach (ResOrder resOrder in allResOrders) { var total = resOrder.Amount * resOrder.MenuPrice * (1 - resOrder.Discount); string key = resOrder.MenuName + "|" + resOrder.UnitName; if (mapResOrder.ContainsKey(key)) { var resOrderdto = (ResOrderDto)mapResOrder[key]; resOrderdto.Amount += resOrder.Amount; resOrderdto.Total += total; } else { var resOrderdto = new ResOrderDto() { MenuName = resOrder.MenuName, UnitName = resOrder.UnitName, Amount = resOrder.Amount, Total = total }; listResOrderDtos.Add(resOrderdto); mapResOrder.Add(key, resOrderdto); } } return(listResOrderDtos); } }