public ActionResult Create(TreatmentPlaceViewModel model)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
TreatmentPlace trp = new TreatmentPlace();
trp.TreatmentPlaceName = model.TreatmentPlaceName;
trp.TreatmentPlaceNumber = model.TreatmentPlaceNumber;
db.TreatmentPlace.Add(trp);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}
// GET: TreatmentPlaces
public ActionResult Index()
{
//string username = User.Identity.Name;
//string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <TreatmentPlaceViewModel> model = new List <TreatmentPlaceViewModel>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <TreatmentPlace> treatplaces = entities.TreatmentPlace.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (TreatmentPlace treatplace in treatplaces)
{
TreatmentPlaceViewModel view = new TreatmentPlaceViewModel();
view.TreatmentPlace_id = treatplace.TreatmentPlace_id;
view.TreatmentPlaceName = treatplace.TreatmentPlaceName;
view.TreatmentPlaceNumber = treatplace.TreatmentPlaceNumber;
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//Index
}//Index
// GET: TreatmentPlaces/Details/5
//public ActionResult Details(int? id)
//{
// TreatmentPlaceViewModel model = new TreatmentPlaceViewModel();
// JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
// try
// {
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// TreatmentPlace treatmentPlace = db.TreatmentPlace.Find(id);
// if (treatmentPlace == null)
// {
// return HttpNotFound();
// }
// // muodostetaan näkymämalli tietokannan rivien pohjalta
// TreatmentPlaceViewModel view = new TreatmentPlaceViewModel();
// view.TreatmentPlace_id = treatmentPlace.TreatmentPlace_id;
// view.TreatmentPlaceName = treatmentPlace.TreatmentPlaceName;
// view.TreatmentPlaceNumber = treatmentPlace.TreatmentPlaceNumber;
// model = view;
// }
// finally
// {
// entities.Dispose();
// }
// return View(model);
//}//details
// GET: TreatmentPlaces/Create
public ActionResult Create()
{
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
TreatmentPlaceViewModel model = new TreatmentPlaceViewModel();
return(View(model));
}//create
public ActionResult Edit(TreatmentPlaceViewModel model)
{
TreatmentPlace treatplace = db.TreatmentPlace.Find(model.TreatmentPlace_id);
treatplace.TreatmentPlaceName = model.TreatmentPlaceName;
treatplace.TreatmentPlaceNumber = model.TreatmentPlaceNumber;
db.SaveChanges();
return(RedirectToAction("Index"));
}//edit
}//Index
// GET: TreatmentPlaces/Details/5
//public ActionResult Details(int? id)
//{
// TreatmentPlaceViewModel model = new TreatmentPlaceViewModel();
// JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
// try
// {
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// TreatmentPlace treatmentPlace = db.TreatmentPlace.Find(id);
// if (treatmentPlace == null)
// {
// return HttpNotFound();
// }
// // muodostetaan näkymämalli tietokannan rivien pohjalta
// TreatmentPlaceViewModel view = new TreatmentPlaceViewModel();
// view.TreatmentPlace_id = treatmentPlace.TreatmentPlace_id;
// view.TreatmentPlaceName = treatmentPlace.TreatmentPlaceName;
// view.TreatmentPlaceNumber = treatmentPlace.TreatmentPlaceNumber;
// model = view;
// }
// finally
// {
// entities.Dispose();
// }
// return View(model);
//}//details
// GET: TreatmentPlaces/Create
public ActionResult Create()
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
TreatmentPlaceViewModel model = new TreatmentPlaceViewModel();
return(View(model));
}//create
public ActionResult Edit(TreatmentPlaceViewModel model)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
TreatmentPlace treatplace = db.TreatmentPlace.Find(model.TreatmentPlace_id);
treatplace.TreatmentPlaceName = model.TreatmentPlaceName;
treatplace.TreatmentPlaceNumber = model.TreatmentPlaceNumber;
db.SaveChanges();
return(RedirectToAction("Index"));
}//edit
}//edit
// GET: TreatmentPlaces/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TreatmentPlace treatmentPlace = db.TreatmentPlace.Find(id);
if (treatmentPlace == null)
{
return(HttpNotFound());
}
TreatmentPlaceViewModel view = new TreatmentPlaceViewModel();
view.TreatmentPlace_id = treatmentPlace.TreatmentPlace_id;
view.TreatmentPlaceName = treatmentPlace.TreatmentPlaceName;
view.TreatmentPlaceNumber = treatmentPlace.TreatmentPlaceNumber;
return(View(view));
}//Delete
// GET: TreatmentPlaces/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TreatmentPlace treatmentPlace = db.TreatmentPlace.Find(id);
if (treatmentPlace == null)
{
return(HttpNotFound());
}
TreatmentPlaceViewModel treatplace = new TreatmentPlaceViewModel();
treatplace.TreatmentPlace_id = treatmentPlace.TreatmentPlace_id;
treatplace.TreatmentPlaceName = treatmentPlace.TreatmentPlaceName;
treatplace.TreatmentPlaceNumber = treatmentPlace.TreatmentPlaceNumber;
return(View(treatplace));
}
public ActionResult Create(TreatmentPlaceViewModel model)
{
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
TreatmentPlace trp = new TreatmentPlace();
trp.TreatmentPlaceName = model.TreatmentPlaceName;
trp.TreatmentPlaceNumber = model.TreatmentPlaceNumber;
db.TreatmentPlace.Add(trp);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}
}//edit
// GET: TreatmentPlaces/Delete/5
public ActionResult Delete(int?id)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TreatmentPlace treatmentPlace = db.TreatmentPlace.Find(id);
if (treatmentPlace == null)
{
return(HttpNotFound());
}
TreatmentPlaceViewModel view = new TreatmentPlaceViewModel();
view.TreatmentPlace_id = treatmentPlace.TreatmentPlace_id;
view.TreatmentPlaceName = treatmentPlace.TreatmentPlaceName;
view.TreatmentPlaceNumber = treatmentPlace.TreatmentPlaceNumber;
return(View(view));
}//Delete
