public ActionResult Create([Bind(Include = "Id,Name,Description")] Company company) { if (ModelState.IsValid) { db.Companies.Add(company); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(company)); }
public ActionResult Create([Bind(Include = "AppId,AppName")] App app) { if (ModelState.IsValid) { db.Apps.Add(app); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(app)); }
public ActionResult Create([Bind(Include = "JobId,Time,Day,Success,Files_DwUp,Files_Sorted,AppId")] Job job) { if (ModelState.IsValid) { db.Jobs.Add(job); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AppId = new SelectList(db.Apps, "AppId", "AppName", job.AppId); return(View(job)); }
private void SaveToDatabase() { string message; try { foreach (JobWrapper job in jobsList.Where(j => j.IsModified)) { if (db.Jobs.Any(j => j.Id == job.Id)) { Job result = db.Jobs.SingleOrDefault(j => j.Id == job.Id); result.JobDetails = job.JobDetails; result.JobDate = job.JobDate; } else { db.Jobs.Add(job.Job); } } db.SaveChanges(); message = "SaveSuccess"; Messenger.Default.Send(new NotificationMessage(message)); GetJobsAsync(); } catch (SqlException ex) { SendError("SaveError", ex); } }
public void DeleteJobById(int jobId) { using var db = new JobsContext(); var jobToDelete = db.Jobs.Find(jobId); db.Jobs.Remove(jobToDelete); db.SaveChanges(); }
public bool AddJobs([FromForm] JobsVM model) { var category = db.Categories.FirstOrDefault(c => c.Name == model.Category) ?? new Category { Name = model.Category }; var job = new Job { Category = category, Deadline = DateTime.Parse(model.Deadline), Priority = model.Priority, Status = (JobStatus)model.Status, Description = model.Description, }; db.Jobs.Add(job); db.SaveChanges(); return(true); }
public Job add(Job job) { using (var db = new JobsContext()) { db.Jobs.Add(job); db.SaveChanges(); } return(job); }
public Company add(Company company) { using (var db = new JobsContext()) { db.Companies.Add(company); db.SaveChanges(); } return(company); }
private static void PopulateAddressTable() { using (TransactionScope transaction = new TransactionScope()) { using (JobsContext db = new JobsContext()) { #region//person1 //TO-DO: check whether person exists first... ContactPerson person1 = new ContactPerson { FirstName = "Ray", LastName = "Oflite" }; db.People.Add(person1); db.SaveChanges(); Address person1Addr = new Address { Street = "8 Adams", City = "Detroit", StateProvince = "MI", PostalCode = "01237", ContactPersonId = person1.Id }; db.Addresses.Add(person1Addr); #endregion //////////////////////////////////////// #region//person 'Brice' var Brice = db.People.Where(p => p.FirstName == "Brice").Single(); Address personBriceAddr = new Address { Street = "8 Adams", City = "Detroit", StateProvince = "MI", PostalCode = "01237", ContactPersonId = Brice.Id }; db.Addresses.Add(personBriceAddr); #endregion try { db.SaveChanges(); transaction.Complete(); } catch (Exception ex) { Console.WriteLine(ex); } } } }
//automapper? public Jobs UpdateJob(int jobIdToEdit, Jobs updateJobValues) { using var db = new JobsContext(); var JobToEdit = db.Jobs.First(Jobs => Jobs.Id == jobIdToEdit); JobToEdit.Company = updateJobValues.Company; JobToEdit.JobTitle = updateJobValues.JobTitle; JobToEdit.Description = updateJobValues.Description; JobToEdit.Salary = updateJobValues.Salary; JobToEdit.DateCreated = updateJobValues.DateCreated; db.SaveChanges(); return(JobToEdit); }
public List <WeatherForecast> WeatherForecasts() { using (var db = new JobsContext()) { var rng = new Random(); for (int i = 0; i < 10; i++) { db.WeatherForecasts.Add(new WeatherForecast { DateFormatted = DateTime.Now.AddDays(i).ToString("d"), TemperatureC = rng.Next(-20, 55), Summary = Summaries[rng.Next(Summaries.Length)] }); } db.SaveChanges(); return(db.WeatherForecasts.ToList()); } }
public static void Initialize(JobsContext jobsApplied) { jobsApplied.Database.EnsureCreated(); if (jobsApplied.JobsModel.Any()) { return; } var jobs = new JobsModel { ID = 1, company = "Amazon", title = "Software Engineer", job_number = "000001", last_checked = DateTime.Parse("2020-05-01"), last_updated = DateTime.Parse("2020-04-01"), date_applied = DateTime.Parse("2020-03-01"), status = "Active", notes = "Still Active", interview = true, rejected = false, city = "Seattle", state = "Washington", country = "United States" }; jobsApplied.JobsModel.AddRange(jobs); jobsApplied.SaveChanges(); }
public void CreateCompany(Company newCompany) { using var db = new JobsContext(); db.Add(newCompany); db.SaveChanges(); }
public void CreateJob(Jobs newJob) { using var db = new JobsContext(); db.Add(newJob); db.SaveChanges(); }