public IHttpActionResult GetPasvaldibasApmeklejumiBasic(string id)
{
var municipality = _db.Pasvaldibas.Include("Deputati").FirstOrDefault(x => x.Code == id);
if (municipality != null)
{
var result = new PasvaldibaViewModel
{
PasvaldibaName = municipality.Name,
PasvaldibaCode = municipality.Code,
Deputies = new List <DeputyViewModel>()
};
var deputies = municipality.Deputati.OrderBy(x => x.Name);
foreach (var deputats in deputies)
{
var deputyModel = new DeputyViewModel
{
Id = deputats.DeputatsId,
Name = deputats.Name,
AttendedCount = 0,
NotAttendedCount = 0
};
_db.Entry(deputats).Collection(x => x.ApmekletasSedes).Load();
foreach (var apmekletaSede in deputats.ApmekletasSedes)
{
if (apmekletaSede.Apmekleja)
{
deputyModel.AttendedCount++;
}
else
{
deputyModel.NotAttendedCount++;
}
}
deputyModel.AllCount = deputyModel.AttendedCount + deputyModel.NotAttendedCount;
result.Deputies.Add(deputyModel);
}
return(Ok(result));
}
;
return(null);
}
public IHttpActionResult GetPasvaldibasApmeklejumi(string id)
{
var municipality = _db.Pasvaldibas.Include("Deputati").FirstOrDefault(x => x.Code == id);
if (municipality != null)
{
var result = new PasvaldibaViewModel
{
PasvaldibaName = municipality.Name,
PasvaldibaCode = municipality.Code,
Deputies = new List <DeputyViewModel>()
};
foreach (var deputats in municipality.Deputati)
{
var deputyModel = new DeputyViewModel
{
Id = deputats.DeputatsId,
Name = deputats.Name,
AttendedCount = 0,
NotAttendedCount = 0,
NotAttendedCountReasons = new Dictionary <string, int>()
};
_db.Entry(deputats).Collection(x => x.ApmekletasSedes).Load();
foreach (var apmekletaSede in deputats.ApmekletasSedes)
{
if (apmekletaSede.Apmekleja)
{
deputyModel.AttendedCount++;
}
else
{
deputyModel.NotAttendedCount++;
var iemesls = apmekletaSede.NeapmeklesanasIemesls.Length > 3
? apmekletaSede.NeapmeklesanasIemesls
: "Nav zināms";
if (deputyModel.NotAttendedCountReasons.ContainsKey(iemesls))
{
deputyModel.NotAttendedCountReasons[iemesls] =
deputyModel.NotAttendedCountReasons[iemesls] + 1;
}
else
{
deputyModel.NotAttendedCountReasons.Add(iemesls, 1);
}
}
}
deputyModel.AllCount = deputyModel.AttendedCount + deputyModel.NotAttendedCount;
result.Deputies.Add(deputyModel);
}
return(Ok(result));
}
;
return(null);
}