/// <summary>
/// GetContracts() returns a list of contracts currently on the contract marketplace
/// </summary>
/// <returns>List<Contract></returns>
public List <Contract> GetContracts()
{
List <Contract> contracts = new List <Contract>();
const string queryString = "SELECT * FROM Contract;";
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
conn.Open();
MySqlCommand query = new MySqlCommand(queryString, conn);
MySqlDataReader reader = query.ExecuteReader();
DataTable table = new DataTable();
table.Load(reader);
TmsDal dal = new TmsDal();
foreach (DataRow row in table.Rows)
{
Contract contract = new Contract();
Customer customer = new Customer();
customer.Name = (string)row["Client_Name"];
try
{
customer = dal.GetCustomer(customer.Name);
}
catch (CustomerNotExistsException)
{
try
{
customer = dal.CreateCustomer(customer);
Logger.Info(LogOrigin.Database, "(CmpDal.GetContracts) Created new customer '" + customer.Name + "'");
}
catch (CouldNotInsertException)
{
Logger.Error(LogOrigin.Database, "(CmpDal.GetContracts) Could not create customer");
}
}
contract.Status = Status.PENDING;
contract.Customer = customer;
contract.JobType = (JobType)row["Job_Type"];
contract.VanType = (VanType)row["Van_Type"];
contract.Quantity = (int)row["Quantity"];
City origin;
City destination;
Enum.TryParse((string)row["Origin"], out origin);
Enum.TryParse((string)row["Destination"], out destination);
contract.Origin = origin;
contract.Destination = destination;
contracts.Add(contract);
}
conn.Close();
Logger.Info(LogOrigin.Database, "(CmpDal.GetContracts) Fetched " + contracts.Count + " contracts");
}
return(contracts);
}
public Carrier()
{
dal = new TmsDal();
}