public DataResponse <EntityList <T> > GetList <T>(IQueryable <T> query) { //int count = query.Count(); DataResponse <EntityList <T> > response = new DataResponse <EntityList <T> >(); EntityList <T> entity = new EntityList <T>(); try { entity.Pager = new DataPager { TotalCount = query.Count() }; entity.List = query.ToList(); if (entity.List == null) { response.CreateResponse(null, DataResponseStatus.NoContent); } else { response.CreateResponse(entity, DataResponseStatus.OK); } } catch (Exception ex) { //ex.Log(); response.ThrowError(ex); } return(response); }
public DataResponse <EntityList <T> > GetList <T>(IEnumerable <T> query, int skip, int take) { //int count = query.Count(); DataResponse <EntityList <T> > response = new DataResponse <EntityList <T> >(); EntityList <T> entity = new EntityList <T>(); try { entity.Pager = new DataPager { TotalCount = query.Count(), Skip = skip, Take = take }; entity.List = query.Skip(skip).Take(take).ToList(); if (entity.List == null) { response.CreateResponse(null, DataResponseStatus.NoContent); } else { response.CreateResponse(entity, DataResponseStatus.OK); } } catch (Exception ex) { response.ThrowError(ex); } return(response); }
public DataResponse <EntityProfile> GetUserDeviceIdById(int UserId) { DataResponse <EntityProfile> response = new DataResponse <EntityProfile>(); try { base.DBInit(); var query = DBEntity.UserProfiles.Where(a => a.UserId == UserId).FirstOrDefault(); var entity = new EntityProfile { Id = query.UserId.Value, DeviceId = query.DeviceId }; if (query != null) { response.CreateResponse(entity, DataResponseStatus.OK); } else { response.CreateResponse(DataResponseStatus.InternalServerError); } } catch (Exception ex) { response.ThrowError(ex); } finally { base.DBClose(); } return(response); }
public DataResponse UpdateNotification(long id, long userId) { var response = new DataResponse(); try { DBInit(); var model = DBEntity.NotificationUsers.Where(t => t.NotificationId == id).FirstOrDefault(); model.IsRead = true; var rowCount = DBSaveUpdate(model); if (rowCount > 0) { response.CreateResponse(DataResponseStatus.OK); } else { response.CreateResponse(DataResponseStatus.NotModified); } } catch (Exception ex) { response.ThrowError(ex); } finally { DBClose(); } return(response); }
public DataResponse <EntityNote> GetNoteById(int ParentId, int ParentTypeId) { DataResponse <EntityNote> response = new DataResponse <EntityNote>(); try { base.DBInit(); base.DBInit(); var query = DBEntity.Notes.Where(a => a.ParentTypeId == ParentTypeId & a.ParentId == ParentId).OrderByDescending(a => a.Id).FirstOrDefault(); var entity = new EntityNote { Id = query.Id, ParentId = query.ParentId, ParentTypeId = query.ParentTypeId, Description = query.Description, CreatedBy = query.CreatedBy, CreatedOn = query.CreatedOn, UserDetails = new UserDetails { UserId = query.CreatedBy, Name = query.User.FirstName + " " + query.User.LastName, date = query.CreatedOn.ToString() } }; if (query != null) { response.CreateResponse(entity, DataResponseStatus.OK); } else { response.CreateResponse(DataResponseStatus.InternalServerError); } } catch (Exception ex) { response.ThrowError(ex); } finally { base.DBClose(); } return(response); }
public DataResponse <EntityNotificationSettings> SaveNotification(EntityNotificationSettings entity) { DataResponse <EntityNotificationSettings> response = new DataResponse <EntityNotificationSettings>(); try { base.DBInit(); var model = DBEntity.UserNotificationMappers.FirstOrDefault(a => a.NotificationTypeId == entity.NotificationTypeId & a.UserId == entity.UserId); if (model != null) { if (entity.Status != null) { model.Status = entity.Status; model.UpdatedBy = entity.UserId; model.UpdatedOn = DateTime.UtcNow; } base.DBSaveUpdate(model); } else { var data = DBEntity.UserNotificationMappers.Add(new Database.UserNotificationMapper { UserId = entity.UserId, NotificationTypeId = entity.NotificationTypeId, Status = entity.Status, CreatedBy = entity.UserId, CreatedOn = DateTime.UtcNow }); base.DBSave(data); } } catch (Exception ex) { response.ThrowError(ex); } finally { base.DBClose(); } return(response); }
public DataResponse <T> GetFirst <T>(IQueryable <T> query) { //int count = query.Count(); DataResponse <T> response = new DataResponse <T>(); try { var entity = query.FirstOrDefault(); response.CreateResponse(entity, DataResponseStatus.OK); } catch (Exception ex) { response.ThrowError(ex); } finally { // DBClose(); } return(response); }
public DataResponse <EntityCountry> Insert(EntityCountry entity) { var response = new DataResponse <EntityCountry>(); try { base.DBInit(); var model = new Database.LookupCountry { CountryName = entity.CountryName, CountryCode = entity.CountryCode, CreatedBy = entity.CreatedBy, CreatedOn = System.DateTime.UtcNow, IsActive = entity.IsActive }; if (base.DBSave(model) > 0) { entity.Id = model.Id; response.CreateResponse(entity, DataResponseStatus.OK); } else { response.CreateResponse(DataResponseStatus.InternalServerError); } } catch (Exception ex) { ex.Log(); response.ThrowError(ex); } finally { base.DBClose(); } return(response); }
public DataResponse <bool> UpdateDeviceId(int id, string DeviceId) { DataResponse <bool> response = new DataResponse <bool>(); try { base.DBInit(); var model = DBEntity.UserProfiles.Where(a => a.UserId == id).Select(a => a).FirstOrDefault(); if (model != null) { model.DeviceId = DeviceId; if (base.DBSaveUpdate(model) > 0) { response.CreateResponse(true, DataResponseStatus.OK); } else { response.CreateResponse(false, DataResponseStatus.NotModified); } } else { response.CreateResponse(false, DataResponseStatus.NoContent); } } catch (Exception ex) { response.ThrowError(ex); } finally { DBClose(); } return(response); }
public DataResponse <EntityNote> SaveNote(EntityNote entity) { DataResponse <EntityNote> response = new DataResponse <EntityNote>(); try { base.DBInit(); var model = new Database.Note { Id = entity.Id, ParentId = entity.ParentId, ParentTypeId = entity.ParentTypeId, Description = entity.Description, CreatedBy = entity.CreatedBy, CreatedOn = DateTime.UtcNow, }; int rowCount = entity.Id > 0 ? base.DBSaveUpdate(model) : base.DBSave(model); if (rowCount > 0) { if (entity.ParentTypeId == (int)NoteType.Task) { var TaskModel = new RepositoryTask().GetTaskById(model.ParentId, entity.CreatedBy, entity.BusinessId); if (TaskModel.Model != null) { //Add To Notification Table List <EntityNotification> notificationlist = new List <EntityNotification>(); if (TaskModel.Model.AssignedTo > 0) { notificationlist.Add(new EntityNotification { UserId = TaskModel.Model.AssignedTo, Message = NotificationMessages.TaskNoteNotification }); } if (TaskModel.Model.Watchers != null) { foreach (var user in TaskModel.Model.Watchers) { notificationlist.Add(new EntityNotification { UserId = int.Parse(user), Message = NotificationMessages.TaskNoteNotification }); } } notificationlist.Add(new EntityNotification { UserId = TaskModel.Model.CreatedBy, Message = NotificationMessages.TaskNoteNotification }); #region Save Notification Data new RepositoryNotification().Save(notificationlist, entity.CreatedBy, model.Id, (int)NotificationTargetType.Task, (int)NotificationType.Normal, model.CreatedBy, entity.CreatedByName, model.CreatedOn, TaskModel.Model.Subject); #endregion } } entity.Id = model.Id; entity.UserDetails = DBEntity.Users.Where(a => a.Id == model.CreatedBy).Select(a => new UserDetails { UserId = model.CreatedBy, Name = a.FirstName + "" + a.LastName, date = model.CreatedOn.ToString() }).FirstOrDefault(); response.CreateResponse(entity, DataResponseStatus.OK); } else { response.CreateResponse(DataResponseStatus.InternalServerError); } } catch (Exception ex) { response.ThrowError(ex); } finally { base.DBClose(); } return(response); }