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(); } }