static void part4()
{
dynamic MyDynamicVar = 4534534;
Console.WriteLine(MyDynamicVar.GetType() + "\t" + MyDynamicVar);
dynamic MyDynamicVar2 = 156476746766L;
Console.WriteLine(MyDynamicVar2.GetType() + "\t" + MyDynamicVar2);
MyDynamicVar = 100;
Console.WriteLine("Value: {0}, Type: {1}", MyDynamicVar, MyDynamicVar.GetType());
MyDynamicVar = "Hello World!!";
Console.WriteLine("Value: {0}, Type: {1}", MyDynamicVar, MyDynamicVar.GetType());
MyDynamicVar = true;
Console.WriteLine("Value: {0}, Type: {1}", MyDynamicVar, MyDynamicVar.GetType());
MyDynamicVar = DateTime.Now;
Console.WriteLine("Value: {0}, Type: {1}", MyDynamicVar, MyDynamicVar.GetType());
dynamic stud = new Studentx();
//stud.DisplayStudentInfo(1, "Bill");// run-time error, no compile-time error
//stud.DisplayStudentInfo("1");// run-time error, no compile-time error
//stud.FakeMethod();// run-time error, no compile-time error
}
public ActionResult DeleteConfirmed(int id)
{
Studentx studentx = db.Studentx.Find(id);
db.Studentx.Remove(studentx);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Archive(StudentViewModel model)
{
Studentx svm = db.Studentx.Find(model.Student_id);
svm.Active = model.Active;
svm.DeletedAt = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}//Archive
public ActionResult DeleteConfirmed(int id)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
Studentx studentx = db.Studentx.Find(id);
db.Studentx.Remove(studentx);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}//create
// GET: Studentxes/Edit/5
public ActionResult Edit(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));
}
Studentx studetail = db.Studentx.Find(id);
if (studetail == null)
{
return(HttpNotFound());
}
StudentViewModel view = new StudentViewModel();
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 = DateTime.Now;
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", view.Student_id);
view.Information = studetail.Information;
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", view.User_id);
//stu.Password = studetail.User?.FirstOrDefault()?.Password;
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", view.StudentGroup_id);
return(View(view));
}
public ActionResult Archive(StudentViewModel model)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
Studentx svm = db.Studentx.Find(model.Student_id);
svm.Active = model.Active;
svm.DeletedAt = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}//Archive
}//edit
// GET: Studentxes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Studentx studetail = db.Studentx.Find(id);
if (studetail == null)
{
return(HttpNotFound());
}
StudentViewModel stu = new StudentViewModel();
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;
stu.Information = studetail.Information;
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 = studetail.User?.FirstOrDefault()?.User_id;
stu.UserIdentity = studetail.User?.FirstOrDefault()?.UserIdentity;
stu.Password = studetail.User?.FirstOrDefault()?.Password;
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;
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 = studetail.StudentGroup?.StudentGroup_id;
stu.StudentGroupName = studetail.StudentGroup?.StudentGroupName;
return(View(stu));
}
// Hoitajatietojen arkistointi:
// GET: Customers/Archive/5
public ActionResult Archive(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Studentx student = db.Studentx.Find(id);
if (student == null)
{
return(HttpNotFound());
}
StudentViewModel svm = new StudentViewModel();
svm.Student_id = student.Student_id;
svm.Active = student.Active;
svm.DeletedAt = DateTime.Now;
return(View(svm));
}//Archive
// Hoitajatietojen arkistointi:
// GET: Customers/Archive/5
public ActionResult Archive(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));
}
Studentx student = db.Studentx.Find(id);
if (student == null)
{
return(HttpNotFound());
}
StudentViewModel svm = new StudentViewModel();
svm.Student_id = student.Student_id;
svm.Active = student.Active;
svm.DeletedAt = DateTime.Now;
return(View(svm));
}//Archive
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));
}//
public ActionResult Edit(StudentViewModel model)
{
Studentx stu = db.Studentx.Find(model.Student_id);
stu.FirstName = model.FirstNameH;
stu.LastName = model.LastNameH;
stu.Identity = model.Identity;
stu.Address = model.Address;
stu.Email = model.Email;
stu.EnrollmentDateIN = model.EnrollmentDateIN;
stu.EnrollmentDateOUT = model.EnrollmentDateOUT;
stu.EnrollmentDateOFF = model.EnrollmentDateOFF;
stu.Notes = model.Notes;
stu.CreatedAt = model.CreatedAt;
stu.LastModifiedAt = DateTime.Now;
stu.DeletedAt = model.DeletedAt;
stu.Active = model.Active;
ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", stu.Student_id);
stu.Information = model.Information;
//ViewBag.User_id = new SelectList(db.User, "User_id", "UserIdentity");
if (stu.User == null)
{
User usr = new User();
usr.UserIdentity = model.UserIdentity;
usr.Password = "******";
usr.Studentx = stu;
db.User.Add(usr);
}
else
{
User user = stu.User.FirstOrDefault();
if (user != null)
{
user.UserIdentity = model.UserIdentity;
}
}
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
if (stu.Phone == null)
{
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.Studentx = stu;
db.Phone.Add(pho);
}
else
{
Phone pho = stu.Phone.FirstOrDefault();
if (pho != null)
{
pho.PhoneNum_1 = model.PhoneNum_1;
}
}
if (stu.PostOffices == null)
{
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.Studentx = stu;
db.PostOffices.Add(pos);
}
else
{
PostOffices po = stu.PostOffices.FirstOrDefault();
if (po != null)
{
po.PostalCode = model.PostalCode;
po.PostOffice = model.PostOffice;
}
}
int studentgroupId = int.Parse(model.StudentGroupName);
if (studentgroupId > 0)
{
StudentGroup stg = db.StudentGroup.Find(studentgroupId);
stu.StudentGroup_id = stg.StudentGroup_id;
}
ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null);
db.SaveChanges();
return(RedirectToAction("Index"));
}//edit
public ActionResult Create(StudentViewModel model)
{
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
Studentx stu = new Studentx();
stu.FirstName = model.FirstNameH;
stu.LastName = model.LastNameH;
stu.Identity = model.Identity;
stu.Address = model.Address;
stu.Email = model.Email;
stu.Notes = model.Notes;
stu.EnrollmentDateIN = model.EnrollmentDateIN;
stu.EnrollmentDateOUT = model.EnrollmentDateOUT;
stu.EnrollmentDateOFF = model.EnrollmentDateOFF;
stu.CreatedAt = DateTime.Now;
stu.LastModifiedAt = DateTime.Now;
stu.DeletedAt = model.DeletedAt;
stu.Active = model.Active;
stu.Information = model.Information;
db.Studentx.Add(stu);
User usr = new User();
usr.UserIdentity = model.UserIdentity;
usr.Password = "******";
usr.Studentx = stu;
db.User.Add(usr);
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.Studentx = stu;
db.Phone.Add(pho);
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.Studentx = stu;
db.PostOffices.Add(pos);
// etsitään StudentGroup-rivi kannasta valitun nimen perusteella
int studentgroupId = int.Parse(model.StudentGroupName);
if (studentgroupId > 0)
{
StudentGroup stg = db.StudentGroup.Find(studentgroupId);
stu.StudentGroup_id = stg.StudentGroup_id;
}
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null);
ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", null);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create
}//
// 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
