public void CreateNewJob(string jobname)
{
//check if already exists.
using (var context = new JobContext())
{
try
{
var job = context.Jobs.First(j => j.name == jobname);
if (job != null)
{
Debug.WriteLine(jobname + "はすでにテーブルに存在しているため追加しませんでした。");
return;
}
}
catch
{
}
}
Job newjob = new Job(jobname);
using (var context = new JobContext())
{
context.Jobs.Add(newjob);
context.SaveChanges();
}
}
public string currentWorkingTime(string jobname)
{
using (var context = new JobContext())
{
var job = context.Jobs.First(j => j.name == jobname);
TimeSpan time = job.currentWorkingTime(DateTime.Now);
return TimeHelper.Timespan2String(time);
}
}
public void DeleteJob(string jobname)
{
using (var context = new JobContext())
{
var job = context.Jobs.First(j => j.name == jobname);
context.Jobs.Remove(job);
context.SaveChanges();
}
}
public List<JobRecord> GetAllJobRecords()
{
try
{
using (var context = new JobContext())
{
var records = from record in context.JobRecords
select record;
return records.ToList();
}
}
catch
{
return null;
}
}
public List<JobRecord> GetAllRecordAboutJob(string jobname)
{
try
{
using (var context = new JobContext())
{
var records = from record in context.JobRecords
where record.name == jobname
select record;
return records.ToList();
}
}
catch
{
return null;
}
}
public List<string> GetJobList()
{
List<string> joblist = new List<string>();
using (var context = new JobContext())
{
foreach (var job in context.Jobs)
{
joblist.Add(job.name);
}
}
return joblist;
}
public string totalWorkingTime(string jobname)
{
using (var context = new JobContext())
{
var job = context.Jobs.First(j => j.name == jobname);
TimeSpan time = TimeHelper.String2Timespan(job.totalWorkingTime);
if (job.isRunning)
time = time.Add(job.currentWorkingTime(DateTime.Now));
return TimeHelper.Timespan2String(time);
}
}
public void StopJob(string jobname)
{
using (var context = new JobContext())
{
var job = context.Jobs.First(j => j.name == jobname);
DateTime now = DateTime.Now;
job.stop(now);
JobRecord record = new JobRecord(job);
context.JobRecords.Add(record);
context.SaveChanges();
}
}
public void StartJob(string jobname)
{
using (var context = new JobContext())
{
var job = context.Jobs.First(j => j.name == jobname);
job.start(DateTime.Now);
context.SaveChanges();
}
}
public bool IsThereJob(string jobname)
{
using (var context = new JobContext())
{
Job job = null;
try
{
job = context.Jobs.First(j => j.name == jobname);
}
catch { }
if (job != null)
return true;
else
return false;
}
}
public bool IsRunningJob(string jobname)
{
using (var context = new JobContext())
{
try
{
var job = context.Jobs.First(j => j.name == jobname);
return job.isRunning;
}
catch
{
return false;
}
}
}