public ActionResult Create([Bind(Include = "Id,FirstName,LastName,DateOfBirth,Active,ClientNote,Location")] HfedClient hfedClient)
{
//EF adding blank Foreign Key records: use raw SQL
using (var context = new SenecaContext())
{
string cmdString = "INSERT INTO HfedClient (";
cmdString += "FirstName,LastName,DateOfBirth,Active,ClientNote,Location_Id)";
cmdString += " VALUES (";
cmdString += "'" + hfedClient.FirstName + "','" + hfedClient.LastName + "',";
cmdString += "'" + hfedClient.DateOfBirth + "',";
if (hfedClient.Active)
{
cmdString += "1,";
}
else
{
cmdString += "0,";
}
if (!hfedClient.ClientNote.IsNullOrEmpty())
{
cmdString += "'" + hfedClient.ClientNote.Replace("'", "''") + "',";
}
else
{
cmdString += "'',";
}
cmdString += hfedClient.Location.Id + ")";
context.Database.ExecuteSqlCommand(cmdString);
}
TempData["ClientLocationId"] = hfedClient.Location.Id;
return(RedirectToAction("Index"));
}
private HfedScheduleViewModel CheckForDuplicateClient(HfedScheduleViewModel schedule)
{
// Check for duplicate clients on same day
var otherSchedules = db.HfedSchedules.Where(s => s.Date == schedule.Date &&
s.Id != schedule.Id).ToList();
if (otherSchedules.Count > 0 && schedule.HfedClientsArray != null)
{
foreach (HfedSchedule otherSched in otherSchedules)
{
otherSched.HfedClientsArray = otherSched.HfedClientIds.Split(',').ToArray();
foreach (var c in otherSched.HfedClientsArray)
{
foreach (var c1 in schedule.HfedClientsArray)
{
if (c == c1 && !c1.IsNullOrEmpty())
{
HfedClient dupClient = db.HfedClients.Find(Convert.ToInt32(c));
if (dupClient != null)
{
schedule.ErrorMessage = dupClient.FullName
+ " is already selected in another run on "
+ otherSched.Date.ToShortDateString();
schedule = GetDropDownData(schedule);
return(schedule); // (for error functions)
}
}
}
}
}
}
return(schedule);
}
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,DateOfBirth,Active,Location,ClientNote,NumberInHousehold")] HfedClient hfedClient)
{
if (ModelState.IsValid)
{
using (var context = new SenecaContext())
{
var query = @"UPDATE HfedClient"
+ " SET FirstName=@FirstName,LastName=@LastName,DateOfBirth=@DateOfBirth,"
+ "Active=@Active,ClientNote=@ClientNote,Location_Id=@Location_Id,"
+ "NumberInHousehold=@NumberInHousehold"
+ " WHERE Id = " + hfedClient.Id;
context.Database.ExecuteSqlCommand(query,
new SqlParameter("@FirstName", hfedClient.FirstName),
new SqlParameter("@LastName", hfedClient.LastName),
new SqlParameter("@DateOfBirth", hfedClient.DateOfBirth.ToShortDateString()),
new SqlParameter("@Active", hfedClient.Active ? 1 : 0),
new SqlParameter("@ClientNote", hfedClient.ClientNote + ""),
new SqlParameter("@Location_Id", hfedClient.Location.Id),
new SqlParameter("@NumberInHousehold", hfedClient.NumberInHousehold));
}
// This version not updating location change:
TempData ["ClientLocationId"] = hfedClient.Location.Id;
return(RedirectToAction("Index"));
}
return(View(hfedClient));
}
// GET: HfedClients/Create
public ActionResult Create()
{
var hfedClientView = new HfedClient
{
HfedLocations = db.HfedLocations.OrderBy(l => l.Name).ToList(), Active = true
};
return(View(hfedClientView));
}
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,DateOfBirth,Active,Location,ClientNote")] HfedClient hfedClient)
{
if (ModelState.IsValid)
{
using (var context = new SenecaContext())
{
var sqlString = "UPDATE HfedClient SET ";
if (hfedClient.FirstName != null)
{
sqlString += "FirstName = '" + hfedClient.FirstName + "',";
}
if (hfedClient.LastName != null)
{
sqlString += "LastName = '" + hfedClient.LastName + "',";
}
sqlString += "DateOfBirth = '" + hfedClient.DateOfBirth + "',";
if (hfedClient.Active)
{
sqlString += "Active = 1,";
}
else
{
sqlString += "Active = 0,";
}
if (hfedClient.ClientNote != null)
{
sqlString += "ClientNote = '" + hfedClient.ClientNote.Replace("'", "''") + "',";
}
else
{
sqlString += "ClientNote='',";
}
sqlString += "Location_Id = " + hfedClient.Location.Id;
sqlString += " WHERE Id = " + hfedClient.Id;
context.Database.ExecuteSqlCommand(sqlString);
}
// This version not updating location change:
//db.Entry(hfedClient).State = EntityState.Modified;
//db.SaveChanges();
TempData ["ClientLocationId"] = hfedClient.Location.Id;
return(RedirectToAction("Index"));
}
return(View(hfedClient));
}
// GET: HfedClients/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HfedClient hfedClient = db.HfedClients.Find(id);
if (hfedClient == null)
{
return(HttpNotFound());
}
hfedClient.HfedLocations = db.HfedLocations.OrderBy(l => l.Name).ToList();
return(View(hfedClient));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,DateOfBirth,Active,ClientNote,Location,NumberInHousehold")] HfedClient hfedClient)
{
//EF adding blank Foreign Key records: use raw SQL
using (var context = new SenecaContext())
{
var query = @"INSERT INTO HfedClient"
+ " (FirstName,LastName,DateOfBirth,Active,ClientNote,Location_Id,NumberInHousehold)"
+ " VALUES "
+ "(@FirstName,@LastName,@DateOfBirth,@Active,@ClientNote,@Location_Id,@NumberInHousehold)";
context.Database.ExecuteSqlCommand(query,
new SqlParameter("@FirstName", hfedClient.FirstName),
new SqlParameter("@LastName", hfedClient.LastName),
new SqlParameter("@DateOfBirth", hfedClient.DateOfBirth.ToShortDateString()),
new SqlParameter("@Active", hfedClient.Active ? 1 : 0),
new SqlParameter("@ClientNote", hfedClient.ClientNote + ""),
new SqlParameter("@Location_Id", hfedClient.Location.Id),
new SqlParameter("@NumberInHousehold", hfedClient.NumberInHousehold));
}
// This version not updating location change:
TempData["ClientLocationId"] = hfedClient.Location.Id;
return(RedirectToAction("Index"));
}
