public SponsorNew(ISurveyRepository repo, Instance version) { SurveyRepository = repo; Version = version; }
public ActionResult Edit(int projectVersionId, int previousVersionId) { Instance version = new Instance() { ProjectVersionId = projectVersionId , PreviousVersionId = previousVersionId , UpdateStatusId = (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Edited }; IAmendmentStrategy strategy = new AmendmentStrategy(_surveyRepository, version).PickStrategy(); projectVersionId = strategy.Amend(); return RedirectToAction("Info", new { controller = "Survey", id = projectVersionId, message = "Amendment processed successfully." }); }
/* *Get Current Amendment Status * Does project need to be copied? * Amend Project * Check if Previous Active Amendment needs to be changed to inactive * Return to details page */ public AmendmentStrategy(ISurveyRepository repo, Instance version) { SurveyRepository = repo; Version = version; }
public void SetSurveyStatus(Instance version) { IList<SqlParameter> parms = new List<SqlParameter>(); string sproc = string.Empty; version.UpdateStatusId = (version.UpdateStatusId == (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Revised) ? (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Edited : version.UpdateStatusId; switch (version.UpdateStatusId) { case (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Completed: sproc = "[Survey].[SetOpenToPublic]"; parms.Add(new SqlParameter("@ProjectVersionId", version.ProjectVersionId)); parms.Add(new SqlParameter("@EndConstructionYear", version.EndConstructionYear)); parms.Add(new SqlParameter("@UpdateStatusId", version.UpdateStatusId)); break; case (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Edited: case (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Withdrawn: case (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Reviewed: case (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Accepted: case (int)DRCOG.Domain.Enums.SurveyUpdateStatus.Current: case (int)DRCOG.Domain.Enums.SurveyUpdateStatus.AwaitingAction: sproc = "[Survey].[UpdateProjectUpdateStatusId]"; parms.Add(new SqlParameter("@ProjectVersionId", version.ProjectVersionId)); parms.Add(new SqlParameter("@UpdateStatusId", version.UpdateStatusId)); break; } using (SqlCommand command = new SqlCommand(sproc) { CommandType = CommandType.StoredProcedure }) { foreach (SqlParameter p in parms) { command.Parameters.Add(p); } this.ExecuteNonQuery(command); } }