public Models.Plan GetPlan(int id)
{
Queries.PlanQuery query = new Queries.PlanQuery();
query.IdIs = id;
string connStr =
ConfigurationManager.ConnectionStrings["urbanPlanningDB"].ToString();
using (DbConnection db = new SqlConnection(connStr)) {
db.Open();
var repository = new Repositories.PlanRepository(db);
return((Models.Plan)repository.Single(query));
}
}
public IEnumerable <Models.PlanBrief> GetPlans(
string keyword = null,
string planName = null,
int[] tyviId = null,
string[] generatedPlanId = null,
string[] municipalityPlanId = null,
string[] approver = null,
string planType = null,
Util.DateRange approvalDateWithin = null,
Util.DateRange proposalDateWithin = null,
Util.DateRange initialDateWithin = null,
Util.DateRange fillDateWithin = null,
int[] ely = null,
int[] subRegion = null,
int[] county = null,
int[] greaterArea = null,
int[] administrativeCourt = null,
int[] municipality = null)
{
Queries.PlanQuery query = new Queries.PlanQuery();
if (planName != null)
{
query.NameLike = "%" + planName + "%";
}
query.KeywordSearch = keyword;
query.GeneratedPlanIdIn = generatedPlanId;
query.MunicipalityPlanIdIn = municipalityPlanId;
query.ApproverIn = approver;
query.TyviIdIn = tyviId;
if (planType != null)
{
query.PlanTypeIn = planType.Split(',').ToList().ConvertAll(
x => (new Dictionary <string, int>()
{
{ "T", (int)Queries.PlanQuery.PlanTypes.Normal },
{ "R", (int)Queries.PlanQuery.PlanTypes.BeachPlan },
{ "M", (int)Queries.PlanQuery.PlanTypes.WithUndergroundAreas },
{ "tavallinen", (int)Queries.PlanQuery.PlanTypes.Normal },
{ "rantaasemakaava", (int)Queries.PlanQuery.PlanTypes.BeachPlan },
{ "maanalaistasisaltava", (int)Queries.PlanQuery.PlanTypes.WithUndergroundAreas },
})[x]).ToArray();
}
query.ApprovalDateWithin = approvalDateWithin;
query.ProposalDateWithin = proposalDateWithin;
query.InitialDateWithin = initialDateWithin;
query.FillDateWithin = fillDateWithin;
query.ElyIn = ely;
query.SubRegionIn = subRegion;
query.CountyIn = county;
query.GreaterAreaIn = greaterArea;
query.AdministrativeCourtIn = administrativeCourt;
query.MunicipalityIn = municipality;
string connStr =
ConfigurationManager.ConnectionStrings["urbanPlanningDB"].ToString();
using (DbConnection db = new SqlConnection(connStr)) {
db.Open();
var repository = new Repositories.PlanBriefRepository(db);
return((List <Models.PlanBrief>)repository.FindAll(query));
}
}
