// GET: Phones
public ActionResult Index()
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <Phone> model = new List <Phone>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Phone> phones = entities.Phone.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Phone phone in phones)
{
Phone view = new Phone();
view.Phone_id = phone.Phone_id;
view.PhoneNum_1 = phone.PhoneNum_1;
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}
// 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
// GET: Henkilo
public ActionResult Index()
{
List <SimplyTunnitData> model = new List <SimplyTunnitData>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Henkilot> henkilot = entities.Henkilot.OrderByDescending(Henkilot => Henkilot.Sukunimi).ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Henkilot henkilo in henkilot)
{
SimplyTunnitData hlo = new SimplyTunnitData();
hlo.Henkilo_id = henkilo.Henkilo_id;
hlo.Etunimi = henkilo.Etunimi;
hlo.Sukunimi = henkilo.Sukunimi;
hlo.Osoite = henkilo.Osoite;
hlo.Esimies = henkilo.Esimies;
hlo.Postinumero = henkilo.Postinumero;
model.Add(hlo);
}
return(View(model));
}
finally
{
entities.Dispose();
}
}
// GET: Henkilo/Details/5
public ActionResult Details(int?id)
{
List <SimplyTunnitData> model = new List <SimplyTunnitData>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
Henkilot henkilodetail = entities.Henkilot.Find(id);
if (henkilodetail == null)
{
return(HttpNotFound());
}
SimplyTunnitData hlo = new SimplyTunnitData();
hlo.Henkilo_id = henkilodetail.Henkilo_id;
hlo.Etunimi = henkilodetail.Etunimi;
hlo.Sukunimi = henkilodetail.Sukunimi;
hlo.Osoite = henkilodetail.Osoite;
hlo.Esimies = henkilodetail.Esimies;
hlo.Postinumero = henkilodetail.Postinumero;
}
finally
{
entities.Dispose();
}
return(View(model));
}
// GET: Studentxes
public ActionResult Index()
{
//string username = User.Identity.Name;
//string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <StudentViewModel> model = new List <StudentViewModel>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Studentx> students = entities.Studentx.OrderBy(Studentx => Studentx.LastName).ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Studentx student in students)
{
StudentViewModel stu = new StudentViewModel();
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
stu.User_id = student.User?.FirstOrDefault()?.User_id;
stu.UserIdentity = student.User?.FirstOrDefault()?.UserIdentity;
stu.Student_id = student.Student_id;
stu.FirstNameH = student.FirstName;
stu.LastNameH = student.LastName;
stu.Identity = student.Identity;
stu.Address = student.Address;
stu.Email = student.Email;
stu.EnrollmentDateIN = student.EnrollmentDateIN;
stu.EnrollmentDateOUT = student.EnrollmentDateOUT;
stu.EnrollmentDateOFF = student.EnrollmentDateOFF;
stu.Notes = student.Notes;
stu.CreatedAt = student.CreatedAt;
stu.LastModifiedAt = student.LastModifiedAt;
stu.DeletedAt = student.DeletedAt;
ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", null);
stu.Active = student.Active;
stu.Information = student.Information;
stu.Phone_id = student.Phone?.FirstOrDefault()?.Phone_id;
stu.PhoneNum_1 = student.Phone?.FirstOrDefault()?.PhoneNum_1;
stu.Post_id = student.PostOffices?.FirstOrDefault()?.Post_id;
stu.PostalCode = student.PostOffices?.FirstOrDefault()?.PostalCode;
stu.PostOffice = student.PostOffices?.FirstOrDefault()?.PostOffice;
ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null);
stu.StudentGroup_id = student.StudentGroup?.StudentGroup_id;
stu.StudentGroupName = student.StudentGroup?.StudentGroupName;
model.Add(stu);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}
//2.vaihtoehto ilman ViewModel luokkaa
//List<Henkilot> model = new List<Henkilot>();
//try
//{
// JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
// model = entities.Henkilot.ToList();
// entities.Dispose();
//}
//catch (Exception ex)
//{
// ViewBag.ErrorMessage = ex.GetType() + ": " + ex.Message;
//}
//return View(model);
public ActionResult GetTunnit(int?id)
{
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
List <Tunnit> tunnit = (from t in entities.Tunnit
where t.Henkilo_id == id
select t).ToList();
List <SimplyTunnitData> result = new List <SimplyTunnitData>();
CultureInfo fiFi = new CultureInfo("fi-FI");
foreach (Tunnit tunti in tunnit)
{
SimplyTunnitData data = new SimplyTunnitData();
data.Tunti_id = tunti.Tunti_id;
data.Henkilo_id = (int)(tunti.Henkilo_id);
//data.Pvm = tunti.Pvm.Value.ToString(fiFi);
data.Pvm = tunti.Pvm;
data.ProjektiTunnit = (int)tunti.ProjektiTunnit;
List <Projektit> projektit = (from p in entities.Projektit
where p.Projekti_id == tunti.Projekti_id
select p).ToList();
data.ProjektiNimi = projektit[0].ProjektiNimi;
result.Add(data);
}
entities.Dispose();
return(Json(result, JsonRequestBehavior.AllowGet));
}
// GET: StudentGroups
public ActionResult Index()
{
//string username = User.Identity.Name;
//string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <StudentGroupViewModel> model = new List <StudentGroupViewModel>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <StudentGroup> treatoffs = entities.StudentGroup.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (StudentGroup stg in treatoffs)
{
StudentGroupViewModel view = new StudentGroupViewModel();
view.StudentGroup_id = stg.StudentGroup_id;
view.StudentGroupName = stg.StudentGroupName;
view.Active = stg.Active;
view.CreatedAt = stg.CreatedAt;
view.LastModifiedAt = stg.LastModifiedAt;
view.DeletedAt = stg.DeletedAt;
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//Index
// GET: Projekti
public ActionResult Index()
{
List <SimplyTunnitData> model = new List <SimplyTunnitData>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Projektit> projektit = entities.Projektit.OrderByDescending(Projektit => Projektit.Avattu).ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Projektit projekti in projektit)
{
SimplyTunnitData pro = new SimplyTunnitData();
pro.Projekti_id = projekti.Projekti_id;
pro.ProjektiNimi = projekti.ProjektiNimi;
pro.Esimies = projekti.Esimies;
pro.Avattu = projekti.Avattu;
pro.Suljettu = projekti.Suljettu;
pro.Status = projekti.Status;
model.Add(pro);
}
return(View(model));
}
finally
{
entities.Dispose();
}
}
// GET: PostOffices
public ActionResult Index()
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <PostOffices> model = new List <PostOffices>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <PostOffices> postoff = entities.PostOffices.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (PostOffices post in postoff)
{
PostOffices view = new PostOffices();
view.Post_id = post.Post_id;
view.PostalCode = post.PostalCode;
view.PostOffice = post.PostOffice;
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//Index
// GET: Customers
public ActionResult Index()
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <CustomerViewModel> model = new List <CustomerViewModel>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Customer> customers = entities.Customer.OrderBy(Customer => Customer.LastName).ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Customer customer in customers)
{
CustomerViewModel view = new CustomerViewModel();
view.User_id = customer.User?.FirstOrDefault()?.User_id;
view.UserIdentity = customer.User?.FirstOrDefault()?.UserIdentity;
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
view.Customer_id = customer.Customer_id;
view.FirstNameA = customer.FirstName;
view.LastNameA = customer.LastName;
view.Identity = customer.Identity;
view.Email = customer.Email;
view.Address = customer.Address;
view.Notes = customer.Notes;
view.CreatedAt = customer.CreatedAt;
view.LastModifiedAt = customer.LastModifiedAt;
view.DeletedAt = customer.DeletedAt;
view.Active = customer.Active;
view.Permission = customer.Permission;
view.Phone_id = customer.Phone?.FirstOrDefault()?.Phone_id;
view.PhoneNum_1 = customer.Phone?.FirstOrDefault()?.PhoneNum_1;
view.Post_id = customer.PostOffices?.FirstOrDefault()?.Post_id;
view.PostalCode = customer.PostOffices?.FirstOrDefault()?.PostalCode;
view.PostOffice = customer.PostOffices?.FirstOrDefault()?.PostOffice;
//haetaan seuraava varaus:
view.Reservation_id = customer.Reservation?.FirstOrDefault()?.Reservation_id;
view.Start = customer.Reservation?.FirstOrDefault()?.Start;
view.End = customer.Reservation?.FirstOrDefault()?.End.Value;
view.Date = customer.Reservation?.FirstOrDefault()?.Date.Value;
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//Index
//PDF-tiedoston luominen:
public ActionResult DownloadViewPDF(int?id)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
PersonnelViewModel model = new PersonnelViewModel();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Personnel> personnels = entities.Personnel.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Personnel persdetail in personnels)
{
PersonnelViewModel view = new PersonnelViewModel();
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
view.User_id = persdetail.User?.FirstOrDefault()?.User_id;
view.UserIdentity = persdetail.User?.FirstOrDefault()?.UserIdentity;
view.Personnel_id = persdetail.Personnel_id;
view.FirstNameP = persdetail.FirstName;
view.LastNameP = persdetail.LastName;
view.Identity = persdetail.Identity;
view.Email = persdetail.Email;
view.Notes = persdetail.Notes;
view.CreatedAt = persdetail.CreatedAt;
view.LastModifiedAt = persdetail.LastModifiedAt;
view.DeletedAt = persdetail.DeletedAt;
view.Active = persdetail.Active;
view.Information = persdetail.Information;
view.Phone_id = persdetail.Phone?.FirstOrDefault()?.Phone_id;
view.PhoneNum_1 = persdetail.Phone?.FirstOrDefault()?.PhoneNum_1;
view.Post_id = persdetail.PostOffices?.FirstOrDefault()?.Post_id;
view.PostalCode = persdetail.PostOffices?.FirstOrDefault()?.PostalCode;
view.PostOffice = persdetail.PostOffices?.FirstOrDefault()?.PostOffice;
model = view;
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Personnel personnel = db.Personnel.Find(id);
if (personnel == null)
{
return(HttpNotFound());
}
}
finally
{
entities.Dispose();
}
return(new ViewAsPdf(model));
}//DownloadViewPDF
public int PersonCount()
{
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
int personCount = entities.Henkilot.Count();
entities.Dispose();
return(personCount);
}
public int ProjectCount()
{
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
int projectCount = entities.Projektit.Count();
entities.Dispose();
return(projectCount);
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
//[Authorize(Roles = "Personnel User")]
// GET: Reports
public ActionResult HoursPerReservation()
{
//string username = User.Identity.Name;
//string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
DateTime today = DateTime.Today;
DateTime tomorrow = today.AddDays(1);
// haetaan kaikki kuluvan päivän tuntikirjaukset
List <Reservation> allReservationsToday = (from rs in entities.Reservation
where (rs.Start > today) &&
(rs.Start < tomorrow) &&
(rs.TreatmentCompleted == true)
select rs).ToList();
// ryhmitellään kirjaukset tehtävittäin, ja lasketaan kestot
List <HoursPerReservationModel> model = new List <HoursPerReservationModel>();
foreach (Reservation reservation in allReservationsToday)
{
int reservationId = reservation.Reservation_id;
HoursPerReservationModel existing = model.Where(
m => m.Reservation_id == reservationId).FirstOrDefault();
if (existing != null)
{
existing.TotalHours += (reservation.End.Value - reservation.Start.Value).TotalHours;
}
else
{
existing = new HoursPerReservationModel()
{
Reservation_id = reservationId,
TreatmentName = reservation.Treatment.TreatmentName,
TotalHours = (reservation.End.Value - reservation.Start.Value).TotalHours
};
model.Add(existing);
}
}
return(View(model));
}
finally
{
entities.Dispose();
}
}
// GET: Personnels
public ActionResult Index()
{
//string username = User.Identity.Name;
//string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <PersonnelViewModel> model = new List <PersonnelViewModel>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Personnel> personnels = entities.Personnel.OrderBy(Personnel => Personnel.LastName).ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Personnel personnel in personnels)
{
PersonnelViewModel view = new PersonnelViewModel();
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
view.User_id = personnel.User?.FirstOrDefault()?.User_id;
view.UserIdentity = personnel.User?.FirstOrDefault()?.UserIdentity;
view.Personnel_id = personnel.Personnel_id;
view.FirstNameP = personnel.FirstName;
view.LastNameP = personnel.LastName;
view.Identity = personnel.Identity;
view.Email = personnel.Email;
view.Notes = personnel.Notes;
view.CreatedAt = personnel.CreatedAt;
view.LastModifiedAt = personnel.LastModifiedAt;
view.DeletedAt = personnel.DeletedAt;
view.Active = personnel.Active;
view.Phone_id = personnel.Phone?.FirstOrDefault()?.Phone_id;
view.PhoneNum_1 = personnel.Phone?.FirstOrDefault()?.PhoneNum_1;
view.Post_id = personnel.PostOffices?.FirstOrDefault()?.Post_id;
view.PostalCode = personnel.PostOffices?.FirstOrDefault()?.PostalCode;
view.PostOffice = personnel.PostOffices?.FirstOrDefault()?.PostOffice;
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//Index
public List <string> Henkilomaara(int id)
{
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
int henkilotToReturn = id;
List <Henkilot> allHenkilot =
(from h in entities.Henkilot orderby h.Sukunimi descending select h).Take(henkilotToReturn).ToList();
List <string> henkiloNimet =
allHenkilot.Select(h => h.Sukunimi).ToList();
//List<string> projektiStatus =
// allProjects.Select(n => n.Status).ToList();
entities.Dispose();
return(henkiloNimet);
}
public List <string> ProjectStatus(int id)
{
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
int projectStatusToReturn = id;
List <Projektit> allProjects =
(from p in entities.Projektit orderby p.Status descending select p).Take(projectStatusToReturn).ToList();
List <string> projektiNimet =
allProjects.Select(p => p.ProjektiNimi).ToList();
//List<string> projektiStatus =
// allProjects.Select(n => n.Status).ToList();
entities.Dispose();
return(projektiNimet);
}
}//DownloadViewPDF
//Lisätty 10.3.2017
// GET: Personnels/Details/5
public ActionResult Details(int?id)
{
PersonnelViewModel model = new PersonnelViewModel();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
Personnel persdetail = entities.Personnel.Find(id);
if (persdetail == null)
{
return(HttpNotFound());
}
// muodostetaan näkymämalli tietokannan rivien pohjalta
PersonnelViewModel view = new PersonnelViewModel();
view.Personnel_id = persdetail.Personnel_id;
view.FirstNameP = persdetail.FirstName;
view.LastNameP = persdetail.LastName;
view.Identity = persdetail.Identity;
view.Email = persdetail.Email;
view.Notes = persdetail.Notes;
view.CreatedAt = persdetail.CreatedAt;
view.LastModifiedAt = persdetail.LastModifiedAt;
view.DeletedAt = persdetail.DeletedAt;
view.Active = persdetail.Active;
view.Information = persdetail.Information;
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
view.User_id = persdetail.User?.FirstOrDefault()?.User_id;
view.UserIdentity = persdetail.User?.FirstOrDefault()?.UserIdentity;
view.Phone_id = persdetail.Phone?.FirstOrDefault()?.Phone_id;
view.PhoneNum_1 = persdetail.Phone?.FirstOrDefault()?.PhoneNum_1;
view.Post_id = persdetail.PostOffices?.FirstOrDefault()?.Post_id;
view.PostalCode = persdetail.PostOffices?.FirstOrDefault()?.PostalCode;
view.PostOffice = persdetail.PostOffices?.FirstOrDefault()?.PostOffice;
model = view;
}
finally
{
entities.Dispose();
}
return(View(model));
}//details
}//Index
// GET: StudentGroups/Details/5
public ActionResult Details(int?id)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
StudentGroupViewModel model = new StudentGroupViewModel();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <StudentGroup> stugs = entities.StudentGroup.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (StudentGroup stg in stugs)
{
StudentGroupViewModel view = new StudentGroupViewModel();
view.StudentGroup_id = stg.StudentGroup_id;
view.StudentGroupName = stg.StudentGroupName;
view.Active = stg.Active;
view.CreatedAt = stg.CreatedAt;
view.LastModifiedAt = stg.LastModifiedAt;
view.DeletedAt = stg.DeletedAt;
model = view;
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentGroup studentGroup = db.StudentGroup.Find(id);
if (studentGroup == null)
{
return(HttpNotFound());
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//details
// GET: Tunti/Details/5
public ActionResult Details(int?id)
{
List <SimplyTunnitData> model = new List <SimplyTunnitData>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
Tunnit tunti = entities.Tunnit.Find(id);
if (tunti == null)
{
return(HttpNotFound());
}
Tunnit tuntidetail = entities.Tunnit.Find(tunti.Tunti_id);
SimplyTunnitData tun = new SimplyTunnitData();
tun.Tunti_id = tuntidetail.Tunti_id;
tun.Pvm = tuntidetail.Pvm.GetValueOrDefault();
tun.ProjektiTunnit = tuntidetail.ProjektiTunnit;
tun.Henkilo_id = tuntidetail.Henkilot.Henkilo_id;
tun.Etunimi = tuntidetail.Henkilot.Etunimi;
tun.Sukunimi = tuntidetail.Henkilot.Sukunimi;
tun.Projekti_id = tuntidetail.Projektit.Projekti_id;
tun.ProjektiNimi = tuntidetail.Projektit.ProjektiNimi;
tun.Esimies = tuntidetail.Projektit.Esimies;
tun.Avattu = tuntidetail.Projektit.Avattu;
tun.Suljettu = tuntidetail.Projektit.Suljettu;
tun.Status = tuntidetail.Projektit.Status;
ViewBag.ProjektiNimi = new SelectList((from pn in db.Projektit select new { Projekti_id = pn.Projekti_id, ProjektiNimi = pn.ProjektiNimi }), "Projekti_id", "ProjektiNimi", tun.Projekti_id);
ViewBag.KokonimiH = new SelectList((from kn in db.Henkilot select new { Henkilo_id = kn.Henkilo_id, KokonimiH = kn.Etunimi + " " + kn.Sukunimi }), "Henkilo_id", "KokonimiH", tun.Henkilo_id);
}
finally
{
entities.Dispose();
}
return(View(model));
}
// GET: Users
public ActionResult Index()
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <User> model = new List <User>();
try
{
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
model = entities.User.ToList();
entities.Dispose();
}
catch (Exception ex)
{
ViewBag.ErrorMessage = ex.GetType() + ": " + ex.Message;
}
//malliolion (model) välitys näkymälle- antaa instanssin asiakastietolistasta:
return(View(model));
}
// GET: Treatments
public ActionResult Index()
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <Treatment> model = new List <Treatment>();
try
{
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
model = entities.Treatment.ToList();
entities.Dispose();
}
catch (Exception ex)
{
ViewBag.ErrorMessage = ex.GetType() + ": " + ex.Message;
}
// List<Treatment> treatoffs = entities.Treatment.ToList();
// // muodostetaan näkymämalli tietokannan rivien pohjalta
// foreach (Treatment treatoff in treatoffs)
// {
// Treatment view = new Treatment();
// view.Treatment_id = treatoff.Treatment_id;
// view.TreatmentName = treatoff.TreatmentName;
// view.TreatmentTime = treatoff.TreatmentTime;
// view.TreatmentPrice = treatoff.TreatmentPrice;
// model.Add(view);
// }
//}
//finally
//{
// entities.Dispose();
//}
return(View(model));
}
}//Index
//Lisätty 28.3.2017 oma koodi:
// GET: TreatmentOffices/Details/5
public ActionResult Details(int?id)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
TreatmentOfficeViewModel model = new TreatmentOfficeViewModel();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
TreatmentOffice treatoff = entities.TreatmentOffice.Find(id);
if (treatoff == null)
{
return(HttpNotFound());
}
TreatmentOfficeViewModel view = new TreatmentOfficeViewModel();
view.TreatmentOffice_id = treatoff.TreatmentOffice_id;
view.TreatmentOfficeName = treatoff.TreatmentOfficeName;
view.Address = treatoff.Address;
view.Note = treatoff.Note;
view.MapPlace = treatoff.MapPlace;
view.Phone_id = treatoff.Phone?.FirstOrDefault()?.Phone_id;
view.PhoneNum_1 = treatoff.Phone?.FirstOrDefault()?.PhoneNum_1;
view.Post_id = treatoff.PostOffices?.FirstOrDefault()?.Post_id;
view.PostalCode = treatoff.PostOffices?.FirstOrDefault()?.PostalCode;
view.PostOffice = treatoff.PostOffices?.FirstOrDefault()?.PostOffice;
model = view;
}
finally
{
entities.Dispose();
}
return(View(model));
}//details
}//Index
// GET: StudentGroups/Details/5
public ActionResult Details(int?id)
{
StudentGroupViewModel model = new StudentGroupViewModel();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <StudentGroup> stugs = entities.StudentGroup.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (StudentGroup stg in stugs)
{
StudentGroupViewModel view = new StudentGroupViewModel();
view.StudentGroup_id = stg.StudentGroup_id;
view.StudentGroupName = stg.StudentGroupName;
view.Active = stg.Active;
view.CreatedAt = stg.CreatedAt;
view.LastModifiedAt = stg.LastModifiedAt;
view.DeletedAt = stg.DeletedAt;
model = view;
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentGroup studentGroup = db.StudentGroup.Find(id);
if (studentGroup == null)
{
return(HttpNotFound());
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//details
// GET: Tunti
public ActionResult Index()
{
List <SimplyTunnitData> model = new List <SimplyTunnitData>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Tunnit> tunnit = entities.Tunnit.OrderByDescending(Tunnit => Tunnit.Pvm).ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Tunnit tunti in tunnit)
{
SimplyTunnitData tun = new SimplyTunnitData();
tun.Tunti_id = tunti.Tunti_id;
tun.Pvm = tunti.Pvm.GetValueOrDefault();
tun.ProjektiTunnit = tunti.ProjektiTunnit;
tun.Henkilo_id = tunti.Henkilot.Henkilo_id;
tun.Etunimi = tunti.Henkilot.Etunimi;
tun.Sukunimi = tunti.Henkilot.Sukunimi;
tun.Projekti_id = tunti.Projektit.Projekti_id;
tun.ProjektiNimi = tunti.Projektit.ProjektiNimi;
tun.Esimies = tunti.Projektit.Esimies;
tun.Avattu = tunti.Projektit.Avattu;
tun.Suljettu = tunti.Projektit.Suljettu;
tun.Status = tunti.Projektit.Status;
model.Add(tun);
}
return(View(model));
}
finally
{
entities.Dispose();
}
}
// GET: TreatmentOffices
public ActionResult Index()
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <TreatmentOfficeViewModel> model = new List <TreatmentOfficeViewModel>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <TreatmentOffice> treatoffs = entities.TreatmentOffice.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (TreatmentOffice treatoff in treatoffs)
{
TreatmentOfficeViewModel view = new TreatmentOfficeViewModel();
view.TreatmentOffice_id = treatoff.TreatmentOffice_id;
view.TreatmentOfficeName = treatoff.TreatmentOfficeName;
view.Address = treatoff.Address;
view.Note = treatoff.Note;
view.MapPlace = treatoff.MapPlace;
view.Phone_id = treatoff.Phone?.FirstOrDefault()?.Phone_id;
view.PhoneNum_1 = treatoff.Phone?.FirstOrDefault()?.PhoneNum_1;
view.Post_id = treatoff.PostOffices?.FirstOrDefault()?.Post_id;
view.PostalCode = treatoff.PostOffices?.FirstOrDefault()?.PostalCode;
view.PostOffice = treatoff.PostOffices?.FirstOrDefault()?.PostOffice;
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//Index
}//Index
//Lisätty 28.3.2017 oma koodi:
// GET: TreatmentOffices/Details/5
public ActionResult Details(int?id)
{
TreatmentOfficeViewModel model = new TreatmentOfficeViewModel();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
TreatmentOffice treatoff = entities.TreatmentOffice.Find(id);
if (treatoff == null)
{
return(HttpNotFound());
}
TreatmentOfficeViewModel view = new TreatmentOfficeViewModel();
view.TreatmentOffice_id = treatoff.TreatmentOffice_id;
view.TreatmentOfficeName = treatoff.TreatmentOfficeName;
view.Address = treatoff.Address;
view.Note = treatoff.Note;
view.MapPlace = treatoff.MapPlace;
view.Phone_id = treatoff.Phone?.FirstOrDefault()?.Phone_id;
view.PhoneNum_1 = treatoff.Phone?.FirstOrDefault()?.PhoneNum_1;
view.Post_id = treatoff.PostOffices?.FirstOrDefault()?.Post_id;
view.PostalCode = treatoff.PostOffices?.FirstOrDefault()?.PostalCode;
view.PostOffice = treatoff.PostOffices?.FirstOrDefault()?.PostOffice;
model = view;
}
finally
{
entities.Dispose();
}
return(View(model));
}//details
public ActionResult DownloadViewPDF(int?id)
{
ReservationDetailViewModel model = new ReservationDetailViewModel();
//List<StudentViewModel> model = new List<StudentViewModel>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <Studentx> students = entities.Studentx.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (Studentx studetail in students)
{
ReservationDetailViewModel stu = new ReservationDetailViewModel();
stu.User_id = studetail.User?.FirstOrDefault()?.User_id;
stu.UserIdentity = studetail.User?.FirstOrDefault()?.UserIdentity;
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
//stu.Password = studetail.User?.FirstOrDefault()?.Password;
stu.Student_id = studetail.Student_id;
stu.FirstNameH = studetail.FirstName;
stu.LastNameH = studetail.LastName;
stu.Identity = studetail.Identity;
stu.Address = studetail.Address;
stu.Email = studetail.Email;
stu.EnrollmentDateIN = studetail.EnrollmentDateIN;
stu.EnrollmentDateOUT = studetail.EnrollmentDateOUT;
stu.EnrollmentDateOFF = studetail.EnrollmentDateOFF;
stu.Notes = studetail.Notes;
stu.CreatedAt = studetail.CreatedAt;
stu.LastModifiedAt = studetail.LastModifiedAt;
stu.DeletedAt = studetail.DeletedAt;
stu.Active = studetail.Active;
ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", null);
stu.Information = studetail.Information;
stu.Phone_id = studetail.Phone?.FirstOrDefault()?.Phone_id;
stu.PhoneNum_1 = studetail.Phone?.FirstOrDefault()?.PhoneNum_1;
stu.Post_id = studetail.PostOffices?.FirstOrDefault()?.Post_id;
stu.PostalCode = studetail.PostOffices?.FirstOrDefault()?.PostalCode;
stu.PostOffice = studetail.PostOffices?.FirstOrDefault()?.PostOffice;
stu.StudentGroup_id = studetail.StudentGroup?.StudentGroup_id;
stu.StudentGroupName = studetail.StudentGroup?.StudentGroupName;
ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null);
// muodostetaan Studentx - näkymän alitiedostona asiakkaan palvelutiedot
stu.Studentreservations = new List <StudentDetailViewModel>();
foreach (Reservation res in studetail.Reservation.OrderBy(r => r.Start))
{
stu.Studentreservations.Add(new StudentDetailViewModel()
{
Date = res.Date,
Start = res.Start,
End = res.End,
TreatmentName = res.Treatment?.TreatmentName,
TreatmentTime = res.Treatment?.TreatmentTime,
FirstNameA = res.Customer?.FirstName,
LastNameA = res.Customer?.LastName,
Notes = res.Note
});
}
model = stu;
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Studentx studentx = db.Studentx.Find(id);
if (studentx == null)
{
return(HttpNotFound());
}
}
finally
{
entities.Dispose();
}
return(new ViewAsPdf(model));
}//
}//
// GET: Studentxes/Details/5
public ActionResult Details(int?id)
{
ReservationDetailViewModel model = new ReservationDetailViewModel();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
Studentx studetail = entities.Studentx.Find(id);
if (studetail == null)
{
return(HttpNotFound());
}
// muodostetaan näkymämalli tietokannan rivien pohjalta
ReservationDetailViewModel view = new ReservationDetailViewModel();
view.User_id = studetail.User?.FirstOrDefault()?.User_id;
view.UserIdentity = studetail.User?.FirstOrDefault()?.UserIdentity;
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
//stu.Password = studetail.User?.FirstOrDefault()?.Password;
view.Student_id = studetail.Student_id;
view.FirstNameH = studetail.FirstName;
view.LastNameH = studetail.LastName;
view.Identity = studetail.Identity;
view.Address = studetail.Address;
view.Email = studetail.Email;
view.EnrollmentDateIN = studetail.EnrollmentDateIN;
view.EnrollmentDateOUT = studetail.EnrollmentDateOUT;
view.EnrollmentDateOFF = studetail.EnrollmentDateOFF;
view.Notes = studetail.Notes;
view.CreatedAt = studetail.CreatedAt;
view.LastModifiedAt = studetail.LastModifiedAt;
view.DeletedAt = studetail.DeletedAt;
view.Active = studetail.Active;
ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", null);
view.Information = studetail.Information;
view.Phone_id = studetail.Phone?.FirstOrDefault()?.Phone_id;
view.PhoneNum_1 = studetail.Phone?.FirstOrDefault()?.PhoneNum_1;
view.Post_id = studetail.PostOffices?.FirstOrDefault()?.Post_id;
view.PostalCode = studetail.PostOffices?.FirstOrDefault()?.PostalCode;
view.PostOffice = studetail.PostOffices?.FirstOrDefault()?.PostOffice;
view.StudentGroup_id = studetail.StudentGroup?.StudentGroup_id;
view.StudentGroupName = studetail.StudentGroup?.StudentGroupName;
ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null);
// muodostetaan Studentx - näkymän alitiedostona asiakkaan palvelutiedot
view.Studentreservations = new List <StudentDetailViewModel>();
foreach (Reservation res in studetail.Reservation.OrderBy(r => r.Start))
{
view.Studentreservations.Add(new StudentDetailViewModel()
{
Date = res.Date,
Start = res.Start,
End = res.End,
TreatmentName = res.Treatment?.TreatmentName,
TreatmentTime = res.Treatment?.TreatmentTime,
FirstNameA = res.Customer?.FirstName,
LastNameA = res.Customer?.LastName,
Notes = res.Note
});
}
model = view;
}
finally
{
entities.Dispose();
}
return(View(model));
}//details
