public ActionResult EditContact(PvgMemberViewModel model)
{
//string returnMsg;
if (!ModelState.IsValid)
{
return(View(model));
}
if (model.PvgMember.Id == 0)
{
model.PvgMember.DateEntered = DateTime.Now;
model.PvgMember.EnteredBy = Session["UserId"].ToString();
model.PvgMember.DateLastUpdated = model.PvgMember.DateEntered;
model.PvgMember.LastUpdatedBy = model.PvgMember.EnteredBy;
}
else
{
model.PvgMember.DateLastUpdated = DateTime.Now;
model.PvgMember.LastUpdatedBy = Session["UserId"].ToString();
}
model.PvgMember.State = model.PvgMember.State?.ToUpper();
_pvgMemberRepository.Save(model);
//if (_caseFileRepository.Save(model))
// returnMsg = $"Case File for {model.FirstName + " " + model.LastName} was edited successfully.";
return(RedirectToAction("View", new { id = model.PvgMember.Id }));
}
internal bool SaveAssignments(PvgMemberViewModel viewModel)
{
// First, delete all assignments currently associated with this Member and
// then add back in the ones that are not marked as Remove
try
{
var sql = $"delete from hlc_PVGMemberHospital where PVGMemberId={viewModel.PvgMember.Id};";
ExecuteSql(sql);
foreach (var toInsert in viewModel.Hospitals)
{
if (!toInsert.Remove && toInsert.HospitalId != 0)
{
toInsert.PvgMemberId = viewModel.PvgMember.Id;
toInsert.Id = 0;
var newId = Connection.Insert(toInsert);
toInsert.Id = (int)newId;
}
}
return(true);
}
catch (Exception ex)
{
LogException(ex, viewModel);
return(false);
}
}
internal bool Save(PvgMemberViewModel model)
{
try
{
if (model.PvgMember.Id == 0)
{
Connection.Insert(model.PvgMember);
}
else
{
Connection.Update(model.PvgMember);
}
GetSelectList(true);
return(true);
}
catch (Exception ex)
{
LogException(ex, model.PvgMember);
return(false);
}
}
public ActionResult EditContact(int id)
{
PvgMemberViewModel model;
if (id == 0)
{
model = new PvgMemberViewModel();
model.PvgMember = new PvgMember();
}
else
{
// Retrieve existing data and populate model
model = _pvgMemberRepository.Get(id);
if (model == null)
{
return(RedirectToAction("Search", "Home",
new { msg = $"PVG Member {id} was not found in the database." }));
}
}
return(View(model));
}
/// <summary>
/// Get PvgMember details and a list of all Doctors at the PvgMember
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
//internal PvgMember Get(int id)
//{
// var sql = $"select * from hlc_PVGMember where Id='{id}'";
// var results = GetListFromSql<PvgMember>(sql).FirstOrDefault();
// return results;
//}
internal PvgMemberViewModel Get(int id)
{
var model = new PvgMemberViewModel();
using (var conn = Connection)
{
var sql = $"select * from hlc_PVGMember where ID={id};" +
"select pvgh.ID, HospitalId, HospitalName, pvgh.Notes, DayOfWeek, w.Description as WeekDay " +
"from hlc_PVGMemberHospital pvgh " +
" left join hlc_Hospital h on pvgh.HospitalID = h.ID " +
" left join hlc_DayOfWeek w on w.Id = pvgh.DayOfWeek " +
$"where pvgh.PVGMemberID={id} " +
"order by HospitalName;";
conn.Open();
var multi = conn.QueryMultiple(sql);
model.PvgMember = multi.Read <PvgMember>().FirstOrDefault();
model.Hospitals = multi.Read <PvgMemberHospital>().ToList();
}
return(model);
}
public ActionResult EditAssignments(PvgMemberViewModel viewModel)
{
_pvgMemberRepository.SaveAssignments(viewModel);
return(RedirectToAction("View", new { id = viewModel.PvgMember.Id }));
}
