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);
}