public IHttpActionResult PutProjectViewModel(int id, ProjectViewModel projectviewmodel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != projectviewmodel.ProjectID) { return(BadRequest()); } db.Entry(projectviewmodel).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProjectViewModelExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
// PUT api/TimeSheets/5 public IHttpActionResult PutTimeSheet(int id, TimeSheetViewModel timesheet) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != timesheet.TimeSheetID) { return(BadRequest()); } db.Entry(timesheet).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TimeSheetExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public static void AddOption(string fixtureID, string workcenter, string optionName, double prodTime, int?SectionLength = null) { using (var db = new TimeContext()) { var fixture = db.Fixtures.Where(item => item.FxCode == fixtureID && item.WorkCenter == workcenter).FirstOrDefault(); if (fixture == null) { FixtureTB.AddInstance(fixtureID, workcenter); } fixture = db.Fixtures.Where(item => item.FxCode == fixtureID && item.WorkCenter == workcenter).FirstOrDefault(); OptionTB optionindex = new OptionTB(); if (SectionLength == null) { optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime).FirstOrDefault(); } else { optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime && item.sectionLength == SectionLength).FirstOrDefault(); } if (!fixture.Options.Contains(optionindex)) { fixture.Options.Add(optionindex); } db.SaveChanges(); } }
public static void AddOption(string product, string workcenter, string optionName, double prodTime, int?SectionLength = null) { using (var db = new TimeContext()) { var prod = db.Prod.Where(item => item.ProdCode == product && item.WorkCenter == workcenter).FirstOrDefault(); OptionTB optionindex = new OptionTB(); if (SectionLength == null) { optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime).FirstOrDefault(); } else { optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime && item.sectionLength == SectionLength).FirstOrDefault(); } if (!prod.Options.Contains(optionindex)) { prod.Options.Add(optionindex); } db.SaveChanges(); } }
static void saveToDB(TimeContext db, Time time) { Console.WriteLine(time.Output); db.Times.Add(time); db.SaveChanges(); Console.WriteLine("Data was successfully saved!"); }
public static void AddInstance(string ParamName, string ParamValue) { using (var db = new TimeContext()) { var paramindex = db.Params.Where(item => item.ParamName == ParamName && item.ParamValue == ParamValue).FirstOrDefault(); if (paramindex == null) { db.Params.Add(new ParametersTB { ParamName = ParamName, ParamValue = ParamValue }); } db.SaveChanges(); } }
public static void AddInstance(string FamCode, string workcenter) { using (var db = new TimeContext()) { var prod = db.ProdFam.Where(item => item.FamCode == FamCode && item.WorkCenter == workcenter).FirstOrDefault(); if (prod == null) { db.ProdFam.Add(new ProdFamTB { FamCode = FamCode, WorkCenter = workcenter }); } db.SaveChanges(); } }
static void Main(string[] args) { using (var context = new TimeContext()) { var emp = new Employee() { FirstName = "Joe", LastName = "Smith", YearlySalarhy = 75000m }; context.Employees.Add(emp); context.SaveChanges(); Console.WriteLine($"New Employee ID: {emp.EmployeeID}"); Console.ReadLine(); } }
public static void AddInstance(string FixtureCode, string WorkCenter) { using (var db = new TimeContext()) { var fixture = db.Fixtures.Where(item => item.FxCode == FixtureCode && item.WorkCenter == WorkCenter).FirstOrDefault(); if (fixture == null) { db.Fixtures.Add(new FixtureTB { FxCode = FixtureCode, WorkCenter = WorkCenter }); } db.SaveChanges(); } }
public ActionResult TimeFormatting() { int formatDuration = 0; if (int.TryParse(Request["Time"].ToString(), out formatDuration)) { ViewBag.OutputData = TimeCalculations.Calculations(formatDuration); db.Times.Add(new Time() { Output = ViewBag.OutputData }); db.SaveChanges(); } else { ViewBag.OutputData = "The number is too large or wrong input data."; } return(View("Index", db.Times.ToList().Reverse <Time>().Take(5).Reverse())); }
private void computeButton_Click(object sender, EventArgs e) { formatDuration = 0; if (int.TryParse(inputData.Text, out formatDuration)) { outputCurrent.Text = TimeCalculations.Calculations(formatDuration); db.Times.Add(new Time() { Output = outputCurrent.Text }); db.SaveChanges(); OnLoad(e); } else { outputCurrent.Text = "The number is too large or wrong input data."; } inputData.Clear(); }
public static void AddInstance(string optionName, double ProdTime, int?SectionLength = null) { using (var db = new TimeContext()) { var optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == ProdTime && item.sectionLength == SectionLength).FirstOrDefault(); if (optionindex == null) { db.Options.Add(new OptionTB { OptionName = optionName, ProdTime = ProdTime, sectionLength = SectionLength }); } db.SaveChanges(); } }
public Optic(string paramFilePath) { string optionName = this.GetType().Name; var dt = ConvertCSVtoDataTable(paramFilePath); var newSort = (from row in dt.AsEnumerable() group row by new { ID = row.Field <string>("Family Product"), Optic = row.Field <string>("Optic"), Length = row.Field <string>("Length"), Workcenter = row.Field <string>("Work Center") } into grp select new { ProdFam = grp.Key.ID, Optic = grp.Key.Optic, Length = grp.Key.Length, workcenter = grp.Key.Workcenter, Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time (min)"))) }).ToList(); using (var db = new TimeContext()) { foreach (var row in newSort) { ProdFamTB.AddInstance(row.ProdFam, row.workcenter); int length = Int32.Parse(row.Length); OptionTB.AddInstance(optionName, row.Sum, length); ParametersTB.AddInstance("Optic", row.Optic); OptionTB.AddParam(optionName, row.Sum, "Optic", row.Optic); ProdFamTB.AddOption(row.ProdFam, row.workcenter, optionName, row.Sum, length); db.SaveChanges(); } } }
public static void AddParam(string optionName, double prodTime, string ParamName, string ParamValue, int?SectionLength = null) { using (var db = new TimeContext()) { OptionTB optionindex = new OptionTB(); if (SectionLength == null) { optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime).FirstOrDefault(); } else { optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime && item.sectionLength == SectionLength).FirstOrDefault(); } var paramindex = db.Params.Where(item => item.ParamName == ParamName && item.ParamValue == ParamValue).FirstOrDefault(); if (!optionindex.Params.Contains(paramindex)) { optionindex.Params.Add(paramindex); db.SaveChanges(); } } }
public static void AddOption(string FamCode, string workcenter, string optionName, double prodTime, int?SectionLength = null) { using (var db = new TimeContext()) { var prodfam = db.ProdFam.Where(item => item.FamCode == FamCode && item.WorkCenter == workcenter).FirstOrDefault(); if (prodfam == null) { ProdFamTB.AddInstance(FamCode, workcenter); } prodfam = db.ProdFam.Where(item => item.FamCode == FamCode && item.WorkCenter == workcenter).FirstOrDefault(); var optionindex = db.Options.Where(item => item.OptionName == optionName && item.ProdTime == prodTime && item.sectionLength == SectionLength).FirstOrDefault(); if (!prodfam.Options.Contains(optionindex)) { prodfam.Options.Add(optionindex); } db.SaveChanges(); } }
public void Save() { _context.SaveChanges(); }
public void save() { m_context.SaveChanges(); }