public GiayNhanConNuoi findById(string id)
{
try
{
string sqlString = "select * from GiayNhanConNuois where MaGiayNhanConNuoi = " + id + "";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
GiayNhanConNuoi gncn = new GiayNhanConNuoi()
{
MaGiayNhanConNuoi = (string)ds.Tables[0].Rows[0].ItemArray[0],
MaQuyen = (string)ds.Tables[0].Rows[0].ItemArray[1],
MaCD_Cha = (string)ds.Tables[0].Rows[0].ItemArray[2],
//Cha = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[2]),
MaCD_Me = (string)ds.Tables[0].Rows[0].ItemArray[3],
//Me = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[3]),
MaCD_Con = (string)ds.Tables[0].Rows[0].ItemArray[4],
//Con = ketNoiCongDan.findById((string)ds.Tables[0].Rows[0].ItemArray[4]),
NoiDangKi = (string)ds.Tables[0].Rows[0].ItemArray[5],
NgayDangKi = (DateTime)ds.Tables[0].Rows[0].ItemArray[6],
GhiChu = (string)ds.Tables[0].Rows[0].ItemArray[7]
};
return(gncn);
}
catch (Exception e)
{
MessageBox.Show("Lỗi findById GiayNhanConNuoi + " + e.Message);
return(null);
}
}
public bool create(GiayNhanConNuoi entity)
{
try
{
string sqlString = "INSERT INTO GiayNhanConNuois VALUES ('" + entity.MaGiayNhanConNuoi + "','" + entity.MaQuyen + "','" + entity.MaCD_Cha + "','" + entity.MaCD_Me + "','" + entity.MaCD_Con + "',N'" + entity.NoiDangKi + "','" + entity.NgayDangKi.ToShortDateString() + "',N'" + entity.GhiChu + "')";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text));
}
catch (Exception e)
{
MessageBox.Show("Lỗi create GiayNhanConNuoi + " + e.Message);
return(false);
}
}
public string layMa()
{
GiayNhanConNuoi giayNhanConNuoi = nhanConNuoiDAO.getLast();
if (giayNhanConNuoi == null)
{
return("001");
}
else
{
string temp = giayNhanConNuoi.MaGiayNhanConNuoi;
return((int.Parse(temp) + 1) < 10 ? "00" + (int.Parse(temp) + 1) : ((int.Parse(temp) + 1) < 100 ? "0" + (int.Parse(temp) + 1) : "" + (int.Parse(temp) + 1)));
}
}
public List <GiayNhanConNuoi> getAll()
{
try
{
string sqlString = "select * from GiayNhanConNuois ";
DataSet ds = db.ExecuteQueryDataSet(sqlString, CommandType.Text);
DataTable dt = ds.Tables[0];
List <GiayNhanConNuoi> giayNhanConNuois = new List <GiayNhanConNuoi>();
foreach (DataRow dr in dt.Rows)
{
GiayNhanConNuoi gncn = findById((string)dr.ItemArray[0]);
giayNhanConNuois.Add(gncn);
}
return(giayNhanConNuois);
}
catch (Exception e)
{
MessageBox.Show("Lỗi getAll GiayNhanConNuoi + " + e.Message);
return(null);
}
}
public bool edit(GiayNhanConNuoi enitity)
{
try
{
string sqlString = " UPDATE GiayNhanConNuois " +
" SET MaGiayNhanConNuoi = '" + enitity.MaGiayNhanConNuoi + "'" +
",MaQuyen = '" + enitity.MaQuyen + "'" +
",MaCD_Cha = '" + enitity.MaCD_Cha + "'" +
",MaCD_Me = N'" + enitity.MaCD_Me + "'" +
",MaCD_Con = '" + enitity.MaCD_Con + "'" +
",NoiDangKi = N'" + enitity.NoiDangKi + "'" +
",NgayDangKi = '" + enitity.NgayDangKi.ToShortDateString() + "'" +
",GhiChu = N'" + enitity.GhiChu + "'" +
"WHERE MaGiayNhanConNuoi = '" + enitity.MaGiayNhanConNuoi + "'";
return(db.MyExecuteNonQuery(sqlString, CommandType.Text));
}
catch (Exception e)
{
MessageBox.Show("Lỗi Edit GiayNhanConNuoi!!! + " + e.Message);
return(false);
}
}
public bool taoGiayNhanConNuoi(string so, string quyen, CongDan cha, CongDan me, CongDan con, string noiDK, DateTime ngayDK, string ghiChu)
{
GiayNhanConNuoi giayNhanConNuoi = new GiayNhanConNuoi();
if (me == null)
{
giayNhanConNuoi = new GiayNhanConNuoi(so, quyen, cha.MaCD, null, con.MaCD, noiDK, ngayDK, ghiChu);
}
if (cha == null)
{
giayNhanConNuoi = new GiayNhanConNuoi(so, quyen, null, me.MaCD, con.MaCD, noiDK, ngayDK, ghiChu);
}
if (cha != null && me != null)
{
giayNhanConNuoi = new GiayNhanConNuoi(so, quyen, cha.MaCD, me.MaCD, con.MaCD, noiDK, ngayDK, ghiChu);
}
if (nhanConNuoiDAO.create(giayNhanConNuoi))
{
MessageBox.Show("Tạo giấy nhận con nuôi thành công");
return(true);
}
MessageBox.Show("Tạo giấy nhận con nuôi thất bại");
return(false);
}
