public bool InsertNGH(DTO_GiamHo gh)
{
try
{
//_conn.Open();
//string SQL = @"INSERT INTO NGUOIGIAMHO
// ( MAGH, HOTEN, DIACHI, SDT )
// VALUES
// ( @MAGH, @HOTEN, @DIACHI, @SDT )";
//SqlCommand cmd = new SqlCommand(SQL, _conn);
//cmd.Parameters.AddWithValue("@MAGH", gh.MaGH);
//cmd.Parameters.AddWithValue("@HOTEN", gh.HoTen);
//cmd.Parameters.AddWithValue("@DIACHI", gh.DiaChi);
//cmd.Parameters.AddWithValue("@SDT", gh.Sdt);
//if (cmd.ExecuteNonQuery() > 0)
// return true;
_conn.Open();
SqlCommand cmd = new SqlCommand("sp_InsertNGH", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MAGH", gh.MaGH);
cmd.Parameters.AddWithValue("@HOTEN", gh.HoTen);
cmd.Parameters.AddWithValue("@DIACHI", gh.DiaChi);
cmd.Parameters.AddWithValue("@SDT", gh.Sdt);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception)
{
throw;
}
finally
{
_conn.Close();
}
return(false);
}
public bool InsertNGH(DTO_GiamHo gh)
{
return(dao.InsertNGH(gh));
}
