public int InsertParkingSpace(Parking parking) { SpaceData spaceData = new SpaceData(); try { parking.Id = parkingData.GetParkingId(parking.Name, parking.CampusId); foreach (Space space in parking.SpaceList) { spaceData.InsertSpace(space, 0); } return 0; } catch (SqlException) { try { parkingData.DeleteParking(parking.Id); return 1; } catch (SqlException) { return 2; } } }
public int InsertParking(Parking parking) { SpaceData spaceData = new SpaceData(); if (parking.Name.Equals(string.Empty)) return 1; else if (parking.Height <= 0) return 13; else if (parking.Width <= 0) return 14; else if (parking.TotalSpace <= 0) return 2; else if (parking.CarSpace < 0) return 3; else if (parking.MotorcycleSpace < 0) return 4; else if (parking.HandicapSpace < 0) return 5; else if (parking.BusSpace < 0) return 6; else if (parking.CarSpace + parking.MotorcycleSpace + parking.HandicapSpace + parking.BusSpace <= 0) return 7; else if (parking.CarSpace + parking.MotorcycleSpace + parking.HandicapSpace + parking.BusSpace > parking.TotalSpace) return 8; else if (parking.CarSpace + parking.MotorcycleSpace + parking.HandicapSpace + parking.BusSpace < parking.TotalSpace) return 11; else if (parking.CampusId.Equals(string.Empty)) return 12; else { try { parkingData.InsertParking(parking); return 0; } catch (SqlException) { return 10; } } }
protected Parking CreateParking() { Parking parking = new Parking(); try { if (textboxParkingName.Value.Equals(string.Empty)) buttonStyle.buttonStyleRed(buttonErrors, "The parking name space field can't be empty."); else if (textboxTotalSpace.Value.Equals(string.Empty)) buttonStyle.buttonStyleWhite(buttonErrors, "The total space field can't be empty."); else if (textboxCarSpace.Value.Equals(string.Empty)) buttonStyle.buttonStyleRed(buttonErrors, "The car space field can't be empty."); else if (textboxMotorCycleSpace.Value.Equals(string.Empty)) buttonStyle.buttonStyleWhite(buttonErrors, "The motorcycle space field can't be empty."); else if (textboxBusSpace.Value.Equals(string.Empty)) buttonStyle.buttonStyleRed(buttonErrors, "The bus space field can't be empty."); else if (textboxHandicapSpace.Value.Equals(string.Empty)) buttonStyle.buttonStyleWhite(buttonErrors, "The handicap space field can't be empty."); else { parking.Name = textboxParkingName.Value; parking.TotalSpace = Convert.ToInt32(textboxTotalSpace.Value); parking.FreeSpace = parking.TotalSpace; parking.CarSpace = Convert.ToInt32(textboxCarSpace.Value); parking.MotorcycleSpace = Convert.ToInt32(textboxMotorCycleSpace.Value); parking.HandicapSpace = Convert.ToInt32(textboxHandicapSpace.Value); parking.BusSpace = Convert.ToInt32(textboxBusSpace.Value); parking.Height = Convert.ToInt32(textHeight.Value); parking.Width = Convert.ToInt32(textWidth.Value); if (hiddenCampusValue.Value.Equals(string.Empty)) { try { parking.CampusId = Convert.ToInt32(selectCampus.Items[0].Value); parking.CampusName = selectCampus.Items[0].Text; } catch (Exception) { buttonStyle.buttonStyleRed(buttonErrors, "The select campus is empty."); return null; } } else { parking.CampusId = Convert.ToInt32(hiddenCampusValue.Value); parking.CampusName = selectCampus.Items.FindByValue(hiddenCampusValue.Value).ToString(); } return parking; } return null; } catch (FormatException) { buttonStyle.buttonStyleRed(buttonErrors, "Invalid data. You can't enter \n only numbers in parking name," + "\n" + "letters in space fields," + "\n " + "or empty fields."); return null; } }
protected void UpdateParking(Parking parking) { if (parking != null) { switch (parkingBussinessRules.UpdateParking(parking)) { case 0: ClearControls(); buttonStyle.buttonStyleBlue(buttonErrors, "Parking created sucessfully."); break; case 1: buttonStyle.buttonStyleRed(buttonErrors, "The parking name field is empty."); break; case 2: buttonStyle.buttonStyleWhite(buttonErrors, "The total space field can't be less or equal than zero"); break; case 3: buttonStyle.buttonStyleRed(buttonErrors, "The car space field can't be less than zero."); break; case 4: buttonStyle.buttonStyleWhite(buttonErrors, "The motorcycle space field can't be less than zero."); break; case 5: buttonStyle.buttonStyleBlue(buttonErrors, "The handicap space field can't be less than zero."); break; case 6: buttonStyle.buttonStyleWhite(buttonErrors, "The bus space field can't be less than zero."); break; case 7: buttonStyle.buttonStyleRed(buttonErrors, "You can't enter zero in all space fields or less than zero."); break; case 8: buttonStyle.buttonStyleWhite(buttonErrors, "The sum of space fields can't be higher than the total space."); break; case 9: buttonStyle.buttonStyleWhite(buttonErrors, "The sum of space fields can't be less than the total space."); break; case 10: buttonStyle.buttonStyleWhite(buttonErrors, "An error ocurred updating the parking, please check data or contact with us."); break; } } }
protected void InsertParking(Parking parking) { if (parking != null) { switch (parkingBussinessRules.InsertParking(parking)) { case 0: parking.SpaceList = CreateSpaceListWithMap(); if (parking.SpaceList != null) { switch (parkingBussinessRules.InsertParkingSpace(parking)) { case 0: ClearControls(); OpenControls(); tableGray.Disabled = false; buttonStyle.buttonStyleBlue(buttonErrors2, "Parking created sucessfully."); break; case 1: OpenControls(); buttonStyle.buttonStyleRed(buttonErrors2, "An error ocurred creating the parking spaces."); break; case 2: OpenControls(); buttonStyle.buttonStyleWhite(buttonErrors2, "An error ocurred creating the parking spaces and deleting the parking."); break; } } else { OpenControls(); buttonStyle.buttonStyleRed(buttonErrors, "An error ocurred creating the parking spaces."); parkingBussinessRules.DeleteParking(parking.Id); } break; case 1: OpenControls(); buttonStyle.buttonStyleRed(buttonErrors, "The parking name field is empty."); break; case 2: OpenControls(); buttonStyle.buttonStyleWhite(buttonErrors, "The total space field can't be less or equal than zero"); break; case 3: OpenControls(); buttonStyle.buttonStyleRed(buttonErrors, "The car space field can't be less than zero."); break; case 4: OpenControls(); buttonStyle.buttonStyleWhite(buttonErrors, "The motorcycle space field can't be less than zero."); break; case 5: OpenControls(); buttonStyle.buttonStyleBlue(buttonErrors, "The handicap space field can't be less than zero."); break; case 6: OpenControls(); buttonStyle.buttonStyleWhite(buttonErrors, "The bus space field can't be less than zero."); break; case 7: OpenControls(); buttonStyle.buttonStyleRed(buttonErrors, "You can't enter zero in all space fields."); break; case 8: OpenControls(); buttonStyle.buttonStyleWhite(buttonErrors, "The sum of space fields can't be higher than the total space."); break; case 10: OpenControls(); buttonStyle.buttonStyleWhite(buttonErrors, "An error ocurred creating the parking, please check data or contact with us."); break; case 11: OpenControls(); buttonStyle.buttonStyleWhite(buttonErrors, "The sum of space fields can't be less than the total space."); break; } } }
public void UpdateParking(Parking parking) { connection = ManageDatabaseConnection("Open"); using (SqlCommand update = new SqlCommand(@"UpdateParking", connection)) { update.CommandType = CommandType.StoredProcedure; update.Parameters.Add("@Id", SqlDbType.Int).Value = parking.Id; update.Parameters.Add("@Name", SqlDbType.VarChar).Value = parking.Name; update.Parameters.Add("@TotalSpace", SqlDbType.Int).Value = parking.TotalSpace; update.Parameters.Add("@CarSpace", SqlDbType.Int).Value = parking.CarSpace; update.Parameters.Add("@MotorcycleSpace", SqlDbType.Int).Value = parking.MotorcycleSpace; update.Parameters.Add("@HandicapSpace", SqlDbType.Int).Value = parking.HandicapSpace; update.Parameters.Add("@BusSpace", SqlDbType.Int).Value = parking.BusSpace; update.Parameters.Add("@CampusId", SqlDbType.Int).Value = parking.CampusId; update.ExecuteNonQuery(); } connection = ManageDatabaseConnection("Close"); }
public Parking SendParkingInfo(DataTable dtParking) { Parking parking = new Parking(); if (dtParking.Rows.Count > 0) { parking.Width = Convert.ToInt32(dtParking.Rows[0]["Width"]); parking.Height = Convert.ToInt32(dtParking.Rows[0]["Height"]); return parking; } else return null; }
public Parking SendParking(DataTable dataTableParkingInfo) { Parking parking = new Parking(); parking.Name = dataTableParkingInfo.Rows[0]["Name"].ToString(); parking.TotalSpace = Convert.ToInt32(dataTableParkingInfo.Rows[0]["TotalSpace"]); parking.CarSpace = Convert.ToInt32(dataTableParkingInfo.Rows[0]["CarSpace"]); parking.MotorcycleSpace = Convert.ToInt32(dataTableParkingInfo.Rows[0]["MotorcycleSpace"]); parking.HandicapSpace = Convert.ToInt32(dataTableParkingInfo.Rows[0]["HandicapSpace"]); parking.BusSpace = Convert.ToInt32(dataTableParkingInfo.Rows[0]["BusSpace"]); parking.CampusId = Convert.ToInt32(dataTableParkingInfo.Rows[0]["CampusId"]); return parking; }
public void InsertParking(Parking parking) { connection = ManageDatabaseConnection("Open"); using (SqlCommand insert = new SqlCommand(@"InsertParking", connection)) { insert.CommandType = CommandType.StoredProcedure; insert.Parameters.Add("@Name", SqlDbType.VarChar).Value = parking.Name; insert.Parameters.Add("@CampusId", SqlDbType.Int).Value = parking.CampusId; insert.Parameters.Add("@CampusName", SqlDbType.VarChar).Value = parking.CampusName; insert.Parameters.Add("@Height", SqlDbType.Int).Value = parking.Height; insert.Parameters.Add("@Width", SqlDbType.Int).Value = parking.Width; insert.Parameters.Add("@TotalSpace", SqlDbType.Int).Value = parking.TotalSpace; insert.Parameters.Add("@FreeSpace", SqlDbType.Int).Value = parking.FreeSpace; insert.Parameters.Add("@CarSpace", SqlDbType.Int).Value = parking.CarSpace; insert.Parameters.Add("@MotorcycleSpace", SqlDbType.Int).Value = parking.MotorcycleSpace; insert.Parameters.Add("@HandicapSpace", SqlDbType.Int).Value = parking.HandicapSpace; insert.Parameters.Add("@BusSpace", SqlDbType.Int).Value = parking.BusSpace; insert.ExecuteNonQuery(); } connection = ManageDatabaseConnection("Close"); }
protected void GenerateMap() { try { buttonErrors2.Visible = true; buttonErrors2.Value = "Click on a space " + "\n" + " to reserve it."; //Building an HTML string. StringBuilder html = new StringBuilder(); Parking parking = new Parking(); List<Space> spaceList = new List<Space>(); int parkingId; int campusId; //Cleaning last table placeHolderMap.Controls.Clear(); if (hiddenCampusValue.Value.Equals(string.Empty)) campusId = Convert.ToInt32(selectCampus.Items[0].Value); else campusId = Convert.ToInt32(hiddenCampusValue.Value); if (hiddenParkingValue.Value.Equals(string.Empty)) parkingId = Convert.ToInt32(selectParking.Items[0].Value); else parkingId = Convert.ToInt32(hiddenParkingValue.Value); parking = parkingData.SendParkingInfo(parkingData.GetParking(parkingId)); spaceList = spaceData.SendParkingSpaceList(spaceData.DataTableParkingSpace(campusId, parkingId)); if (parking != null) { if (spaceList != null) { for (int i = 0; i < parking.Width; i++) { html.Append("<tr>"); for (int j = 0; j < parking.Height; j++) { foreach (Space space in spaceList) { if (space.Position == i + "," + j) { switch (space.SpaceType.Id) { case 1: html.Append("<td>"); html.Append("<button type='button' onclick='getSpaceId(this, 'hiddenSpaceValue')' id='buttonSpaceCar' value='" + space.Id +"'>" + space.Name + "</button>"); html.Append("</td>"); break; case 2: html.Append("<td>"); html.Append("<button type='button' onclick='getSpaceId(this, 'hiddenSpaceValue')' id='buttonSpaceMoto' value='" + space.Id + "'>" + space.Name + "</button>"); html.Append("</td>"); break; case 3: html.Append("<td>"); html.Append("<button type='button' onclick='getSpaceId(this, 'hiddenSpaceValue')' id='buttonSpaceHandicap' disabled='disabled' value='" + space.Id + "'>" + space.Name + "</button>"); html.Append("</td>"); break; case 4: html.Append("<td>"); html.Append("<button type='button' onclick='getSpaceId(this, 'hiddenSpaceValue')' id='buttonSpaceBus' value='" + space.Id + "'>" + space.Name + "</button>"); html.Append("</td>"); break; case 5: html.Append("<td>"); html.Append("<button type='button' onclick='getSpaceId(this, 'hiddenSpaceValue')' id='buttonSpaceStreet' disabled='disabled' value='" + space.Id + "'>" + space.Name + "</button>"); html.Append("</td>"); break; case 6: html.Append("<td>"); html.Append("<button type='button' onclick='getSpaceId(this, 'hiddenSpaceValue')' id='buttonSpaceClear' disabled='disabled' value='" + space.Id + "'>" + space.Name + "</button>"); html.Append("</td>"); break; } } } } html.Append("</tr>"); } //Append the HTML string to Placeholder. placeHolderMap.Controls.Add(new Literal { Text = html.ToString() }); } else buttonStyle.buttonStyleRed(buttonErrors2, "Spaces in parking not found."); } else buttonStyle.buttonStyleRed(buttonErrors2, "Parking not found."); } catch (Exception) { buttonStyle.buttonStyleRed(buttonErrors2, "An error ocurred generating the parking."); } }
public int UpdateParking(Parking parking) { if (parking.Name.Equals(string.Empty)) return 1; else if (parking.TotalSpace <= 0) return 2; else if (parking.CarSpace < 0) return 3; else if (parking.MotorcycleSpace < 0) return 4; else if (parking.HandicapSpace < 0) return 5; else if (parking.BusSpace < 0) return 6; else if (parking.CarSpace + parking.MotorcycleSpace + parking.HandicapSpace + parking.BusSpace <= 0) return 7; else if (parking.CarSpace + parking.MotorcycleSpace + parking.HandicapSpace + parking.BusSpace > parking.TotalSpace) return 8; else if (parking.CarSpace + parking.MotorcycleSpace + parking.HandicapSpace + parking.BusSpace < parking.TotalSpace) return 9; else if (parking.CampusId.Equals(string.Empty)) return 12; else { try { parkingData.UpdateParking(parking); return 0; } catch (SqlException) { return 10; } } }