public IHttpActionResult PutDateSheet(int id, DateSheet dateSheet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != dateSheet.ID)
{
return(BadRequest());
}
db.Entry(dateSheet).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DateSheetExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostDateSheet(DateSheet dateSheet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DateSheets.Add(dateSheet);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (DateSheetExists(dateSheet.ID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = dateSheet.ID }, dateSheet));
}
//creating method to add data coming from angular project through url
public async Task <Object> AddFullDetail(DateSheetViewModel dateSheet)
{
if (ModelState.IsValid)
{
DateSheet model = new DateSheet
{
ID = dateSheet.ID,
Class = authDb.Classes.Where(a => a.ID == dateSheet.Class).FirstOrDefault(),
Subject = authDb.Courses.Where(a => a.ID == dateSheet.Subject).FirstOrDefault(),
Teacher = authDb.Teachers.Where(a => a.ID == dateSheet.Teacher).FirstOrDefault(),
Date = dateSheet.Date,
StartDate = dateSheet.StartDate,
EndDate = dateSheet.EndDate,
DateSheetName = dateSheet.DateSheetHeader,
};
if (authDb.DateSheet.Any(a => a.Class == model.Class && a.Date == model.Date))
{
await Task.Run(() => authDb.RemoveRange(authDb.DateSheet.Where(a => a.Class == model.Class && a.Date == model.Date).ToList()));
await authDb.SaveChangesAsync();
}
await Task.Run(() => authDb.AddAsync(model));
await authDb.SaveChangesAsync();
return(Ok("success"));
}
return(BadRequest(ModelState));
}
public ActionResult DeleteConfirmed(int id)
{
DateSheet dateSheet = db.DateSheets.Find(id);
db.DateSheets.Remove(dateSheet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult GetDateSheet(int id)
{
DateSheet dateSheet = db.DateSheets.Find(id);
if (dateSheet == null)
{
return(NotFound());
}
return(Ok(dateSheet));
}
public ActionResult Edit([Bind(Include = "ID,Title,Content,Department")] DateSheet dateSheet)
{
if (ModelState.IsValid)
{
dateSheet.Date = DateTime.Now;
db.Entry(dateSheet).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dateSheet));
}
public IHttpActionResult PostDateSheet(DateSheet dateSheet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DateSheets.Add(dateSheet);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = dateSheet.ID }, dateSheet));
}
public IHttpActionResult DeleteDateSheet(int id)
{
DateSheet dateSheet = db.DateSheets.Find(id);
if (dateSheet == null)
{
return(NotFound());
}
db.DateSheets.Remove(dateSheet);
db.SaveChanges();
return(Ok(dateSheet));
}
//public ActionResult Search()
//{
// return View();
//}
// GET: DateSheets/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DateSheet dateSheet = db.DateSheets.Find(id);
if (dateSheet == null)
{
return(HttpNotFound());
}
return(View(dateSheet));
}
public ActionResult Create(HttpPostedFileBase File)
{
DateSheet dateSheet = new DateSheet();
TryUpdateModel(dateSheet);
if (ModelState.IsValid)
{
dateSheet.Date = DateTime.Now;
var filePath = uploadFile(File);
if (filePath != "")
{
dateSheet.ContentUrl = filePath;
db.DateSheets.Add(dateSheet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
DateSheetViewModel viewModel = new DateSheetViewModel();
TryUpdateModel(viewModel);
return(View(viewModel));
}
