//inserts new Lease in database
public string CreateLease(Lease lease)
{
string active = "1";
if (lease.active == false)
{
active = "0";
}
string insertLease = $"insert into Lease (CreationDate, Active, DebtorID, BranchID, ContactFname, ContactLname, ContactPhone, Status) output inserted.LeaseID " +
$"Values (CONVERT (date, CURRENT_TIMESTAMP), {active}, '{lease.debtorID}', {lease.branchID}, '{lease.contactFirstName.Replace("'", "''")}'," +
$" '{lease.contactLastName.Replace("'", "''")}', '{lease.contactPhone.Replace("'", "''")}', '{lease.status}')";
DataTable dataTable = DatabaseManager.ReadFromDatabase(insertLease);
int leaseID = (int)dataTable.Rows[0][0];
if (lease.GetLeaseOrders().Count > 0)
{
lease.SetLeaseID(leaseID);
string insertLeaseOrder = GetLeaseOrderInsertString(lease);
string isInsertSuccess = DatabaseManager.CreateUpdateDeleteInDatabase(insertLeaseOrder);
return(leaseID.ToString() + ";" + isInsertSuccess);
}
else
{
return(leaseID.ToString() + ";Success");
}
}
private void buttonUpdateOrder_Click(object sender, EventArgs e)
{
DelpinCore.Lease lease = GetLeaseFromForm();
lease.SetLeaseID(Convert.ToInt32(leaseNumber.Text));
string isUpdateSuccess = controller.UpdateLease(lease);
MessageBox.Show(isUpdateSuccess);
}