public BaseViewModel()
{
Current = new DRCOG.Domain.Models.Survey.Survey();
Person = new Person();
}
public PartialViewResult CreatePartial(Survey model)
{
LoadSessionData();
CreateProjectViewModel viewModel = _surveyRepository.GetCreateProjectViewModel(model);
return PartialView("~/Views/Survey/Partials/CreatePartial.ascx", viewModel);
}
public int Add(Survey value)
{
return (List.Add(value));
}
public CreateProjectViewModel GetCreateProjectViewModel(Survey model)
{
List<SqlParameter> improvementTypeParams = new List<SqlParameter>();
improvementTypeParams.Add(new SqlParameter("@TimePeriodId", model.Id));
return new CreateProjectViewModel()
{
Survey = model
,
AvailableImprovementTypes = AvailableImprovementTypes(improvementTypeParams)
};
}
public Survey GetCurrentSurvey()
{
Survey model = new Survey();
SqlCommand cmd = new SqlCommand("[Survey].[GetCurrentSurvey]");
cmd.CommandType = CommandType.StoredProcedure;
using (IDataReader rdr = this.ExecuteReader(cmd))
{
if (rdr.Read())
{
model.Id = rdr["TimePeriodId"].ToString().SmartParseDefault<int>(default(int));
model.Name = rdr["TimePeriod"].ToString();
model.OpeningDate = rdr["OpeningDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
model.ClosingDate = rdr["ClosingDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
//model.AcceptedDate = rdr["AcceptedDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
}
else
{
model = null;
}
}
return model;
}
public void SetSurveyDates(Survey model)
{
using (SqlCommand command = new SqlCommand("[Survey].[SetSurveyDates]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@TimePeriodId", model.Id);
if (!model.OpeningDate.Equals(DateTime.MinValue))
{
command.Parameters.AddWithValue("@OpeningDate", model.OpeningDate);
}
if (!model.ClosingDate.Equals(DateTime.MinValue))
{
command.Parameters.AddWithValue("@ClosingDate", model.ClosingDate);
}
this.ExecuteNonQuery(command);
}
}
public void OpenSurveyNow(Survey model)
{
using (SqlCommand command = new SqlCommand("[Survey].[OpenSurveyNow]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@TimePeriodId", model.Id);
this.ExecuteNonQuery(command);
}
}
public Survey GetSurveyDates(Survey model)
{
using (SqlCommand command = new SqlCommand("[Survey].[GetSurveyDates]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@TimePeriodId", model.Id);
using (IDataReader rdr = this.ExecuteReader(command))
{
while (rdr.Read())
{
model.OpeningDate = rdr["OpeningDate"].ToString().SmartParseDefault<DateTime>(default(DateTime));
model.ClosingDate = rdr["ClosingDate"].ToString().SmartParseDefault<DateTime>(default(DateTime));
}
}
}
return model;
}
public Survey GetSurvey(string year)
{
SqlCommand cmd = new SqlCommand("[Survey].[GetSummary]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Year", year);
Survey model = new Survey();
using (IDataReader rdr = this.ExecuteReader(cmd))
{
if (rdr.Read())
{
model.Id = rdr["Id"].ToString().SmartParseDefault<int>(default(int));
model.Name = rdr["Name"].ToString();
model.OpeningDate = rdr["OpeningDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
model.ClosingDate = rdr["ClosingDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
model.AcceptedDate = rdr["AcceptedDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
}
else
{
model = null;
}
}
return model;
}
/// <summary>
/// Populate view model for Plan List
/// </summary>
/// <returns></returns>
public ListViewModel GetListViewModel()
{
ListViewModel model = new ListViewModel();
SqlCommand cmd = new SqlCommand("[Survey].[GetList]");
cmd.CommandType = CommandType.StoredProcedure;
IList<Survey> surveyList = new List<Survey>();
Survey sm = null;
using (IDataReader rdr = this.ExecuteReader(cmd))
{
//be sure we got a reader
while (rdr.Read())
{
sm = new Survey();
sm.Id = rdr["TimePeriodId"].ToString().SmartParseDefault<int>(default(int));
sm.Name = rdr["TimePeriod"].ToString();
sm.OpeningDate = rdr["OpeningDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
sm.ClosingDate = rdr["ClosingDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
sm.AcceptedDate = rdr["AcceptedDate"].ToString().SmartParseDefault<DateTime>(DateTime.MinValue);
surveyList.Add(sm);
}
}
model.SurveyList = surveyList;
return model;
}
