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);
}
