/// <summary>
/// Handles the specified command.
/// </summary>
/// <param name="command">The command.</param>
public void Handle(SetJobLastKnownEventCommand command)
{
var col = command.Database.GetCollection <Schema.JobsTable>(_tableNameHelper.JobTableName);
var results = col.Query()
.Where(x => x.JobName == command.JobName)
.Limit(1)
.ToList();
if (results != null && results.Count == 1)
{ //this job already existed; just update the time stamps to the last run
results[0].JobScheduledTime = command.JobScheduledTime;
results[0].JobEventTime = command.JobEventTime;
}
else
{ //this is a brand new job entry
var record = new JobsTable()
{
JobScheduledTime = command.JobScheduledTime,
JobEventTime = command.JobEventTime,
JobName = command.JobName
};
col.Insert(record);
}
}
// GET: Bilgiler/Details/5
public ActionResult Details(int id)
{
using (BilgiDbEntitiesEntities db = new BilgiDbEntitiesEntities())
{
Bilgiler bilgiler = new Bilgiler();
if (id != 0)
{
bilgiler = db.Bilgiler.Where(x => x.ID == id).FirstOrDefault();
}
int meslekId = int.Parse(bilgiler.Meslek);
int ozurId = int.Parse(bilgiler.OzurGrubu);
int sabikaId = int.Parse(bilgiler.Sabika);
int ehliyetId = int.Parse(bilgiler.Ehliyet);
int askerId = int.Parse(bilgiler.Askerlik);
int calismaId = int.Parse(bilgiler.CalismaDurum);
EngelTablosu engel = db.EngelTablosu.FirstOrDefault(x => x.EngelliID == ozurId);
JobsTable meslek = db.JobsTable.FirstOrDefault(x => x.JobID == meslekId);
CheckTablosu checkSabika = db.CheckTablosu.FirstOrDefault(x => x.CheckID == sabikaId);
CheckTablosu checkAsker = db.CheckTablosu.FirstOrDefault(x => x.CheckID == askerId);
CheckTablosu checkCalisma = db.CheckTablosu.FirstOrDefault(x => x.CheckID == calismaId);
EhliyetTablosu ehliyet = db.EhliyetTablosu.FirstOrDefault(x => x.EhliyetID == ehliyetId);
ViewBag.SelectedMeslek = meslek.Jobs;
ViewBag.SelectedEngel = engel.EngelliTuru;
ViewBag.SelectedAsker = checkAsker.CheckDeger;
ViewBag.SelectedCalisma = checkCalisma.CheckDeger;
ViewBag.SelectedSabika = checkSabika.CheckDeger;
ViewBag.SelectedEhliyet = ehliyet.EhliyetGrup;
return(View(bilgiler));
}
}
public ActionResult DeleteConfirmed(int id)
{
JobsTable jobsTable = db.JobsTable.Find(id);
db.JobsTable.Remove(jobsTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "JobID,Jobs")] JobsTable jobsTable)
{
if (ModelState.IsValid)
{
db.Entry(jobsTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(jobsTable));
}
public ActionResult Create([Bind(Include = "JobID,Jobs")] JobsTable jobsTable)
{
if (ModelState.IsValid)
{
db.JobsTable.Add(jobsTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(jobsTable));
}
// GET: JobsTables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
JobsTable jobsTable = db.JobsTable.Find(id);
if (jobsTable == null)
{
return(HttpNotFound());
}
return(View(jobsTable));
}
