public void Insert_Update_Delete(Cls_NhanPhong_DTA NP_Data, string sThucThi) { sConn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SP_NhanPhong"; cmd.Connection = this.sConn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MaNP", SqlDbType.Char); cmd.Parameters["@MaNP"].Value = NP_Data.MaNP; cmd.Parameters.Add("@TenKH", SqlDbType.NVarChar); cmd.Parameters["@TenKH"].Value = NP_Data.TenKH; cmd.Parameters.Add("@NgayNhan", SqlDbType.DateTime); cmd.Parameters["@NgayNhan"].Value = NP_Data.NgayNhan; cmd.Parameters.Add("@GioNhan", SqlDbType.NVarChar); cmd.Parameters["@GioNhan"].Value = NP_Data.GioNhan; cmd.Parameters.Add("@MaPH", SqlDbType.Char); cmd.Parameters["@MaPH"].Value = NP_Data.MaPH; cmd.Parameters.Add("@SoLuongNguoi", SqlDbType.Int); cmd.Parameters["@SoLuongNguoi"].Value = NP_Data.SoLuongNguoi; cmd.Parameters.Add("@DiaChi", SqlDbType.NVarChar); cmd.Parameters["@DiaChi"].Value = NP_Data.DiaChi; cmd.Parameters.Add("@Email", SqlDbType.NVarChar); cmd.Parameters["@Email"].Value = NP_Data.Emai; cmd.Parameters.Add("@SoDienThoai", SqlDbType.NVarChar); cmd.Parameters["@SoDienThoai"].Value = NP_Data.SoDienThoai; cmd.Parameters.Add("@sqlTemp", SqlDbType.NVarChar); if (sThucThi == "Insert" || sThucThi == "Delete" || sThucThi == "Update") { cmd.Parameters["@sqlTemp"].Value = sThucThi; } cmd.ExecuteNonQuery(); sConn.Close(); }
public void Insert_Update_Delete(Cls_NhanPhong_DTA NPhong_DATA, string sThucThi) { NPhong_BUS.Insert_Update_Delete(NPhong_DATA, sThucThi); }