public TransferObj <MdBoHangVm.Dto> GetDataByCode(string code) { code = code.ToUpper(); var result = new TransferObj <MdBoHangVm.Dto>(); var temp = new MdBoHangVm.Dto(); var boHang = _service.UnitOfWork.Repository <MdBoHang>().DbSet.FirstOrDefault(x => x.MaBoHang == code); temp = Mapper.Map <MdBoHang, MdBoHangVm.Dto>(boHang); if (boHang != null) { decimal tongle = 0; decimal tongbuon = 0; temp = Mapper.Map <MdBoHang, MdBoHangVm.Dto>(boHang); var chiTietBoHang = _service.UnitOfWork.Repository <MdBoHangChiTiet>().DbSet.Where(x => x.MaBoHang == boHang.MaBoHang).ToList(); foreach (var x in chiTietBoHang) { tongle += (decimal)x.TongBanLe; tongbuon += (decimal)x.TongBanBuon; } //temp.DataDetails = Mapper.Map<List<MdBoHangChiTiet>, List<MdBoHangVm.DtoDetail>>(chiTietBoHang); temp.TongLe = tongle; temp.TongBuon = tongbuon; result.Data = temp; result.Status = true; } return(result); }
public MemoryStream CreateExcelTemplate(MdBoHangVm.Dto param) { var ms = new MemoryStream(); using (ExcelPackage package = new ExcelPackage()) { package.Workbook.Worksheets.Add("Sheet1"); var worksheet = package.Workbook.Worksheets["Sheet1"]; int startColumn = 1; worksheet.Cells[1, 1].Value = "STT"; worksheet.Cells[1, 1].Style.Border.BorderAround(ExcelBorderStyle.Thin); worksheet.Cells[1, 2].Value = "Masieuthi"; worksheet.Cells[1, 2].Style.Border.BorderAround(ExcelBorderStyle.Thin); worksheet.Cells[1, 3].Value = "Tenviettat"; worksheet.Cells[1, 3].Style.Border.BorderAround(ExcelBorderStyle.Thin); worksheet.Cells[1, 4].Value = "Barcode"; worksheet.Cells[1, 4].Style.Border.BorderAround(ExcelBorderStyle.Thin); worksheet.Cells[1, 5].Value = "Giabanbuoncovat"; worksheet.Cells[1, 5].Style.Border.BorderAround(ExcelBorderStyle.Thin); worksheet.Cells[1, 6].Value = "Giabanlecovat"; worksheet.Cells[1, 6].Style.Border.BorderAround(ExcelBorderStyle.Thin); worksheet.Cells[1, 7].Value = "Makhachhang"; worksheet.Cells[1, 7].Style.Border.BorderAround(ExcelBorderStyle.Thin); worksheet.Cells[1, 8].Value = "Soluong"; worksheet.Cells[1, 8].Style.Border.BorderAround(ExcelBorderStyle.Thin); int currentRow = 2; int stt = 0; for (int i = 0; i < param.SoLuongIn; i++) { worksheet.Cells[currentRow, startColumn].Value = i + 1; worksheet.Cells[currentRow, startColumn + 1].Value = param.MaBoHang; worksheet.Cells[currentRow, startColumn + 2].Value = UnicodetoTCVN222(param.TenBoHang); worksheet.Cells[currentRow, startColumn + 3].Value = ""; worksheet.Cells[currentRow, startColumn + 4].Value = Formattienviet(param.ThanhTien.ToString()); worksheet.Cells[currentRow, startColumn + 5].Value = Formattienviet(param.ThanhTien.ToString()); worksheet.Cells[currentRow, startColumn + 6].Value = ""; worksheet.Cells[currentRow, startColumn + 7].Value = 1; currentRow++; } worksheet.Column(1).AutoFit(); worksheet.Column(2).AutoFit(); worksheet.Column(3).AutoFit(); worksheet.Column(4).AutoFit(); worksheet.Column(5).AutoFit(); worksheet.Column(6).AutoFit(); worksheet.Column(7).AutoFit(); worksheet.Column(8).AutoFit(); int totalRows = worksheet.Dimension.End.Row; int totalCols = worksheet.Dimension.End.Column; var dataCells = worksheet.Cells[1, 1, totalRows, totalCols]; var dataFont = dataCells.Style.Font; dataFont.SetFromFont(new Font(".VnTime", 10)); HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); HttpContext.Current.Response.Charset = "UTF-8"; HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; package.SaveAs(ms); return(ms); } }
public TransferObj <MdBoHangVm.Dto> GetDetails(string id) { var result = new TransferObj <MdBoHangVm.Dto>(); var temp = new MdBoHangVm.Dto(); var boHang = _service.FindById(id); var chitietBoHang = _service.UnitOfWork.Repository <MdBoHangChiTiet>().DbSet; if (boHang != null) { temp = Mapper.Map <MdBoHang, MdBoHangVm.Dto>(boHang); var chiTietBoHang = chitietBoHang.Where(x => x.MaBoHang == boHang.MaBoHang).ToList(); //foreach (var x in chitietBoHang) //{ //} temp.DataDetails = Mapper.Map <List <MdBoHangChiTiet>, List <MdBoHangVm.DtoDetail> >(chiTietBoHang); result.Data = temp; result.Status = true; } return(result); }
public async Task <IHttpActionResult> Post(MdBoHangVm.Dto instance) { var result = new TransferObj <MdBoHang>(); try { var item = _service.InsertDto(instance); _service.SaveCode(); _service.UnitOfWork.Save(); result.Status = true; result.Message = "Thêm mới thành công"; result.Data = item; } catch (Exception e) { result.Status = false; result.Message = e.Message; return(Ok(result)); } return(CreatedAtRoute("DefaultApi", new { controller = this, id = instance.Id }, result)); }
public TransferObj <MdBoHangVm.Dto> GetDetails(string id) { var unitCode = _service.GetCurrentUnitCode(); var result = new TransferObj <MdBoHangVm.Dto>(); var temp = new MdBoHangVm.Dto(); var boHang = _service.FindById(id); var chitietBoHang = _service.UnitOfWork.Repository <MdBoHangChiTiet>().DbSet; if (boHang != null) { temp = Mapper.Map <MdBoHang, MdBoHangVm.Dto>(boHang); var chiTietBoHang = chitietBoHang.Where(x => x.MaBoHang == boHang.MaBoHang).ToList(); temp.DataDetails = Mapper.Map <List <MdBoHangChiTiet>, List <MdBoHangVm.DtoDetail> >(chiTietBoHang); if (temp.DataDetails.Count > 0) { var merchandisePriceService = _service.UnitOfWork.Repository <MdMerchandisePrice>(); foreach (var a in temp.DataDetails) { MdMerchandisePrice merchandisePrice = merchandisePriceService.DbSet.FirstOrDefault(x => x.MaVatTu.Equals(a.MaHang) && x.MaDonVi.Equals(unitCode)); if (merchandisePrice != null) { a.GiaMua = merchandisePrice.GiaMua; a.GiaMuaVat = merchandisePrice.GiaMuaVat; a.GiaBanLe = merchandisePrice.GiaBanLe; a.GiaBanBuon = merchandisePrice.GiaBanBuon; a.GiaBanLeVat = merchandisePrice.GiaBanLeVat; a.GiaBanBuonVat = merchandisePrice.GiaBanBuonVat; a.DonGia = merchandisePrice.GiaBanLeVat; } } } result.Data = temp; result.Status = true; } return(result); }
public async Task <IHttpActionResult> Put(string id, MdBoHangVm.Dto instance) { var result = new TransferObj <MdBoHang>(); if (id != instance.Id) { result.Status = false; result.Message = "Id không hợp lệ"; return(Ok(result)); } try { for (int i = 0; i < instance.DataDetails.Count; i++) { string maMoi = instance.DataDetails[i].MaHang; var unitcode = _service.GetCurrentUnitCode(); var sa = _service.UnitOfWork.Repository <MdMerchandisePrice>().DbSet.FirstOrDefault(x => x.MaVatTu == maMoi && x.MaDonVi == unitcode); if (sa != null) { instance.DataDetails[i].DonGia = sa.GiaBanLe; } } var item = _service.UpdateDto(instance); _service.UnitOfWork.Save(); result.Status = true; result.Message = "Cập nhật thành công"; result.Data = item; return(Ok(result)); } catch (Exception e) { result.Status = false; result.Message = e.Message; return(Ok(result)); } }