public IHttpActionResult PutJOBS(int id, JOBS jOBS) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != jOBS.JOB_ID) { return(BadRequest()); } db.Entry(jOBS).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!JOBSExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetJOBS(int id) { JOBS jOBS = db.JOBS.Find(id); if (jOBS == null) { return(NotFound()); } return(Ok(jOBS)); }
public IHttpActionResult PostJOBS(JOBS jOBS) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.JOBS.Add(jOBS); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = jOBS.JOB_ID }, jOBS)); }
public IHttpActionResult DeleteJOBS(int id) { JOBS jOBS = db.JOBS.Find(id); if (jOBS == null) { return(NotFound()); } db.JOBS.Remove(jOBS); db.SaveChanges(); return(Ok(jOBS)); }
List <JOBS> prepareXML(string fileName) { string xmlContent = ""; using (FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read)) using (StreamReader sr = new StreamReader(fs)) xmlContent = sr.ReadToEnd(); XmlDocument doc = new XmlDocument(); doc.LoadXml(xmlContent); List <JOBS> jobsList = new List <JOBS>(); XmlNode form1Node = doc.ChildNodes[1]; for (int i = 0; i < form1Node.ChildNodes.Count; i++) { XmlNode dateNode = form1Node.ChildNodes[i].ChildNodes[0].ChildNodes[0], jobNumNode = form1Node.ChildNodes[i].ChildNodes[1].ChildNodes[0], timeTicksNode = form1Node.ChildNodes[i].ChildNodes[6].ChildNodes[0]; bool foundDate = false; for (int j = 0; j < jobsList.Count; j++) { if (jobsList[j].compareDate(dateNode.Value)) { jobsList[j].addJob(jobNumNode.Value, Math.Round(TimeSpan.FromTicks( (long)Convert.ToDouble(timeTicksNode.Value)).TotalHours, 2).ToString()); foundDate = true; break; } } if (!foundDate) { JOBS job = new JOBS(dateNode.Value); string jbnum = jobNumNode.Value; string tbtck = timeTicksNode.Value; long tktk = Convert.ToInt64(tbtck); double tkdb = TimeSpan.FromTicks(tktk).TotalHours; job.addJob(jobNumNode.Value, Math.Round(TimeSpan.FromTicks( Convert.ToInt64(timeTicksNode.Value)).TotalHours, 2).ToString()); jobsList.Add(job); } } jobsList.OrderByDescending(x => x.jobDate); return(jobsList); }