public object AddSubject(subjectTab sub) { var result = objEntity.subjectTabs.Where(s => s.cId == sub.cId && s.subName == sub.subName).FirstOrDefault(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (result == null) { objEntity.subjectTabs.Add(sub); int x = objEntity.SaveChanges(); return(x); } else { return("Exists"); } } catch (Exception) { throw; } }
public object UpdateSubject(subjectTab subjectt) { var result = objEntity.subjectTabs.Where(s => s.subName == subjectt.subName && s.cId == subjectt.cId && s.isActive == true && s.subId == subjectt.subId).FirstOrDefault(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (result == null) { subjectTab objSub = objEntity.subjectTabs.Find(subjectt.subId); if (objSub != null) { objSub.subId = subjectt.subId; objSub.subName = subjectt.subName; objSub.cId = subjectt.cId; } objEntity.Entry(objSub).Property("subName").IsModified = true; objEntity.Entry(objSub).Property("cId").IsModified = true; objEntity.Entry(objSub).Property("subId").IsModified = true; int i = objEntity.SaveChanges(); return(i); } else { return("Exists"); } } catch (Exception) { throw; } }
public object DeleteSubject(subjectTab subject) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { int res = 0; subjectTab objSub = objEntity.subjectTabs.Find(subject.subId); objSub.subId = subject.subId; if (objSub.isActive == true) { objSub.isActive = subject.isActive; res = 1; } else { objSub.isActive = true; res = 0; } objEntity.Entry(objSub).Property("isActive").IsModified = true; int i = objEntity.SaveChanges(); return(i + res); } catch (Exception) { throw; } }