public int Delete(int ID)
{
try
{
tblSemester tb = _db.tblSemesters.Where(s => s.Semester_Id == ID).FirstOrDefault();
_db.tblSemesters.Remove(tb);
return(_db.SaveChanges());
}
catch (Exception Error)
{
throw Error;
}
}
public int Update(SemesterViewModel svm)
{
tblSemester tb = _db.tblSemesters.Where(s => s.Semester_Id == svm.Id).FirstOrDefault();
var semesterName = tb.Semester_Name;
tb.Semester_Name = svm.Semester_Name;
_db.SaveChanges();
tblMainLog tml = new tblMainLog();
var principal = System.Security.Claims.ClaimsPrincipal.Current;
string Name = principal.FindFirst(ClaimsIdentity.DefaultNameClaimType).Value;
str = "Semester Name Updated from '" + semesterName + "' " + "to '" + svm.Semester_Name + "' " + "by Admin";
tml.Description = str;
tml.AdminName = Name;
tml.Date = System.DateTime.Now;
tml.EntityId = 7;
tml.ItemId = tb.Semester_Id;
_db.tblMainLogs.Add(tml);
return(_db.SaveChanges());
}
public int Add(SemesterViewModel svm)
{
tblSemester tb = new tblSemester();
tb.Semester_Name = svm.Semester_Name;
_db.tblSemesters.Add(tb);
_db.SaveChanges();
tblMainLog tml = new tblMainLog();
var principal = System.Security.Claims.ClaimsPrincipal.Current;
string Name = principal.FindFirst(ClaimsIdentity.DefaultNameClaimType).Value;
str = "New Semester '" + svm.Semester_Name + "' " + "Added by Admin";
tml.Description = str;
tml.AdminName = Name;
tml.Date = System.DateTime.Now;
tml.EntityId = 7;
tml.ItemId = tb.Semester_Id;
_db.tblMainLogs.Add(tml);
return(_db.SaveChanges());
}