public TypeConsultationPermissionItem InsertPermission(TypeConsultationPermissionItem item) { try { TmpTypeConsultationPermission entity = new TmpTypeConsultationPermission { TypeConsultationPermissionID = 0, TypeConsultationID = item.TypeConsultationID, UserID = item.UserID, IsRead = item.IsRead, IsChange = item.IsChange, GUID = item.GUID }; db.TmpTypeConsultationPermissions.Add(entity); db.SaveChanges(); item.ID = entity.ID; item.TypeConsultationPermissionID = entity.TypeConsultationPermissionID; AspNetUsers user = db.AspNetUsers.Find(item.UserID); item.UserName = user.FirstName + " " + user.LastName; return(item); } catch (Exception ex) { exception = ex; return(null); } }
public TypeConsultationPermissionItem UpdatePermission(TypeConsultationPermissionItem item) { try { TmpTypeConsultationPermission entity = new TmpTypeConsultationPermission { ID = item.ID, TypeConsultationPermissionID = item.TypeConsultationPermissionID, TypeConsultationID = item.TypeConsultationID, UserID = item.UserID, IsRead = item.IsRead, IsChange = item.IsChange, GUID = item.GUID }; db.TmpTypeConsultationPermissions.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 TypeConsultationPermissionItem DeletePermission(TypeConsultationPermissionItem item) { try { TmpTypeConsultationPermission entity = new TmpTypeConsultationPermission { ID = item.ID, TypeConsultationPermissionID = item.TypeConsultationPermissionID, TypeConsultationID = item.TypeConsultationID, UserID = item.UserID, IsRead = item.IsRead, IsChange = item.IsChange, GUID = item.GUID }; db.TmpTypeConsultationPermissions.Attach(entity); db.TmpTypeConsultationPermissions.Remove(entity); db.SaveChanges(); return(item); } catch (Exception ex) { exception = ex; return(null); } }