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