public IActionResult Edit(long id, [Bind("id,profile_id,tobacco,tobacco_amount,tobacco_years,alcohol,alcohol_type,alcohol_freq,last_drink,drink_amount,withdrawal_symptons,withdrawal_symptons_description,blackouts,blackouts_freq,illicit_drugs,drug_type,drug_freq,date_of_last_use,substance_abuse_treatment,agency,treatment_type,treatment_date,support_programs,support_programs_description,triggers,triggers_description,use_legal_issues,legal_issues_description")] mp_substance_use mp_substance_use)
{
if (id != mp_substance_use.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_substanceUseService.UpdateSubstanceUse(mp_substance_use);
}
catch (DbUpdateConcurrencyException)
{
if (!_substanceUseService.substanceUseExists(mp_substance_use.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(mp_substance_use));
}
public async Task <IActionResult> Create([Bind("profile_id,tobacco,tobacco_amount,tobacco_years,alcohol,alcohol_type,alcohol_freq,last_drink,drink_amount,withdrawal_symptons,withdrawal_symptons_description,blackouts,blackouts_freq,illicit_drugs,drug_type,drug_freq,date_of_last_use,substance_abuse_treatment,agency,treatment_type,treatment_date,support_programs,support_programs_description,triggers,triggers_description,use_legal_issues,legal_issues_description")] mp_substance_use mp_substance_use)
{
if (ModelState.IsValid)
{
await _substanceUseService.AddSubstanceUse(mp_substance_use);
return(RedirectToAction(nameof(Index)));
}
return(View(nameof(Index)));
}
//updates mp_substance_use record
//returns 0 if record was not found
public int UpdateSubstanceUse(mp_substance_use substance_use)
{
var existing = _context.mp_substance_use.FirstOrDefault(m => m.id == substance_use.id);
if (existing != null)
{
//do update
substance_use.created_at = existing.created_at;
substance_use.created_by = existing.created_by;
_context.Entry(existing).CurrentValues.SetValues(substance_use);
return(_context.SaveChanges());
}
return(0);
}
public string SubstanceUse(mp_substance_use mp_substance_use, IFormCollection collections)
{
if (ModelState.IsValid)
{
var profile = _profileService.GetByUserId(Guid.Parse(User.FindFirstValue(ClaimTypes.NameIdentifier)));
mp_substance_use.created_at = DateTime.Now;
mp_substance_use.created_by = User.FindFirstValue(ClaimTypes.NameIdentifier);
mp_substance_use.profile_id = Guid.Parse(collections["profile_id"]);
mp_substance_use.appointment_id = Guid.Parse(collections["appointment_id"]);
_pschosocialService.AddSubstanceUse(mp_substance_use);
return("success");
}
return("failure");
}
public int AddSubstanceUse(mp_substance_use substance_use)
{
_context.Add(substance_use);
return(_context.SaveChanges());
}
//adds mp_substance_use to the db
public async Task <int> AddSubstanceUse(mp_substance_use substance_use)
{
_context.Add(substance_use);
return(await _context.SaveChangesAsync());
}
