public void SaveVccData(VCCRootData vCCRootData)
{
try
{
_vccIntegrationRepository.Save(vCCRootData);
}
catch (Exception e)
{
throw e;
}
}
public void Post(VCCRootData dto)
{
_VccIntergrationManager.SaveVccData(dto);
}
public void Save(VCCRootData vccRootData)
{
SqlConnection connection = new SqlConnection(ConnectionString);
for (int i = 0; i < vccRootData.Carparks.Count; i++)
{
#region sp1
//var argsVccCampusParking = new Dictionary<string, object>
//{
// {"@AsOf", vccRootData.AsOf},
// {"@ParkId", vccRootData.Carparks[i].Id},
// {"@ParkName", vccRootData.Carparks[i].Name},
// {"@Usable", vccRootData.Carparks[i].TotalsDetailed.All.Usable},
// {"@Vacant", vccRootData.Carparks[i].TotalsDetailed.All.Vacant},
// {"@Occupied", vccRootData.Carparks[i].TotalsDetailed.All.Occupied },
// {"@Unknown", vccRootData.Carparks[i].TotalsDetailed.All.Unknown},
//};
//var resultVccCampusParking = ExecuteScalarAsync<int>(VccCampusParking, argsVccCampusParking);
//for (int j = 0; j < vccRootData.Carparks[i].Areas.Count; j++)
//{
// var argsVccCampusAreaParking = new Dictionary<string, object>
// {
// {"@AsOf", vccRootData.AsOf},
// {"@AreaId", vccRootData.Carparks[i].Areas[j].Id},
// {"@AreaName", vccRootData.Carparks[i].Areas[j].Name},
// {"@Usable", vccRootData.Carparks[i].Areas[j].TotalsDetailed.All.Usable},
// {"@Vacant", vccRootData.Carparks[i].Areas[j].TotalsDetailed.All.Vacant},
// {"@Occupied", vccRootData.Carparks[i].Areas[j].TotalsDetailed.All.Occupied },
// {"@Unknown", vccRootData.Carparks[i].Areas[j].TotalsDetailed.All.Unknown},
// {"@ParkId", vccRootData.Carparks[i].Id},
// {"@ParkName", vccRootData.Carparks[i].Name},
// };
// var resultVccAreaParking = ExecuteScalarAsync<int>(VccAreaParking, argsVccCampusAreaParking);
//}
#endregion
// Save Vcc Campus Parking
SqlCommand cmdVccCampusParking = new SqlCommand("uspVccCampusParking", connection);
cmdVccCampusParking.Parameters.Add("@AsOf", System.Data.SqlDbType.DateTime).Value = vccRootData.AsOf;
cmdVccCampusParking.Parameters.Add("@ParkId", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].Id;
cmdVccCampusParking.Parameters.Add("@ParkName", System.Data.SqlDbType.VarChar).Value = vccRootData.Carparks[i].Name;
cmdVccCampusParking.Parameters.Add("@Usable", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].TotalsDetailed.All.Usable;
cmdVccCampusParking.Parameters.Add("@Vacant", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].TotalsDetailed.All.Vacant;
cmdVccCampusParking.Parameters.Add("@Occupied", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].TotalsDetailed.All.Occupied;
cmdVccCampusParking.Parameters.Add("@Unknown", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].TotalsDetailed.All.Unknown;
connection.Open();
cmdVccCampusParking.CommandType = System.Data.CommandType.StoredProcedure;
cmdVccCampusParking.ExecuteNonQuery();
connection.Close();
// Save Vcc Area Parking
for (int j = 0; j < vccRootData.Carparks[i].Areas.Count; j++)
{
SqlCommand cmdVccAreaParking = new SqlCommand("uspVccAreaParking", connection);
cmdVccAreaParking.Parameters.Add("@AsOf", System.Data.SqlDbType.DateTime).Value = vccRootData.AsOf;
cmdVccAreaParking.Parameters.Add("@AreaId", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].Areas[j].Id;
cmdVccAreaParking.Parameters.Add("@AreaName", System.Data.SqlDbType.VarChar).Value = vccRootData.Carparks[i].Areas[j].Name;
cmdVccAreaParking.Parameters.Add("@Usable", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].Areas[j].TotalsDetailed.All.Usable;
cmdVccAreaParking.Parameters.Add("@Vacant", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].Areas[j].TotalsDetailed.All.Vacant;
cmdVccAreaParking.Parameters.Add("@Occupied", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].Areas[j].TotalsDetailed.All.Occupied;
cmdVccAreaParking.Parameters.Add("@Unknown", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].Areas[j].TotalsDetailed.All.Unknown;
cmdVccAreaParking.Parameters.Add("@ParkId", System.Data.SqlDbType.Int).Value = vccRootData.Carparks[i].Id;
cmdVccAreaParking.Parameters.Add("@ParkName", System.Data.SqlDbType.VarChar).Value = vccRootData.Carparks[i].Name;
connection.Open();
cmdVccAreaParking.CommandType = System.Data.CommandType.StoredProcedure;
cmdVccAreaParking.ExecuteNonQuery();
connection.Close();
}
}
}
