public void updateModel(tblDocGiaModel docGia)
{
// sql = "Update tblDocGia set HOTEN=N'" + docGia.HoTen + "',NGAYSINH='" + docGia.NgaySinh + "',GIOITINH=N'" + docGia.GioiTinh + "',LOP='" + docGia.Lop + "',DIACHI=N'" + docGia.DiaChi + "',EMAIL='" + docGia.Email + "',GHICHU=N'" + docGia.GhiChu + "' where MADG='" + docGia.MaDocGia + "'";
//connectSer.ThucThiSQLTheoPhiKetNoi(sql);
sqlCom = new SqlCommand();
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.CommandText = "USP_UpdateDocGia";
sqlCom.Parameters.Add("@MADG", SqlDbType.VarChar).Value = docGia.MaDocGia;
sqlCom.Parameters.Add("@HOTEN", SqlDbType.NVarChar).Value = docGia.HoTen;
sqlCom.Parameters.Add("@NGAYSINH", SqlDbType.VarChar).Value = docGia.NgaySinh;
sqlCom.Parameters.Add("@GIOITINH", SqlDbType.NVarChar).Value = docGia.GioiTinh;
sqlCom.Parameters.Add("@LOP", SqlDbType.VarChar).Value = docGia.Lop;
sqlCom.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = docGia.DiaChi;
sqlCom.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = docGia.Email;
sqlCom.Parameters.Add("@GHICHU", SqlDbType.NVarChar).Value = docGia.GhiChu;
sqlCom.Connection = connectSer.Connect();
sqlCom.ExecuteNonQuery();
}
public void createModel(tblDocGiaModel docGia)
{
//string sql = "Insert Into tblDocGia(MADG,HOTEN,NGAYSINH,GIOITINH,LOP,DIACHI,EMAIL,GHICHU) values ('" + docGia.MaDocGia + "',N'" + docGia.HoTen + "','" + docGia.NgaySinh + "',N'" + docGia.GioiTinh + "','" + docGia.Lop + "',N'" + docGia.DiaChi + "','" + docGia.Email + "',N'" + docGia.GhiChu + "')";
//connectSer.ThucThiSQLTheoPhiKetNoi(sql);
sqlCom = new SqlCommand();
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.CommandText = "USP_InsertDocGia";
sqlCom.Parameters.Add("@MADG", SqlDbType.VarChar).Value = docGia.MaDocGia;
sqlCom.Parameters.Add("@HOTEN", SqlDbType.NVarChar).Value = docGia.HoTen;
sqlCom.Parameters.Add("@NGAYSINH", SqlDbType.VarChar).Value = docGia.NgaySinh;
sqlCom.Parameters.Add("@GIOITINH", SqlDbType.NVarChar).Value = docGia.GioiTinh;
sqlCom.Parameters.Add("@LOP", SqlDbType.VarChar).Value = docGia.Lop;
sqlCom.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = docGia.DiaChi;
sqlCom.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = docGia.Email;
sqlCom.Parameters.Add("@GHICHU", SqlDbType.NVarChar).Value = docGia.GhiChu;
sqlCom.Connection = connectSer.Connect();
sqlCom.ExecuteNonQuery();
}
