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));
}
// 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));
}
