public bool Update(UserDetails ud, out string error)
{
string sqlString = "UPDATE Tbl_Users SET Us_Username = @username, Us_Email = @email, Us_PostalCode = @postalcode WHERE Us_Id = @id";
sql.SetCommand(sqlString);
sql.AddIntParamter("id", ud.Id);
sql.AddStringParameter("username", 20, ud.Username);
sql.AddStringParameter("email", 20, ud.Email);
sql.AddIntParamter("postalcode", ud.PostalCode);
return(sql.Execute(out error));
}
public bool InsertLocation(LocationDetails ld, out string error)
{
string sqlCheck = "SELECT COUNT(*) FROM Tbl_Locations WHERE Loc_PostalCode = @postalcode";
sql.SetCommand(sqlCheck);
sql.AddIntParamter("postalcode", ld.PostalCode);
if ((int)sql.ExecuteScalar(out error) != 0)
{
return(Update(ld, out error));
}
string sqlPostalCode = "INSERT INTO Tbl_Locations (Loc_PostalCode, Loc_Location) VALUES (@postalcode, @location)";
sql.SetCommand(sqlPostalCode);
sql.AddStringParameter("location", 20, ld.Location);
sql.AddIntParamter("postalcode", ld.PostalCode);
return(sql.Execute(out error));
}
