public static void Delete(int equationId)
{
using (EquationEntities entities = new EquationEntities())
{
var equationFile = entities.EquationFiles.FirstOrDefault(x => x.EquationFileId == equationId);
entities.EquationFiles.Remove(equationFile);
entities.SaveChanges();
}
}
public static IQueryable <EquationFile> GetList()
{
EquationEntities _equationListEntities = new EquationEntities();
var equationList = from e in _equationListEntities.EquationFiles
orderby e.EquationFileId
select e;
return(equationList);
}
public static long SaveEquationFile(EquationFile equationFile)
{
long id = 0;
using (EquationEntities entities = new EquationEntities())
{
entities.EquationFiles.Add(equationFile);
entities.SaveChanges();
id = equationFile.EquationFileId;
}
return(id);
}
public static void LogError(string errorMessage)
{
using (EquationEntities entities = new EquationEntities())
{
ErrorLog errorLog = new ErrorLog();
errorLog.UserId = 1;
errorLog.ErrorMessage = errorMessage;
errorLog.InsertDate = DateTime.Now;
entities.ErrorLogs.Add(errorLog);
entities.SaveChanges();
}
}
public static void LogActivity(List <int> tagSubjectRelationIds, long equationid)
{
using (EquationEntities entities = new EquationEntities())
{
foreach (var item in tagSubjectRelationIds)
{
TagSubjectRelationEquation _tagSubjectRelationEquation = new TagSubjectRelationEquation();
_tagSubjectRelationEquation.EquationId = equationid;
_tagSubjectRelationEquation.TagSubjectRelationId = item;
entities.TagSubjectRelationEquations.Add(_tagSubjectRelationEquation);
entities.SaveChanges();
}
}
}