public IList <Order_DTO> getListOrder(string page) { DataTable dt = new DataTable(); string cmdText = string.Format(@"Select DH.*,NV.TenNhanVien, KH.TenKhachHang From dbo.DON_HANG DH Left Join dbo.Nhan_Vien_ NV On DH.MaNhanVien = NV.MaNhanVien Inner Join dbo.Khach_Hang KH On KH.MaKhachHang = DH.MaKhachHang Order By MaDonHang Desc Offset 10*({0}-1) Rows Fetch Next 10 Rows Only" , page); dt = DataAccessHelper.log(cmdText); List <Order_DTO> li = new List <Order_DTO>(); foreach (DataRow dr in dt.Rows) { Order_DTO or = new Order_DTO(); or.MaDonHang = dr[0].ToString(); or.MaKhachhang = dr[1].ToString(); or.MaNhanVien = dr[2].ToString(); or.TrangThai = int.Parse(dr[3].ToString()); or.TongTien = int.Parse(dr[4].ToString()); or.NgayMua = DateTime.Parse(dr[5].ToString()); try { or.NgayXacThuc = DateTime.Parse(dr[6].ToString()); } catch { } or.SoDienThoai = dr[7].ToString(); or.DiaChi = dr[8].ToString(); or.TenNhanVien = dr[9].ToString(); or.TenKhachHang = dr[10].ToString(); li.Add(or); } return(li); }
public IList <Order_DTO> listOrder(string makhachhang) { DataTable dt = new DataTable(); string cmdtext = string.Format(@"select * from DON_HANG where MaKhachHang = '{0}'", makhachhang);//lấy về 6 sản phẩm ngẫu nhiên để tạo dt = DataAccessHelper.log(cmdtext); List <Order_DTO> li = new List <Order_DTO>(); foreach (DataRow dr in dt.Rows) { Order_DTO sp = new Order_DTO(); sp.MaDonHang = dr[0].ToString(); sp.MaKhachhang = dr[1].ToString(); sp.MaNhanVien = dr[2].ToString(); sp.TrangThai = int.Parse(dr[3].ToString()); sp.TongTien = int.Parse(dr[4].ToString()); sp.NgayMua = DateTime.Parse(dr[5].ToString()); try { sp.NgayXacThuc = DateTime.Parse(dr[6].ToString()); } catch { } sp.SoDienThoai = dr[7].ToString(); sp.DiaChi = dr[8].ToString(); li.Add(sp); } return(li); }
public IActionResult Get_Order(int id) { if (id <= 0) { return(BadRequest("Id must be greater than zero.")); } var order = customerLogic.GetOrder(id); //TODO Change to Team context; if (order == null) { return(NotFound()); } try { return(Ok(Order_DTO.MapFromModel(order))); } catch (Exception ex) { #if DEBUG throw; #endif return(StatusCode((int)HttpStatusCode.InternalServerError, ex)); } }
public static Orders OrdersDTOtoReg(Order_DTO dto) { var tempList = new List <Tickets>(); var tempGuid = Guid.NewGuid(); foreach (var ticket in dto.Tickets) { Tickets tick = new Tickets { Id = Guid.NewGuid(), OrderId = tempGuid, SeatId = ticket.SeatId, FlightId = ticket.FlightId }; tempList.Add(tick); } Orders order = new Orders { Id = tempGuid, Price = 123.45F, DateOfEntry = DateTime.Now, UserId = dto.UserId, Tickets = tempList }; return(order); }
public IActionResult ChangeOrderStatus(int id, [FromBody] OrderStatusChangeRequest data) { if (id <= 0) { return(BadRequest("Id must be greater than zero.")); } if (ModelState.IsValid == false) { return(BadRequest(ModelState)); } Order order; try { switch (data.Status) { case OrderStatus.InProgress: order = _shopLogic.SetOrderState_InProgress(id); break; case OrderStatus.ReadyToReceive: order = _shopLogic.SetOrderState_ReadyToReceive(id); break; case OrderStatus.Finished: order = _shopLogic.SetOrderState_Finished(id); break; default: throw new NotImplementedException($"Status {data.Status} is not supporrted"); } return(Ok(Order_DTO.MapFromModel(order))); } catch (ArgumentException ex) { return(BadRequest(ex.Message)); } catch (Exception ex) { #if DEBUG throw; #endif return(StatusCode((int)HttpStatusCode.InternalServerError, ex)); } }
public async System.Threading.Tasks.Task <IActionResult> GetAllAsync() { try { var orders = await customerLogic.GetOrdersAsync(); AddTeamDataToOrders(orders); return(Ok(orders.Select(o => Order_DTO.MapFromModel(o)))); } catch (Exception ex) { #if DEBUG throw; #endif return(StatusCode((int)HttpStatusCode.InternalServerError, ex)); } }
public async Task <IActionResult> Reserve([FromBody] Order_DTO model) { try { foreach (var ticket in model.Tickets) { await _repo2.SetSeatToNotAvailable(ticket.SeatId); } //var x = TicketsMapper.OrdersDTOtoReg(model); //return BadRequest(x); //await _repo2.InsertOrderAndTickets(x); var x = new Orders() { Id = Guid.NewGuid(), Price = 123.45F, DateOfEntry = DateTime.Now, UserId = model.UserId, }; await _repo2.InsertNewOrder(x); var y = new List <Tickets>(); foreach (var t in model.Tickets) { Tickets tick = new Tickets { Id = Guid.NewGuid(), OrderId = x.Id, SeatId = t.SeatId, FlightId = t.FlightId }; y.Add(tick); } await _repo2.InsertNewTickets(y); return(Ok("Succes!")); } catch (Exception ex) { return(BadRequest("Something went wrong! " + ex)); } }
public IActionResult Get([FromQuery] int teamId) { if (teamId <= 0) { return(BadRequest("Id must be greater than zero.")); } var orders = customerLogic.GetTeamOrders(new Model.Team { Id = teamId }).Result; //TODO Change to Team context; if (orders.Any() == false) { return(NotFound()); } AddTeamDataToOrders(orders); return(Ok(orders.Select(order => Order_DTO.MapFromModel(order)))); }