public void insert_CongNos(CongNo a)
{
QLVESODataContext db = new QLVESODataContext();
db.CongNos.InsertOnSubmit(a);
db.SubmitChanges();
}
public void insert_Phathanh(PhatHanh a)
{
QLVESODataContext db = new QLVESODataContext();
db.PhatHanhs.InsertOnSubmit(a);
db.SubmitChanges();
}
public void insert_PhieuChi(PhieuChi a)
{
QLVESODataContext db = new QLVESODataContext();
db.PhieuChis.InsertOnSubmit(a);
db.SubmitChanges();
}
public void insert_Daily(DaiLy a)
{
QLVESODataContext db = new QLVESODataContext();
db.DaiLies.InsertOnSubmit(a);
db.SubmitChanges();
}
public void insert_SoLuongDk(SoLuongDK a)
{
QLVESODataContext db = new QLVESODataContext();
db.SoLuongDKs.InsertOnSubmit(a);
db.SubmitChanges();
}
public void delete_PhieuThu(string ma)
{
QLVESODataContext db = new QLVESODataContext();
PhieuThu b = db.PhieuThus.Where(a => a.MaPhieuThu == ma).Single();
db.PhieuThus.DeleteOnSubmit(b);
db.SubmitChanges();
}
public void delete_DaiLy(string Madaily)
{
QLVESODataContext db = new QLVESODataContext();
DaiLy b = db.DaiLies.Where(a => a.MaDaiLy == Madaily).Single();
db.DaiLies.DeleteOnSubmit(b);
db.SubmitChanges();
}
public void delete_CongNos(string macongno)
{
QLVESODataContext db = new QLVESODataContext();
CongNo b = db.CongNos.Where(a => a.MaCongNo == macongno).Single();
db.CongNos.DeleteOnSubmit(b);
db.SubmitChanges();
}
public void delete_Phathanh(string Maphathanh)
{
QLVESODataContext db = new QLVESODataContext();
PhatHanh b = db.PhatHanhs.Where(a => a.MaPhatHanh == Maphathanh).Single();
db.PhatHanhs.DeleteOnSubmit(b);
db.SubmitChanges();
}
public void delete_SoLuongDk(string ID)
{
QLVESODataContext db = new QLVESODataContext();
SoLuongDK b = db.SoLuongDKs.Where(a => a.ID == ID).Single();
db.SoLuongDKs.DeleteOnSubmit(b);
db.SubmitChanges();
}
public void delete_PhieuChi(string ma)
{
QLVESODataContext db = new QLVESODataContext();
PhieuChi b = new PhieuChi();
b = db.PhieuChis.Where(ax => ax.MaPhieuChi == ma).Single();
db.PhieuChis.DeleteOnSubmit(b);
db.SubmitChanges();
}
public void update_SoLuongDk(SoLuongDK a)
{
QLVESODataContext db = new QLVESODataContext();
SoLuongDK b = db.SoLuongDKs.Where(x => x.ID == a.ID).Single();
b.MaLoaiveSo = a.MaLoaiveSo;
b.MaDaiLy = a.MaDaiLy;
b.NgayDK = a.NgayDK;
b.SoLuongDK1 = a.SoLuongDK1;
db.SubmitChanges();
}
public void update_CongNos(CongNo a)
{
QLVESODataContext db = new QLVESODataContext();
CongNo b = db.CongNos.Where(x => x.MaCongNo == a.MaCongNo).Single();
b.MaPhatHanh = a.MaPhatHanh;
b.MaDaiLy = a.MaDaiLy;
b.TongSoTien = a.TongSoTien;
b.SoTienConNo = a.SoTienConNo;
db.SubmitChanges();
}
public void update_PhieuThu(PhieuThu a)
{
QLVESODataContext db = new QLVESODataContext();
PhieuThu b = new PhieuThu();
b = db.PhieuThus.Where(ax => ax.MaPhieuThu == a.MaPhieuThu).Single();
b.MaCongNo = a.MaCongNo;
b.NgayThu = a.NgayThu;
b.SoTienNop = a.SoTienNop;
b.Flag = a.Flag;
db.SubmitChanges();
}
public void update_PhieuChi(PhieuChi a)
{
QLVESODataContext db = new QLVESODataContext();
PhieuChi b = new PhieuChi();
b = db.PhieuChis.Where(ax => ax.MaPhieuChi == a.MaPhieuChi).Single();
b.MaPhatHanh = a.MaPhatHanh;
b.Ngay = a.Ngay;
b.NoiDung = a.NoiDung;
b.SoTien = a.SoTien;
db.SubmitChanges();
}
public void update_Daily(DaiLy a)
{
QLVESODataContext db = new QLVESODataContext();
DaiLy b = db.DaiLies.Where(x => x.MaDaiLy == a.MaDaiLy).Single();
b.TenDaiLy = a.TenDaiLy;
b.SDT = a.SDT;
b.DiaChi = a.DiaChi;
b.flag = a.flag;
db.SubmitChanges();
}
public void update_PhatHanh(PhatHanh a)
{
QLVESODataContext db = new QLVESODataContext();
PhatHanh b = db.PhatHanhs.Where(x => x.MaPhatHanh == a.MaPhatHanh).Single();
b.NgayPhatHanh = a.NgayPhatHanh;
b.SLBan = SL_pp(b.MaPhatHanh) - SL_trave(b.MaPhatHanh);
b.SoLuong = a.SoLuong;
b.DoanhThuDPH = a.DoanhThuDPH;
b.HoaHong = a.HoaHong;
b.TienThanhToan = a.TienThanhToan;
db.SubmitChanges();
}
public int SL_trave(string maphathanh)
{
QLVESODataContext db = new QLVESODataContext();
int SLpp = 0;
var query1 = from p in db.PhanPhois
where p.MaPhatHanh == maphathanh
select p.SoLuongvetra;
if (query1.Count() > 0)
{
SLpp = Convert.ToInt32(query1.Sum());
}
return(SLpp);
}
private void btthem_Click(object sender, EventArgs e)
{
try
{
PhieuChi pc = new PhieuChi();
QLVESODataContext db = new QLVESODataContext();
pc.MaPhieuChi = txtMaPhieuChi.Text;
pc.MaPhatHanh = txtMaPhatHanh.Text;
pc.Ngay = DateTime.Parse(txtNgay.Text);
pc.NoiDung = txtNoiDung.Text;
pc.SoTien = int.Parse(txtSoTien.Text);
busPhieuChi.insert_PhieuChi(pc);
ucPhieuChi_Load(sender, e);
}
catch
{
MessageBox.Show("Yêu cầu nhập đầy đủ dữ liệu");
}
resetForm();
}
private void btnsuaPC_Click(object sender, EventArgs e)
{
try
{
PhieuChi pc = new PhieuChi();
QLVESODataContext db = new QLVESODataContext();
pc = db.PhieuChis.Where(s => s.MaPhieuChi == txtMaPhieuChi.Text).Single();
pc.MaPhieuChi = txtMaPhieuChi.Text;
pc.MaPhatHanh = txtMaPhatHanh.Text;
pc.Ngay = DateTime.Parse(txtNgay.Text);
pc.NoiDung = txtNoiDung.Text;
pc.SoTien = int.Parse(txtSoTien.Text);
busPhieuChi.update_PhieuChi(pc);
ucPhieuChi_Load(sender, e);
}
catch
{
MessageBox.Show("Kiểm tra lại dữ liệu");
}
resetForm();
}
public List <PhieuChi> GetAll()
{
QLVESODataContext db = new QLVESODataContext();
return(db.PhieuChis.ToList());
}
public IEnumerable <CongNo> GetCongNosbyMaDaily(String ma)
{
QLVESODataContext db = new QLVESODataContext();
return(db.CongNos.Where(a => a.MaDaiLy == ma).ToList());
}
public List <PhatHanh> GetAll()
{
QLVESODataContext db = new QLVESODataContext();
return(db.PhatHanhs.ToList());
}
public IEnumerable <String> getTenDaily()
{
QLVESODataContext db = new QLVESODataContext();
return(db.DaiLies.AsEnumerable().Select(s => s.MaDaiLy));
}
public DaiLy GetByMa(String ma)
{
QLVESODataContext db = new QLVESODataContext();
return(db.DaiLies.Where(a => a.MaDaiLy == ma).SingleOrDefault());
}
// QLVESODataContext db = new QLVESODataContext();
public List <DaiLy> GetAll()
{
QLVESODataContext db = new QLVESODataContext();
return(db.DaiLies.ToList());
}
public List <PhanPhoi> GetAll_PhanPhoi()
{
QLVESODataContext db = new QLVESODataContext();
return(db.PhanPhois.ToList());
}
public IEnumerable <String> get_MaPhatHanh()
{
QLVESODataContext db = new QLVESODataContext();
return(db.PhatHanhs.AsEnumerable().Select(s => s.MaPhatHanh));
}
public PhieuChi GetByMa(String ma)
{
QLVESODataContext db = new QLVESODataContext();
return(db.PhieuChis.Where(a => a.MaPhieuChi == ma).SingleOrDefault());
}
public IEnumerable <String> get_Maveso()
{
QLVESODataContext db = new QLVESODataContext();
return(db.LoaiVesos.AsEnumerable().Select(s => s.MaLoaiVeSo));
}
