public DatingProfile loadDatingProfileFromDB(string userName, DatingProfile dateProfile)
{
//open the DB connection
db.OpenConnection();
//exec the query to the users dating Ad
DataTable userInfo = db.ExecuteSQL("SELECT * FROM datingAds WHERE nickname='" + userName + "';");
//assign all the vars in the class
dateProfile.NickName = userName;
dateProfile.Sex = (string)userInfo.Rows[0]["sex"];
dateProfile.Max_Weight = (int)userInfo.Rows[0]["max_weight"];
dateProfile.Min_Weight = (int)userInfo.Rows[0]["min_weight"];
dateProfile.Max_Age = (int)userInfo.Rows[0]["max_age"];
dateProfile.Min_Age = (int)userInfo.Rows[0]["min_age"];
dateProfile.Race = (int)(userInfo.Rows[0]["race"]);
dateProfile.Hair = (int)userInfo.Rows[0]["hair"];
dateProfile.Max_Height_ft = (int)userInfo.Rows[0]["max_height_ft"];
dateProfile.Min_Height_ft = (int)userInfo.Rows[0]["min_height_ft"];
dateProfile.Max_Height_in = (int)userInfo.Rows[0]["max_height_in"];
dateProfile.Min_Height_in = (int)userInfo.Rows[0]["min_height_in"];
dateProfile.Interest1 = (int)userInfo.Rows[0]["interest_1"];
dateProfile.Interest2 = (int)userInfo.Rows[0]["interest_2"];
dateProfile.Interest3 = (int)userInfo.Rows[0]["interest_3"];
//close the DB connection
db.CloseConnection();
//return a reference to the newly filled datingProfile
return dateProfile;
}
/// <summary>
///
/// </summary>
/// <param name="dateProfile"></param>
/// <returns></returns>
public bool DeletedateingProfile(DatingProfile dateProfile)
{
int result = -1;
string sql = string.Empty;
string.Format("DELETE FROM [noIdeas].[dbo].[datingAds] WHERE username = '******'",dateProfile.NickName);
try
{
db.OpenConnection();
result = db.ExecuteSql(sql);
}
catch { }
finally
{
db.CloseConnection();
}
if (result == 1)
return true;
else
return false;
}
public bool UpdateDatingProfile(DatingProfile dprofile)
{
object[] results = this.Invoke("UpdateDatingProfile", new object[] {
dprofile});
return ((bool)(results[0]));
}
/// <remarks/>
public System.IAsyncResult BeginUpdateDatingProfile(DatingProfile dprofile, System.AsyncCallback callback, object asyncState)
{
return this.BeginInvoke("UpdateDatingProfile", new object[] {
dprofile}, callback, asyncState);
}
/// <remarks/>
public void RunAndFindMatchesAsync(Profile profile, DatingProfile dprofile, object userState) {
if ((this.RunAndFindMatchesOperationCompleted == null)) {
this.RunAndFindMatchesOperationCompleted = new System.Threading.SendOrPostCallback(this.OnRunAndFindMatchesOperationCompleted);
}
this.InvokeAsync("RunAndFindMatches", new object[] {
profile,
dprofile}, this.RunAndFindMatchesOperationCompleted, userState);
}
/// <remarks/>
public void RunAndFindMatchesAsync(Profile profile, DatingProfile dprofile) {
this.RunAndFindMatchesAsync(profile, dprofile, null);
}
public List<MatchedResults> RunAndFindMatches(Profile profile, DatingProfile dprofile) {
object[] results = this.Invoke("RunAndFindMatches", new object[] {
profile,
dprofile});
return ((List<MatchedResults>)(results[0]));
}
/// <remarks/>
public void DeletedatingProfileAsync(DatingProfile dprofile, object userState) {
if ((this.DeletedatingProfileOperationCompleted == null)) {
this.DeletedatingProfileOperationCompleted = new System.Threading.SendOrPostCallback(this.OnDeletedatingProfileOperationCompleted);
}
this.InvokeAsync("DeletedatingProfile", new object[] {
dprofile}, this.DeletedatingProfileOperationCompleted, userState);
}
/// <remarks/>
public void DeletedatingProfileAsync(DatingProfile dprofile) {
this.DeletedatingProfileAsync(dprofile, null);
}
/// <remarks/>
public void LoadDatingProfileAsync(DatingProfile dprofile) {
this.LoadDatingProfileAsync(dprofile, null);
}
/// <remarks/>
public void UpdateDatingProfileAsync(DatingProfile dprofile) {
this.UpdateDatingProfileAsync(dprofile, null);
}
public bool LoadDatingProfile(DatingProfile dprofile)
{
WorkerClass worker = new WorkerClass();
return worker.LoadDatingProfile(dprofile);
}
public bool DeletedatingProfile(DatingProfile dprofile)
{
WorkerClass worker = new WorkerClass();
return worker.DeletedateingProfile(dprofile);
}
public double matchPercentage(String user1, String user2)
{
db = new DataBaseWorker(connectionString);
//get each users profile information
Profile userOne = new Profile();
userOne = loadProfileFromDB(user1, userOne);
Profile userTwo = new Profile();
userTwo = loadProfileFromDB(user2, userTwo);
DatingProfile userOneWants = new DatingProfile();
userOneWants = loadDatingProfileFromDB(user1, userOneWants);
DatingProfile userTwoWants = new DatingProfile();
userTwoWants = loadDatingProfileFromDB(user1, userTwoWants);
//keep a running total of the total points
double total_points = 0;
//If height is in range add points (MAX 10)
//check if userOne is in userTwos range
if (userOne.Height_ft >= userTwoWants.Min_Height_ft && userOne.Height_ft <= userTwoWants.Max_Height_ft &&
userOne.Height_in >= userTwoWants.Min_Height_in && userOne.Height_in <= userTwoWants.Min_Height_in)
{
total_points += 10;
}
//check if userTwo is in userOnes range
if (userTwo.Height_ft >= userOneWants.Min_Height_ft && userTwo.Height_ft <= userOneWants.Max_Height_ft &&
userTwo.Height_in >= userOneWants.Min_Height_in && userTwo.Height_in <= userOneWants.Min_Height_in)
{
total_points += 10;
}
//If weight is in range add points (MAX 10)
//check if userOne is in userTwos range
if (userOne.Weight >= userTwoWants.Min_Weight && userOne.Weight <= userTwoWants.Max_Weight)
{
total_points += 10;
}
//check if userTwo is in userOnes range
if (userTwo.Weight >= userOneWants.Min_Weight && userTwo.Weight <= userOneWants.Max_Weight)
{
total_points += 10;
}
//If age is in range add points (MAX 10)
//check if userOne is in userTwos range
if (userOne.Age >= userTwoWants.Min_Age && userOne.Age <= userTwoWants.Max_Age)
{
total_points += 10;
}
//check if userTwo is in userOnes range
if (userTwo.Age >= userOneWants.Min_Age && userTwo.Age <= userOneWants.Max_Age)
{
total_points += 10;
}
//10 points for race match
if (userOne.Race == userTwoWants.Race)
{
total_points += 10;
}
if (userTwo.Race == userOneWants.Race)
{
total_points += 10;
}
//10 points for hair match
if (userOne.Hair == userTwoWants.Hair)
{
total_points += 10;
}
if (userTwo.Hair == userOneWants.Hair)
{
total_points += 10;
}
//10 points for each matching interest
if (userOne.Interest1 == userTwoWants.Interest1)
{
total_points += 10;
}
if (userTwo.Interest1 == userOneWants.Interest1)
{
total_points += 10;
}
//interest 2
if (userOne.Interest2 == userTwoWants.Interest2)
{
total_points += 10;
}
if (userTwo.Interest2 == userOneWants.Interest2)
{
total_points += 10;
}
//interest 3
if (userOne.Interest3 == userTwoWants.Interest3)
{
total_points += 10;
}
if (userTwo.Interest3 == userOneWants.Interest3)
{
total_points += 10;
}
return Math.Round((total_points / 160) * 100, 2);
}
/// <summary>
///
/// </summary>
/// <param name="dateProfile"></param>
/// <returns></returns>
public bool LoadDatingProfile(DatingProfile dateProfile)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("INSERT INTO [noIdeas].[dbo].[datingAds] " +
"([username],[sex],[min_age],[max_age],[race]" +
",[min_height_ft],[min_height_in],[max_height_ft],[max_height_in] " +
",[min_weight],[max_weight],[hair],[interest_1] ,[interest_2] " +
",[interest_3]) " +
" VALUES('{0}', '{1}','{2}', '{3}','{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}','{12}','{13}','{14}')",
dateProfile.NickName, dateProfile.Sex, dateProfile.Min_Age, dateProfile.Max_Age, dateProfile.Race,
dateProfile.Min_Height_ft, dateProfile.Min_Height_in,dateProfile.Max_Height_ft, dateProfile.Max_Height_in,
dateProfile.Min_Weight, dateProfile.Max_Weight,dateProfile.Hair,dateProfile.Interest1, dateProfile.Interest2, dateProfile.Interest3);
int result = -1;
try
{
db.OpenConnection();
result = db.ExecuteSql(sql.ToString());
}
catch (Exception ex)
{
}
finally
{
db.CloseConnection();
}
if (result == 1)
return true;
else
return false;
}
