private Lease ConvertDataTabeToLease(DataTable dataTable)
{
int leaseID = Convert.ToInt32(dataTable.Rows[0]["LeaseID"]);
int branchID = Convert.ToInt32(dataTable.Rows[0]["BranchID"]);
DateTime creationDate = Convert.ToDateTime(dataTable.Rows[0]["CreationDate"]);
string debtorID = (string)dataTable.Rows[0]["DebtorID"];
string status = (string)dataTable.Rows[0]["Status"];
string activeString = (string)dataTable.Rows[0]["Active"];
bool active = true;
if (activeString == "0")
{
active = false;
}
Lease lease = new Lease(debtorID, branchID, leaseID, creationDate, active);
try
{
string contactFirstName = (string)dataTable.Rows[0]["ContactFname"];
string contactLastName = (string)dataTable.Rows[0]["ContactLname"];
string contactPhone = (string)dataTable.Rows[0]["ContactPhone"];
lease.SetContactDetails(contactFirstName, contactLastName, contactPhone);
}
catch { }
lease.SetStatus(status);
foreach (DataRow dataRow in dataTable.Rows)
{
if (dataRow["StartDate"] == DBNull.Value)
{
continue;
}
DateTime startDate = Convert.ToDateTime(dataRow["StartDate"]);
DateTime endDate = Convert.ToDateTime(dataRow["EndDate"]);
int resourcesID = Convert.ToInt32(dataRow["ResourcesID"]);
decimal leasePrice = Convert.ToDecimal(dataRow["LeasePrice"]);
LeaseOrder leaseOrder = new LeaseOrder(startDate, endDate, leasePrice, resourcesID);
string deliveryStreet = dataRow["DeliveryStreet"].ToString();
int deliveryPostalCode = Convert.ToInt32(dataRow["DeliveryPostalCode"]);
string deliveryCity = dataRow["DeliveryCity"].ToString();
decimal deliveryPrice = Convert.ToDecimal(dataRow["DeliveryPrice"]);
leaseOrder.SetDeliveryAddress(deliveryStreet, deliveryPostalCode, deliveryCity, deliveryPrice);
leaseOrder.SetModelName(dataRow["ModelName"].ToString());
lease.AddLeaseOrder(leaseOrder);
}
return(lease);
}
//create insertstring for leaseorders
private string GetLeaseOrderInsertString(Lease lease)
{
string insertLeaseOrder = $"insert into LeaseOrder (StartDate, EndDate, LeasePrice, ResourcesID, LeaseID, DeliveryStreet, DeliveryPostalCode, DeliveryCity, DeliveryPrice)\nvalues\n";
for (int i = 0; i < lease.GetLeaseOrders().Count; i++)
{
LeaseOrder lo = lease.GetLeaseOrders()[i];
if (i != 0)
{
insertLeaseOrder += ", ";
}
insertLeaseOrder += $"('{lo.startDate.ToString("yyyy-MM-dd")}', '{lo.endDate.ToString("yyyy-MM-dd")}', {lo.leasePrice.ToString("G", new CultureInfo("en-US"))}," +
$" {lo.resourceID}, {lease.leaseID}, '{lo.deliveryStreet.Replace("'", "''")}', {lo.deliveryPostalCode}, '{lo.deliveryCity.Replace("'", "''")}', {lo.deliveryPrice.ToString("G", new CultureInfo("en-US"))})";
}
return(insertLeaseOrder);
}
public void AddLeaseOrderAtSpecificIndes(LeaseOrder leaseOrder, int indexToAddAt)
{
leaseOrders.Insert(indexToAddAt, leaseOrder);
}
public void AddLeaseOrder(LeaseOrder leaseOrder)
{
leaseOrders.Add(leaseOrder);
}
