public void InsertNewUser(PropertyService P)
{
cmd = new SqlCommand("InsertNewUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Fname", P.FirstName);
cmd.Parameters.AddWithValue("@Lname", P.LastName);
con.Open();
cmd.ExecuteNonQuery();//To Save Changes into Table. & to findout Number of affected by Query
con.Close();
}
public void UpdateUser(PropertyService P)
{
cmd = new SqlCommand("UpdateUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UID", P.UserID);
cmd.Parameters.AddWithValue("@Fname", P.FirstName);
cmd.Parameters.AddWithValue("@Lname", P.LastName);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
