public bool InsertOrUpdateQuan(QUAN[] quans) { try { using (QLDLEntities db = new QLDLEntities()) { foreach (QUAN quan in quans) { if (quan.MAQUAN == 0) { QUAN item = new QUAN() { TENQUAN = quan.TENQUAN, SODLTOIDA = quan.SODLTOIDA }; db.QUANs.Add(item); } else { QUAN item = db.QUANs.FirstOrDefault(x => x.MAQUAN == quan.MAQUAN); item.TENQUAN = quan.TENQUAN; item.SODLTOIDA = quan.SODLTOIDA; } } db.SaveChanges(); } return(true); } catch { return(false); } }
public int?InsertDaiLy(string tendl, string diachi, string dienthoai, int maquan, int loaidl) { try { using (QLDLEntities context = new QLDLEntities()) { DAILY dl = new DAILY { TENDL = tendl, DIACHI = diachi, DIENTHOAI = dienthoai, NGAYTIEPNHAN = DateTime.Now, MAQUAN = maquan, LOAIDL = loaidl, TINHTRANG = 1, // 1: đang hoạt động, 0: đã dẹp tiệm SONO = 0 }; context.DAILies.Add(dl); context.SaveChanges(); return(dl.MADL); } } catch { return(null); } }
public bool InsertOrUpdateMatHang(MATHANG[] mathangs) { try { using (QLDLEntities db = new QLDLEntities()) { foreach (MATHANG mathang in mathangs) { if (mathang.MAHANG == 0) { MATHANG item = new MATHANG() { TENHANG = mathang.TENHANG, DONGIA = mathang.DONGIA, MADVT = mathang.MADVT, }; db.MATHANGs.Add(item); } else { MATHANG item = db.MATHANGs.FirstOrDefault(x => x.MAHANG == mathang.MAHANG); item.TENHANG = mathang.TENHANG; item.DONGIA = mathang.DONGIA; item.MADVT = mathang.MADVT; } } db.SaveChanges(); } return(true); } catch { return(false); } }
public bool InsertOrUpdateDonViTinh(DVT[] DVTs) { try { using (QLDLEntities db = new QLDLEntities()) { foreach (DVT dvt in DVTs) { if (dvt.MADVT == 0) { DVT item = new DVT() { DVT1 = dvt.DVT1 }; db.DVTs.Add(item); } else { DVT item = db.DVTs.FirstOrDefault(x => x.MADVT == dvt.MADVT); item.DVT1 = dvt.DVT1; } } db.SaveChanges(); } return(true); } catch { return(false); } }
public bool InsertOrUpdateLoaiDL(LOAIDL[] loaiDLs) { try { using (QLDLEntities db = new QLDLEntities()) { foreach (LOAIDL loaiDL in loaiDLs) { if (loaiDL.MALOAI == 0) { LOAIDL item = new LOAIDL() { TENLOAI = loaiDL.TENLOAI, SONOTOIDA = loaiDL.SONOTOIDA }; db.LOAIDLs.Add(item); } else { LOAIDL item = db.LOAIDLs.FirstOrDefault(x => x.MALOAI == loaiDL.MALOAI); item.TENLOAI = loaiDL.TENLOAI; item.SONOTOIDA = loaiDL.SONOTOIDA; } } db.SaveChanges(); } return(true); } catch { return(false); } }
public int?AddNhanVien_TaiKhoan(NHANVIEN nhanvien, TAIKHOAN taikhoan) { try { using (QLDLEntities db = new QLDLEntities()) { db.NHANVIENs.Add(nhanvien); db.SaveChanges(); taikhoan.MANV = nhanvien.MANV; db.TAIKHOANs.Add(taikhoan); db.SaveChanges(); return(nhanvien.MANV); } } catch (Exception e) { System.Console.Out.WriteLine(e.ToString()); return(null); } }
public bool InsertPhieuXuat(CTPX[] arr_ctpx, PHIEUXUATHANG pxh) { try { using (QLDLEntities context = new QLDLEntities()) { // do EF ko hỗ trợ auto increase primary key khi bị chiếu tới nên dùng thủ công context.Database.ExecuteSqlCommand("insert into phieuxuathang(madl,ngaylap,tongtien,sotientra,conlai,nguoixuat) values({0},{1},{2},{3},{4},{5});", pxh.MADL, DateTime.Now, pxh.TONGTIEN, pxh.SOTIENTRA, pxh.CONLAI, pxh.NGUOIXUAT); DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == pxh.MADL); daily.SONO += (pxh.TONGTIEN - pxh.SOTIENTRA); context.SaveChanges(); /// lấy mã phiếu cuối cùng (dòng mới vừa nhập) nếu hệ thống chạy song song là tạch :(( int value = int.Parse(context.PHIEUXUATHANGs .OrderByDescending(p => p.MAPHIEU) .Select(r => r.MAPHIEU) .First().ToString()); // tạo các chi tiết phiếu xuất foreach (CTPX ct in arr_ctpx) { ct.MAPHIEU = value; context.CTPXes.Add(ct); } context.SaveChanges(); return(true); } } catch (Exception e) { Console.WriteLine("---------------------------------------------------------"); Console.WriteLine("{0}", e); return(false); } }
public bool RemoveDaiLy(int madl) { try { using (QLDLEntities context = new QLDLEntities()) { DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == madl); context.DAILies.Remove(daily); context.SaveChanges(); return(true); } } catch { return(false); } }
public bool InsertPhieuThu(PHIEUTHUTIEN pt) { try { using (QLDLEntities context = new QLDLEntities()) { DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == pt.MADL); daily.SONO -= pt.SOTIEN; context.PHIEUTHUTIENs.Add(pt); context.SaveChanges(); return(true); } } catch { return(false); } }
public bool UpdateNhanVien(vwCHUCVU_NHANVIEN_TAIKHOAN nhanvien) { try { using (QLDLEntities db = new QLDLEntities()) { NHANVIEN nv = db.NHANVIENs.Where(p => p.MANV == nhanvien.MANV).Single(); nv.TENNV = nhanvien.TENNV.Length > 10 ? nhanvien.TENNV.Substring(0, 10) : nhanvien.TENNV; nv.NGAYSINH = nhanvien.NGAYSINH; nv.DIACHI = nhanvien.DIACHI.Length > 50 ? nhanvien.DIACHI.Substring(0, 50) : nhanvien.DIACHI; //.Substring(0, 50); nv.MACHUCVU = nhanvien.MACHUCVU; db.SaveChanges(); return(true); } } catch (Exception e) { System.Console.Out.WriteLine(e.ToString()); return(false); } }
public bool UpdateDaiLy(int madl, string tendl, string diachi, string dienthoai, int maquan, int loaidl) { try { using (QLDLEntities context = new QLDLEntities()) { DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == madl); daily.TENDL = tendl; daily.DIACHI = diachi; daily.DIENTHOAI = dienthoai; daily.MAQUAN = maquan; daily.LOAIDL = loaidl; context.SaveChanges(); return(true); } } catch (Exception e) { System.Console.Out.WriteLine(e.ToString()); return(false); } }