public DBContextResult <object> Insert(TRN_Notes p_TRN_Notes)
{
return(ExecuteDALMethod <TRN_Notes, object>(db, (DataContext, P_TRN_Notes) =>
{
db.TRN_Notes.Add(P_TRN_Notes);
db.SaveChanges();
return null;
}, p_TRN_Notes));
}
public DBContextResult <object> ChangeNoteImportance(int NoteId, bool IsImportant)
{
return(ExecuteDALMethod <int, object>(db, (DataContext, NoteID) =>
{
TRN_Notes Obj = DataContext.TRN_Notes.Find(NoteID);
Obj.IsImportant = IsImportant;
DataContext.SaveChanges();
return null;
}, NoteId));
}
public DBContextResult <object> Delete(int p_NoteId)
{
return(ExecuteDALMethod <int, object>(db, (DataContext, P_NoteId) =>
{
TRN_Notes Obj = DataContext.TRN_Notes.Find(P_NoteId);
Obj.IsActive = false;
DataContext.SaveChanges();
return null;
}, p_NoteId));
}
public DBContextResult <object> Update(TRN_Notes p_TRN_Notes)
{
return(this.ExecuteDALMethod <TRN_Notes, object>(db, (DataContext, P_TRN_Notes) =>
{
TRN_Notes NoteObj = DataContext.TRN_Notes.Find(P_TRN_Notes.NoteId);
NoteObj.Subject = P_TRN_Notes.Subject;
NoteObj.NoteText = P_TRN_Notes.NoteText;
NoteObj.CreatedDate = P_TRN_Notes.CreatedDate;
NoteObj.ModifiedDate = P_TRN_Notes.ModifiedDate;
DataContext.SaveChanges();
return null;
}, p_TRN_Notes));
}
