public void DeleteUserData(PropertyClass PS)
{
cmd = new SqlCommand("sp_DeleteUserData", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", PS.UserID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertUserData(PropertyClass PS)
{
cmd = new SqlCommand("sp_InsertUserData", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", PS.FirstName);
cmd.Parameters.AddWithValue("@LastName", PS.LastName);
cmd.Parameters.AddWithValue("@Email", PS.Email);
cmd.Parameters.AddWithValue("@FK_CountryID", PS.CountryID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}