public RentalContract FindRentalContract(int?id)
{
RentalContract contract = null;
foreach (var rent in GetRentalContracts())
{
if (rent.RentalContractID == id)
{
contract = rent;
break;
}
}
return(contract);
}
//Rental Contracts
public List <RentalContract> GetRentalContracts()
{
List <RentalContract> rentalContracts = new List <RentalContract>();
using (SqlConnection scApartmentsManagement = new SqlConnection(System.
Configuration.
ConfigurationManager.
ConnectionStrings["csApartmentsRentalManagement"].
ConnectionString))
{
SqlCommand cmdRentalContracts = new SqlCommand("SELECT RentalContractID, ContractNumber, EmployeeID, " +
" ContractDate, FirstName, LastName, " +
" MaritalStatus, NumberOfChildren, " +
" ApartmentID, RentStartDate " +
"FROM Management.RentalContracts;",
scApartmentsManagement);
scApartmentsManagement.Open();
cmdRentalContracts.ExecuteNonQuery();
SqlDataAdapter sdaRentalContracts = new SqlDataAdapter(cmdRentalContracts);
DataSet dsRentalContracts = new DataSet("rent-contracts");
sdaRentalContracts.Fill(dsRentalContracts);
for (int i = 0; i < dsRentalContracts.Tables[0].Rows.Count; i++)
{
RentalContract contract = new RentalContract()
{
RentalContractID = int.Parse(dsRentalContracts.Tables[0].Rows[i][0].ToString()),
ContractNumber = int.Parse(dsRentalContracts.Tables[0].Rows[i][1].ToString()),
EmployeeID = int.Parse(dsRentalContracts.Tables[0].Rows[i][2].ToString()),
ContractDate = DateTime.Parse(dsRentalContracts.Tables[0].Rows[i][3].ToString()),
FirstName = dsRentalContracts.Tables[0].Rows[i][4].ToString(),
LastName = dsRentalContracts.Tables[0].Rows[i][5].ToString(),
MaritalStatus = dsRentalContracts.Tables[0].Rows[i][6].ToString(),
NumberOfChildren = int.Parse(dsRentalContracts.Tables[0].Rows[i][7].ToString()),
ApartmentID = int.Parse(dsRentalContracts.Tables[0].Rows[i][8].ToString()),
RentStartDate = DateTime.Parse(dsRentalContracts.Tables[0].Rows[i][9].ToString())
};
rentalContracts.Add(contract);
}
}
return(rentalContracts);
}