public static bool addnewHoaDon(QuanLyHomestayEntities db, HOADON hd) { if (hd.NgayDen == null) { return(false); } else if (hd.NgayDen < DateTime.Today) { return(false); } else if (hd.NgayDen > hd.NgayDi) { return(false); } else if (hd.NgayDi == null) { return(false); } else if (hd.MaLoaiPhong == null) { return(false); } else if (hd.MaHoaDon == null) { return(false); } else { db.HOADONs.Add(hd); db.SaveChanges(); return(true); } }
public static bool deletePhong(QuanLyHomestayEntities db, HOADON hd) { db = new QuanLyHomestayEntities(); db.HOADONs.Attach(hd); db.HOADONs.Remove(hd); db.SaveChanges(); return(true); }
private void btnSearch_Click(object sender, EventArgs e) { HOADON hd = (from i in db.HOADONs where i.MaHoaDon == txtFind.Text select i).FirstOrDefault(); Confirm fm = new Confirm(hd, "edit"); if (fm.ShowDialog() == DialogResult.OK) { } }
private void btnDatPhong_Click(object sender, EventArgs e) { HOADON hd = Picked(comboBox2.SelectedValue.ToString(), dateTimePicker1.Value, dateTimePicker2.Value); Confirm fm = new Confirm(hd, "add"); if (dangnhap) { if (fm.ShowDialog() == DialogResult.OK) { } } else { MessageBox.Show("Yêu cầu đăng nhập.", "Cảnh báo!!!", MessageBoxButtons.OK); } }
private HOADON Picked(string MaLoaiPhong, DateTime NgayDen, DateTime NgayDi) { int maso = (from i in db.HOADONs select i).Count(); HOADON hd = new HOADON(); hd.NgayDen = NgayDen; hd.NgayDi = NgayDi; hd.SoTienDatTruoc = 0; PHONG p = (from i in db.PHONGs where MaLoaiPhong == i.MaLoaiPhong select i).FirstOrDefault(); hd.GiaTien = p.GiaPhong.ToString(); hd.MaLoaiPhong = MaLoaiPhong; hd.DonVi = "VND"; hd.MaHoaDon = RandomString(5) + MaLoaiPhong; hd.NgayThanhToan = NgayDi; //hd.StringCode = RandomString(8); return(hd); }
public Confirm(HOADON obj, string status) { InitializeComponent(); db = new QuanLyHomestayEntities(); lOAIPHONGBindingSource.DataSource = db.LOAIPHONGs.ToList(); if (status.Equals("add")) { bindingSource1.DataSource = obj; hd = obj; LOAIPHONG p = (from i in db.LOAIPHONGs where i.MaLoaiPhong == obj.MaLoaiPhong select i).FirstOrDefault(); textBox1.Text = p.TenLoaiPhong; this.status = status; } else if (status.Equals("edit")) { bindingSource1.DataSource = obj; hd = obj; db.HOADONs.Attach(hd); unlock(); this.status = status; } }