public string Update(int id, [FromBody] bookissue i) { var c = (from t in db.bookissues where t.iis == id select t).SingleOrDefault(); if (c == null) { throw new Exception("Issued Id Invalid"); } else { string actual = i.actualreturndate.ToString(); string expected = c.expreturndate.ToString(); c.actualreturndate = i.actualreturndate; TimeSpan ts = Convert.ToDateTime(actual).Subtract(Convert.ToDateTime(expected)); int d = ts.Days; if (d > 0) { c.fine = (10 * d); } else { c.fine = 0; } var result = db.SaveChanges(); if (result > 0) { return("Data Uploaded"); } } return("Error Updating Data"); }
public string Post([FromBody] bookissue p) { p.expreturndate = (Convert.ToDateTime(p.issuedate).AddDays(p.noofdays)).ToString(); db.bookissues.Add(p); var res = db.SaveChanges(); if (res > 0) { return("New Book issue"); } else { return("Error In Issue"); } }