public object DeleteTeacherSubject(assignSubTeacherTab assign)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
int res = 0;
assignSubTeacherTab objAssign = objEntity.assignSubTeacherTabs.Find(assign.aId);
objAssign.aId = assign.aId;
if (objAssign.isActive == true)
{
objAssign.isActive = assign.isActive;
res = 1;
}
else
{
objAssign.isActive = true;
res = 0;
}
objEntity.Entry(objAssign).Property("isActive").IsModified = true;
int i = objEntity.SaveChanges();
return(i + res);
}
catch (Exception)
{
throw;
}
}
public object AddTeacherSubject(assignSubTeacherTab assign)
{
var result = objEntity.assignSubTeacherTabs.Where(s => s.uId == assign.uId && s.subId == assign.subId).FirstOrDefault();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
if (result == null)
{
objEntity.assignSubTeacherTabs.Add(new assignSubTeacherTab()
{
uId = assign.uId,
subId = assign.subId,
isActive = true
});
int x = objEntity.SaveChanges();
return(x);
}
else
{
return("Exists");
}
}
catch (Exception)
{
throw;
}
}
public object GetAssignId(assignSubTeacherTab assign)
{
try
{
var result = from assignSubTeacherTabs in db.assignSubTeacherTabs
where
assignSubTeacherTabs.uId == assign.uId &&
assignSubTeacherTabs.subId == assign.subId &&
assignSubTeacherTabs.isActive == true
select new
{
aId = assignSubTeacherTabs.aId,
uId = assignSubTeacherTabs.uId,
subId = assignSubTeacherTabs.subId,
isActive = assignSubTeacherTabs.isActive
};
if (result == null)
{
return("Data not available");
}
else
{
return(result);
}
}
catch (Exception)
{
throw;
}
}
public object EditTeacherSubject(assignSubTeacherTab assign)
{
var result = objEntity.assignSubTeacherTabs.Where(s => s.uId == assign.uId && s.subId == assign.subId).FirstOrDefault();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
assignSubTeacherTab objSub = objEntity.assignSubTeacherTabs.Find(assign.aId);
if (result == null)
{
objEntity.assignSubTeacherTabs.Add(new assignSubTeacherTab()
{
uId = assign.uId,
subId = assign.subId,
isActive = true
});
objEntity.Entry(objSub).Property("uId").IsModified = true;
objEntity.Entry(objSub).Property("subId").IsModified = true;
objEntity.Entry(objSub).Property("isActive").IsModified = true;
int x = objEntity.SaveChanges();
return(x);
}
else
{
return("Exists");
}
}
catch (Exception)
{
throw;
}
}
