public hopdong GetHopdongDavao(int macanho)
{
CSDL db = new CSDL();
hopdong l1 = db.hopdongs.Where(p => p.macanho == macanho && p.dahuy == false && p.davao == true).FirstOrDefault();
return(l1);
}
private void btOk_Click(object sender, EventArgs e)
{
if (Check() == true)
{
try
{
hopdong a = new hopdong();
a.mahopdong = Convert.ToInt32(txtMaHD.Text);
a.manhanvien = ((CBBItem)cbbMaNHv.SelectedItem).Value;
a.macanho = Convert.ToInt32(cbbMaCanHo.SelectedItem);
a.maho = Convert.ToInt32(((CBBItem)cbbHogiadinh.SelectedItem).Value);
a.tenhopdong = txtTenHD.Text;
a.giatien = Convert.ToDouble(txtGiaTien.Text);
a.thoihan = txtThoiHan.Text;
a.ngayki = dateTimePicker1.Value;
a.dahuy = false;
BLL.BLL_HD.Instance().AddorUpdate(a);
d();
this.Close();
}
catch (Exception t)
{
}
}
else
{
MessageBox.Show("sai Format or trung MaHD ");
this.Close();
}
}
private void tbs_save_Click(object sender, EventArgs e)
{
if (txtmahd.Text == "")
{
MessageBox.Show("Chưa chọn thông tin");
return;
}
hopdong hd = new hopdong();
hd.mahd = txtmahd.Text;
hd.loaihd = txtloaihd.Text;
hd.manv = cbbmanv.SelectedValue.ToString();
hd.tungay = datetungay.Value;
hd.denngay = datedenngay.Value;
hd.ngaykikethd = datengaykikethd.Value;
if (MessageBox.Show(string.Format("Thêm hợp đồng"), "", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (Bus.InsertProfile(hd) > 0)
{
MessageBox.Show("Đã Thêm");
Hopdong_Load(sender, e);
}
else
{
MessageBox.Show("Mã hợp đồng đã tồn tại");
}
}
}
public static int DeleteProfile(hopdong hd)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@mahd", hd.mahd),
};
return(DataProvider.ExcuteNonQuerry("xoahd", para));
}
public hopdong GetHDdetail(int id)
{
if (db.hopdongs.Where(p => p.mahopdong.Equals(id)).Select(p => p).FirstOrDefault() != null)
{
var l1 = db.hopdongs.Where(p => p.mahopdong.Equals(id)).Select(p => p).FirstOrDefault();
hopdong a = (hopdong)l1;
return(a);
}
return(null);
}
public List <hopdong> Sort(string properties)
{
List <hopdong> data = new List <hopdong>();
// data = db.hopdongs.Select(p => p).ToList<hopdong>();
data = GetAllHD();
if (properties.Equals("Name"))
{
for (int i = 0; i < data.Count - 1; i++)
{
for (int j = i + 1; j < data.Count; j++)
{
if (string.Compare(data[i].tenhopdong, data[j].tenhopdong, false) > 0)
{
hopdong temp = data[i];
data[i] = data[j];
data[j] = temp;
}
}
}
}
if (properties.Equals("ThoiHan"))
{
for (int i = 0; i < data.Count - 1; i++)
{
for (int j = i + 1; j < data.Count; j++)
{
if (Convert.ToInt32(data[i].thoihan) > Convert.ToInt32(data[j].thoihan))
{
hopdong temp = data[i];
data[i] = data[j];
data[j] = temp;
}
}
}
}
if (properties.Equals("GiaTien"))
{
for (int i = 0; i < data.Count - 1; i++)
{
for (int j = i + 1; j < data.Count; j++)
{
if (Convert.ToDouble(data[i].giatien) > Convert.ToDouble(data[j].giatien))
{
hopdong temp = data[i];
data[i] = data[j];
data[j] = temp;
}
}
}
}
return(data);
}
public static int UpdateProfile(hopdong hd)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@mahd", hd.mahd),
new SqlParameter("@loaihd", hd.loaihd),
new SqlParameter("@manv", hd.manv),
new SqlParameter("@tungay", hd.tungay),
new SqlParameter("@denngay", hd.denngay),
new SqlParameter("@ngaykikethd", hd.ngaykikethd),
};
return(DataProvider.ExcuteNonQuerry("suahd", para));
}
public void SetGUI(int MAHD)
{
if (MAHD != 0)
{
hopdong a = BLL.BLL_HD.Instance().GetHDdetail(MAHD);
txtMaHD.Text = (a.mahopdong).ToString();
txtMaHD.Enabled = false;
txtTenHD.Text = a.tenhopdong.ToString();
txtThoiHan.Text = a.thoihan.ToString();
txtGiaTien.Text = a.giatien.ToString();
txtThoiHan.Text = a.thoihan.ToString();
dateTimePicker1.Value = a.ngayki;
}
}
private void SetGUI(int macanho)
{
cb_nguoidoi.Items.Clear();
pnl_canho.Tag = macanho;
canho ch = CanhoBLL.Instance.GetCanhoByMacanho(macanho);
hopdong hd = HopdongBLL.Instance.GetHopdongDavao(macanho);
List <hopdong> Listhd = HopdongBLL.Instance.GetListHopdongChuavao(macanho);
lb_infomacanho.Text = ch.macanho.ToString();
lb_infoloaicanho.Text = ch.loaicanho.ToString();
if (hd == null)
{
lb_infonguoithue.Text = "Chưa có";
lb_infothoigian.Text = "Trống";
btn_huy.Enabled = false;
btn_tieptheo.Enabled = true;
if (Listhd.Count == 0)
{
lb_infotrangthai.Text = "Trống";
lb_songuoidoi.Text = "Còn 0 chủ hộ đang đợi: ";
}
else
{
lb_infotrangthai.Text = "Đang đợi";
lb_songuoidoi.Text = "Còn " + Listhd.Count + " chủ hộ đang đợi: ";
foreach (hopdong i in Listhd)
{
cb_nguoidoi.Items.Add(new CBBHopdong {
Value = i.mahopdong, Text = i.hogiadinh.tenchuho.ToString()
});
}
}
}
else
{
lb_infonguoithue.Text = hd.hogiadinh.tenchuho;
lb_infotrangthai.Text = "Đã thuê";
lb_infothoigian.Text = hd.thoihan + " tháng";
lb_songuoidoi.Text = "Còn " + Listhd.Count + " chủ hộ đang đợi: ";
foreach (hopdong i in Listhd)
{
cb_nguoidoi.Items.Add(new CBBHopdong {
Value = i.mahopdong, Text = i.hogiadinh.tenchuho.ToString()
});
}
btn_huy.Enabled = true;
btn_tieptheo.Enabled = false;
}
}
public bool HuyHopdong(int mahopdong)
{
try
{
CSDL db = new CSDL();
hopdong l1 = db.hopdongs.Where(p => p.mahopdong == mahopdong).FirstOrDefault();
l1.dahuy = true;
l1.canho.maho = null;
db.SaveChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool NhanHopDongTiepTheo(int mahopdong)
{
try
{
CSDL db = new CSDL();
hopdong l1 = db.hopdongs.Where(p => p.mahopdong == mahopdong).FirstOrDefault();
l1.canho.maho = l1.maho;
l1.davao = true;
l1.thoigianconlai = l1.thoihan;
db.SaveChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public void AddorUpdate(hopdong a)
{
if (db.hopdongs.Where(p => p.mahopdong.Equals(a.mahopdong)).Select(p => p).FirstOrDefault() != null)
{
var l1 = db.hopdongs.Where(p => p.mahopdong.Equals(a.mahopdong)).Select(p => p).FirstOrDefault();
l1.mahopdong = a.mahopdong;
l1.maho = a.maho;
l1.macanho = a.macanho;
l1.giatien = a.giatien;
l1.thoihan = a.thoihan;
l1.manhanvien = a.manhanvien;
l1.ngayki = a.ngayki;
l1.dahuy = a.dahuy;
l1.tenhopdong = a.tenhopdong;
db.SaveChanges();
}
else
{
db.hopdongs.Add(a);
db.SaveChanges();
}
}
public static int DeleteProfile(hopdong hd)
{
return(Dao.DeleteProfile(hd));
}
public static int UpdateProfile(hopdong hd)
{
return(Dao.UpdateProfile(hd));
}
public static int InsertProfile(hopdong hd)
{
return(Dao.InsertProfile(hd));
}
