public List <Found> GetFoundsPersonalArea(Person person) { SqlCommand cmd = ConnectSql(string.Format("Select * From Found Where FindID = '{0}'", person.PersonID)); SqlDataReader reader = cmd.ExecuteReader(); List <Found> resultFound = new List <Found>(); Found found = new Found(); while (reader.Read()) { resultFound.Add(found.Initialization(reader)); } connection.DisConnectSql(); int x = resultFound.Count(); return(resultFound); }
public List <Found> GetLosses() { SqlCommand cmd = ConnectSql("Select * from Found"); SqlDataReader reader = cmd.ExecuteReader(); List <Found> resultFounds = new List <Found>(); Found found = new Found(); while (reader.Read()) { resultFounds.Add(found.Initialization(reader)); } connection.DisConnectSql(); if (resultFounds.Count() == 0) { return(null); } return(resultFounds); }
public List <Found> GetFounds(Signs signs) { SqlCommand cmd = ConnectSql("Select * From Found"); SqlDataReader reader = cmd.ExecuteReader(); List <Found> resultFounds = new List <Found>(); Found found = new Found(); while (reader.Read()) { resultFounds.Add(found.Initialization(reader)); } connection.DisConnectSql(); int flag, i, j; for (i = resultFounds.Count() - 1; i >= 0; i--) { flag = 0; if (resultFounds[i].FoundDate.CompareTo(signs.Date.Subtract(TimeSpan.FromDays(7))) >= 0) { if (resultFounds[i].CategoryCode == signs.Category) { flag += 30; } if (signs.Description != " ") { string[] description = signs.Description.Split(' '); j = 0; foreach (string word in description) { string[] FoundDesc = resultFounds[i].FoundDesc.Split(' '); foreach (string desc in FoundDesc) { j += word.Contains(desc) == true ? 1 : 0; } } if (j != 0) { flag += 20; } } else { flag += 10; } if (GetRelevantColors(signs.Color).Contains(resultFounds[i].FoundColor.ToString())) { flag += 15; } if (signs.Remarks != " ") { string[] remarks = signs.Remarks.Split(' '); j = 0; foreach (string word in remarks) { string[] FoundRemark = resultFounds[i].Remarks.Split(' '); foreach (string remark in FoundRemark) { j += word.Contains(remark) == true ? 1 : 0; } } if (j != 0) { flag += 20; } } else { flag += 10; } } if (flag <= 60) { resultFounds.Remove(resultFounds[i]); } } return(resultFounds); }