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