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); }