public void MapUpdate(ref PlayerWeeklyActivities dbmodel, PlayerWeeklyActivityExt model)
{
dbmodel.PlayerWeeklyActivityID = model.PlayerWeeklyActivityID;
//dbmodel.PlayerID = model.PlayerID;
//dbmodel.ActivityDate = model.ActivityDate;
dbmodel.Activity = model.Activity;
dbmodel.ActivityTime = model.ActivityTime;
dbmodel.Completed = model.Completed;
}
public long CreateOrUpdate(PlayerWeeklyActivityExt model, ref string Msg, ref bool status, Controller ctrl)
{
long PlayerWeeklyActivityID = 0;
//Remove the last commna
model.Activity = string.IsNullOrEmpty(model.Activity) == false?model.Activity.TrimEnd().TrimEnd(',') : null;
if (model.PlayerWeeklyActivityID == 0)
{
try
{
//TODO: Map to DB Object
var dbmodel = Map(model);
//TODO: Save DB Changes and Set the Return Primary Key ID
db.PlayerWeeklyActivities.Add(dbmodel);
db.SaveChanges();
//TOD: Add to Audit Log
AuditLog(ctrl, AuditAction.Create, model, null);
PlayerWeeklyActivityID = dbmodel.PlayerWeeklyActivityID;
}
catch (Exception ex)
{
Msg = ErrorHandling.HandleException(ex);
status = false;
}
}
else
{
try
{
var dbmodel = db.PlayerWeeklyActivities.FirstOrDefault(p => p.PlayerWeeklyActivityID == model.PlayerWeeklyActivityID);
var ForAuditLog = Map(dbmodel);
//TODO: Map to DB Object
MapUpdate(ref dbmodel, model);
//TODO: Update DB Changes
db.SaveChanges();
//TOD: Add to Audit Log
AuditLog(ctrl, AuditAction.Update, ForAuditLog, model);
PlayerWeeklyActivityID = dbmodel.PlayerWeeklyActivityID;
}
catch (Exception ex)
{
Msg = ErrorHandling.HandleException(ex);
status = false;
}
}
return(PlayerWeeklyActivityID);
}
public PlayerWeeklyActivityExt Map(PlayerWeeklyActivities model)
{
PlayerWeeklyActivityExt tblModel = new PlayerWeeklyActivityExt()
{
PlayerWeeklyActivityID = model.PlayerWeeklyActivityID,
PlayerID = model.PlayerID,
ActivityDate = model.ActivityDate,
Activity = model.Activity,
ActivityTime = model.ActivityTime,
Completed = model.Completed
};
return(tblModel);
}
/// <summary>
/// Add the Action to Audit Log
/// </summary>
/// <param name="model">The Object for which this Auditlog took place</param>
/// <param name="Action">"Added New User OR Updated User Details OR Deleted User"</param>
private void AuditLog(Controller ctrl, AuditAction auditAction, PlayerWeeklyActivityExt dbmodel = null, PlayerWeeklyActivityExt model = null)
{
string AuditLogShortDesc = "", AuditLogLongDesc = "";
StringBuilder sb = new StringBuilder();
if (auditAction == AuditAction.Create) //Creating new Record
{
AuditLogShortDesc = AuditLogLongDesc = "New Player Weekly Activity has been Added PlayerID = " + dbmodel.PlayerID + " Activity Date = " + dbmodel.ActivityDate.ToString("dd/MM/yyyy");
}
else if (auditAction == AuditAction.Update)
{
AuditLogShortDesc = AuditLogLongDesc = "Player Weekly Activity has been Updated PlayerID = " + model.PlayerID + " DashboardURL = " + model.ActivityDate.ToString("dd/MM/yyyy");
}
else if (auditAction == AuditAction.Delete)
{
AuditLogShortDesc = AuditLogLongDesc = "Player Weekly Activity has been Deleted PlayerID = " + model.PlayerID + " DashboardURL = " + model.ActivityDate.ToString("dd/MM/yyyy");
}
SecurityUtils.AddAuditLog(AuditLogShortDesc, AuditLogLongDesc, ctrl);
}
public List <vmWeeklyActivity> GetWeeklyActivityData(long PlayerID, DateTime ActivityDate, Controller ctrl)
{
var StartDateOfWeek = DateTimeExtensions.StartOfWeek(ActivityDate, DayOfWeek.Monday);
var EndDateOfWeek = StartDateOfWeek.AddDays(6);
List <vmWeeklyActivity> ListOfViewModel = new List <vmWeeklyActivity>();
for (DateTime loopDate = StartDateOfWeek; loopDate <= EndDateOfWeek; loopDate = loopDate.AddDays(1))
{
var data = db.PlayerWeeklyActivities.Where(m => m.PlayerID == PlayerID && m.ActivityDate == loopDate).OrderBy(o => o.PlayerWeeklyActivityID);
if (data.Count() == 0)
{
//Add it into DB and Load in the GUI after getting PlayerWeeklyActivityID
PlayerWeeklyActivityExt m = new PlayerWeeklyActivityExt()
{
PlayerID = PlayerID,
ActivityDate = loopDate
};
string Msg = "";
bool status = true;
m.PlayerWeeklyActivityID = CreateOrUpdate(m, ref Msg, ref status, ctrl);
vmWeeklyActivity vmWeeklyAct = new vmWeeklyActivity()
{
PlayerWeeklyActivityID = m.PlayerWeeklyActivityID,
PlayerID = m.PlayerID,
ActivityDate = m.ActivityDate
};
PlayerWeeklyActivityExt mAct = new PlayerWeeklyActivityExt()
{
PlayerWeeklyActivityID = m.PlayerWeeklyActivityID,
ActivityDate = m.ActivityDate,
Activity = "",
ActivityTime = 0,
Completed = false
};
vmWeeklyAct.ListOfWeeklyActivities.Add(mAct);
ListOfViewModel.Add(vmWeeklyAct);
}
else
{
foreach (var item in data)
{
if (ListOfViewModel.Any(m => m.ActivityDate == item.ActivityDate))
{
var model = ListOfViewModel.FirstOrDefault(m => m.ActivityDate == item.ActivityDate);
PlayerWeeklyActivityExt mAct = new PlayerWeeklyActivityExt()
{
PlayerWeeklyActivityID = item.PlayerWeeklyActivityID,
ActivityDate = item.ActivityDate,
Activity = item.Activity,
ActivityTime = item.ActivityTime,
Completed = item.Completed
};
model.ListOfWeeklyActivities.Add(mAct);
}
else
{
vmWeeklyActivity m = new vmWeeklyActivity()
{
PlayerWeeklyActivityID = item.PlayerWeeklyActivityID,
PlayerID = item.PlayerID,
ActivityDate = item.ActivityDate
};
PlayerWeeklyActivityExt mAct = new PlayerWeeklyActivityExt()
{
PlayerWeeklyActivityID = item.PlayerWeeklyActivityID,
ActivityDate = item.ActivityDate,
Activity = item.Activity,
ActivityTime = item.ActivityTime,
Completed = item.Completed
};
m.ListOfWeeklyActivities.Add(mAct);
ListOfViewModel.Add(m);
}
}
}
}
return(ListOfViewModel);
}
