public RAMetaObjektum LoadXmlById(int id)
{
RAMetaObjektum r = null;
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
var query = ctx.RAMetaObjektums
.Where(ss => ss.id == id)
.FirstOrDefault <RAMetaObjektum>();
r = query;
}
string xml = r.serialization;
RAMetaObjektum rResult = null;
XmlSerializer serializer = new XmlSerializer(typeof(RAMetaObjektum));
StringReader reader = new StringReader(xml);
rResult = (RAMetaObjektum)serializer.Deserialize(reader);
reader.Close();
return(rResult);
}
public GovernmentController(RoleManager <IdentityRole> roleManager, UserManager <User> userManager, AllContext context, IWebHostEnvironment appEnvironment)
{
_roleManager = roleManager;
_userManager = userManager;
db = context;
_appEnvironment = appEnvironment;
}
public void ApplyMigrations(AllContext context)
{
if (context.Database.GetPendingMigrations().Any())
{
context.Database.Migrate();
}
}
public EljarasTipus LoadXmlById(int id)
{
EljarasTipus e = null;
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
var query = ctx.EljarasTipuss
.Where(ss => ss.id == id)
.FirstOrDefault <EljarasTipus>();
e = query;
}
string xml = e.serialization;
EljarasTipus eResult = null;
XmlSerializer serializer = new XmlSerializer(typeof(EljarasTipus));
StringReader reader = new StringReader(xml);
eResult = (EljarasTipus)serializer.Deserialize(reader);
reader.Close();
return(eResult);
}
public ActionResult EditReporte(int?Id)
{
if (Id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var db = new AllContext())
{
var reporteUpdate = db.Reportes.Find(Id);
if (TryUpdateModel(reporteUpdate, "",
new string[] { "GastosTransportes", "GastosTransporteAereos", "GastosAlimenticios", "GastosHotelarios", "GastosImprevistos" }))
{
try
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (RetryLimitExceededException /* dex */)
{
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator.");
}
}
return(View(reporteUpdate));
}
}
public Muvelet LoadXmlById(int id)
{
Muvelet m = null;
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
var query = ctx.Muvelets
.Where(ss => ss.id == id)
.FirstOrDefault <Muvelet>();
m = query;
}
string xml = m.serialization;
Muvelet mResult = null;
XmlSerializer serializer = new XmlSerializer(typeof(Muvelet));
StringReader reader = new StringReader(xml);
mResult = (Muvelet)serializer.Deserialize(reader);
reader.Close();
return(mResult);
}
public TablaOszlop LoadXmlById(int id)
{
TablaOszlop t = null;
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
var query = ctx.TablaOszlops
.Where(ss => ss.id == id)
.FirstOrDefault <TablaOszlop>();
t = query;
}
string xml = t.serialization;
TablaOszlop tResult = null;
XmlSerializer serializer = new XmlSerializer(typeof(TablaOszlop));
StringReader reader = new StringReader(xml);
tResult = (TablaOszlop)serializer.Deserialize(reader);
reader.Close();
return(tResult);
}
public Ac4ySDSequence LoadXmlById(int id)
{
Ac4ySDSequence a = null;
using (var ctx = new AllContext(baseName, userName, password))
{
var query = ctx.Ac4ySDSequences
.Where(ss => ss.id == id)
.FirstOrDefault <Ac4ySDSequence>();
a = query;
}
string xml = a.serialization;
Ac4ySDSequence aResult = null;
XmlSerializer serializer = new XmlSerializer(typeof(Ac4ySDSequence));
StringReader reader = new StringReader(xml);
aResult = (Ac4ySDSequence)serializer.Deserialize(reader);
reader.Close();
return(aResult);
}
public Kepernyo LoadXmlById(int id)
{
Kepernyo k = null;
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
var query = ctx.Kepernyos
.Where(ss => ss.id == id)
.FirstOrDefault <Kepernyo>();
k = query;
}
string xml = k.serialization;
Kepernyo kResult = null;
XmlSerializer serializer = new XmlSerializer(typeof(Kepernyo));
StringReader reader = new StringReader(xml);
kResult = (Kepernyo)serializer.Deserialize(reader);
reader.Close();
return(kResult);
}
public List <Reporte> ObtenerTodos()
{
using (var db = new AllContext())
{
return(db.Reportes.ToList());
}
}
/// <summary>
/// возвращает имя годового плана по ид пункта годового плана
/// </summary>
/// <param name="YearEventId"></param>
/// <param name="db"></param>
/// <returns></returns>
static public async Task <string> GetStringDataYear(int YearEventId, AllContext db)
{
YearEvent yearEvent = await db.YearEvents.FirstOrDefaultAsync(y => y.Id == YearEventId);
string hh = yearEvent.DataYear;
return(hh);
}
public void addNew(Ac4yIdentification _Ac4yIdentification)
{
using (var ctx = new AllContext(baseName))
{
ctx.Ac4yIdentifications.Add(_Ac4yIdentification);
ctx.SaveChanges();
}
}
public void addNew(RAMetaObjektum _RAMetaObjektum)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.RAMetaObjektums.Add(_RAMetaObjektum);
ctx.SaveChanges();
}
}
public void addNew(Muvelet _Muvelet)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.Muvelets.Add(_Muvelet);
ctx.SaveChanges();
}
}
public void addNew(Kepernyo _Kepernyo)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.Kepernyos.Add(_Kepernyo);
ctx.SaveChanges();
}
}
public void addNew(TaroltEljaras _TaroltEljaras)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.TaroltEljarass.Add(_TaroltEljaras);
ctx.SaveChanges();
}
}
public void addNew(Modul _Modul)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.Moduls.Add(_Modul);
ctx.SaveChanges();
}
}
public void addNew(Ac4yXMLObject _Ac4yXMLObject)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.Ac4yXMLObjects.Add(_Ac4yXMLObject);
ctx.SaveChanges();
}
}
public void addNew(Ac4ySDSequence _Ac4ySDSequence)
{
using (var ctx = new AllContext(baseName, userName, password))
{
ctx.Ac4ySDSequences.Add(_Ac4ySDSequence);
ctx.SaveChanges();
}
}
public void addNew(TablaOszlop _TablaOszlop)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.TablaOszlops.Add(_TablaOszlop);
ctx.SaveChanges();
}
}
public void addNew(Ac4y _Ac4y)
{
using (var ctx = new AllContext(baseName))
{
ctx.Ac4ys.Add(_Ac4y);
ctx.SaveChanges();
}
}
public void addNew(EljarasTipus _EljarasTipus)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.EljarasTipuss.Add(_EljarasTipus);
ctx.SaveChanges();
}
}
public Ac4ySDSequenceEntityMethods(string newBaseName, string uName, string pwd)
{
baseName = newBaseName;
userName = uName;
password = pwd;
AllContext context = new AllContext(baseName, userName, password);
context.Database.EnsureCreated();
}
public async Task <float> GetFullPriceBNowTotal(List <Agency> agencies, AllContext db, string dataYear)
{
float FullPriceBnow = 0;
foreach (Agency agency in agencies)
{
FullPriceBnow += await GetFullPriceBNowAgency(agency.Id, db, dataYear);
}
return(FullPriceBnow);
}
public TablaOszlopEntityMethods(string sName, string newBaseName, string uName, string pwd)
{
serverName = sName;
baseName = newBaseName;
userName = uName;
password = pwd;
AllContext context = new AllContext(serverName, baseName, userName, password);
context.Database.EnsureCreated();
}
public static int GetNowDoneNotAsync(int YeId, AllContext db)
{
List <PartYearEvent> partYearEventsСonfirmed = db.PartYearEvents
.Where(p => p.YearEventId == YeId && p.Сomment == null && p.UserNameСonfirmed != null).ToList();
int fullDoneNaw = 0;
foreach (var part in partYearEventsСonfirmed)
{
fullDoneNaw += part.Done;
}
return(fullDoneNaw);
}
/// <summary>
/// Возвращает процент выполнения годового плана по году и списку учреждений
/// </summary>
/// <param name="agencies"></param>
/// <param name="db"></param>
/// <param name="dataYear"></param>
/// <returns></returns>
public async Task <decimal> GetProcentTotal(List <Agency> agencies, AllContext db, string dataYear)
{
List <decimal> procents = new List <decimal>();
foreach (Agency ag in agencies)
{
procents.Add(await GetProcentAgency(ag.Id, db, dataYear));
}
decimal aver = procents.Average();
return(aver);
}
/// <summary>
/// возвращает сколько запланировано
/// </summary>
/// <param name="agencies"></param>
/// <param name="db"></param>
/// <returns></returns>
public async Task <int> GetYearPlanCount(List <Agency> agencies, AllContext db, string dataYear)
{
int number = 0;
foreach (Agency agency in agencies)
{
number += await db.YearEvents.Where(y => y.AgencyId == agency.Id)
.Where(y => y.DataYear == dataYear)
.CountAsync();
}
return(number);
}
/// <summary>
/// возвращает стоимость работ по учреждению внебюджет
/// </summary>
/// <param name="agencyId"></param>
/// <param name="db"></param>
/// <returns></returns>
public async Task <float> GetFullPriceNotBNowAgency(int agencyId, AllContext db, string dataYear)
{
float FullPriceNotBnow = 0;
List <YearEvent> yearEvents = await db.YearEvents.Where(y => y.AgencyId == agencyId)
.Where(y => y.DataYear == dataYear)
.ToListAsync();
foreach (var ye in yearEvents)
{
FullPriceNotBnow += await GetFullPriceNotBNow(ye.Id, db);
}
return(FullPriceNotBnow);
}
public ActionResult DeleteReporte(int?Id)
{
using (var db = new AllContext())
{
var query = (from p in db.Reportes
where p.ReporteId == Id
select p).Single();
db.Reportes.Remove(query);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
