} // end method
public int UpdatePopUp(LeaseUnits LeaseUnit)
{
return(providerBase.Update(LeaseUnit));
} // end method
} // end method
/// <summary>
/// This method gets a single LeaseUnit object from the LeaseUnit datastore.
/// It returns 0 to indicate the LeaseUnit was loaded from the datastore, or
/// -1 to indicate that no LeaseUnit was loaded from the datastore.
/// </summary>
/// <param name="ID">The LeaseUnit ID of the StorageUnit to load from the datastore.</param>
/// <param name="LeaseUnit">The LeaseUnit object loaded from the datastore.</param>
public int SelectLeaseUnit(string ID, ref LeaseUnits LeaseUnit)
{
return(providerBase.SelectLeaseUnit(ID, ref LeaseUnit));
} // end method
} // end method
/// <summary>
/// This method inserts a row in the LeaseUnit datastore.
/// It returns 0 to indicate the LeaseUnit was inserted into datastore, or
/// -1 to indicate the LeaseUnit was not inserted because a duplicate was found
/// </summary>
/// <param name="LeaseUnit">The LeaseUnit object to add to the LeaseUnit datastore.</param>
public int Insert(LeaseUnits LeaseUnit)
{
return(providerBase.Insert(LeaseUnit));
} // end method
/// <summary> /// This method updates a row in the LeaseUnit datastore. /// It returns 0 to indicate the LeaseUnit was found and updated successfully, or /// -1 to indicate the LeaseUnit was not updated because the record was not found /// </summary> /// <param name="LeaseUnit">The new LeaseUnit data for the row in the LeaseUnit datastore.</param> public abstract int Update(LeaseUnits LeaseUnits);
public abstract int UpdatePopUp(LeaseUnits LeaseUnits);
/// <summary> /// This method gets a single LeaseUnit object from the LeaseUnit datastore. /// It returns 0 to indicate the LeaseUnit was loaded from datastore, or /// -1 to indicate that no LeaseUnit was loaded from the datastore (not found). /// </summary> /// <param name="ID">The ID of the LeaseUnit to load from the datastore.</param> /// <param name="LeaseUnit">The LeaseUnit object loaded from the datastore.</param> public abstract int SelectLeaseUnit(string ID, ref LeaseUnits LeaseUnit);
/// <summary> /// This method inserts a row in the LeaseUnit datastore. /// It returns 0 to indicate the LeaseUnit was inserted into datastore, or /// -1 to indicate the LeaseUnit was not inserted because a duplicate was found /// </summary> /// <param name="LeaseUnit">The LeaseUnit object to add to the LeaseUnit datastore.</param> public abstract int Insert(LeaseUnits LeaseUnits);
private void Update_Click(object sender, RoutedEventArgs e)
{
int rc = 0;
LeaseUnits leaseUnit = new LeaseUnits();
StorageUnit unit = new StorageUnit();
List <LeaseUnits> list = _lubl.SelectAll();
//foreach (LeaseUnits leaseUnits in list)
//{
// if (leaseUnits.LeaseID.Equals(LeaseIDTxtBox.Text))
// {
// unitID = leaseUnits.StorageUnit.UnitId;
// unitClass = leaseUnits.StorageUnit.UnitClassification;
// unitPrice = leaseUnits.StorageUnit.UnitPrice;
// }
//}
LeaseIDTxtBox.IsEnabled = false;
ClientIDTxtBox.IsEnabled = false;
leaseUnit.LeaseID = LeaseIDTxtBox.Text;
leaseUnit.Client.idNumber = ClientIDTxtBox.Text;
leaseUnit.Client.FirstName = LeaseNameTxtBox.Text;
leaseUnit.Client.LastName = LeaseSurnameTxtBox.Text;
leaseUnit.AmountOwed = LeaseOwedTxtBox.Text;
leaseUnit.AmountPaid = LeasePaidTxtBox.Text;
leaseUnit.Paid = Convert.ToBoolean(1);
leaseUnit.DateOfPayment = LeaseDateTxtBox.SelectedDate.Value.Date.ToShortDateString();
leaseUnit.MonthsPaid = MonthspaidTxtBox.Text;
LeaseUnits leaseUnit_UnitInfo = new LeaseUnits();
_lubl.SelectLeaseUnit(leaseUnit.LeaseID, ref leaseUnit_UnitInfo);
leaseUnit.StorageUnit.UnitId = leaseUnit_UnitInfo.StorageUnit.UnitId;
leaseUnit.StorageUnit.UnitClassification = leaseUnit_UnitInfo.StorageUnit.UnitClassification;
leaseUnit.StorageUnit.UnitPrice = leaseUnit_UnitInfo.StorageUnit.UnitPrice;
if (int.Parse(LeaseDateTxtBox.SelectedDate.Value.Date.ToShortDateString().Substring(5, 2)) > 1)
{
leaseUnit.TypeOfPayment = "Advance";
unit.UnitInAdvance = Convert.ToBoolean(1);
}
else if (int.Parse(LeaseDateTxtBox.SelectedDate.Value.Date.ToShortDateString().Substring(5, 2)) == 1)
{
leaseUnit.TypeOfPayment = "Deposit";
}
else
{
leaseUnit.TypeOfPayment = "Deposit";
}
if (leaseUnit.Paid == Convert.ToBoolean(1))
{
leaseUnit.Status = "Up To Date";
unit.UnitUpToDate = Convert.ToBoolean(1);
}
rc = _lubl.UpdatePopUp(leaseUnit);
if (rc == 0)
{
this.ShowMessageAsync("Updated", "Successfully Updated!");
}
else
{
this.ShowMessageAsync("Updated Failed", "Update Did Not Perform!");
}
}
} // end method
public override int SelectLeaseUnit(string ID, ref LeaseUnits LeaseUnit)
{
//
//Method Name : int SelectLeaseUnit(string ID, ref LeaseUnit LeaseUnit)
//Purpose : Try to get a single LeaseUnits object from the LeaseUnits datastore
//Re-use :
//Input : string ID
// - The ID of the LeaseUnits to load from the datastore
// ref LeaseUnit LeaseUnit
// - The LeaseUnits object loaded from the datastore
//Output : - int
// 0 : LeaseUnit loaded from datastore
// -1 : no LeaseUnit was loaded from the datastore (not found)
//
int rc = 0; // will be returned, thus can not be declared in try block
try
{
_sqlCon = new SQLiteConnection(_conStr); // new connection
bool bRead = false;
LeaseUnit = new LeaseUnits();
_sqlCon.Open(); // open connection
string selectQuery = "SELECT * FROM LeaseUnits WHERE [LeaseID] = '" + ID + "'";
SQLiteCommand sqlCommand = new SQLiteCommand(selectQuery, _sqlCon); // setup command
SQLiteDataReader sdr = sqlCommand.ExecuteReader();
bRead = sdr.Read();
if (bRead == true) // false indicates no row/record read
{
LeaseUnit.LeaseID = Convert.ToString(sdr["LeaseID"]);
LeaseUnit.Client.idNumber = Convert.ToString(sdr["ClientID"]);
LeaseUnit.Client.FirstName = Convert.ToString(sdr["ClientName"]);
LeaseUnit.Client.LastName = Convert.ToString(sdr["ClientSurName"]);
LeaseUnit.StorageUnit.UnitId = Convert.ToString(sdr["UnitID"]);
LeaseUnit.StorageUnit.UnitClassification = Convert.ToString(sdr["UnitClass"]);
LeaseUnit.StorageUnit.UnitPrice = Convert.ToDouble(sdr["UnitPrice"]);
LeaseUnit.NoOfUnits = Convert.ToInt32(sdr["NoOfUnits"]);
LeaseUnit.ClientWaitingList = (Convert.ToInt16(sdr["ClientWaitingList"]) == 1) ? true : false;
LeaseUnit.AvailableUnits = Convert.ToString(sdr["AvailableUnits"]);
LeaseUnit.TypeOfPayment = Convert.ToString(sdr["TypeOfPayment"]);
LeaseUnit.DateOfPayment = Convert.ToString(sdr["DatePaid"]);
LeaseUnit.DateOfContractStart = Convert.ToString(sdr["DateOfContractStart"]);
LeaseUnit.DateOfContractEnd = Convert.ToString(sdr["DateOfContractEnd"]);
LeaseUnit.AmountDeposited = Convert.ToString(sdr["AmountDeposited"]);
LeaseUnit.AmountOwed = Convert.ToString(sdr["AmountOwed"]);
LeaseUnit.AmountPaid = Convert.ToString(sdr["AmountPaid"]);
LeaseUnit.ClientCurrentTotal = Convert.ToString(sdr["ClientCurrentTotal"]);
LeaseUnit.UnitLeased = (Convert.ToInt16(sdr["UnitLeased"]) == 1) ? true : false;
LeaseUnit.ClientAdded = (Convert.ToInt16(sdr["ClientAdded"]) == 1) ? true : false;
LeaseUnit.TotalUnitPrice = Convert.ToString(sdr["TotalUnitPrice"]);
LeaseUnit.StorageUnit.UnitSize = Convert.ToString(sdr["UnitSize"]);
LeaseUnit.MonthsPaid = Convert.ToString(sdr["MonthsPaid"]);
LeaseUnit.Paid = Convert.ToInt16(sdr["Paid"]) == 1 ? true : false;
LeaseUnit.Refund = Convert.ToDouble(sdr["Refund"]);
rc = 0;
} // end if
else
{
rc = -1;
} // end else
sdr.Close(); // close reader
} // end try
catch (Exception ex)
{
throw ex;
} // end catch
finally
{
_sqlCon.Close(); // Close connection
} // end finally
return(rc); // single return
} // end method
} // end method
public override int UpdatePopUp(LeaseUnits LeaseUnit)
{
//
//Method Name : int Update(LeaseUnit LeaseUnit)
//Purpose : Try to update a row in the LeaseUnit datastore
//Re-use : None
//Input : LeaseUnit LeaseUnit
// - The new LeaseUnit data for the row in the LeaseUnit datastore
//Output : - int
// 0 : LeaseUnit found and updated successfully
// -1 : LeaseUnit not updated because the record was not found
//
int rc = 0; // will be returned, thus can not be declared in try block
try
{
int rowsAffected = 0;
_sqlCon = new SQLiteConnection(_conStr); // New connection
_sqlCon.Open(); // open connection
//
// A better option would be to only update the fields that actually changed
//
string updateQuery = "UPDATE LeaseUnits SET [ClientName]=@ClientName," +
"[ClientSurname]=@ClientSurname,[DatePaid]=@DatePaid," +
"[AmountOwed]=@AmountOwed,[AmountPaid]=@AmountPaid," +
$"[UnitLeased]=@UnitLeased,[Status]=@Status,[MonthsPaid]=@MonthsPaid,[Paid]=@Paid,[Refund]=@Refund WHERE [LeaseID] = '{LeaseUnit.LeaseID}'";
SQLiteCommand sqlCommand = new SQLiteCommand(updateQuery, _sqlCon); // setup command
SQLiteParameter[] sqlParams = new SQLiteParameter[] // setup parameters
{ new SQLiteParameter("@LeaseID", DbType.String),
new SQLiteParameter("@ClientName", DbType.String),
new SQLiteParameter("@ClientSurname", DbType.String),
new SQLiteParameter("@DatePaid", DbType.String),
new SQLiteParameter("@AmountOwed", DbType.String),
new SQLiteParameter("@AmountPaid", DbType.String),
new SQLiteParameter("@UnitLeased", DbType.Int16),
new SQLiteParameter("@Status", DbType.String),
new SQLiteParameter("@MonthsPaid", DbType.String),
new SQLiteParameter("@Paid", DbType.Int16),
new SQLiteParameter("@Refund", DbType.Double) };
// Populate SQLiteParameters from LeaseUnit
sqlParams[0].Value = LeaseUnit.LeaseID;
sqlParams[1].Value = LeaseUnit.Client.FirstName;
sqlParams[2].Value = LeaseUnit.Client.LastName;
sqlParams[3].Value = LeaseUnit.DateOfPayment;
sqlParams[4].Value = LeaseUnit.AmountOwed;
sqlParams[5].Value = LeaseUnit.AmountPaid;
sqlParams[6].Value = LeaseUnit.UnitLeased ? 1 : 0;// ? 1 : 0 Converts Boolean to Int16 for Database Storage
sqlParams[7].Value = LeaseUnit.Status;
sqlParams[8].Value = LeaseUnit.MonthsPaid;
sqlParams[9].Value = LeaseUnit.Paid ? 1 : 0;
sqlParams[10].Value = LeaseUnit.Refund;
sqlCommand.Parameters.AddRange(sqlParams);
rowsAffected = sqlCommand.ExecuteNonQuery();
if (rowsAffected == 0) // Test rowsAffected
{
// 0 rows affected, thus NO row updated in datastore, thus not found, thus failure
rc = -1;
} // end if
else
{
// 1 row affected, thus 1 row updated in datastore, thus success
rc = 0;
} // end else
} // end try
catch (Exception ex)
{
throw ex;
} // end catch
finally
{
_sqlCon.Close(); // Close connection
} // end finally
return(rc); // single return
} // end method
} // end method
public override int Insert(LeaseUnits LeaseUnit)
{
//
//Method Name : int Insert(LeaseUnit LeaseUnit)
//Purpose : Try to insert a row in the LeaseUnit datastore
//Re-use : DoesExist()
//Input : LeaseUnit LeaseUnit
// - The LeaseUnit object to add to the LeaseUnit datastore
//Output : - int
// 0 : LeaseUnit inserted into datastore
// -1 : LeaseUnit not inserted because a duplicate was found
//
int rc = 0; // will be returned, thus can not be declared in try block
try
{
bool doesExist = false;
int rowsAffected = 0;
{
//TO:DO
_sqlCon = new SQLiteConnection(_conStr); // new connection
_sqlCon.Open(); // open connection
string insertQuery = "INSERT INTO LeaseUnits([LeaseID],[ClientID], [ClientName], [ClientSurname], " +
"[UnitID],[UnitClass],[UnitPrice],[NoOfUnits]," +
"[ClientWaitingList],[AvailableUnits],[TypeOfPayment],[DatePaid]," +
"[DateOfContractStart],[DateOfContractEnd],[AmountDeposited],[AmountOwed]," +
"[AmountPaid],[ClientCurrentTotal],[UnitLeased],[ClientAdded],[TotalUnitPrice],[UnitSize],[Status],[MonthsPaid],[Paid],[Refund] )" +
" VALUES(" +
"@LeaseID,@ClientID, @ClientName, @ClientSurname, @UnitID,@UnitClass,@UnitPrice," +
"@NoOfUnits,@ClientWaitingList,@AvailableUnits,@TypeOfPayment,@DatePaid," +
"@DateOfContractStart,@DateOfContractEnd,@AmountDeposited,@AmountOwed,@AmountPaid," +
"@ClientCurrentTotal,@UnitLeased,@ClientAdded,@TotalUnitPrice,@UnitSize,@Status,@MonthsPaid,@Paid,@Refund)";
SQLiteCommand sqlCommand = new SQLiteCommand(insertQuery, _sqlCon); // setup command
SQLiteParameter[] sqlParams = new SQLiteParameter[] // setup parameters
{
new SQLiteParameter("@LeaseID", DbType.String),
new SQLiteParameter("@ClientID", DbType.String),
new SQLiteParameter("@ClientName", DbType.String),
new SQLiteParameter("@ClientSurname", DbType.String),
new SQLiteParameter("@UnitID", DbType.String),
new SQLiteParameter("@UnitClass", DbType.String),
new SQLiteParameter("@UnitPrice", DbType.Double),
new SQLiteParameter("@NoOfUnits", DbType.String),
new SQLiteParameter("@ClientWaitingList", DbType.String),
new SQLiteParameter("@AvailableUnits", DbType.String),
new SQLiteParameter("@TypeOfPayment", DbType.String),
new SQLiteParameter("@DatePaid", DbType.String),
new SQLiteParameter("@DateOfContractStart", DbType.String),
new SQLiteParameter("@DateOfContractEnd", DbType.String),
new SQLiteParameter("@AmountDeposited", DbType.String),
new SQLiteParameter("@AmountOwed", DbType.String),
new SQLiteParameter("@AmountPaid", DbType.String),
new SQLiteParameter("@ClientCurrentTotal", DbType.String),
new SQLiteParameter("@UnitLeased", DbType.Int16),
new SQLiteParameter("@ClientAdded", DbType.Int16),
new SQLiteParameter("@TotalUnitPrice", DbType.String),
new SQLiteParameter("@UnitSize", DbType.String),
new SQLiteParameter("@Status", DbType.String),
new SQLiteParameter("@MonthsPaid", DbType.String),
new SQLiteParameter("@Paid", DbType.Int16),
new SQLiteParameter("@Refund", DbType.Double)
};
sqlParams[0].Value = LeaseUnit.LeaseID;
sqlParams[1].Value = LeaseUnit.Client.idNumber; // Populate SQLiteParameters from Client
sqlParams[2].Value = LeaseUnit.Client.FirstName;
sqlParams[3].Value = LeaseUnit.Client.LastName;
sqlParams[4].Value = LeaseUnit.StorageUnit.UnitId;
sqlParams[5].Value = LeaseUnit.StorageUnit.UnitClassification;
sqlParams[6].Value = LeaseUnit.StorageUnit.UnitPrice;
sqlParams[7].Value = LeaseUnit.NoOfUnits;
sqlParams[8].Value = LeaseUnit.ClientWaitingList;
sqlParams[9].Value = LeaseUnit.AvailableUnits;
sqlParams[10].Value = LeaseUnit.TypeOfPayment;
sqlParams[11].Value = LeaseUnit.DateOfPayment;
sqlParams[12].Value = LeaseUnit.DateOfContractStart;
sqlParams[13].Value = LeaseUnit.DateOfContractEnd;
sqlParams[14].Value = LeaseUnit.AmountDeposited;
sqlParams[15].Value = LeaseUnit.AmountOwed;
sqlParams[16].Value = LeaseUnit.AmountPaid;
sqlParams[17].Value = LeaseUnit.ClientCurrentTotal;
sqlParams[18].Value = LeaseUnit.UnitLeased ? 1 : 0;// ? 1 : 0 Converts Boolean to Int16 for Database Storage
sqlParams[19].Value = LeaseUnit.ClientAdded ? 1 : 0;
sqlParams[20].Value = LeaseUnit.TotalUnitPrice;
sqlParams[21].Value = LeaseUnit.StorageUnit.UnitSize;
sqlParams[22].Value = LeaseUnit.Status;
sqlParams[23].Value = LeaseUnit.MonthsPaid;
sqlParams[24].Value = LeaseUnit.Paid ? 1 : 0;
sqlParams[25].Value = LeaseUnit.Refund;
sqlCommand.Parameters.AddRange(sqlParams);
rowsAffected = sqlCommand.ExecuteNonQuery();
if (rowsAffected == 1) // Test rowsAffected
{
// 1 row affected, thus 1 row added to datastore, thus success
rc = 0;
} // end if
} // end if
} // end try
catch (Exception ex)
{
throw ex;
} // end catch
finally
{
_sqlCon.Close(); // Close connection
} // end finally
return(rc); // Single return
} // end method
public override List <LeaseUnits> SelectAll()
{
//
//Method Name : List<LeaseUnits> SelectAll()
//Purpose : Try to get all the LeaseUnit objects from the datastore
//Re-use : None
//Input : None
//Output : - ref List<LeaseUnit>
// - the list that will contain the LeaseUnit objects loaded from datastore
//
List <LeaseUnits> LeaseUnits; // will be returned, thus can not be declared in try block
try
{
_sqlCon = new SQLiteConnection(_conStr); // new connection
bool bRead = false;
LeaseUnits = new List <LeaseUnits>(); // this ensures that if there are no records,
// the returned list will not be null, but
// it will be empty (Count = 0)
_sqlCon.Open(); // open connection
string selectQuery = "SELECT * FROM LeaseUnits";
SQLiteCommand sqlCommand = new SQLiteCommand(selectQuery, _sqlCon); // setup command
SQLiteDataReader sdr = sqlCommand.ExecuteReader();
bRead = sdr.Read(); // Priming read (must have 2nd read in loop)
while (bRead == true) // false indicates no more rows/records4\4
{
LeaseUnits LeaseUnit = new LeaseUnits();
//unit.Address = new Address();
//unit.Phone = new Phone();
LeaseUnit.Client = new Client();
LeaseUnit.StorageUnit = new StorageUnit();
LeaseUnit.LeaseID = Convert.ToString(sdr["LeaseID"]);
LeaseUnit.Client.idNumber = Convert.ToString(sdr["ClientID"]);
LeaseUnit.Client.FirstName = Convert.ToString(sdr["ClientName"]);
LeaseUnit.Client.LastName = Convert.ToString(sdr["ClientSurName"]);
LeaseUnit.StorageUnit.UnitId = Convert.ToString(sdr["UnitID"]);
LeaseUnit.StorageUnit.UnitClassification = Convert.ToString(sdr["UnitClass"]);
LeaseUnit.StorageUnit.UnitPrice = Convert.ToDouble(sdr["UnitPrice"]);
LeaseUnit.NoOfUnits = Convert.ToInt32(sdr["NoOfUnits"]);
LeaseUnit.ClientWaitingList = (Convert.ToInt16(sdr["ClientWaitingList"]) == 1) ? true : false;
LeaseUnit.AvailableUnits = Convert.ToString(sdr["AvailableUnits"]);
LeaseUnit.TypeOfPayment = Convert.ToString(sdr["TypeOfPayment"]);
LeaseUnit.DateOfPayment = Convert.ToString(sdr["DatePaid"]);
LeaseUnit.DateOfContractStart = Convert.ToString(sdr["DateOfContractStart"]);
LeaseUnit.DateOfContractEnd = Convert.ToString(sdr["DateOfContractEnd"]);
LeaseUnit.AmountDeposited = Convert.ToString(sdr["AmountDeposited"]);
LeaseUnit.AmountOwed = Convert.ToString(sdr["AmountOwed"]);
LeaseUnit.AmountPaid = Convert.ToString(sdr["AmountPaid"]);
LeaseUnit.ClientCurrentTotal = Convert.ToString(sdr["ClientCurrentTotal"]);
LeaseUnit.UnitLeased = Convert.ToInt16(sdr["UnitLeased"]) == 1 ? true : false;
LeaseUnit.ClientAdded = Convert.ToInt16(sdr["ClientAdded"]) == 1 ? true : false;
LeaseUnit.TotalUnitPrice = Convert.ToString(sdr["TotalUnitPrice"]);
LeaseUnit.StorageUnit.UnitSize = Convert.ToString(sdr["UnitSize"]);
LeaseUnit.Status = Convert.ToString(sdr["Status"]);
LeaseUnit.MonthsPaid = Convert.ToString(sdr["MonthsPaid"]);
LeaseUnit.Paid = Convert.ToInt16(sdr["Paid"]) == 1 ? true:false;
LeaseUnit.Refund = Convert.ToDouble(sdr["Refund"]);
LeaseUnits.Add(LeaseUnit);
bRead = sdr.Read(); // Priming read (must have 1st read before loop)
} // end while
sdr.Close(); // close reader
} // end try
catch (Exception ex)
{
throw ex;
} // end catch
finally
{
_sqlCon.Close(); // Close connection
} // end finally
return(LeaseUnits); // Single return
} // end method
