public void Data_Delete(int bandit_id) { InterpolContext context = new InterpolContext(); Spirit spirit_remove = context.Spirits.Where(c => c.person_id == bandit_id).FirstOrDefault(); Parameter par_remove = context.Parameters.Where(c => c.person_id == bandit_id).FirstOrDefault(); Passport pass_remove = context.Passports.Where(c => c.person_id == bandit_id).FirstOrDefault(); Criminal criminal_remove = context.Criminals.Where(c => c.person_id == bandit_id).FirstOrDefault(); Permit permit_remove = context.Permits.Where(c => c.person_id == bandit_id).FirstOrDefault(); context.Permits.Remove(permit_remove); context.Spirits.Remove(spirit_remove); context.Parameters.Remove(par_remove); context.Passports.Remove(pass_remove); context.Criminals.Remove(criminal_remove); context.SaveChanges(); if (context.PSRelations.Any(c => c.person_id == bandit_id)) { PSRelation rel = context.PSRelations.Where(c => c.person_id == bandit_id).FirstOrDefault(); context.PSRelations.Remove(rel); context.SaveChanges(); } context.SaveChanges(); Person person_remove = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault(); context.Persons.Remove(person_remove); context.SaveChanges(); GlobalTab.count_datarows--; }
public void Syndicate_Delete(int synd_id) { InterpolContext context = new InterpolContext(); if (context.PSRelations.Any(c => c.sys_id == synd_id)) { var relation_list = context.PSRelations.Where(c => c.sys_id == synd_id).ToList(); context.PSRelations.RemoveRange(relation_list); context.SaveChanges(); } context.SaveChanges(); Syndicate syndicate = context.Syndicates.Where(c => c.syn_id == synd_id).FirstOrDefault(); context.Syndicates.Remove(syndicate); context.SaveChanges(); }
public void UpdatePerson_Language(int bandit_id, string new_bandit_language) { InterpolContext context = new InterpolContext(); var person = context.Spirits.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_language = new_bandit_language; context.SaveChanges(); }
//--------------------------------- // Spirits table - //--------------------------------- public void UpdatePerson_Religion(int bandit_id, string new_bandit_religion) { InterpolContext context = new InterpolContext(); var person = context.Spirits.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_religion = new_bandit_religion; context.SaveChanges(); }
public void UpdatePerson_Birthday(int bandit_id, string new_bandit_birthday) { InterpolContext context = new InterpolContext(); var person = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_birthday = new_bandit_birthday; context.SaveChanges(); }
//--------------------------------- // Passports table - //--------------------------------- public void UpdatePerson_Citizenship(int bandit_id, string new_bandit_citizen) { InterpolContext context = new InterpolContext(); var person = context.Passports.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_citizenship = new_bandit_citizen; context.SaveChanges(); }
public void UpdatePerson_Role(int bandit_id, string new_bandit_role) { InterpolContext context = new InterpolContext(); var person = context.Criminals.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_role = new_bandit_role; context.SaveChanges(); }
//--------------------------------- // Criminals table - //--------------------------------- public void UpdatePerson_Profession(int bandit_id, string new_bandit_profession) { InterpolContext context = new InterpolContext(); var person = context.Criminals.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_profession = new_bandit_profession; context.SaveChanges(); }
public void UpdatePerson_Haircolor(int bandit_id, string new_bandit_haircolor) { InterpolContext context = new InterpolContext(); var person = context.Parameters.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_haircolor = new_bandit_haircolor; context.SaveChanges(); }
public void UpdatePerson_Weight(int bandit_id, int new_bandit_Weight) { InterpolContext context = new InterpolContext(); var person = context.Parameters.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_weight = new_bandit_Weight; context.SaveChanges(); }
public void UpdatePerson_Photo(int bandit_id, string new_bandit_photo) { InterpolContext context = new InterpolContext(); var person = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.photo_path = new_bandit_photo; context.SaveChanges(); }
public void UpdatePerson_Status(int bandit_id, string new_bandit_status) { InterpolContext context = new InterpolContext(); var person = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_status = new_bandit_status; context.SaveChanges(); }
public void UpdatePerson_Nationality(int bandit_id, string new_bandit_nationality) { InterpolContext context = new InterpolContext(); var person = context.Passports.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_nationality = new_bandit_nationality; context.SaveChanges(); }
public void UpdatePerson_Nickname(int bandit_id, string new_bandit_nickname) { InterpolContext context = new InterpolContext(); var person = context.Persons.Where(c => c.person_id == bandit_id).FirstOrDefault(); person.person_nickname = new_bandit_nickname; context.SaveChanges(); }
public void Delete_From_Syndicate(int bandit_id) { InterpolContext context = new InterpolContext(); PSRelation syndicate_person = context.PSRelations.Where(c => c.person_id == bandit_id).FirstOrDefault(); context.PSRelations.Remove(syndicate_person); context.SaveChanges(); }
public void OpenPermit(int bandit_id) { InterpolContext context = new InterpolContext(); var permit = context.Permits.Where(c => c.person_id == bandit_id).FirstOrDefault(); permit.permit_value = "Свободна"; context.SaveChanges(); }
public void CreateSyndicate(string synd_name, string synd_date) { InterpolContext context = new InterpolContext(); Syndicate syn = new Syndicate { syn_name = synd_name, syn_date = synd_date }; context.Syndicates.Add(syn); context.SaveChanges(); }
public void Add_To_Syndicate(int bandit_id, int syndicate_id, string bandit_date) { InterpolContext context = new InterpolContext(); PSRelation rel = new PSRelation { person_id = bandit_id, sys_id = syndicate_id, dateFrom = bandit_date }; context.PSRelations.Add(rel); context.SaveChanges(); }
public void CreateDataRow(string bandit_name, string bandit_nickname, string bandit_birthday, string photo, string bandit_status, string bandit_religion, string bandit_language, string bandit_profession, string bandit_role, int bandit_rise, int bandit_weight, string bandit_eyecolor, string bandit_haircolor, string bandit_citizen, string bandit_nationality) { InterpolContext context = new InterpolContext(); Person person = new Person { person_name = bandit_name, person_nickname = bandit_nickname, person_birthday = bandit_birthday, person_status = bandit_status, photo_path = photo }; context.Persons.Add(person); context.SaveChanges(); int bandit_id = context.Persons.Where(c => c.person_nickname == bandit_nickname).Select(c => c.person_id).FirstOrDefault(); Criminal crim = new Criminal { person_profession = bandit_profession, person_role = bandit_role, person_id = bandit_id }; context.Criminals.Add(crim); context.SaveChanges(); Passport pass = new Passport { person_citizenship = bandit_citizen, person_nationality = bandit_nationality, person_id = bandit_id }; context.Passports.Add(pass); context.SaveChanges(); Spirit sp = new Spirit { person_language = bandit_language, person_religion = bandit_religion, person_id = bandit_id }; context.Spirits.Add(sp); context.SaveChanges(); Parameter par = new Parameter { person_rise = bandit_rise, person_weight = bandit_weight, person_eyecolor = bandit_eyecolor, person_haircolor = bandit_haircolor, person_id = bandit_id }; context.Parameters.Add(par); context.SaveChanges(); Permit permit = new Permit { permit_value = "Свободна", person_id = bandit_id }; context.Permits.Add(permit); context.SaveChanges(); }