public static string getAddUserCredentialQuery(User user, short userType) { StringBuilder query = new StringBuilder(); query.Append("Insert into users values(").Append(user.ID); query.Append(", \'").Append(user.Username).Append("\', \'").Append(user.Password); query.Append("\', ").Append(userType).Append(")"); return query.ToString(); }
public static string getAddGenericUserProfileQuery(User user) { StringBuilder query = new StringBuilder(); query.Append("Insert into generic_user_profiles values(").Append(user.ID).Append(", \'"); query.Append(user.Name).Append("\', ").Append(user.DOB).Append(", \'").Append(user.Email).Append("\', \'"); query.Append(user.HomeAddress).Append("\', \'").Append(user.ContactNumber).Append("\', "); query.Append((int)user.Gender).Append(")"); return query.ToString(); }
private static bool extractGenericUserDetails(Dictionary<string, string> userDetails, User user) { try { user.ID = UInt64.Parse(userDetails["uid"]); user.Username = userDetails["username"]; user.Password = userDetails["password"]; user.Name = userDetails["name"]; user.Email = userDetails["email"]; user.HomeAddress = userDetails["home_address"]; user.ContactNumber = userDetails["contact_number"]; user.DOB = UInt64.Parse(userDetails["dob"]); string gender = userDetails["gender"]; if (gender == "m") user.Gender = GENDER.MALE; else if (gender == "f") user.Gender = GENDER.FEMALE; else if (gender == "s") user.Gender = GENDER.SHEMALE; else return false; return true; } catch (Exception ex) { return Utilities.logException(ex); } }