public override void ExecuteTask(string[] args) { const string method = "ExecuteTask"; if (args.Length < 2) { throw new ArgumentException("Need at least 2 arguments, \"days batch <iterations>\""); } var days = int.Parse(args[0]); var batch = int.Parse(args[1]); var iterations = args.Length > 2 ? int.Parse(args[2]) : 1; var total = 0; EventSource.Raise(Event.Information, method, "Starting to delete old tiny urls.", Event.Arg("days", days), Event.Arg("batch", batch), Event.Arg("iterations", iterations)); for (var iteration = 0; iteration < iterations; ++iteration) { EventSource.Raise(Event.Information, method, "Deleting old tiny urls.", Event.Arg("days", days), Event.Arg("batch", batch), Event.Arg("iteration", iteration)); using (var dc = new MaintenanceDataContext(_connectionFactory.CreateConnection())) { dc.CommandTimeout = (int)new TimeSpan(2, 0, 0).TotalSeconds; var count = dc.DeleteOldTinyUrls(days, batch); total += count; EventSource.Raise(Event.Information, method, "Old tiny urls deleted.", Event.Arg("count", count), Event.Arg("total", total)); } } }
public SeventhPage() { InitializeComponent(); dc = new MaintenanceDataContext(); dgvEmployees.ItemsSource = dc.Specialities; }
private IList <Guid> GetSearchableMembers() { using (var dc = new MaintenanceDataContext(_connectionFactory.CreateConnection())) { dc.CommandTimeout = (int)new TimeSpan(1, 0, 0).TotalSeconds; return((from m in dc.SearchableMemberEntities select m.id).ToList()); } }
}// lvClient_SelectionChanged // При нажатии кнопки изменить private void change_Click(object sender, RoutedEventArgs e) { try { ChangeClientInfo(); using (dc = new MaintenanceDataContext()) dc.SubmitChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } // try-catch } //change_Click
private void UpdateJobAdIndexing(Guid jobAdId, DateTime modifiedTime) { using (var dc = new MaintenanceDataContext(_connectionFactory.CreateConnection())) { var entity = (from i in dc.JobAdIndexingEntities where i.jobAdId == jobAdId select i).SingleOrDefault(); if (entity == null) { dc.JobAdIndexingEntities.InsertOnSubmit(new JobAdIndexingEntity { jobAdId = jobAdId, modifiedTime = modifiedTime }); } else { entity.modifiedTime = modifiedTime; } dc.SubmitChanges(); } }
private void add_Click(object sender, RoutedEventArgs e) { //проверяет все ли данные введены if (FieldsAreNotFilled()) { MessageBox.Show("Не все данные введены"); return; } using (dc = new MaintenanceDataContext()) { dc.Persons.InsertOnSubmit(GetPerson()); try { dc.SubmitChanges(); MessageBox.Show("Клиент добавлен"); } catch (Exception f) { MessageBox.Show(f.Message); } // try-catch } // using } // add_Click
private IList <Guid> GetOutdatedJobAdIds(DateTime minLastUpdatedTime) { const string method = "GetOutdatedJobAdIds"; EventSource.Raise(Event.Information, method, "Getting outdated job ads.", Event.Arg("minLastUpdatedTime", minLastUpdatedTime)); var jobAdIds = new List <Guid>(); using (var dc = new MaintenanceDataContext(_connectionFactory.CreateConnection())) { dc.CommandTimeout = (int)new TimeSpan(1, 0, 0).TotalSeconds; // Choose all job ads which do not have an indexing entry. var outdatedJobAdIds = (from j in dc.JobAdEntities where !(from i in dc.JobAdIndexingEntities where i.jobAdId == j.id select j).Any() && j.lastUpdatedTime >= minLastUpdatedTime select j.id).ToList(); jobAdIds = jobAdIds.Concat(outdatedJobAdIds).ToList(); EventSource.Raise(Event.Information, method, "Found " + outdatedJobAdIds.Count + " job ads which do not have an indexing entry."); // Choose all job ads that are out of date. outdatedJobAdIds = (from j in dc.JobAdEntities join i in dc.JobAdIndexingEntities on j.id equals i.jobAdId where j.lastUpdatedTime > i.modifiedTime && j.lastUpdatedTime > minLastUpdatedTime select j.id).ToList(); jobAdIds = jobAdIds.Concat(outdatedJobAdIds).ToList(); EventSource.Raise(Event.Information, method, "Found " + outdatedJobAdIds.Count + " job ads which are out of date."); } return(jobAdIds); }
private IList <Guid> GetOutdatedMemberIds(DateTime minLastUpdatedTime) { const string method = "GetOutdatedMemberIds"; EventSource.Raise(Event.Information, method, "Getting outdated members.", Event.Arg("minLastUpdatedTime", minLastUpdatedTime)); var memberIds = new List <Guid>(); using (var dc = new MaintenanceDataContext(_connectionFactory.CreateConnection())) { dc.CommandTimeout = (int)new TimeSpan(1, 0, 0).TotalSeconds; // Choose all members who have a resume but do not have a indexing entry. var outdatedMemberIds = (from m in dc.MemberEntities join c in dc.CandidateEntities on m.id equals c.id join cr in dc.CandidateResumeEntities on c.id equals cr.candidateId join r in dc.ResumeEntities on cr.resumeId equals r.id where !(from i in dc.MemberIndexingEntities where i.memberId == m.id select m).Any() && dc.GetLatestDate(m.lastEditedTime, c.lastEditedTime, r.lastEditedTime) > minLastUpdatedTime select m.id).ToList(); memberIds = memberIds.Concat(outdatedMemberIds).ToList(); EventSource.Raise(Event.Information, method, "Found " + outdatedMemberIds.Count + " members who have a resume but do not have an indexing entry."); // Choose all members who don't have a resume and do not have an indexing entry. outdatedMemberIds = (from m in dc.MemberEntities join c in dc.CandidateEntities on m.id equals c.id where !(from cr in dc.CandidateResumeEntities join r in dc.ResumeEntities on cr.resumeId equals r.id where cr.candidateId == c.id select r).Any() && !(from i in dc.MemberIndexingEntities where i.memberId == m.id select m).Any() && dc.GetLatestDate(m.lastEditedTime, c.lastEditedTime, null) > minLastUpdatedTime select m.id).ToList(); memberIds = memberIds.Concat(outdatedMemberIds).ToList(); EventSource.Raise(Event.Information, method, "Found " + outdatedMemberIds.Count + " members who do not have a resume and do not have an indexing entry."); // Choose all members who have a resume and are out of date. outdatedMemberIds = (from m in dc.MemberEntities join c in dc.CandidateEntities on m.id equals c.id join cr in dc.CandidateResumeEntities on c.id equals cr.candidateId join r in dc.ResumeEntities on cr.resumeId equals r.id join i in dc.MemberIndexingEntities on m.id equals i.memberId where dc.GetLatestDate(m.lastEditedTime, c.lastEditedTime, r.lastEditedTime) > minLastUpdatedTime && dc.GetLatestDate(m.lastEditedTime, c.lastEditedTime, r.lastEditedTime) > i.modifiedTime select m.id).ToList(); memberIds = memberIds.Concat(outdatedMemberIds).ToList(); EventSource.Raise(Event.Information, method, "Found " + outdatedMemberIds.Count + " members who have a resume and are out of date."); // Choose all members who don't have a resume and are out of date. outdatedMemberIds = (from m in dc.MemberEntities join c in dc.CandidateEntities on m.id equals c.id join i in dc.MemberIndexingEntities on m.id equals i.memberId where !(from cr in dc.CandidateResumeEntities join r in dc.ResumeEntities on cr.resumeId equals r.id where cr.candidateId == c.id select r).Any() where dc.GetLatestDate(m.lastEditedTime, c.lastEditedTime, null) > minLastUpdatedTime && dc.GetLatestDate(m.lastEditedTime, c.lastEditedTime, null) > i.modifiedTime select m.id).ToList(); memberIds = memberIds.Concat(outdatedMemberIds).ToList(); EventSource.Raise(Event.Information, method, "Found " + outdatedMemberIds.Count + " members who have don't have a resume and are out of date."); } return(memberIds); }
private void EditClient_Loaded(object sender, RoutedEventArgs e) { using (dc = new MaintenanceDataContext()) { lvClient.ItemsSource = dc.Persons; } // using } // EditClient_Loaded