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