//public TimeSheetActivity Add(TimeSheetActivity activity, string ipAddress)
//{
// try
// {
// //TimeSheetTaskId,
// //ipAddress
// if (activity.TimeSheetTaskId == 0)
// {
// return null;
// }
// bool ipAdded = _ipAddressMethods.AddIfNotExist(ipAddress);
// if (ipAdded)
// {
// activity.Address = ipAddress;
// }
// var dbActivity = _mapper.Map<DataSets.TimeSheetActivity>(activity);
// var record_pending = db.TimeSheetActivities.Add(dbActivity);
// if (db.SaveChanges() > 0)
// {
// return Get(record_pending.Entity.ID);
// }
// return null;
// }
// catch (Exception ex)
// {
// return null;
// }
//}
//public TimeSheetActivity Update(TimeSheetActivity activity, string ipAddress)
//{
// try
// {
// DataSets.TimeSheetActivity dbActivity = db.TimeSheetActivities.FirstOrDefault(k => k.ID == activity.ID);
// if (dbActivity == null)
// {
// return null;
// }
// #region ACTIVITY LOG
// TimeSheetActivityLog log = _mapper.Map<TimeSheetActivityLog>(dbActivity);
// log.DateAdded = DateTime.Now;
// log.TimeSheetActivityId = dbActivity.ID;
// log.ID = 0;
// _activityLogs.Add(log);
// #endregion
// bool ipAdded = _ipAddressMethods.AddIfNotExist(ipAddress);
// dbActivity.Address = ipAdded ? activity.Address : null;
// dbActivity.FromDate = activity.FromDate;
// dbActivity.ToDate = activity.ToDate;
// dbActivity.Message = activity.Message;
// db.SaveChanges();
// return Get(dbActivity.ID);
// }
// catch (Exception ex)
// {
// return null;
// }
//}
public TimeSheetActivity Get(int id)
{
DataSets.TimeSheetActivity dbActivity = db.TimeSheetActivities
//.Include(k => k.TimeSheetTask)
.Include(k => k.IpAddress)
.FirstOrDefault(k => k.ID == id);
if (dbActivity == null)
{
return(null);
}
TimeSheetActivity activity = _mapper.Map <TimeSheetActivity>(dbActivity);
// get ip title
//if (dbActivity.IpAddress != null)
//{
// DataSets.IpAddress address = db.IpAddresses.FirstOrDefault(k => k.Address == dbActivity.IpAddress);
// if (address != null)
// {
// activity.IpAddressDisplay = address.Title;
// }
//}
return(activity);
}
public TimeSheetActivity Start(int timeSheetTaskId, string ipAddress)
{
// get the record
var dbRecord = db.TimeSheetTasks
.Include(k => k.TimeSheet)
.FirstOrDefault(k => k.ID == timeSheetTaskId);
if (dbRecord == null)
{
throw new Exception("record not found");
}
// check if there are any active activities on that timesheet
//var hasActiveActivity = db.TimeSheetActivities.Any(k =>
//db.TimeSheetTasks.Any(t => t.ID == k.TimeSheetTaskId && t.TimeSheetId == dbRecord.TimeSheetId && !k.ToDate.HasValue));
bool hasActiveActivity = UserHasActiveActivity(dbRecord.TimeSheet.UserId);
if (hasActiveActivity)
{
throw new ClientException($"there is already an active activity");
}
if (ipAddress == "::1")
{
ipAddress = "127.0.0.1";
}
bool ipAdded = _ipAddressMethods.AddIfNotExist(ipAddress);
DataSets.TimeSheetActivity activity = new DataSets.TimeSheetActivity()
{
//Address = ipAddress,
FromDate = DateTime.Now,
TimeSheetTaskId = timeSheetTaskId,
DateAdded = DateTime.Now
};
if (ipAdded)
{
activity.Address = ipAddress;
}
// add the activity
var record_pending = db.TimeSheetActivities.Add(activity);
// save changes
if (db.SaveChanges() > 0)
{
// return activity
return(Get(record_pending.Entity.ID));
}
return(null);
}
public void Delete(int id)
{
DataSets.TimeSheetActivity dbActivity = db.TimeSheetActivities.FirstOrDefault(k => k.ID == id);
if (dbActivity == null)
{
throw new ClientException("dont exist");
}
dbActivity.DeletedAt = DateTime.Now;
db.SaveChanges();
//if (dbActivity != null)
//{
// db.TimeSheetActivities.Remove(dbActivity);
// return db.SaveChanges() > 0;
//}
//return false;
}
public TimeSheetActivity Update(TimeSheetActivityUpdateModel model)
{
if (model == null)
{
throw new ArgumentNullException("activity is null*");
}
if (string.IsNullOrEmpty(model.message))
{
throw new ClientException("message is required*");
}
if (model.toDate <= model.fromDate)
{
throw new ClientException("To Date should be greater than From Date*");
}
// can be null (case VPN, etc..)
string ipAddress = model.GetIpAddress();
// clean
model.message = model.message.Trim();
// save the location if doesn't exist
if (ipAddress != null)
{
if (ipAddress == "::1")
{
ipAddress = "127.0.0.1";
}
_ipAddressMethods.AddIfNotExist(ipAddress);
}
var dbActivity = db.TimeSheetActivities
.Include(k => k.IpAddress)
.FirstOrDefault(k => k.ID == model.id);
if (dbActivity == null)
{
throw new ClientException("activity not found");
}
string userId = db.TimeSheets.First(k => k.TimeSheetTasks.Any(t => t.ID == dbActivity.TimeSheetTaskId)).UserId;
DataSets.TimeSheetActivity conflictedActivity = db.TimeSheetActivities.FirstOrDefault(c =>
c.TimeSheetTask.TimeSheet.UserId == userId &&
c.ID != dbActivity.ID &&
!c.DeletedAt.HasValue &&
((model.fromDate >= c.FromDate && model.fromDate <= c.ToDate) ||
(model.toDate >= c.FromDate && model.toDate <= c.ToDate) ||
(!c.ToDate.HasValue && model.fromDate >= c.FromDate) ||
(!c.ToDate.HasValue && model.toDate >= c.FromDate)
));
if (conflictedActivity != null)
{
throw new ClientException($"An activity is already made on the choosen dates. " +
$"Activity No.{conflictedActivity.ID} ({conflictedActivity.FromDate.ToDisplayDateTime()} - {(conflictedActivity.ToDate.HasValue ? conflictedActivity.ToDate.ToDisplayDateTime() : "*")})");
}
// check for change
bool fromDateChanged = dbActivity.FromDate != model.fromDate;
bool toDateChanged = dbActivity.ToDate != model.toDate;
bool messageChanged = dbActivity.Message != model.message;
bool hasChange = fromDateChanged || toDateChanged || messageChanged;
if (hasChange)
{
db.TimeSheetActivityLogs.Add(new DataSets.TimeSheetActivityLog()
{
Address = dbActivity.Address,
FromDate = dbActivity.FromDate,
ToDate = dbActivity.ToDate,
Message = dbActivity.Message,
TimeSheetActivityId = dbActivity.ID,
DateAdded = DateTime.Now
});
// update the activity
dbActivity.Address = ipAddress;
dbActivity.Message = model.message;
dbActivity.FromDate = model.fromDate;
dbActivity.ToDate = model.toDate;
db.SaveChanges();
}
return(_mapper.Map <TimeSheetActivity>(dbActivity));
}