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;
}
}
}
