public ActionResult VoterLogin(VoterInfo model)
{
var dataItem = db.VoterInfoes.FirstOrDefault(x => x.VoterId == model.VoterId && x.VFirstName == model.VFirstName && x.VLastName == model.VLastName);
if (dataItem != null)
{
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCVoterLogin";
DBModel.Actual_SQL = "Select * from VoterInfo where VoterID and Last Name and First name match search";
DBModel.TableName = "VoterInfo";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
Session["voterName"] = dataItem.VFirstName;
Session["voterID"] = dataItem.VoterId;
return(RedirectToAction("Index", "VoterContactInfoes", new { search = (int)Session["voterID"] }));
}
else
{
ModelState.AddModelError("", "Invalid login information");
return(View());
}
}
public static string GetPercentage(LogUpdate i)
{
var total = i.LogUpdateSteps.Count();
var count = i.LogUpdateSteps.Where(x => x.Progress == "Done" || x.Progress == "Skip").Count();
return(string.Format("{0:0.0%}", (float)count / total));
}
private async Task UpdateLogFromMessage(FahClientMessage message)
{
bool messageIsLogRestart = message.Identifier.MessageType == FahClientMessageType.LogRestart;
if (messageIsLogRestart)
{
SetupLogAssetsForLogRestart();
}
var logUpdate = LogUpdate.Load(message.MessageText);
if (LogIsRetrieved)
{
await UpdateLogAssetsFromStringBuilder(logUpdate.Value, FileMode.Append).ConfigureAwait(false);
}
else
{
AppendToLogBuffer(logUpdate.Value);
if (message.MessageText.Length < UInt16.MaxValue)
{
await UpdateLogAssetsFromStringBuilder(LogBuffer, FileMode.Create).ConfigureAwait(false);
LogBuffer = null;
}
}
}
public ActionResult Index(string searchString)
{
string test = (string)Session["userRole"];
List <string> acceptableRoles = new List <string> {
"DBA"
};
if (!acceptableRoles.Contains(test))
{
Response.Redirect("~/Login/Login");
}
var content = from a in db.LogUpdates
select a;
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCViewLog";
DBModel.Actual_SQL = "Select * from LogUpdate";
DBModel.TableName = "Audit Log Table";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
if (!String.IsNullOrEmpty(searchString))
{
content = content.Where(s => s.Date.Contains(searchString));
}
return(View(content));
}
public async Task <ActionResult> Create([Bind(Include = "UserId,FirstName,LastName,MiddleName,Role,County,District,Email,Phone,Party,AssignedUsername,AssignedPassword")] User user)
{
string test = (string)Session["userRole"];
List <string> acceptableRoles = new List <string> {
"DBA"
};
if (!acceptableRoles.Contains(test))
{
Response.Redirect("~/Login/Login");
}
if (ModelState.IsValid)
{
db.Users.Add(user);
await db.SaveChangesAsync();
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCCreateUser";
DBModel.Actual_SQL = "Insert into users Values";
DBModel.TableName = "Users Table";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
// GET: Users/Edit/5
public async Task <ActionResult> Edit(int?id)
{
string test = (string)Session["userRole"];
List <string> acceptableRoles = new List <string> {
"DBA"
};
if (!acceptableRoles.Contains(test))
{
Response.Redirect("~/Login/Login");
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User user = await db.Users.FindAsync(id);
if (user == null)
{
return(HttpNotFound());
}
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCUpdateUsers";
DBModel.Actual_SQL = "Select * from users where id = search id";
DBModel.TableName = "Users Table";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
return(View(user));
}
protected virtual LogUpdate ToUpdateModel(TimerBaseInformation info, int maxLength)
{
var model = new LogUpdate
{
Identifier = info.Identifier,
Elapsed = info.GetElapsed()
};
if (IncludeHigh)
{
foreach (var(key, value) in info.HighProperties)
{
model.Other.Add(key, value.ShortenWithEllipses(maxLength));
}
}
if (IncludeMed)
{
foreach (var(key, value) in info.MedProperties)
{
model.Other.Add(key, value.ShortenWithEllipses(maxLength));
}
}
// ReSharper disable once InvertIf
if (IncludeLow)
{
foreach (var(key, value) in info.LowProperties)
{
model.Other.Add(key, value.ShortenWithEllipses(maxLength));
}
}
return(model);
}
public async Task <ActionResult> Edit([Bind(Include = "contactId,Phone,VoteEmail,PublicEmail")] VoterContactInfo voterContactInfo)
{
if (ModelState.IsValid)
{
VoterContactInfo v = new VoterContactInfo {
contactId = voterContactInfo.contactId
};
db.VoterContactInfoes.Attach(v);
v.Phone = voterContactInfo.Phone;
v.VoteEmail = voterContactInfo.VoteEmail;
v.PublicEmail = voterContactInfo.PublicEmail;
await db.SaveChangesAsync();
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCUpdateVoter";
DBModel.Actual_SQL = "Insert into table values where voterID = searchID";
DBModel.TableName = "VoterContactInfo List";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
return(RedirectToAction("Index", new { search = Session["voterIDSearch"] }));
}
return(View(voterContactInfo));
}
public async Task <ActionResult> StartUpdate(LogUpdate updateChecklist)
{
var checklist = await _repo.UpdateExists(updateChecklist);
if (checklist != null)
{
return(BadRequest($"{updateChecklist.Process} {updateChecklist.SiteKml} already exists. Please Try again"));
}
updateChecklist.StartTime = DateTime.Now;
updateChecklist.Status = "In Progress";
_repo.Add(updateChecklist);
var steps = await _repo.GetSteps(updateChecklist.Idchecklist, updateChecklist.Version);
foreach (var s in steps)
{
var step = new LogUpdateSteps
{
Step = s.Step,
StepText = s.StepText,
Title = s.Title,
Idupdate = updateChecklist.Idupdate
};
_repo.Add(step);
}
if (await _repo.SaveAll())
{
return(CreatedAtAction("GetUpdate", new { id = updateChecklist.Idupdate }, updateChecklist));
}
return(BadRequest("Failed to Create Update"));
}
public void CBLogInvoke(LogUpdate LogDelegate)//委托器
{
if (this.InvokeRequired)
{
this.Invoke(LogDelegate);
}
else
{
LogUpdateWindow();
}
}
public ActionResult Index(string party, string race)
{
string test = (string)Session["userRole"];
List <string> acceptableRoles = new List <string> {
"PA", "BCC", "SO", "SE", "DSB", "V", "CC", "TC", "SS", "DBA"
};
if (!acceptableRoles.Contains(test))
{
Response.Redirect("~/Login/Login");
}
var content = from a in db.VoterPhoneLists
select a;
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCVoterPhoneList";
DBModel.Actual_SQL = "Select * from view (where criteria are met)";
DBModel.TableName = "VoterPhone List";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
if (!String.IsNullOrEmpty(party) && !String.IsNullOrEmpty(race))
{
content = content.Where(
s =>
(s.party.Contains(party)) &&
(s.description.Contains(race))
);
}
else if (!String.IsNullOrEmpty(party) && String.IsNullOrEmpty(race))
{
content = content.Where(
s =>
(s.party.Contains(party))
);
}
else if (String.IsNullOrEmpty(party) && !String.IsNullOrEmpty(race))
{
content = content.Where(
s =>
(s.description.Contains(race))
);
}
Session["content"] = content.ToList <VoterPhoneList>();
return(View(content));
}
protected override Task DoUpdate(LogUpdate model, TimerBaseInformation info, int maxLength)
{
var subject = $"[{model.Identifier}] Completed";
var body = $@"
{info.Type} Complete!
{info.IdentifierStr}
{info.GetElapsedStr()}
{string.Join("\r\n", model.Other)}
";
return(Email.SendAsync(EmailImpl, EmailType.Logging, subject, body));
}
public ActionResult Index(string search)
{
Session["voterIDSearch"] = search;
string test = null;
List <string> acceptableRoles = new List <string> {
"V", "DBA"
};
int?voterid = null;
if (Session["userRole"] != null)
{
test = (string)Session["userRole"];
}
if (Session["voterID"] != null)
{
voterid = (int)Session["voterID"];
}
if (!acceptableRoles.Contains(test) && voterid == null)
{
Response.Redirect("~/Login/VoterLogin");
}
var content = from a in db.VoterContactInfoes
select a;
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCVoterContactInfo";
DBModel.Actual_SQL = "Select * from table";
DBModel.TableName = "VoterContactInfo List";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
if (!String.IsNullOrEmpty(search))
{
int searchInt = Int32.Parse(search);
content = content.Where(s => s.VoterId == searchInt);
}
else
{
content = null;
}
return(View(content));
}
// GET: VoterContactInfoes/Edit/5
public async Task <ActionResult> Edit(int?id)
{
string test = null;
List <string> acceptableRoles = new List <string> {
"V", "DBA"
};
int?voterid = null;
if (Session["userRole"] != null)
{
test = (string)Session["userRole"];
}
if (Session["voterID"] != null)
{
voterid = (int)Session["voterID"];
}
if (!acceptableRoles.Contains(test) && voterid == null)
{
Response.Redirect("~/Login/VoterLogin");
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VoterContactInfo voterContactInfo = await db.VoterContactInfoes.FindAsync(id);
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCUpdateVoter";
DBModel.Actual_SQL = "Select * from table where voterId is searchID";
DBModel.TableName = "VoterContactInfo List";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
if (voterContactInfo == null)
{
return(HttpNotFound());
}
return(View(voterContactInfo));
}
public ActionResult Index(string party, string race)
{
var content = from a in db.VoterEmailLists
select a;
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCVoterEmailList";
DBModel.Actual_SQL = "Select * from view (where criteria are met)";
DBModel.TableName = "VoterEmail List";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
if (!String.IsNullOrEmpty(party) && !String.IsNullOrEmpty(race))
{
content = content.Where(
s =>
(s.party.Contains(party)) &&
(s.description.Contains(race))
);
}
else if (!String.IsNullOrEmpty(party) && String.IsNullOrEmpty(race))
{
content = content.Where(
s =>
(s.party.Contains(party))
);
}
else if (String.IsNullOrEmpty(party) && !String.IsNullOrEmpty(race))
{
content = content.Where(
s =>
(s.description.Contains(race))
);
}
Session["content"] = content.ToList <VoterEmailList>();
return(View(content));
}
public async Task <ActionResult> Create([Bind(Include = "T_ID,T_Date,T_Content")] Testimonial testimonial)
{
if (ModelState.IsValid)
{
db.Testimonials.Add(testimonial);
await db.SaveChangesAsync();
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCAddTestimonial";
DBModel.Actual_SQL = "Insert into testimonials Values";
DBModel.TableName = "Testimonials Table";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(testimonial));
}
// GET: Testimonials
public ActionResult Index(string searchString)
{
var content = from a in db.Testimonials
select a;
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCSearchTestimonials";
DBModel.Actual_SQL = "Select * from testimonials table";
DBModel.TableName = "Testimonials";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
if (!String.IsNullOrEmpty(searchString))
{
content = content.Where(s => s.T_Content.Contains(searchString));
}
return(View(content));
}
// GET: Users
public async Task <ActionResult> Index()
{
string test = (string)Session["userRole"];
List <string> acceptableRoles = new List <string> {
"DBA"
};
if (!acceptableRoles.Contains(test))
{
Response.Redirect("~/Login/Login");
}
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"]: (string)Session["userRole"];
DBModel.Access = "UCViewUsers";
DBModel.Actual_SQL = "Select * From Users";
DBModel.TableName = "Users Table";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
return(View(await db.Users.ToListAsync()));
}
protected override Task DoUpdate(LogUpdate model, TimerBaseInformation info, int maxLength)
{
Debug.WriteLine(info.Message, $"{info.CategoryStr} {info.GetElapsedStr()}");
WriteOther(model.Other);
return(Task.CompletedTask);
}
private void _logWrapper_OnLoggingEvent(object sender, LogEventArgs e)
{
var del = new LogUpdate(UpdateLogList);
Dispatcher.Invoke(del, e.Level, e.Name, e.Text);
}
/// <summary> /// Actual implementation of updating a logged record /// </summary> /// <param name="model">The model containing everything to be logged</param> /// <param name="info">The log information class</param> /// <param name="maxLength">When to truncate items</param> protected abstract Task DoUpdate(LogUpdate model, TimerBaseInformation info, int maxLength);
public async Task <LogUpdate> UpdateExists(LogUpdate update)
{
var updateExist = await _ctx.LogUpdate.Where(x => x.ProdLine == update.ProdLine && x.SiteKml == update.SiteKml && x.UpdateNum == update.UpdateNum && x.System == update.System && x.Process == update.Process && x.Idchecklist == update.Idchecklist && x.Status != "Cancelled").FirstOrDefaultAsync();
return(updateExist);
}
public ActionResult Login(User model)
{
var dataItem = db.Users.FirstOrDefault(x => x.AssignedUsername == model.AssignedUsername && x.AssignedPassword == model.AssignedPassword);
if (dataItem != null)
{
var DBModel = new LogUpdate();
DBModel.Date = DateTime.Today.ToString("G");
DBModel.Who = !String.IsNullOrEmpty((string)Session["userName"]) ? (string)Session["UserName"] : (string)Session["userRole"];
DBModel.Access = "UCLogin";
DBModel.Actual_SQL = "Select * from users table where username and password match";
DBModel.TableName = "Users Table";
db.LogUpdates.Add(DBModel);
db.SaveChanges();
Session["userFirstName"] = dataItem.FirstName;
Session["userMiddleName"] = dataItem.MiddleName;
Session["userLastName"] = dataItem.LastName;
Session["userRole"] = dataItem.Role;
switch (dataItem.Role)
{
case "CC":
Session["userTitle"] = "Clerk Of Court";
break;
case "PA":
Session["userTitle"] = "Property Appraiser";
break;
case "SO":
Session["userTitle"] = "Sherriff's Office";
break;
case "SE":
Session["userTitle"] = "Supervisor of Elections";
break;
case "TC":
Session["userTitle"] = "Tax Collector";
break;
case "SS":
Session["userTitle"] = "School Superintendent";
break;
case "BCC":
Session["userTitle"] = "Board of County Commissioners";
break;
case "DSB":
Session["userTitle"] = "District School Board";
break;
case "CS":
Session["userTitle"] = "Customer Service";
break;
case "V":
Session["userTitle"] = "Volunteer";
break;
case "DBA":
Session["userTitle"] = "Database Administrator";
break;
}
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Invalid user or password");
return(View());
}
}
