public ActionResult EditUser(EditUserModel value)
{
EventLogHandler Logger = new EventLogHandler();
List <CreateUser> CurrentUser;
using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString()))
{
CurrentUser = db.Query <CreateUser>($"Select * from dbo.Usertable Where ID = @ID", new { ID = value.ID }).ToList();
}
string CurrentPassword = CurrentUser[0].Password.ToString();
int id = CurrentUser[0].ID;
var Original = new List <string>();
var Updated = new List <string>();
string OriginalModel = "";
string UpdatedModel = "";
if (CurrentUser[0].DateModified != value.Date_Modified)
{
Original.Add("Date Modified: " + CurrentUser[0].DateModified);
Updated.Add("Date Modified: " + value.Date_Modified);
}
if (CurrentUser[0].FirstName != value.FirstName)
{
Original.Add("First Name: " + CurrentUser[0].FirstName);
Updated.Add("First Name: " + value.FirstName);
}
if (CurrentUser[0].LastName != value.LastName)
{
Original.Add("Last Name: " + CurrentUser[0].LastName);
Updated.Add("Last Name: " + value.LastName);
}
if (CurrentUser[0].Email != value.Email)
{
Original.Add("Email: " + CurrentUser[0].Email);
Updated.Add("Email: " + value.Email);
}
if (CurrentUser[0].Role != value.Role)
{
Original.Add("Role: " + CurrentUser[0].Role);
Updated.Add("Role: " + value.Role);
}
if (CurrentUser[0].Phone != value.Phone)
{
Original.Add("Phone: " + CurrentUser[0].Phone);
Updated.Add("Phone: " + value.Phone);
}
if (CurrentUser[0].Active != value.Active)
{
Original.Add("Active: " + CurrentUser[0].Active);
Updated.Add("Active: " + value.Active);
}
if (CurrentUser[0].Address != value.Address)
{
Original.Add("Address: " + CurrentUser[0].Address);
Updated.Add("Address: " + value.Address);
}
if (CurrentUser[0].City != value.City)
{
Original.Add("City: " + CurrentUser[0].City);
Updated.Add("City: " + value.City);
}
if (CurrentUser[0].State != value.State)
{
Original.Add("State: " + CurrentUser[0].State);
Updated.Add("State: " + value.State);
}
if (CurrentUser[0].ZIP_Code != value.ZIP_Code)
{
Original.Add("ZIP Code: " + CurrentUser[0].ZIP_Code);
Updated.Add("ZIP Code: " + value.ZIP_Code);
}
OriginalModel = String.Join("|^|", Original);
UpdatedModel = String.Join("|^|", Updated);
if (OriginalModel != "")
{
//A change has been done
Logger.LogEditUser(CurrentUser[0].ID, CurrentUser[0].Username, OriginalModel, UpdatedModel);
}
Original.Clear();
Updated.Clear();
CurrentUser[0].DateModified = value.Date_Modified;
CurrentUser[0].FirstName = value.FirstName;
CurrentUser[0].LastName = value.LastName;
CurrentUser[0].Email = value.Email;
CurrentUser[0].Role = value.Role;
CurrentUser[0].Phone = value.Phone;
CurrentUser[0].Active = value.Active;
CurrentUser[0].Address = value.Address;
CurrentUser[0].City = value.City;
CurrentUser[0].State = value.State;
CurrentUser[0].ZIP_Code = value.ZIP_Code;
using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString()))
{
string sql = "Update dbo.UserTable set FirstName = @FirstName, LastName = @LastName, " +
"Username = @Username, Password = @Password, Role = @Role, Phone = @Phone, " +
"Email = @Email, DateModified = @Date_Modified, Active = @Active, Address = @Address, " +
"City = @City, State = @State, ZIP_Code = @ZIP_Code Where ID = @ID;";
db.Execute(sql, new
{
FirstName = CurrentUser[0].FirstName,
LastName = CurrentUser[0].LastName,
Username = CurrentUser[0].Username,
Password = CurrentUser[0].Password,
Role = CurrentUser[0].Role,
Phone = CurrentUser[0].Phone,
Email = CurrentUser[0].Email,
Date_Modified = CurrentUser[0].DateModified,
Active = CurrentUser[0].Active,
Address = CurrentUser[0].Address,
City = CurrentUser[0].City,
State = CurrentUser[0].State,
ZIP_Code = CurrentUser[0].ZIP_Code,
ID = CurrentUser[0].ID
});
}
TempData["Message"] = "Your entry was successfully updated!";
return(RedirectToAction("AllUsers"));
}
