public bool Create(UsersExt model, ref string Msg, Controller ctrl)
{
bool status = true;
try
{
model.Mobile = model.Mobile.Replace(" ", string.Empty);
if (ValidateMobileNumber(model.Mobile, ref Msg) == false)
{
status = false;
return(status);
}
//TODO: Map to DB Object
var dbmodel = Map(model);
//TODO: Save DB Changes and Set the Return Primary Key ID
db.Users.Add(dbmodel);
db.SaveChanges();
//TOD: Add to Audit Log
AuditLog(ctrl, AuditAction.Create, ReadOne(dbmodel.UserID), null);
}
catch (Exception ex)
{
Msg = ErrorHandling.HandleException(ex);
status = false;
}
return(status);
}
public bool Update(UsersExt model, ref string Msg, Controller ctrl)
{
//Wrap it all in a transaction
bool status = true;
try
{
model.Mobile = model.Mobile.Replace(" ", string.Empty);
if (ValidateMobileNumber(model.Mobile, ref Msg) == false)
{
status = false;
return(status);
}
var dbmodel = db.Users.FirstOrDefault(p => p.UserID == model.UserID);
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, ReadOne(dbmodel.UserID));
}
catch (Exception ex)
{
Msg = ErrorHandling.HandleException(ex);
status = false;
}
return(status);
}
public void MapUpdate(ref Users dbmodel, UsersExt model)
{
dbmodel.UserID = model.UserID;
dbmodel.FullName = model.FullName;
dbmodel.EmailAddress = model.EmailAddress;
dbmodel.Password = SecurityUtils.EncryptText(model.Password);
dbmodel.Locked = model.Locked;
dbmodel.Deleted = model.Deleted;
dbmodel.RoleID = model.RoleID;
dbmodel.DailyStatEmails = model.DailyStatEmails;
dbmodel.DailyLiveLeagueNumEmails = model.DailyLiveLeagueNumEmails;
dbmodel.Mobile = model.Mobile;
dbmodel.Address = model.Address;
}
public Users Map(UsersExt model)
{
Users tblModel = new Users()
{
UserID = model.UserID,
FullName = model.FullName,
EmailAddress = model.EmailAddress,
Password = SecurityUtils.EncryptText(model.Password),
Locked = model.Locked,
Deleted = model.Deleted,
RoleID = model.RoleID,
DailyStatEmails = model.DailyStatEmails,
DailyLiveLeagueNumEmails = model.DailyLiveLeagueNumEmails,
Mobile = model.Mobile,
Address = model.Address,
MobileVerficationCode = model.MobileVerficationCode,
IsMobileNumVerified = model.IsMobileNumVerified
};
return(tblModel);
}
public UsersExt Map(Users model)
{
UsersExt tblModel = new UsersExt()
{
UserID = model.UserID,
FullName = model.FullName,
EmailAddress = model.EmailAddress,
Password = SecurityUtils.DecryptCypher(model.Password),
Locked = model.Locked,
Deleted = model.Deleted,
RoleID = model.RoleID,
Role = model.Roles.Role,
DailyStatEmails = model.DailyStatEmails,
DailyLiveLeagueNumEmails = model.DailyLiveLeagueNumEmails,
Mobile = model.Mobile.Replace(" ", string.Empty),
Address = model.Address,
MobileVerficationCode = model.MobileVerficationCode,
IsMobileNumVerified = model.IsMobileNumVerified
};
return(tblModel);
}
public bool Delete(UsersExt model, ref string Msg, Controller ctrl)
{
bool status = true;
try
{
//TODO: Get Current Object from DB
var ItemToDelete = db.Users.FirstOrDefault(m => m.UserID == model.UserID);
if (ItemToDelete != null)
{
var ForAudiLog = Map(ItemToDelete);
//Delete from DB and any other dependencies
db.DeleteUser(model.UserID);
//Add To Log
AuditLog(ctrl, AuditAction.Delete, null, ForAudiLog);
}
}
catch (Exception ex)
{
Msg = ErrorHandling.HandleException(ex);
if (ex.InnerException.Message.Contains("Leagues"))
{
Msg = "Selected User is Assigned as Admin/Coach for a league, Please replace the Admin/Coach for League to continue";
}
else if (ex.InnerException.Message.Contains("Teams"))
{
Msg = "Selected User is Assigned as Coach for a Team, Please replace the Coach for such Team to continue";
}
status = false;
}
return(status);
}
/// <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, UsersExt dbmodel = null, UsersExt model = null)
{
string AuditLogShortDesc = "", AuditLogLongDesc = "";
//StringBuilder sb = new StringBuilder();
if (auditAction == AuditAction.Create) //Creating new Record
{
AuditLogShortDesc = "New User has been Added";
AuditLogLongDesc = "UserID: " + dbmodel.UserID + " FullName: " + dbmodel.FullName + " EmailAddress: " + dbmodel.EmailAddress + " Role: " + dbmodel.Role;
//sb.Append("<table class='table table-stripped auditLogStyle'>");
//sb.Append("<tr><th colspan='2'>New User has been Added</th></tr>");
//sb.Append("<tr><th>Full Name</th><td>" + dbmodel.FullName + "</td></tr>");
//sb.Append("<tr><th>Email</th><td>" + dbmodel.EmailAddress + "</td></tr>");
//sb.Append("<tr><th>Role</th><td>" + dbmodel.Role + "</td></tr>");
//sb.Append("<tr><th>Locked</th><td>" + dbmodel.Locked + "</td></tr>");
//sb.Append("<tr><th>Deleted</th><td>" + dbmodel.Deleted + "</td></tr>");
//sb.Append("</table>");
//AuditLogLongDesc = sb.ToString();
}
else if (auditAction == AuditAction.Update)
{
AuditLogShortDesc = "User has been Updated";
AuditLogLongDesc = "UserID: " + model.UserID + " FullName: " + model.FullName + " EmailAddress: " + model.EmailAddress + " Role: " + model.Role;
//sb.Append("<table class='table table-stripped auditLogStyle'>");
//sb.Append("<tr><th colspan='2'>User has been Updated</th></tr>");
//sb.Append("<tr><th colspan='2'><label>BEFORE</label></th></tr>");
//sb.Append("<tr><th>Full Name</th><td>" + dbmodel.FullName + "</td></tr>");
//sb.Append("<tr><th>Email</th><td>" + dbmodel.EmailAddress + "</td></tr>");
//sb.Append("<tr><th>Role</th><td>" + dbmodel.Role + "</td></tr>");
//sb.Append("<tr><th>Locked</th><td>" + dbmodel.Locked + "</td></tr>");
//sb.Append("<tr><th>Deleted</th><td>" + dbmodel.Deleted + "</td></tr>");
//sb.Append("<tr><th colspan='2'><label>AFTER</label></th></tr>");
//sb.Append("<tr><th>Full Name</th><td>" + dbmodel.FullName + "</td></tr>");
//sb.Append("<tr><th>Email</th><td>" + dbmodel.EmailAddress + "</td></tr>");
//sb.Append("<tr><th>Role</th><td>" + dbmodel.Role + "</td></tr>");
//sb.Append("<tr><th>Locked</th><td>" + dbmodel.Locked + "</td></tr>");
//sb.Append("<tr><th>Deleted</th><td>" + dbmodel.Deleted + "</td></tr>");
//sb.Append("</table>");
//AuditLogLongDesc = sb.ToString();
}
else if (auditAction == AuditAction.Delete)
{
AuditLogShortDesc = "User has been Deleted";
AuditLogLongDesc = "UserID: " + model.UserID + " FullName: " + model.FullName + " EmailAddress: " + model.EmailAddress + " Role: " + model.Role;
//sb.Append("<tr><th>Full Name</th><td>" + dbmodel.FullName + "</td></tr>");
//sb.Append("<tr><th>Email</th><td>" + dbmodel.EmailAddress + "</td></tr>");
//sb.Append("<tr><th>Role</th><td>" + dbmodel.Role + "</td></tr>");
//sb.Append("<tr><th>Locked</th><td>" + dbmodel.Locked + "</td></tr>");
//sb.Append("<tr><th>Deleted</th><td>" + dbmodel.Deleted + "</td></tr>");
//sb.Append("</table>");
//AuditLogLongDesc = sb.ToString();
}
SecurityUtils.AddAuditLog(AuditLogShortDesc, AuditLogLongDesc, ctrl);
}
