private void UpdateDatabase(BaseCore campus, BaseCore vkd) { var t = campus.LocalTable; var y = vkd.LocalTable; DataCheck(ref t, ref y); campus.UpdateDataBase(t); DeleteCheck(ref t, ref y, campus); campus.UpdateDataBase(t); }
protected void DeleteCheck(ref DataTable campus, ref DataTable Vkd, BaseCore campusBaseCore) { var employeesId = campus.AsEnumerable().Select(o => new { EmpId = o["ID_employee"], SubId = o["ID_Subdivision"] }).Distinct(); foreach (var ident in employeesId) { var empl = Vkd.AsEnumerable().Where(p => p["ID_employee"].ToString() == ident.EmpId.ToString() && p["ID_Subdivision"].ToString() == ident.SubId.ToString()) .Select(u => u["Surname"]).ToList(); if (!empl.Any()) { var employees = campus.Select("ID_employee=" + ident.EmpId.ToString()); foreach (var row in employees) { if (row["vcChangeStatus"].ToString() != "Видалено") { row["vcChangeStatus"] = "Видалено"; row["vcChangeDate"] = DateTime.Now; NLogCore.LogStatusAplication("Запис з ідентифікатором eEmployees1Id=" + row["eEmployees1Id"] + " видалено"); } } campusBaseCore.UpdateDataBase(campus); } } }