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