public static int add(PhieuNhap phieunhap)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
var phieu = new PHIEUNHAP()
{
masonxb = phieunhap.NXB.MaSoNXB,
ngaylap = phieunhap.NgayLap,
nguoigiaosach = phieunhap.NguoiGiao,
tongtien = phieunhap.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia),
trangthai = 0
};
db.PHIEUNHAPs.InsertOnSubmit(phieu);
db.SubmitChanges();
ChiTiet.add(phieunhap.ChiTiet, phieu.masophieunhap);
return(phieu.masophieunhap);
}
}catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
public void DeleteCTUpdateHang(string manx, string mah)
{
try {
using (QLCuaHangDataContext cuahang = new QLCuaHangDataContext()) {
//Cập nhật số lượng ở hàng.
ChiTiet c = cuahang.ChiTiets.SingleOrDefault(ct => ct.MaNX == manx && ct.MaHang == mah);
Hang h = cuahang.Hangs.SingleOrDefault(ha => ha.MaHang == c.MaHang);
if (manx.Substring(0, 1) == "N") //Xoá ChiTiet của Nhập.
{
h.GhiChu += "\n Ngày: " + DateTime.Now.ToString("dd/MM/yyyy") + " xoá Chi Tiết phiếu Nhập thay đổi sl: "
+ (h.SoLuong - c.SoLuong) + " => " + h.SoLuong;
h.SoLuong -= c.SoLuong;
}
else // Xoá ChiTiet của Xuất.
{
h.GhiChu += "\n Ngày: " + DateTime.Now.ToString("dd/MM/yyyy") + " xoá Chi Tiết phiếu Xuất thay đổi sl: "
+ (h.SoLuong + c.SoLuong) + " => " + h.SoLuong;
h.SoLuong += c.SoLuong;
}
//Tiến hành xoá chitiet.
cuahang.ChiTiets.DeleteOnSubmit(c);
cuahang.SubmitChanges();
}
}catch (Exception ex) { myme.ShowError(ex); }
}
//=============Xem chi tiết LS====================
public List <ChiTiet> ChiTietLichSu(string id)
{
List <Models.ChiTiet> chitiet = new List <Models.ChiTiet>();
XDocument xmlDoc = XDocument.Load("C:/Users/Administrator/Desktop/KLTN_UDQLKH/KLTN_UDQLKH/KLTN_UDQLKH/Data/LICH_SU.xml");
XDocument xmlDocCT = XDocument.Load("C:/Users/Administrator/Desktop/KLTN_UDQLKH/KLTN_UDQLKH/KLTN_UDQLKH/Data/CT_HOADON.xml");
XDocument xmlDocSP = XDocument.Load("C:/Users/Administrator/Desktop/KLTN_UDQLKH/KLTN_UDQLKH/KLTN_UDQLKH/Data/SAN_PHAM.xml");
var Node = (from ls in xmlDoc.Descendants("lichsu")
join cthd in xmlDocCT.Descendants("chitiet")
on(string) ls.Element("idhoadon") equals(string) cthd.Attribute("idhoadon")
join sp in xmlDocSP.Descendants("sanpham")
on(string) cthd.Attribute("idsp") equals(string) sp.Attribute("id")
where (string)ls.Element("idhoadon").Value == id
select new
{
id = (string)cthd.Attribute("id"),
tensp = (string)sp.Element("tensp"),
dongia = (int)sp.Element("dongia"),
soluongmua = (int)cthd.Element("soluongmua")
}).ToList();
foreach (var i in Node)
{
ChiTiet ct = new ChiTiet();
ct.id = i.id;
ct.tensp = i.tensp;
ct.dongia = i.dongia;
ct.soluongmua = i.soluongmua;
chitiet.Add(ct);
}
return(chitiet);
}
public static bool edit(PhieuNhap phieu)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
PHIEUNHAP px;
px = (from p in db.PHIEUNHAPs
where p.masophieunhap.Equals(phieu.MaSoPhieuNhap)
select p).SingleOrDefault();
if (px == null)
{
return(false);
}
px.masonxb = phieu.MaSoNXB;
px.ngaylap = phieu.NgayLap;
px.nguoigiaosach = phieu.NguoiGiao;
px.trangthai = phieu.TrangThai;
px.tongtien = phieu.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia); // tính tổng tiền các chi tiết
db.CHITIETPHIEUNHAPs.DeleteAllOnSubmit(px.CHITIETPHIEUNHAPs);
db.SubmitChanges();
foreach (ChiTietPhieuNhap ct in phieu.ChiTiet)
{
ct.MaSoPhieuNhap = phieu.MaSoPhieuNhap;
ChiTiet.add(ct);
}
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
public static int add(HoaDonNXB hoadon)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
var hd = new HOADONNXB
{
masonxb = hoadon.MaSoNXB,
ngaylap = hoadon.NgayLap,
tongtien = hoadon.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia),
trangthai = 0
};
db.HOADONNXBs.InsertOnSubmit(hd);
db.SubmitChanges();
foreach (ChiTietHoaDonNXB ct in hoadon.ChiTiet)
{
ChiTiet.add(ct, hd.masohoadon);
}
return(hd.masohoadon);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
public static bool edit(HoaDonNXB hoadon)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
HOADONNXB hd;
hd = (from p in db.HOADONNXBs
where p.masohoadon.Equals(hoadon.MaSoHoaDon)
select p).SingleOrDefault();
if (hd == null)
{
return(false);
}
hd.masonxb = hoadon.MaSoNXB;
hd.ngaylap = hoadon.NgayLap;
hd.trangthai = hoadon.TrangThai;
hd.tongtien = hoadon.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia); // tính tổng tiền các chi tiết
db.CHITIETHOADONNXBs.DeleteAllOnSubmit(hd.CHITIETHOADONNXBs);
db.SubmitChanges();
foreach (ChiTietHoaDonNXB ct in hoadon.ChiTiet)
{
ChiTiet.add(ct, hoadon.MaSoHoaDon);
}
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
public ResultsData <List <Model.ChiTiet> > view_chi_tiet(string id_kho_hang)
{
ResultsData <List <Model.ChiTiet> > results = new ResultsData <List <Model.ChiTiet> >();
try
{
var data = from chitiet in db.tbl_chi_tiet_khos
where chitiet.kh_id == id_kho_hang
join hanghoa in db.tbl_hang_hoas
on chitiet.hh_id equals hanghoa.hh_id
select new
{
ct_id = chitiet.ct_id,
hh_id = hanghoa.hh_id,
hh_ten = hanghoa.hh_ten,
hh_nha_cung_cap = hanghoa.hh_noi_san_xuat,
ngay_cap_nhat = chitiet.ngay_cap_nhat,
ct_soluong = chitiet.ct_so_luong
};
if (data.Count() > 0)
{
List <ChiTiet> list = new List <ChiTiet>();
foreach (var item in data)
{
Model.ChiTiet row = new ChiTiet();
row.ct_id = item.ct_id;
row.hh_id = item.hh_id;
row.hh_ten = item.hh_ten;
row.hh_nha_cung_cap = item.hh_nha_cung_cap;
row.ngay_cap_nhat = item.ngay_cap_nhat;
row.ct_soluong = (double)item.ct_soluong;
Share.Constant.tong_kho_chua += row.ct_soluong;
list.Add(row);
}
results.data = list.ToList();
results.err_desc = Share.Constant.func_rs_success;
results.err_code = ErrorCode.success;
}
else
{
results.data = null;
results.err_desc = Share.Constant.func_rs_empty;
results.err_code = ErrorCode.empty;
Share.Constant.tong_kho_chua = 0;
}
}
catch (Exception ex)
{
results.data = null;
results.err_desc = ex.ToString();
results.err_code = ErrorCode.fail;
Share.Constant.tong_kho_chua = 0;
}
return(results);
}
// POST: odata/ChiTiets
public IHttpActionResult Post(ChiTiet chiTiet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ChiTiets.Add(chiTiet);
db.SaveChanges();
return(Created(chiTiet));
}
public List <ChiTiet> GetDetailPhieuNhapByIdPhieu(int id)
{
List <ChiTiet> cthdlist = new List <ChiTiet>();
string query = "select TENVATTU, DVT, SO_LUONG, PARSENAME(convert(varchar,convert(money,DONGIA),1),2 ) as DONGIA, PARSENAME(convert(varchar,convert(money,THANH_TIEN),1),2 ) as THANH_TIEN from VATTU ,CHITIETPHIEUNHAP where VATTU.ID_VATTU = CHITIETPHIEUNHAP.ID_VATTU and ID_PHIEU = '" + id + "'";
DataTable data = DataProvider.Instance.ExecuteQuery(query, new object[] { id });
foreach (DataRow item in data.Rows)
{
ChiTiet cthd = new ChiTiet(item);
cthdlist.Add(cthd);
}
return(cthdlist);
}
public void DeleteCTWithMaNX(string manx)
{
try
{
using (QLCuaHangDataContext cuahang = new QLCuaHangDataContext())
{
ChiTiet c = cuahang.ChiTiets.SingleOrDefault(ct => ct.MaNX == manx);
cuahang.ChiTiets.DeleteOnSubmit(c);
cuahang.SubmitChanges();
}
}
catch (Exception ex) { myme.ShowError(ex); }
}
// DELETE: odata/ChiTiets(5)
public IHttpActionResult Delete([FromODataUri] int key)
{
ChiTiet chiTiet = db.ChiTiets.Find(key);
if (chiTiet == null)
{
return(NotFound());
}
db.ChiTiets.Remove(chiTiet);
db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
//GetChiTiet
public JsonResult GetChiTiet(string id)
{
using (CoffeeEntities db = new CoffeeEntities())
{
if (id != null)
{
int idHoaDonBanHang;
if (int.TryParse(id, out idHoaDonBanHang))
{
ChiTiet model = new ChiTiet();
model.ChiTietThucDons = db.ORDER_ChiTietHoaDonBanHang.Where(p => p.idHoaDonBanHang == idHoaDonBanHang).ToList();
model.ChiTietNhanViens = db.ORDER_ChiTietNhanVienHoaDonBanHang.Where(p => p.idHoaDonBanHang == idHoaDonBanHang).ToList();
return(Json(model, JsonRequestBehavior.AllowGet));
}
}
return(null);
}
}
public bool addDetail(Sach sach, decimal soluong)
{
var chitiet = new ChiTietPhieuXuat
{
MaSoSach = sach.MaSoSach,
Sach = sach,
SoLuong = soluong,
DonGia = sach.GiaBan
};
foreach (var ct in ChiTiet)
{
if (ct.Equals(chitiet))
{
ct.SoLuong += chitiet.SoLuong;
return(true);
}
}
ChiTiet.Add(chitiet);
return(true);
}
public ActionResult GhiNhan()
{
Ban ban = db.Ban.SingleOrDefault(n => n.MaBan == ThongTin.MaBan);
if (ban.TinhTangBan == 1)
{
return(RedirectToAction("Index", "Ban"));
}
ban.TinhTangBan = 1;
HoaDon hoadon = new HoaDon();
hoadon.TenKH = ThongTin.HoTen;
hoadon.NgayDat = DateTime.Now;
hoadon.TongTien = TongHoaDon.TongTien;
hoadon.SDT = ThongTin.SDT;
hoadon.TinhTrang = 0;
db.HoaDon.Add(hoadon);
db.SaveChanges();
//int MaHoaDon = hoadon.MaHD;
int id = hoadon.MaHD;
List <HoaDonChiTiet> lstHoaDonChiTiet = LayHoaDonChiTiet();
ban.MaHD = hoadon.MaHD;
ban.GhiChu = ThongTin.GhiChu;
db.SaveChanges();
foreach (var item in lstHoaDonChiTiet)
{
ChiTiet chitiet = new ChiTiet();
chitiet.MaMon = item.iMaMon;
chitiet.SoLuong = item.SoLuong;
chitiet.ThanhTien = item.ThanhTien;
chitiet.MaHD = hoadon.MaHD;
db.ChiTiet.Add(chitiet);
db.SaveChanges();
}
Session.RemoveAll();
return(RedirectToAction("Index", "Ban"));
}
// PUT: odata/ChiTiets(5)
public IHttpActionResult Put([FromODataUri] int key, Delta <ChiTiet> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
ChiTiet chiTiet = db.ChiTiets.Find(key);
if (chiTiet == null)
{
return(NotFound());
}
patch.Put(chiTiet);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ChiTietExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(chiTiet));
}
