Example #1
0
 public int Update(GhiChuDTO Gc)
 {
     string sql = "update GHICHU set MaHoc=@MaHoc,LyDo=@LyDo,ChiTiet=@ChiTiet where MaGC=@MaGC";
     SqlParameter[] sp = new SqlParameter[4];
     sp[0] = new SqlParameter("@MaGC", Gc.MaGC);
     sp[1] = new SqlParameter("@MaHoc", Gc.MaHoc);
     sp[2] = new SqlParameter("@LyDo", Gc.LyDo);
     sp[3] = new SqlParameter("@ChiTiet", Gc.ChiTiet);
     return conectData.Insert_Update_Delete(sql, sp);
 }
Example #2
0
 public int Insert(GhiChuDTO Gc)
 {
     string sql = "insert into GHICHU values (@MaGC,@MaHoc,@LyDo,@ChiTiet)";
     SqlParameter[] sp = new SqlParameter[4];
     sp[0] = new SqlParameter("@MaGC", Gc.MaGC);
     sp[1] = new SqlParameter("@MaHoc", Gc.MaHoc);
     sp[2] = new SqlParameter("@LyDo", Gc.LyDo);
     sp[3] = new SqlParameter("@ChiTiet", Gc.ChiTiet);
     return conectData.Insert_Update_Delete(sql, sp);
 }