public void Insert(PhieuTraHang info)
{
string sqlQuery = "insert into PhieuTraHang values ('" +
info.MaKH + "','" +
info.MaSach + "','" +
info.MaKH + "',N'" +
info.LyDoTra + "')";
ExecuteNonQuery(sqlQuery);
}
public void Update(PhieuTraHang info)
{
string sqlQuery = "update PhieuTraHang" +
" set MaSach='" + info.MaSach + "'," +
"MaKH='" + info.MaKH + "'" +
"LyDoTra='" + info.LyDoTra + "'" +
"where MaTH='" + info.MaTH + "'";
ExecuteNonQuery(sqlQuery);
}
public async Task <IActionResult> Create(decimal TienThu, int ID, List <ChiTietTraHang> returnDetails)
{
try
{
var phieutra = new PhieuTraHang();
phieutra.DonHangId = ID;
phieutra.NgayLap = DateTime.Now;
var user = await _usermanager.FindByNameAsync(User.Identity.Name);
phieutra.NhanVienId = user.Id;
phieutra.TongTien = TienThu;
var kh = _bookStoreData.findCustomerByDonhang((int)phieutra.DonHangId);
phieutra.KhachHangId = kh.Id;
_bookStoreData.TaoPhieuTraHang(phieutra);
var phieuchi = new PhieuChi();
var pt = _bookStoreData.findNewPhieuTraHang();
phieuchi.KhachHangId = kh.Id;
phieuchi.NhanVienId = user.Id;
phieuchi.PhieuTraHangId = pt.Id;
phieuchi.TongTien = phieutra.TongTien;
phieuchi.LoaiPhieuId = 10;
phieuchi.NgayLap = DateTime.Now;
_bookStoreData.TaoPhieuChi(phieuchi);
//List<ChiTietPhieuTraHang> chitietphieu = new List<ChiTietPhieuTraHang>();
for (int i = 0; i < returnDetails.Count; i++)
{
var chitiet = new ChiTietPhieuTraHang();
chitiet.PhieuTraHangId = pt.Id;
chitiet.ChiTietDonHangId = returnDetails[i].ChiTietDonHangId;
chitiet.SoLuong = returnDetails[i].Soluong;
chitiet.GiaTra = returnDetails[i].GiaTra;
_bookStoreData.TaoCTPhieuTraHang(chitiet);
}
var noti = new Notification
{
Title = "Thành Công",
Content = "Tạo phiếu trả hàng thành công",
Icon = "checkmark",
MessageType = "positive",
};
return(PartialView("_Notify", noti));
}
catch (Exception e)
{
var noti = new Notification
{
Title = "Thất bại",
Content = "Có lỗi xảy ra" + e.Message,
Icon = "remove",
MessageType = "negative",
};
return(PartialView("_Notify", noti));
}
}
public List <PhieuTraHang> GetList()
{
List <PhieuTraHang> list = new List <PhieuTraHang>();
string sqlQuery = "select * from PhieuTraHang";
reader = ExecuteReader(sqlQuery);
while (reader.Read())
{
PhieuTraHang phieuTraHang = new PhieuTraHang();
phieuTraHang.MaTH = reader["MaTH"].ToString();
phieuTraHang.MaSach = reader["MaSach"].ToString();
phieuTraHang.MaKH = reader["MaKH"].ToString();
phieuTraHang.LyDoTra = reader["LyDoTra"].ToString();
list.Add(phieuTraHang);
}
return(list);
}
public void TaoPhieuTraHang(PhieuTraHang pth)
{
_context.PhieuTraHang.Add(pth);
_context.SaveChanges();
}
public void Update(PhieuTraHang info)
{
data.Update(info);
}
public void Insert(PhieuTraHang info)
{
data.Insert(info);
}
