public OralConsultationPermissionItem InsertPermission(OralConsultationPermissionItem item) { try { TmpOralConsultationPermission entity = new TmpOralConsultationPermission { OralConsultationPermissionID = 0, OralConsultationID = item.OralConsultationID, UserID = item.UserID, IsRead = item.IsRead, IsChange = item.IsChange, GUID = item.GUID }; db.TmpOralConsultationPermissions.Add(entity); db.SaveChanges(); item.ID = entity.ID; item.OralConsultationPermissionID = entity.OralConsultationPermissionID; AspNetUsers user = db.AspNetUsers.Find(item.UserID); item.UserName = user.FirstName + " " + user.LastName; return(item); } catch (Exception ex) { exception = ex; return(null); } }
public OralConsultationPermissionItem UpdatePermission(OralConsultationPermissionItem item) { try { TmpOralConsultationPermission entity = new TmpOralConsultationPermission { ID = item.ID, OralConsultationPermissionID = item.OralConsultationPermissionID, OralConsultationID = item.OralConsultationID, UserID = item.UserID, IsRead = item.IsRead, IsChange = item.IsChange, GUID = item.GUID }; db.TmpOralConsultationPermissions.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); AspNetUsers user = db.AspNetUsers.Find(item.UserID); item.UserName = user.FirstName + " " + user.LastName; return(item); } catch (Exception ex) { exception = ex; return(null); } }
public OralConsultationPermissionItem DeletePermission(OralConsultationPermissionItem item) { try { TmpOralConsultationPermission entity = new TmpOralConsultationPermission { ID = item.ID, OralConsultationPermissionID = item.OralConsultationPermissionID, OralConsultationID = item.OralConsultationID, UserID = item.UserID, IsRead = item.IsRead, IsChange = item.IsChange, GUID = item.GUID }; db.TmpOralConsultationPermissions.Attach(entity); db.TmpOralConsultationPermissions.Remove(entity); db.SaveChanges(); return(item); } catch (Exception ex) { exception = ex; return(null); } }