public bool create(GiayDangKiKetHon entity)
{
try
{
string sqlString = "INSERT INTO GiayDangKiKetHons VALUES ('" + entity.MaGDKKetHon + "','" + entity.MaQuyen + "','" + entity.MaCD_Chong + "','" + entity.MaCD_Vo + "','" + entity.NgayDangKi.ToShortDateString() + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text));
}
catch (Exception e)
{
MessageBox.Show("Lỗi create KetHon + " + e.Message);
return(false);
}
}
public bool edit(GiayDangKiKetHon enitity)
{
try
{
string sqlString = " UPDATE GiayDangKiKetHons " +
" SET MaGDKKetHon = '" + enitity.MaGDKKetHon + "'" +
",MaQuyen = '" + enitity.MaQuyen + "'" +
",MaCD_Chong = '" + enitity.MaCD_Chong + "'" +
",MaCD_Vo = '" + enitity.MaCD_Vo + "'" +
",NgayDangKi = '" + enitity.NgayDangKi.ToShortDateString() + "' " +
"WHERE MaGDKKetHon = '" + enitity.MaGDKKetHon + "'";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text));
}
catch (Exception e)
{
MessageBox.Show("Lỗi edit KetHon + " + e.Message);
return(false);
}
}
public bool create(string so, string maQuyen, CongDan chong, CongDan vo, DateTime ngayDK)
{
GiayDangKiKetHon giayDangKiKetHon = new GiayDangKiKetHon(so, maQuyen, chong, vo, ngayDK);
if (ketHonDAO.create(giayDangKiKetHon))
{
if (!congDanController.chuyenTrangThaiKetHon(chong.MaCD, so))
{
//MessageBox.Show("Chuyển trạng thái Chồng thất bại");
return(false);
}
if (!congDanController.chuyenTrangThaiKetHon(vo.MaCD, so))
{
//MessageBox.Show("Chuyển trạng thái Vợ thất bại");
return(false);
}
return(true);
}
return(false);
}
private void Form3_Load(object sender, EventArgs e)
{
txtCMNDChong_Search.Select();
GiayDangKiKetHon last = ketHonController.ketHonDAO.getLast();
if (last == null)
{
txtSoQL.Text = "001";
txtSoQuyen.Text = "GKH" + DateTime.Now.Year + "-" + (DateTime.Now.Month > 9 ? "" + DateTime.Now.Month : "0" + DateTime.Now.Month);
txtSoQL.Enabled = false;
txtSoQuyen.Enabled = false;
}
else
{
string temp = last.MaQuyen.Substring(8, 2);
txtSoQL.Text = (int.Parse(last.MaGDKKetHon) + 1) < 10 ? "00" + (int.Parse(last.MaGDKKetHon) + 1) : ((int.Parse(last.MaGDKKetHon) + 1) < 100 ? "0" + (int.Parse(last.MaGDKKetHon) + 1) : "" + (int.Parse(last.MaGDKKetHon) + 1));
txtSoQuyen.Text = "GKH" + DateTime.Now.Year + "-" + (DateTime.Now.Month > 9 ? "" + DateTime.Now.Month : "0" + DateTime.Now.Month);
txtSoQL.Enabled = false;
txtSoQuyen.Enabled = false;
}
}
public GiayDangKiKetHon getLast()
{
try
{
string sqlString = "select * from GiayDangKiKetHons ";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
DataTable dt = ds.Tables[0];
List <GiayDangKiKetHon> giayDangKiKetHons = new List <GiayDangKiKetHon>();
foreach (DataRow dr in dt.Rows)
{
GiayDangKiKetHon gdkkh = findById((string)dr.ItemArray[0]);
giayDangKiKetHons.Add(gdkkh);
}
return(giayDangKiKetHons.LastOrDefault());
}
catch (Exception e)
{
MessageBox.Show("Lỗi getLast KetHon+ " + e.Message);
return(null);
}
}
public GiayDangKiKetHon findById(string id)
{
try
{
string sqlString = "select * from GiayDangKiKetHons where MaGDKKetHon = " + id + "";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
GiayDangKiKetHon gdkkh = new GiayDangKiKetHon()
{
MaGDKKetHon = (string)ds.Tables[0].Rows[0].ItemArray[0],
MaQuyen = (string)ds.Tables[0].Rows[0].ItemArray[1],
MaCD_Chong = (string)ds.Tables[0].Rows[0].ItemArray[2],
//Chong = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[2]),
MaCD_Vo = (string)ds.Tables[0].Rows[0].ItemArray[3],
//Vo = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[3]),
NgayDangKi = (DateTime)ds.Tables[0].Rows[0].ItemArray[4],
};
return(gdkkh);
}
catch (Exception e)
{
MessageBox.Show("Lỗi findById KetHon + " + e.Message);
return(null);
}
}
