public static List <int> SelectYear()
{
string connectionString = @"Data Source=JANLENOVO\SQLEXPRESS;Initial Catalog=CarDB;Integrated Security=True;
Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;
MultiSubnetFailover=False";
string queryString = @"Select Year FROM YearMakeModel";
var yearList = new List <int>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var year = new YearMakeModel();
year.Year = Convert.ToInt32(reader["Year"]);
yearList.Add(year.Year);
}
yearList.Sort();
var years = new List <int>()
{
yearList[0]
};
for (var i = 1; i < yearList.Count; i++)
{
if (yearList[i] != yearList[i - 1])
{
years.Add(yearList[i]);
}
}
return(years);
}
}
public static List <string> SelectModel()
{
string connectionString = @"Data Source=JANLENOVO\SQLEXPRESS;Initial Catalog=CarDB;Integrated Security=True;
Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;
MultiSubnetFailover=False";
string queryString = @"Select Model FROM YearMakeModel";
var modelList = new List <string>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var model = new YearMakeModel();
model.Model = reader["Model"].ToString();
modelList.Add(model.Model);
}
modelList.Sort();
var models = new List <string>()
{
modelList[0]
};
for (var i = 1; i < modelList.Count; i++)
{
if (modelList[i] != modelList[i - 1])
{
models.Add(modelList[i]);
}
}
return(models);
}
}
//Selecting all Model in the database and return a list of Car Models with removed multi copies and alphabetically sorted
public static List <string> SelectModel()
{
using (InsuranceApplicationEntities db = new InsuranceApplicationEntities())
{
var cars = db.YearMakeModels.ToList();
var modelList = new List <string>();
foreach (var car in cars)
{
var carList = new YearMakeModel();
carList.Model = car.Model.ToString();
modelList.Add(carList.Model);
}
modelList.Sort();
var models = new List <string>()
{
modelList[0]
};
for (var i = 1; i < modelList.Count; i++)
{
if (modelList[i] != modelList[i - 1])
{
models.Add(modelList[i]);
}
}
return(models);
}
}
//Selecting all years in the database and return a list of years with removed multi copies and sort by past to present
public static List <int> SelectYear()
{
using (InsuranceApplicationEntities db = new InsuranceApplicationEntities())
{
var cars = db.YearMakeModels.ToList();
var yearList = new List <int>();
foreach (var car in cars)
{
var carList = new YearMakeModel();
carList.Year = Convert.ToInt32(car.Year);
yearList.Add(carList.Year);
}
yearList.Sort();
var years = new List <int>()
{
yearList[0]
};
for (var i = 1; i < yearList.Count; i++)
{
if (yearList[i] != yearList[i - 1])
{
years.Add(yearList[i]);
}
}
return(years);
}
}
private YearMakeModel MatchYearMakeModel(string InputText)
{
var regex = new Regex("(?:<b>)(?<year>\\d{4})(?<makemodel>\\s[0-9A-Za-z ]+)(?:</b>)",
RegexOptions.Multiline
| RegexOptions.CultureInvariant
| RegexOptions.Compiled);
var m = regex.Match(InputText);
YearMakeModel returnVal = null;
if (m.Success)
{
returnVal = new YearMakeModel();
//yearMakeModel.Add(m.Groups["title"].Value);
returnVal.Year = m.Groups["year"].Value.Trim();
var makeModel = m.Groups["makemodel"].Value.Trim();
foreach (var cm in makes)
{
if (makeModel.ToUpper().Contains(cm.Make.ToUpper()))
{
returnVal.Make = cm.Make;
break;
}
}
foreach (var cm in makes)
{
if (makeModel.ToUpper().Contains(cm.Model.ToUpper()) && makeModel.ToUpper().Contains(cm.Make.ToUpper()))
{
returnVal.Model = cm.Model;
break;
}
}
}
return(returnVal);
}
