public static void AddVirtualHouse(VirtualHouse VirtualHouse)
{
using (ElectionContext db = new ElectionContext())
{
db.VirtualHouse.Add(VirtualHouse);
db.SaveChanges();
}
}
public static void DeleteVirtualRegion(VirtualRegion VirtualRegion)
{
using (ElectionContext db = new ElectionContext())
{
db.VirtualRegion.Remove(VirtualRegion);
db.SaveChanges();
}
}
public static void DeleteElection(Election election)
{
using (ElectionContext db = new ElectionContext())
{
db.Election.Remove(election);
db.SaveChanges();
}
}
public static void AddVirtualRegion(VirtualRegion VirtualRegion)
{
using (ElectionContext db = new ElectionContext())
{
db.VirtualRegion.Add(VirtualRegion);
db.SaveChanges();
}
}
public static void AddElection(Election election)
{
using (ElectionContext db = new ElectionContext())
{
db.Election.Add(election);
db.SaveChanges();
}
}
////////Громадянин:
//подати звернення до голови вiртуальноЁ дiльницi (у будь - який час);
//INSERT INTO citizen_feedback(election_id, virtual_house_id, citizen_id, text)
// VALUES(,,)
public static void AddCitizenFeedback(CitizenFeedback citizenFeedback)
{
using (ElectionContext db = new ElectionContext())
{
db.CitizenFeedback.Add(citizenFeedback);
db.SaveChanges();
}
}
//проголосувати(пiд час виборiв, тiльки один раз);
//IF(EXISTS(SELECT vote_id FROM vote WHERE citizen_id = c_id AND election_id = e_id), , )
//INSERT INTO vote(election_id, virtual_house_id, citizen_id, candidate_id)
// VALUES(,,);
public static void AddVote(Vote vote)
{
using (ElectionContext db = new ElectionContext())
{
db.Vote.Add(vote);
db.SaveChanges();
}
}
public static void DeleteCitizen(Citizen Citizen)
{
using (ElectionContext db = new ElectionContext())
{
db.Citizen.Remove(Citizen);
db.SaveChanges();
}
}
//////////Спостерiгач:
//переглянути перелiк виборцiв вiртуальноЁ дiльницi(у будь - який час);
//уже описаний у попередніх запитах//
//переглянути звернення громадян(у будь - який час);
//SELECT * FROM citizen_feedback
//WHERE virtual_house_id = id AND election_id = e_id;
//уже описаний у попередніх запитах//
//подати скаргу (пiд час виборiв);
//INSERT INTO observer_feedback(election_id, virtual_house_id, observer_id, text)
// VALUES(,,);
public static void AddObserverFeedback(ObserverFeedback observerFeedback)
{
using (ElectionContext db = new ElectionContext())
{
db.ObserverFeedback.Add(observerFeedback);
db.SaveChanges();
}
}
public static void AddCitizen(Citizen Citizen)
{
using (ElectionContext db = new ElectionContext())
{
db.Citizen.Add(Citizen);
db.SaveChanges();
}
}
public static void DeleteVirtualHouse(VirtualHouse VirtualHouse)
{
using (ElectionContext db = new ElectionContext())
{
db.VirtualHouse.Remove(VirtualHouse);
db.SaveChanges();
}
}
//вилучити громадянина зi своєї вiртуальної дiльницi (до початку виборiв);
public static void DeleteCitizenFromVirtualHouse(Citizen citizen, VirtualHouse virtualHouse)
{
using (ElectionContext db = new ElectionContext())
{
var citizenVirtualHouse = db.CitizenVirtualHouse.
Where(e => e.VirtualHouseId == virtualHouse.VirtualHouseId &&
e.CitizenId == citizen.CitizenId).OrderByDescending(e => e.RegistrationTime).First();
citizenVirtualHouse.IsActive = false;
db.SaveChanges();
}
}
public static void UpdateChiefHouseOfficer(int ChiefHouseOfficerId, Citizen citizen)
{
using (ElectionContext db = new ElectionContext())
{
var dbChiefHouseOfficer = db.ChiefHouseOfficer.Where(e => e.ChiefHouseOfficerId == ChiefHouseOfficerId).First();
if (dbChiefHouseOfficer != null)
{
dbChiefHouseOfficer.CitizenId = citizen.CitizenId;
}
db.SaveChanges();
}
}
public static void UpdateElection(Election election)
{
using (ElectionContext db = new ElectionContext())
{
var dbElection = db.Election.Where(e => e.ElectionId == election.ElectionId).First();
if (dbElection != null)
{
dbElection = election;
}
db.SaveChanges();
}
}
public static void UpdateVirtualRegion(VirtualRegion VirtualRegion)
{
using (ElectionContext db = new ElectionContext())
{
var dbVirtualRegion = db.VirtualRegion.Where(e => e.VirtualRegionId == VirtualRegion.VirtualRegionId).First();
if (dbVirtualRegion != null)
{
dbVirtualRegion = VirtualRegion;
}
db.SaveChanges();
}
}
public static void UpdateCitizen(Citizen Citizen)
{
using (ElectionContext db = new ElectionContext())
{
var dbCitizen = db.Citizen.Where(e => e.CitizenId == Citizen.CitizenId).First();
if (dbCitizen != null)
{
dbCitizen = Citizen;
}
db.SaveChanges();
}
}
public static void UpdateVirtualHouse(VirtualHouse VirtualHouse)
{
using (ElectionContext db = new ElectionContext())
{
var dbVirtualHouse = db.VirtualHouse.Where(e => e.VirtualHouseId == VirtualHouse.VirtualHouseId).First();
if (dbVirtualHouse != null)
{
dbVirtualHouse = VirtualHouse;
}
db.SaveChanges();
}
}
//////////Голова дільничної комісії
//виборці віртуальної дільниці
//уже описаний у попередніх запитах//
//долучити громадянина (без визначеноЁ дiльницi) до сво№Ё вiртуальноЁ дiльницi (до початку виборiв);
public static void AddCitizenToVirtualHouse(Citizen citizen, VirtualHouse virtualHouse)
{
using (ElectionContext db = new ElectionContext())
{
db.CitizenVirtualHouse.Add(new CitizenVirtualHouse
{
CitizenId = citizen.CitizenId,
VirtualHouseId = virtualHouse.VirtualHouseId,
RegistrationTime = DateTime.Now,
IsActive = true
});
db.SaveChanges();
}
}
//////////////Голова окружної комісії
//обрати чи змiнити голiв дiльничних комiсiй (до початку виборiв);
//INSERT INTO chief_house_officer(election_id, virtual_house_id, citizen_id)
// VALUES(,,);
//UPDATE chief_house_officer
//SET citizen_id = id
//WHERE chief_house_officer=1;
public static void AddChiefHouseOfficer(Election election, VirtualHouse VirtualHouse, Citizen citizen)
{
using (ElectionContext db = new ElectionContext())
{
var ChiefHouseOfficer = new ChiefHouseOfficer
{
ElectionId = election.ElectionId,
VirtualHouseId = VirtualHouse.VirtualHouseId,
CitizenId = citizen.CitizenId
};
db.ChiefHouseOfficer.Add(ChiefHouseOfficer);
db.SaveChanges();
}
}
////////////Голова ЦВК
//обрати чи змiнити голiв окружних комiсiй (до початку виборiв);
//database.Add(chief_region_officer);
//var id = 1;
//var virtual_house = database.First(cro => cro.chief_region_officer_id == id);
public static void AddChiefRegionOfficer(Election election, VirtualRegion virtualRegion, Citizen citizen)
{
using (ElectionContext db = new ElectionContext())
{
var chiefRegionOfficer = new ChiefRegionOfficer
{
ElectionId = election.ElectionId,
VirtulRegionId = virtualRegion.VirtualRegionId,
CitizenId = citizen.CitizenId
};
db.ChiefRegionOfficer.Add(chiefRegionOfficer);
db.SaveChanges();
}
}