public Spot UpdateMultipleSpots(Spot currentSpot, List<int> spotIdsToUpdate)
{
try
{
currentSpot.LastUpdatedBy = Security.GetCurrentUserId;
currentSpot.LastUpdatedOn = DateTime.Now;
foreach (int spotId in spotIdsToUpdate)
{
currentSpot.SpotId = spotId;
currentSpot.Update();
}
return currentSpot;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(new Exception(string.Format("Could not Update the following list of IDs: {0}", String.Join(",", Array.ConvertAll<int, string>(spotIdsToUpdate.ToArray(), new Converter<int, string>(Convert.ToString))), ex)));
throw new Exception("An error occurred while trying to delete the spot(s).");
}
}
public Spot UpdateSpot(Spot spot)
{
try
{
spot.LastUpdatedBy = Security.GetCurrentUserId;
spot.LastUpdatedOn = DateTime.Now;
spot.Update();
return spot;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to update the spot.");
}
}
public List<SpotConflict> SaveMultiStationSpot(Spot spot, int numberOfWeeks, List<int> stationIds)
{
try
{
spot.EnteredBy = Security.GetCurrentUserId;
spot.EnteredOn = DateTime.Now;
spot.LastUpdatedBy = Security.GetCurrentUserId;
spot.LastUpdatedOn = DateTime.Now;
DataTable stations = PopulateStationIdTable(stationIds);
List<SpotConflict> conflicts = Spot.SaveMultiStationSpot(spot, stations);
int prevMonth = spot.Month;
for (int i = 1; i < numberOfWeeks; i++)
{
spot.SpotDate = spot.SpotDate.AddDays(7);
spot.Year = spot.SpotDate.Year;
spot.Month = spot.SpotDate.Month;
spot.Week = (spot.SpotDate.Month == prevMonth ? spot.Week + 1 : 1);
prevMonth = spot.SpotDate.Month;
foreach (SpotConflict conflict in Spot.SaveMultiStationSpot(spot, stations))
{
conflicts.Add(conflict);
}
//conflicts.Add(Spot.SaveMultiStationSpot(spot, stations));
}
return conflicts;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to add the spot.");
}
}
public SpotConflict SaveSpot(Spot spot)
{
try
{
//return InnerSaveSpot(spot);
SpotConflict spotContflicts = new SpotConflict();
try
{
InnerSaveSpot(spot);
}
catch (SpotConflictException)
{
spotContflicts = new SpotConflict(spot.SpotDate);
}
return spotContflicts;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to save the spot.");
}
}
public List<SpotConflict> SaveMultipleSpots(Spot spot, int numberOfWeeks)
{
try
{
DateTime spotDate = spot.SpotDate;
List<Spot> spots = new List<Spot>();
List<SpotConflict> spotConflicts = new List<SpotConflict>();
//This *should* not need to be checked as a user can not add a spot into a non-empty cell
spots.Add(InnerSaveSpot(spot));
Spot newSpot;
int prevMonth = spot.Month;
int week = spot.Week;
for (int i = 1; i < numberOfWeeks; i++)
{
spotDate = spotDate.AddDays(7);
week = (spotDate.Month == prevMonth ? week + 1 : 1);
newSpot = new Spot(spot.StationId, spot.StationSpotId, spot.SpotTypeId
, spotDate, spotDate.Year, spotDate.Month, week
, spot.CampaignName, spot.CampaignNumber, spot.Description);
prevMonth = spotDate.Month;
try
{
spots.Add(InnerSaveSpot(newSpot));
}
catch (SpotConflictException)
{
spotConflicts.Add(new SpotConflict(spotDate));
}
}
return spotConflicts;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to save the spot.");
}
}
public Spot LoadSpot(int spotId)
{
try
{
Spot spot = new Spot(spotId);
return spot;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to load the spot.");
}
}
/// <summary>TBD</summary>
/// <param name="spot">TBD</param>
/// <returns>TBD</returns>
public Spot InnerSaveSpot(Spot spot)
{
spot.EnteredBy = Security.GetCurrentUserId;
spot.EnteredOn = DateTime.Now;
spot.LastUpdatedBy = Security.GetCurrentUserId;
spot.LastUpdatedOn = DateTime.Now;
spot.Save();
return spot;
}
public SpotCampaignDetail GetSpotCampaignDetail(Spot spot)
{
try
{
return SpotCampaignDetail.GetSpotCampaignDetail(spot.StationId, spot.StationSpotId, spot.SpotDate, spot.CampaignName, spot.CampaignNumber);
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occured while trying to retrieve the Campaign detail for the selected spot.");
}
}
/// <summary>TBD</summary>
/// <param name="spot">TBD</param>
/// <param name="stations">TBD</param>
/// <returns>TBD</returns>
public static List<SpotConflict> SaveMultiStationSpot(Spot spot, DataTable stations)
{
DataSet conflicts;
using (IO io = new IO(WebCommon.DigitalAvailsConnectionString))
{
using (SqlCommand cmd = IO.CreateCommandFromStoredProc("DigitalAvails_AddSpotToMultipleStations"))
{
cmd.Parameters.Add(Param.CreateParam("STATIONIDS", SqlDbType.Structured, stations));
cmd.Parameters.Add(Param.CreateParam("STATIONSPOTID", SqlDbType.Int, spot.StationSpotId));
cmd.Parameters.Add(Param.CreateParam("SPOTTYPEID", SqlDbType.Int, spot.SpotTypeId));
cmd.Parameters.Add(Param.CreateParam("SPOTDATE", SqlDbType.Date, spot.SpotDate));
cmd.Parameters.Add(Param.CreateParam("YEAR", SqlDbType.Int, spot.Year));
cmd.Parameters.Add(Param.CreateParam("MONTH", SqlDbType.Int, spot.Month));
cmd.Parameters.Add(Param.CreateParam("WEEK", SqlDbType.Int, spot.Week));
cmd.Parameters.Add(Param.CreateParam("CAMPAIGNNAME", SqlDbType.VarChar, spot.CampaignName.Trim()));
if (!String.IsNullOrEmpty(spot.Description.Trim()))
{
cmd.Parameters.Add(Param.CreateParam("DESCRIPTION", SqlDbType.VarChar, spot.Description.Trim()));
}
if (!String.IsNullOrEmpty(spot.CampaignNumber.Trim()))
{
cmd.Parameters.Add(Param.CreateParam("CAMPAIGNNUMBER", SqlDbType.VarChar, spot.CampaignNumber));
}
cmd.Parameters.Add(Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, spot.EnteredBy));
cmd.Parameters.Add(Param.CreateParam("ENTEREDON", SqlDbType.DateTime, spot.EnteredOn));
cmd.Parameters.Add(Param.CreateParam("LASTUPDATEDBY", SqlDbType.VarChar, spot.LastUpdatedBy));
cmd.Parameters.Add(Param.CreateParam("LASTUPDATEDON", SqlDbType.DateTime, spot.LastUpdatedOn));
conflicts = io.ExecuteDataSetQuery(cmd);
}
}
return SpotConflict.GetMultiStationSpotConflicts(conflicts);
}
