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
