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