public async Task <IActionResult> Edit(int id, [Bind("Id,Name,PhoneNumber,EmailAddress,Message,BeenHelped,EntryDate,ServiceRequested,Comments")] ContactClientModel contactClientModel)
{
if (id != contactClientModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(contactClientModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ContactClientModelExists(contactClientModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(contactClientModel));
}
public ActionResult ContactClientForm(ContactClientModel model)
{
if (ModelState.IsValid)
{
int recordsCreated = CreateClient(model.Name, model.PhoneNumber, model.EmailAddress, model.Message);
return(RedirectToAction("Index"));
}
return(View());
}
public async Task <IActionResult> Create([Bind("Id,Name,PhoneNumber,EmailAddress,Message")] ContactClientModel contactClientModel)
{
if (ModelState.IsValid)
{
_context.Add(contactClientModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Thanks)));
}
return(View(contactClientModel));
}
public static int CreateClient(string name, string emailAddress, string phoneNumber, string message)
{
ContactClientModel data = new ContactClientModel
{
Name = name,
EmailAddress = emailAddress,
PhoneNumber = phoneNumber,
Message = message
};
string sql = @"insert into dbo.ClientContactInfo(Name, PhoneNumber, EmailAddress, Message)
values(@Name, @PhoneNumber, @EmailAddress, @Message)";
return(SQLDataAccess.SaveData(sql, data));
}
