public bool SuaKiemDuyetDiaOc(DiaOcDTO diaOcDTO)
{
try
{
OpenConnect();
string store = "sp_DiaOc_SuaKiemDuyet";
sqlCommand = new SqlCommand(store, connect);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(new SqlParameter("@madiaoc", diaOcDTO.MaDiaOc));
sqlCommand.Parameters.Add(new SqlParameter("@trangthaikiemduyet", diaOcDTO.TrangThaiKiemDuyet));
sqlCommand.Parameters.Add(new SqlParameter("@lydokhongduyet", diaOcDTO.LyDoKhongDuyet));
sqlCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
finally
{
CloseConnect();
}
}
private void dgvDiaOc_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
try
{
DataGridViewRow row = dgvDiaOc.Rows[e.RowIndex];
int columnIndex = dgvDiaOc.CurrentCell.ColumnIndex;
string columnName = dgvDiaOc.Columns[columnIndex].Name;
int maPhieuDO = Int32.Parse(row.Cells["MaDiaOcDO"].Value.ToString());
if (columnName.Equals("ChiTietDO"))
{
DiaLogDiaOc diaLogDiaOc = new DiaLogDiaOc(maPhieuDO);
diaLogDiaOc.StartPosition = FormStartPosition.CenterScreen;
diaLogDiaOc.ShowDialog(this);
}
if (columnName.Equals("XacNhanDO"))
{
int trangThai = 0;
if (row.Cells["TrangThaiKiemDuyetDO"].Value.ToString().Equals("1"))
{
trangThai = 1;
}
string lyDo = "";
if (trangThai == 0)
{
lyDo = row.Cells["LyDoKhongDuyetDO"].Value.ToString();
}
DiaOcDTO diaOcDTO = new DiaOcDTO(maPhieuDO, trangThai, lyDo);
try
{
if (diaOcBLL.SuaKiemDuyetDiaOc(diaOcDTO))
{
MessageBox.Show("Sửa trạng thái địa ốc thành công");
LoadDiaOc();
}
else
{
MessageBox.Show("Sửa trạng thái địa ốc thất bại");
}
}
catch
{
}
}
}
catch { }
}
}
public bool SuaDiaOc(DiaOcDTO diaOcDTO)
{
try
{
OpenConnect();
string store = "sp_DiaOc_Sua";
sqlCommand = new SqlCommand(store, connect);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(new SqlParameter("@madiaoc", diaOcDTO.MaDiaOc));
sqlCommand.Parameters.Add(new SqlParameter("@makhachhang", diaOcDTO.MaKhachHang));
sqlCommand.Parameters.Add(new SqlParameter("@maloaidiaoc", diaOcDTO.MaLoaiDiaOc));
sqlCommand.Parameters.Add(new SqlParameter("@maloainha", diaOcDTO.MaLoaiNha));
sqlCommand.Parameters.Add(new SqlParameter("@diachi", diaOcDTO.DiaChi));
sqlCommand.Parameters.Add(new SqlParameter("@dientichkhuonvien", diaOcDTO.DienTichKhuonVien));
sqlCommand.Parameters.Add(new SqlParameter("@dientichsudung", diaOcDTO.DienTichSuDung));
sqlCommand.Parameters.Add(new SqlParameter("@huongnha", diaOcDTO.HuongNha));
sqlCommand.Parameters.Add(new SqlParameter("@chieudaidat", diaOcDTO.ChieuDaiDat));
sqlCommand.Parameters.Add(new SqlParameter("@chieurongdat", diaOcDTO.ChieuRongDat));
sqlCommand.Parameters.Add(new SqlParameter("@chieudainha", diaOcDTO.ChieuDaiNha));
sqlCommand.Parameters.Add(new SqlParameter("@chieurongnha", diaOcDTO.ChieuRongNha));
sqlCommand.Parameters.Add(new SqlParameter("@sotang", diaOcDTO.SoTang));
sqlCommand.Parameters.Add(new SqlParameter("@motachitiet", diaOcDTO.MoTaChiTiet));
sqlCommand.Parameters.Add(new SqlParameter("@giaban", diaOcDTO.GiaBan));
sqlCommand.Parameters.Add(new SqlParameter("@trangthaikiemduyet", diaOcDTO.TrangThaiKiemDuyet));
sqlCommand.Parameters.Add(new SqlParameter("@trangthaimuaban", diaOcDTO.TrangThaiMuaBan));
sqlCommand.Parameters.Add(new SqlParameter("@lydokhongduyet", diaOcDTO.LyDoKhongDuyet));
sqlCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
finally
{
CloseConnect();
}
}
public bool SuaKiemDuyetDiaOc(DiaOcDTO diaOcDTO)
{
return(diaOcDAL.SuaKiemDuyetDiaOc(diaOcDTO));
}
public bool SuaDiaOc(DiaOcDTO diaOcDTO)
{
return(diaOcDAL.SuaDiaOc(diaOcDTO));
}
public bool ThemDiaOc(DiaOcDTO diaOcDTO)
{
return(diaOcDAL.ThemDiaOc(diaOcDTO));
}
private void btnThem_Click(object sender, EventArgs e)
{
if (KiemTraThongTinTrong())
{
MessageBox.Show("Làm ơn điền đầy đủ thông tin địa ốc");
}
else
{
if (KiemTraThongTinHopLe())
{
int trangThaiMuaBan = 0;
int trangThaiKiemDuyet = 0;
if (rbDaKiemDuyet.Checked)
{
trangThaiKiemDuyet = 1;
}
if (chkTrangThaiMuaBan.Checked)
{
trangThaiMuaBan = 1;
}
int maKH = 0;
if (MaKhachHangPoup == 0)
{
maKH = Int32.Parse(cbKhachHang.SelectedValue.ToString());
}
else
{
maKH = MaKhachHangPoup;
}
DiaOcDTO diaOcDTO = new DiaOcDTO(
maKH,
Int32.Parse(cbLoaiDiaOc.SelectedValue.ToString()),
Int32.Parse(cbLoaiNha.SelectedValue.ToString()),
txtDiaChi.Text.ToString(),
Double.Parse(txtDienTichKhuonVien.Text.ToString()),
Double.Parse(txtDienTichSuDung.Text.ToString()),
txtHuongNha.Text.ToString(),
Double.Parse(txtChieuDaiDat.Text.ToString()),
Double.Parse(txtChieuRongDat.Text.ToString()),
Double.Parse(txtChieuDaiNha.Text.ToString()),
Double.Parse(txtChieuRongNha.Text.ToString()),
Int32.Parse(txtSoTang.Text.ToString()),
txtMoTaChiTiet.Text.ToString(),
Double.Parse(txtGiaBan.Text.ToString()),
trangThaiKiemDuyet, trangThaiMuaBan, "");
try
{
if (diaOcBLL.ThemDiaOc(diaOcDTO))
{
MessageBox.Show("Thêm địa ốc thành công");
if (MaKhachHangPoup == 0)
{
dgvDiaOc.DataSource = diaOcBLL.LayDanhSachDiaOcTheoTenLoai();
}
else
{
dgvDiaOc.DataSource = diaOcBLL.LayDanhSachDiaOcTheoMaKH(MaKhachHangPoup);
}
}
else
{
MessageBox.Show("Thêm địa ốc thất bại");
}
}
catch
{
}
}
}
}
