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