public int Update() { ClientController clientController = new ClientController(information); int clientResult = clientController.Update(); HouseController houseController = new HouseController(information); int houseResult = houseController.Update(); ApartmentController apartmentController = new ApartmentController(information); int apartmentResult = apartmentController.Update(); object[] paramValues = { information["contract_id"], information["apartment_id"], information["commencement_date"], information["expiration_date"], information["validity_extention"], information["payment_per_month"], information["compensation"], information["fine"], information["additional_conditions"] }; int contractResult = dataController.ModifyData("Contract_Update", CommandType.StoredProcedure, updateParamNames, updateParamTypes, paramValues); return(clientResult & houseResult & apartmentResult & contractResult); }
public int Insert(int maxClientId, int maxHouseId, int maxApartmentId) { ClientController clientController = new ClientController(information); int clientResult = 1; if (clientController.ClientExists() == 0) { clientResult = clientController.Insert(maxClientId); } HouseController houseController = new HouseController(information); int houseResult = 1; if (houseController.HouseExists() == 0) { houseResult = houseController.Insert(maxHouseId); } ApartmentController apartmentController = new ApartmentController(information); int apartmentResult = 1; int houseId = houseController.GetHouseId(maxHouseId); int clientId = clientController.GetClientId(maxClientId); if (houseId != 0 && apartmentController.ApartmentExists(houseId) == 0) { apartmentResult = apartmentController.Insert(houseId, clientId, maxApartmentId); } int apartmentId = apartmentController.GetApartmentId(houseId, maxApartmentId); object[] paramValues = { information["contract_id"], apartmentId, information["commencement_date"], information["expiration_date"], information["payment_per_month"], information["compensation"], information["fine"], information["additional_conditions"] }; int contractResult = dataController.ModifyData("Contract_Insert", CommandType.StoredProcedure, insertParamNames, insertParamTypes, paramValues); return(clientResult & houseResult & apartmentResult & contractResult); }