public ActionResult DeleteConfirmed(int aid, int sid) { StudentAssignmentMark studentAssignmentMark = studentAssignmentMarkRepository.GetById(aid, sid); studentAssignmentMarkRepository.Delete(studentAssignmentMark); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "AssignmentId,StudentId,OralMark,TotalMark")] StudentAssignmentMark studentAssignmentMark) { if (ModelState.IsValid) { studentAssignmentMarkRepository.Update(studentAssignmentMark); return(RedirectToAction("Index")); } ViewBag.AssignmentId = new SelectList(studentAssignmentMarkRepository.GetAllAssignmetns(), "AssignmentId", "Title", studentAssignmentMark.AssignmentId); ViewBag.StudentId = new SelectList(studentAssignmentMarkRepository.GetAllStudents(), "StudentId", "FirstName", studentAssignmentMark.StudentId); return(View(studentAssignmentMark)); }
// GET: StudentAssignmentMarks/Details/5 public ActionResult Details(int?aid, int?sid) { if (aid == null || sid == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentAssignmentMark studentAssignmentMark = studentAssignmentMarkRepository.GetById(aid, sid); if (studentAssignmentMark == null) { return(HttpNotFound()); } return(View(studentAssignmentMark)); }
// GET: StudentAssignmentMarks/Edit/5 public ActionResult Edit(int?aid, int?sid) { if (aid == null || sid == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentAssignmentMark studentAssignmentMark = studentAssignmentMarkRepository.GetById(aid, sid); if (studentAssignmentMark == null) { return(HttpNotFound()); } ViewBag.AssignmentId = new SelectList(studentAssignmentMarkRepository.GetAllAssignmetns(), "AssignmentId", "Title", studentAssignmentMark.AssignmentId); ViewBag.StudentId = new SelectList(studentAssignmentMarkRepository.GetAllStudents(), "StudentId", "FirstName", studentAssignmentMark.StudentId); return(View(studentAssignmentMark)); }
protected override void Seed(University.Database.MyDatabase context) { #region Seed Univerisity System #region Seed Trainer //=================Seeding Trainers================= Trainer t1 = new Trainer() { FirstName = "Hector", LastName = "Gatsos", Subject = "C#", PhotoUrl = "http://www.spoudasefest.gr/sites/default/files/styles/square/public/fotografia_gkatsos_1.jpg?itok=b24D-IUm" }; Trainer t2 = new Trainer() { FirstName = "George", LastName = "Pasparakis", Subject = "Java", PhotoUrl = "https://media-exp1.licdn.com/dms/image/C4E03AQFWuZhYfo-rbg/profile-displayphoto-shrink_200_200/0?e=1586995200&v=beta&t=TCz1Q7XZmTArKTRnGIJGlsVJGR1_Hv6aYFq2kA2NrTE" }; Trainer t3 = new Trainer() { FirstName = "Kostas", LastName = "Minaidis", Subject = "Javascript", PhotoUrl = "https://beyond91.cafebabel.com/wp-content/uploads/2016/12/@PhotoMedium-bw.jpg" }; Trainer t4 = new Trainer() { FirstName = "Kostas", LastName = "Stroggylos", Subject = "Databases", PhotoUrl = "https://media-exp1.licdn.com/dms/image/C5103AQFMQARMZAJc-Q/profile-displayphoto-shrink_200_200/0?e=1586995200&v=beta&t=dLec_08Rf4TjOmBL2vlXne_9XAnMaKoxCmA35DTammA" }; Trainer t5 = new Trainer() { FirstName = "Panagiotis", LastName = "Bozas", Subject = "C#", PhotoUrl = "https://media-exp1.licdn.com/dms/image/C5103AQHapdeJGARTlw/profile-displayphoto-shrink_200_200/0?e=1586995200&v=beta&t=c4441f72qyg31oDrrvaJm7DkVSvbClwJ3KJQor3PeQk" }; Trainer t6 = new Trainer() { FirstName = "Vasilis", LastName = "Tzelepopoulos", Subject = "Html-Css", PhotoUrl = "https://pbs.twimg.com/profile_images/955488926365569024/GnDMMyGf.jpg" }; //Trainer t = new Trainer() { FirstName = "", LastName = "", Subject = "" }; #endregion #region Seed Student //=================Seeding Students================= Student s1 = new Student() { FirstName = "Xenofon", LastName = "Vlachogiannis", DateOfBirth = new DateTime(1989, 8, 1), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/54428305_798369990539121_110863100298657792_n.jpg?_nc_cat=102&_nc_sid=dbb9e7&_nc_ohc=FLuw-nBKRPwAX_TOHGD&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=b392127f7f1de4e37166db034ce5e609&oe=5EAE79CE" }; Student s2 = new Student() { FirstName = "Panagiotis", LastName = "Rizos", DateOfBirth = new DateTime(1994, 3, 19), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t31.0-1/c115.0.893.893a/s160x160/16826073_1887513254864184_8287403750433117992_o.jpg?_nc_cat=100&_nc_sid=dbb9e7&_nc_ohc=y8Y-kMo4ebIAX8BNOIF&_nc_ht=scontent.fath6-1.fna&oh=9ef084941114b180b1af03b72e2b3218&oe=5EAC5F8E" }; Student s3 = new Student() { FirstName = "Alex", LastName = "Perikleous", DateOfBirth = new DateTime(1994, 5, 10), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/82950204_2774403002654007_5346124270697185280_o.jpg?_nc_cat=111&_nc_sid=dbb9e7&_nc_ohc=JmwzATYcOI8AX9dSRSQ&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=28cfba789e630071efa6607e74f02b21&oe=5EABD3B1" }; Student s4 = new Student() { FirstName = "Evangelos", LastName = "Koutsogiorgos", DateOfBirth = new DateTime(1987, 2, 27), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/39227285_10212385055998460_863179656449228800_o.jpg?_nc_cat=104&_nc_sid=dbb9e7&_nc_ohc=x-EvdkI1MK4AX_gTAhL&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=062af127cca95bb86ed3d69ff0daedaa&oe=5EACE470" }; Student s5 = new Student() { FirstName = "Zacharias", LastName = "Drimiskianakis", DateOfBirth = new DateTime(1993, 2, 21), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t31.0-1/p160x160/27747689_1760922243939546_4872129996443956546_o.jpg?_nc_cat=105&_nc_sid=dbb9e7&_nc_ohc=PvxCieEs-ZgAX-FqiXU&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=42b86e4416251041cb4f8fb811d99f97&oe=5EAE51F7" }; Student s6 = new Student() { FirstName = "Eleni", LastName = "Parisi", DateOfBirth = new DateTime(1989, 11, 16), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/44643459_1990574251006318_6459707710278467584_o.jpg?_nc_cat=105&_nc_sid=dbb9e7&_nc_ohc=6nHMZjZ6iKwAX_2HsVt&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=81accc94d712c716ef9cdd7c5f2cbe3f&oe=5EADA16D" }; Student s7 = new Student() { FirstName = "Thanos", LastName = "Katrakis", DateOfBirth = new DateTime(1990, 12, 07), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/c227.342.944.944a/s160x160/89728089_216226096428302_4082566749302554624_o.jpg?_nc_cat=110&_nc_sid=dbb9e7&_nc_ohc=5ssUMXflsf4AX98prSH&_nc_ht=scontent.fath6-1.fna&oh=12154e5d6418bc1b889f8a82f02c2c83&oe=5EAC38D9" }; Student s8 = new Student() { FirstName = "Albi", LastName = "Alikaj", DateOfBirth = new DateTime(1991, 6, 26), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/c0.5.160.160a/p160x160/84947519_10221639470159874_2595289818887880704_o.jpg?_nc_cat=108&_nc_sid=dbb9e7&_nc_ohc=T3CFXbOgRdIAX9E18Fo&_nc_ht=scontent.fath6-1.fna&oh=591c46f368b3aa030279a809dab619df&oe=5EAEA85C" }; Student s9 = new Student() { FirstName = "Karol", LastName = "Koniewicz", DateOfBirth = new DateTime(1994, 11, 4), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/c0.0.160.160a/p160x160/60247548_1531966373605919_5288819833486442496_o.jpg?_nc_cat=106&_nc_sid=dbb9e7&_nc_ohc=noA78_rrYRYAX9N9Jhn&_nc_ht=scontent.fath6-1.fna&oh=fc604671046b9139b027fa2c29932a44&oe=5EAAFFA3" }; Student s10 = new Student() { FirstName = "Thanos", LastName = "Christidis", DateOfBirth = new DateTime(1992, 5, 07), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/c0.0.160.160a/p160x160/67228954_10217557567524921_7110492575286427648_o.jpg?_nc_cat=104&_nc_sid=dbb9e7&_nc_ohc=KuFqVmyonwUAX8Odna_&_nc_ht=scontent.fath6-1.fna&oh=cd553fca9b8e35538ff945d7f5ef4894&oe=5EACFD2F" }; Student s11 = new Student() { FirstName = "Ioannis", LastName = "Elefsiniotis", DateOfBirth = new DateTime(1975, 4, 29), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/61049396_837895846579582_4168353704518352896_o.jpg?_nc_cat=110&_nc_sid=dbb9e7&_nc_ohc=Z7pzzKkslNMAX9QPBVQ&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=ceb8445e5d281fb882da087bf3ed1f2d&oe=5EAB5D6D" }; Student s12 = new Student() { FirstName = "Konstantinos", LastName = "Argyropoulos", DateOfBirth = new DateTime(1996, 12, 3), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/45150388_489501521548146_1303393901410779136_n.jpg?_nc_cat=109&_nc_sid=dbb9e7&_nc_ohc=XqWvxMbtcq8AX-hWfK6&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=1a84994849e71701c0629b65d42ea369&oe=5EACCBF1" }; Student s13 = new Student() { FirstName = "Chris", LastName = "Vasilakis", DateOfBirth = new DateTime(1989, 7, 3), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/39755150_2135619819844294_8578400753679335424_n.jpg?_nc_cat=101&_nc_sid=dbb9e7&_nc_ohc=-41rLiHwXpQAX8YJ4V8&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=d7c7d9f33bda42b4bfe673d3b3d55dc1&oe=5EADB5AB" }; Student s14 = new Student() { FirstName = "Eustathios", LastName = "Kanellis", DateOfBirth = new DateTime(1986, 10, 30), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t31.0-1/c94.94.1177.1177a/s160x160/285972_2085671995911_1552357_o.jpg?_nc_cat=107&_nc_sid=dbb9e7&_nc_ohc=BD7IR4mvbFUAX8cKOZT&_nc_ht=scontent.fath6-1.fna&oh=648c2b6b2deff19d37ec2e63f0ee0bff&oe=5EAB4618" }; Student s15 = new Student() { FirstName = "Dionysios", LastName = "Pilikas", DateOfBirth = new DateTime(1983, 4, 21), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/91377105_1493976710773823_144926052131536896_o.jpg?_nc_cat=111&_nc_sid=dbb9e7&_nc_ohc=k9il_zpf3HUAX9u05HJ&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=2bc0534d41d0d4e2e42221027003e9f7&oe=5EACE6A3" }; Student s16 = new Student() { FirstName = "Athanasios", LastName = "Kontodimas", DateOfBirth = new DateTime(1989, 9, 20), PhotoUrl = "https://upload.wikimedia.org/wikipedia/commons/thumb/a/ac/No_image_available.svg/1200px-No_image_available.svg.png" }; Student s17 = new Student() { FirstName = "Ioannis", LastName = "Manthos", DateOfBirth = new DateTime(1969, 3, 3), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/88302137_101199051509909_4621936851232489472_n.jpg?_nc_cat=100&_nc_sid=dbb9e7&_nc_ohc=LRDfNd1eyt8AX_pKyi7&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=57af7a6cd7332e2ac95bfd254f99afc9&oe=5EAEAFEC" }; Student s18 = new Student() { FirstName = "Themistoklis", LastName = "Papageorgiou", DateOfBirth = new DateTime(1995, 8, 14), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/c0.27.160.160a/p160x160/84863141_193902371850182_1184395123736182784_o.jpg?_nc_cat=102&_nc_sid=dbb9e7&_nc_ohc=T0GYWvoNXaAAX_M0ROL&_nc_ht=scontent.fath6-1.fna&oh=fd99d4e5121abe7edc4700cb59b72765&oe=5EAC0680" }; Student s19 = new Student() { FirstName = "Giorgos", LastName = "Poulakos", DateOfBirth = new DateTime(1987, 10, 17), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/r180/p160x160/52602285_10216530072378614_3337311046372163584_o.jpg?_nc_cat=111&_nc_sid=dbb9e7&_nc_ohc=e1fBsjjDQ_0AX8ZXSfY&_nc_ht=scontent.fath6-1.fna&oh=a0b5f7c1fd3b2ff2e04f30e938391088&oe=5EAEAD42" }; Student s20 = new Student() { FirstName = "Kyriakos", LastName = "Zotiadis", DateOfBirth = new DateTime(1996, 2, 25), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/84630614_1474513026042402_2895005899661770752_o.jpg?_nc_cat=107&_nc_sid=dbb9e7&_nc_ohc=eYDyIWM5a48AX-nqE8M&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=b78ee0e63897fed9c5944852aab0bc1e&oe=5EAD0B94" }; Student s21 = new Student() { FirstName = "Vasileios", LastName = "Theodoropoulos", DateOfBirth = new DateTime(1991, 5, 26), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/72421681_10219149774165939_7754066757140086784_o.jpg?_nc_cat=100&_nc_sid=dbb9e7&_nc_ohc=PeTP1MvgW3EAX-GfGiz&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=96e0fd50213cc94f0e822b65bb228ea3&oe=5EAB2837" }; Student s22 = new Student() { FirstName = "Dimitrios", LastName = "Gkotsis", DateOfBirth = new DateTime(1989, 11, 29), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t31.0-1/p160x160/22467607_1805134289516261_6199419177410518079_o.jpg?_nc_cat=109&_nc_sid=dbb9e7&_nc_ohc=ITaph7xmJu4AX_YDEDf&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=e461ab13cb132330feb12a8a24999008&oe=5EAC1070" }; Student s23 = new Student() { FirstName = "Thodoris", LastName = "Thanos", DateOfBirth = new DateTime(1989, 4, 3), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/88197206_10221884389688282_2969913041291837440_o.jpg?_nc_cat=111&_nc_sid=dbb9e7&_nc_ohc=IWjPdkq2rhgAX9Wm74b&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=935c1437b2a84f8b28978fbfcb4a9d2e&oe=5EACDF11" }; Student s24 = new Student() { FirstName = "Vasilios", LastName = "Mourtzinos", DateOfBirth = new DateTime(1989, 8, 10), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/69854692_10220392423504749_6036645172400357376_n.jpg?_nc_cat=102&_nc_sid=dbb9e7&_nc_ohc=Y8AoMG3OXhkAX94IMHg&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=eead0c1a74d4e78e4f2bc8023e470b2c&oe=5EAC3D3E" }; Student s25 = new Student() { FirstName = "Katerina", LastName = "Mos", DateOfBirth = new DateTime(1993, 10, 13), PhotoUrl = "https://upload.wikimedia.org/wikipedia/commons/thumb/a/ac/No_image_available.svg/1200px-No_image_available.svg.png" }; Student s26 = new Student() { FirstName = "Peny", LastName = "Panagopoulou", DateOfBirth = new DateTime(1990, 3, 1), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/37706199_10217035227698667_4979261568865796096_o.jpg?_nc_cat=108&_nc_sid=dbb9e7&_nc_ohc=Fn6cR2W41jcAX_4oRCX&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=34c5fa54fe4460607b8ae9f83dd51d5f&oe=5EAD9B20" }; Student s27 = new Student() { FirstName = "Alex", LastName = "Stergiou", DateOfBirth = new DateTime(1991, 5, 1), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/c0.0.160.160a/p160x160/74569605_10218462029234313_7300403818523525120_o.jpg?_nc_cat=108&_nc_sid=dbb9e7&_nc_ohc=aCIQL4tKLZEAX_HwTjH&_nc_ht=scontent.fath6-1.fna&oh=22bc66a769a74eb15950f82ca00cd905&oe=5EAD34A9" }; Student s28 = new Student() { FirstName = "Dionisis", LastName = "Gialpas", DateOfBirth = new DateTime(1990, 10, 11), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/38072234_10217079765373334_4457410947773890560_n.jpg?_nc_cat=105&_nc_sid=dbb9e7&_nc_ohc=ldHWmdC2AqEAX8tjyr1&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=5dc717f03125f8a32b1815018ce31622&oe=5EAE706C" }; Student s29 = new Student() { FirstName = "Spyros", LastName = "Ntatsikas", DateOfBirth = new DateTime(1988, 3, 8), PhotoUrl = "https://scontent.fath6-1.fna.fbcdn.net/v/t1.0-1/p160x160/31689245_10204206595602579_214031208340783104_n.jpg?_nc_cat=102&_nc_sid=dbb9e7&_nc_ohc=jfvcaxkq-YkAX_bXzF4&_nc_ht=scontent.fath6-1.fna&_nc_tp=6&oh=6c881cf3314ac8ef3250a609940837ff&oe=5EAE26DD" }; Student s30 = new Student() { FirstName = "Irene", LastName = "Zarologlou", DateOfBirth = new DateTime(1998, 5, 4), PhotoUrl = "https://upload.wikimedia.org/wikipedia/commons/thumb/a/ac/No_image_available.svg/1200px-No_image_available.svg.png" }; //Student s = new Student() { FirstName = "", LastName = "", DateOfBirth = new DateTime(1111, 1, 19) }; #endregion #region Seed Assignment //=================Seeding Assignments================= Assignment a1 = new Assignment() { Title = "Private School A", Description = "Create a private school with c#", SubDate = new DateTime(2019, 12, 21), PhotoUrl = "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTd00TyEufzro7-y9xbDh5dDbVrKa6Qkv6mkugxwlIlGGSbdOH3&s" }; Assignment a2 = new Assignment() { Title = "Private School B", Description = "Create a private school with ADO", SubDate = new DateTime(2020, 1, 16), PhotoUrl = "https://static.javatpoint.com/ado/images/ado-net-tutorial.jpg" }; Assignment a3 = new Assignment() { Title = "Private School C", Description = "Create a private school with Entity", SubDate = new DateTime(2020, 1, 29), PhotoUrl = "https://3.bp.blogspot.com/-IHOi-jypA-Q/XQYQrhidHqI/AAAAAAAAD9U/O9bLB6b9GRow6_WE72dL4qwoSG8-ba3lgCLcBGAs/s1600/entity-framework.png" }; Assignment a4 = new Assignment() { Title = "School Java A", Description = "Create a Java program", SubDate = new DateTime(2019, 12, 19), PhotoUrl = "https://www.swiss4ward.com/.imaging/mte/swiss4ward-theme/thumbnail-list/dam/technologies-LOGOS/Java_Logo_Swiss4ward.jpg/jcr:content/Java_Logo_Swiss4ward.jpg.jpg" }; Assignment a5 = new Assignment() { Title = "School Java B", Description = "Create a Java program with database", SubDate = new DateTime(2020, 1, 11), PhotoUrl = "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTn7VWxSEUyeyyMU9gQrX7wm22mhIeub1pLhFbIBvI6bI8OkDD8Ig&s" }; Assignment a6 = new Assignment() { Title = "School Java C", Description = "Create a Java program with mvc", SubDate = new DateTime(2020, 2, 08), PhotoUrl = "https://www.pngkey.com/png/detail/264-2646582_logo-transparent-background-java.png" }; Assignment a7 = new Assignment() { Title = "Bank Project Database", Description = "Create a bank system", SubDate = new DateTime(2020, 2, 10), PhotoUrl = "https://www.pngkit.com/png/detail/438-4384804_only-a-global-structured-copyright-cases-database-with.png" }; Assignment a8 = new Assignment() { Title = "Bank Project RDBMS", Description = "Create a bank rdbms system", SubDate = new DateTime(2020, 3, 29), PhotoUrl = "https://static1.squarespace.com/static/5ccb715016b640627a1c2782/t/5cd076e84e17b66767359b5b/1557165804160/db3.jpg?format=1500w" }; Assignment a9 = new Assignment() { Title = "Bank Project MongoDB", Description = "Create a bank mongoDb system", SubDate = new DateTime(2020, 5, 17), PhotoUrl = "https://seeklogo.net/wp-content/uploads/2015/10/mongodb-logo-vector-download.jpg" }; Assignment a10 = new Assignment() { Title = "Website Html", Description = "Create a Website Html", SubDate = new DateTime(2020, 3, 13), PhotoUrl = "https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcS_fImaOCq91jNiq7mYipP_tlZx9wCyPC3edGrtrACXCWCf5ZTM&usqp=CAU" }; Assignment a11 = new Assignment() { Title = "Website Html-Css", Description = "Create a Website with Html-CSS", SubDate = new DateTime(2020, 4, 22), PhotoUrl = "https://4.bp.blogspot.com/-uyl5kqXIMog/VSZ80P5sALI/AAAAAAAAXuI/0xCQDcWZ4jI/s1600/HTML5CSS3Logos_s.png" }; Assignment a12 = new Assignment() { Title = "Website Javascript", Description = "Create a Website with Javasctipt", SubDate = new DateTime(2020, 7, 25), PhotoUrl = "https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcSjijyWPquveNFUo30p6JSrTEWcxH4aykPmzkbQnrSzzjxuBISH&usqp=CAU" }; Assignment a13 = new Assignment() { Title = "MVC Part A", Description = "Create an MVC Angular 2", SubDate = new DateTime(2020, 3, 20), PhotoUrl = "https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcSgvv8EnePcYY755Yd3ReP_WXViTx5vX2zThwc9GlZ01ofYdBE-&usqp=CAU" }; Assignment a14 = new Assignment() { Title = "MVC Part B", Description = "Create an MVC React", SubDate = new DateTime(2020, 3, 15), PhotoUrl = "https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcTpep6OyPg2v-OBDQQ_hA5izTrKkiGEHLyh7gVpluI1MbBk197X&usqp=CAU" }; Assignment a15 = new Assignment() { Title = "MVC Part C", Description = "Create an MVC Angular", SubDate = new DateTime(2020, 4, 17), PhotoUrl = "https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcSHfPyAuZB0ap92lkxeXN7kAp-Ly6GYob4s1pdWtHRMpQklyQ5V&usqp=CAU" }; //Assignment a = new Assignment() { Title = "", Description = "", SubDate = new DateTime(1111, 1, 19) }; #endregion #region Seed Course //=================Seeding Courses================= Course c1 = new Course() { Title = "CB9-C#", Stream = "C#", CourseType = CourseType.FullTime, StartDate = new DateTime(2019, 11, 15), EndDate = new DateTime(2020, 2, 1), Fees = 2300, PhotoUrl = "https://pla.s6img.com/society6/img/nV1AknlqVm6ykWmiFTdjq2z-dIs/w_1500/prints/~artwork/s6-original-art-uploads/society6/uploads/misc/6668936326d74c3a8bf31df3bc0430eb/~~/c-logo-for-csharp-developers-visual-studio-prints.jpg" }; Course c2 = new Course() { Title = "CB9-Java", Stream = "Java", CourseType = CourseType.FullTime, StartDate = new DateTime(2019, 11, 08), EndDate = new DateTime(2020, 2, 10), Fees = 2200, PhotoUrl = "https://pbs.twimg.com/profile_images/954020529391902720/jW4dnFtA.jpg" }; Course c3 = new Course() { Title = "CB9-RDMBS", Stream = "RDBMS", CourseType = CourseType.PartTime, StartDate = new DateTime(2019, 11, 03), EndDate = new DateTime(2020, 6, 1), Fees = 2500, PhotoUrl = "https://www.computerhope.com/jargon/d/database.jpg" }; Course c4 = new Course() { Title = "CB10-Javascript", Stream = "Javascript", CourseType = CourseType.PartTime, StartDate = new DateTime(2020, 2, 21), EndDate = new DateTime(2020, 8, 10), Fees = 2500, PhotoUrl = "https://4.bp.blogspot.com/-1GOghsk3j-k/XF_8G1N735I/AAAAAAAAcsU/vT7r4s-EL3gEDlzsbD4u8yu5VZo8YSuOQCLcBGAs/s1600/js.jpg" }; Course c5 = new Course() { Title = "CB10-Angular", Stream = "Angular", CourseType = CourseType.PartTime, StartDate = new DateTime(2020, 2, 28), EndDate = new DateTime(2020, 5, 17), Fees = 2000, PhotoUrl = "https://www.zuehlke.com/blog/app/uploads/2013/04/angularjs.jpg" }; //Course c = new Course() { Title = "", Stream = "", CourseType = CourseType.PartTime, StartDate = new DateTime(1111, 1, 19), EndDate = new DateTime(1111, 1, 19), Fees = 0 }; #endregion #region Seed Marks //=================Seeding Marks================= StudentAssignmentMark m1 = new StudentAssignmentMark() { OralMark = 50, TotalMark = 61 }; StudentAssignmentMark m2 = new StudentAssignmentMark() { OralMark = 50.5, TotalMark = 68 }; StudentAssignmentMark m3 = new StudentAssignmentMark() { OralMark = 51, TotalMark = 68 }; StudentAssignmentMark m4 = new StudentAssignmentMark() { OralMark = 51.5, TotalMark = 36 }; StudentAssignmentMark m5 = new StudentAssignmentMark() { OralMark = 52, TotalMark = 68 }; StudentAssignmentMark m6 = new StudentAssignmentMark() { OralMark = 52.5, TotalMark = 56 }; StudentAssignmentMark m7 = new StudentAssignmentMark() { OralMark = 53, TotalMark = 16 }; StudentAssignmentMark m8 = new StudentAssignmentMark() { OralMark = 53.5, TotalMark = 93 }; StudentAssignmentMark m9 = new StudentAssignmentMark() { OralMark = 54, TotalMark = 50 }; StudentAssignmentMark m10 = new StudentAssignmentMark() { OralMark = 54.5, TotalMark = 43 }; StudentAssignmentMark m11 = new StudentAssignmentMark() { OralMark = 55, TotalMark = 98 }; StudentAssignmentMark m12 = new StudentAssignmentMark() { OralMark = 55.5, TotalMark = 54 }; StudentAssignmentMark m13 = new StudentAssignmentMark() { OralMark = 56, TotalMark = 32 }; StudentAssignmentMark m14 = new StudentAssignmentMark() { OralMark = 56.5, TotalMark = 61 }; StudentAssignmentMark m15 = new StudentAssignmentMark() { OralMark = 57, TotalMark = 36 }; StudentAssignmentMark m16 = new StudentAssignmentMark() { OralMark = 57.5, TotalMark = 36 }; StudentAssignmentMark m17 = new StudentAssignmentMark() { OralMark = 58, TotalMark = 66 }; StudentAssignmentMark m18 = new StudentAssignmentMark() { OralMark = 58.5, TotalMark = 41 }; StudentAssignmentMark m19 = new StudentAssignmentMark() { OralMark = 59, TotalMark = 15 }; StudentAssignmentMark m20 = new StudentAssignmentMark() { OralMark = 59.5, TotalMark = 65 }; StudentAssignmentMark m21 = new StudentAssignmentMark() { OralMark = 60, TotalMark = 50 }; StudentAssignmentMark m22 = new StudentAssignmentMark() { OralMark = 60.5, TotalMark = 19 }; StudentAssignmentMark m23 = new StudentAssignmentMark() { OralMark = 61, TotalMark = 43 }; StudentAssignmentMark m24 = new StudentAssignmentMark() { OralMark = 61.5, TotalMark = 71 }; StudentAssignmentMark m25 = new StudentAssignmentMark() { OralMark = 62, TotalMark = 14 }; StudentAssignmentMark m26 = new StudentAssignmentMark() { OralMark = 62.5, TotalMark = 99 }; StudentAssignmentMark m27 = new StudentAssignmentMark() { OralMark = 63, TotalMark = 20 }; StudentAssignmentMark m28 = new StudentAssignmentMark() { OralMark = 63.5, TotalMark = 66 }; StudentAssignmentMark m29 = new StudentAssignmentMark() { OralMark = 64, TotalMark = 57 }; StudentAssignmentMark m30 = new StudentAssignmentMark() { OralMark = 64.5, TotalMark = 46 }; StudentAssignmentMark m31 = new StudentAssignmentMark() { OralMark = 65, TotalMark = 56 }; StudentAssignmentMark m32 = new StudentAssignmentMark() { OralMark = 65.5, TotalMark = 97 }; StudentAssignmentMark m33 = new StudentAssignmentMark() { OralMark = 66, TotalMark = 66 }; StudentAssignmentMark m34 = new StudentAssignmentMark() { OralMark = 66.5, TotalMark = 66 }; StudentAssignmentMark m35 = new StudentAssignmentMark() { OralMark = 67, TotalMark = 32 }; StudentAssignmentMark m36 = new StudentAssignmentMark() { OralMark = 67.5, TotalMark = 38 }; StudentAssignmentMark m37 = new StudentAssignmentMark() { OralMark = 68, TotalMark = 56 }; StudentAssignmentMark m38 = new StudentAssignmentMark() { OralMark = 68.5, TotalMark = 81 }; StudentAssignmentMark m39 = new StudentAssignmentMark() { OralMark = 69, TotalMark = 7 }; StudentAssignmentMark m40 = new StudentAssignmentMark() { OralMark = 69.5, TotalMark = 2 }; StudentAssignmentMark m41 = new StudentAssignmentMark() { OralMark = 70, TotalMark = 25 }; StudentAssignmentMark m42 = new StudentAssignmentMark() { OralMark = 70.5, TotalMark = 34 }; StudentAssignmentMark m43 = new StudentAssignmentMark() { OralMark = 71, TotalMark = 61 }; StudentAssignmentMark m44 = new StudentAssignmentMark() { OralMark = 71.5, TotalMark = 23 }; StudentAssignmentMark m45 = new StudentAssignmentMark() { OralMark = 72, TotalMark = 96 }; StudentAssignmentMark m46 = new StudentAssignmentMark() { OralMark = 72.5, TotalMark = 38 }; StudentAssignmentMark m47 = new StudentAssignmentMark() { OralMark = 73, TotalMark = 4 }; StudentAssignmentMark m48 = new StudentAssignmentMark() { OralMark = 73.5, TotalMark = 44 }; StudentAssignmentMark m49 = new StudentAssignmentMark() { OralMark = 74, TotalMark = 59 }; StudentAssignmentMark m50 = new StudentAssignmentMark() { OralMark = 74.5, TotalMark = 83 }; StudentAssignmentMark m51 = new StudentAssignmentMark() { OralMark = 75, TotalMark = 63 }; StudentAssignmentMark m52 = new StudentAssignmentMark() { OralMark = 75.5, TotalMark = 24 }; StudentAssignmentMark m53 = new StudentAssignmentMark() { OralMark = 76, TotalMark = 77 }; StudentAssignmentMark m54 = new StudentAssignmentMark() { OralMark = 76.5, TotalMark = 18 }; StudentAssignmentMark m55 = new StudentAssignmentMark() { OralMark = 77, TotalMark = 25 }; StudentAssignmentMark m56 = new StudentAssignmentMark() { OralMark = 77.5, TotalMark = 40 }; StudentAssignmentMark m57 = new StudentAssignmentMark() { OralMark = 78, TotalMark = 72 }; StudentAssignmentMark m58 = new StudentAssignmentMark() { OralMark = 78.5, TotalMark = 93 }; StudentAssignmentMark m59 = new StudentAssignmentMark() { OralMark = 79, TotalMark = 47 }; StudentAssignmentMark m60 = new StudentAssignmentMark() { OralMark = 79.5, TotalMark = 26 }; StudentAssignmentMark m61 = new StudentAssignmentMark() { OralMark = 80, TotalMark = 86 }; StudentAssignmentMark m62 = new StudentAssignmentMark() { OralMark = 80.5, TotalMark = 59 }; StudentAssignmentMark m63 = new StudentAssignmentMark() { OralMark = 81, TotalMark = 88 }; StudentAssignmentMark m64 = new StudentAssignmentMark() { OralMark = 81.5, TotalMark = 26 }; StudentAssignmentMark m65 = new StudentAssignmentMark() { OralMark = 82, TotalMark = 75 }; StudentAssignmentMark m66 = new StudentAssignmentMark() { OralMark = 82.5, TotalMark = 12 }; StudentAssignmentMark m67 = new StudentAssignmentMark() { OralMark = 83, TotalMark = 74 }; StudentAssignmentMark m68 = new StudentAssignmentMark() { OralMark = 83.5, TotalMark = 86 }; StudentAssignmentMark m69 = new StudentAssignmentMark() { OralMark = 84, TotalMark = 51 }; StudentAssignmentMark m70 = new StudentAssignmentMark() { OralMark = 84.5, TotalMark = 59 }; StudentAssignmentMark m71 = new StudentAssignmentMark() { OralMark = 85, TotalMark = 10 }; StudentAssignmentMark m72 = new StudentAssignmentMark() { OralMark = 85.5, TotalMark = 98 }; StudentAssignmentMark m73 = new StudentAssignmentMark() { OralMark = 86, TotalMark = 45 }; StudentAssignmentMark m74 = new StudentAssignmentMark() { OralMark = 86.5, TotalMark = 9 }; StudentAssignmentMark m75 = new StudentAssignmentMark() { OralMark = 87, TotalMark = 62 }; StudentAssignmentMark m76 = new StudentAssignmentMark() { OralMark = 87.5, TotalMark = 87 }; StudentAssignmentMark m77 = new StudentAssignmentMark() { OralMark = 88, TotalMark = 9 }; StudentAssignmentMark m78 = new StudentAssignmentMark() { OralMark = 88.5, TotalMark = 12 }; StudentAssignmentMark m79 = new StudentAssignmentMark() { OralMark = 89, TotalMark = 78 }; StudentAssignmentMark m80 = new StudentAssignmentMark() { OralMark = 89.5, TotalMark = 66 }; StudentAssignmentMark m81 = new StudentAssignmentMark() { OralMark = 90, TotalMark = 80 }; StudentAssignmentMark m82 = new StudentAssignmentMark() { OralMark = 90.5, TotalMark = 85 }; StudentAssignmentMark m83 = new StudentAssignmentMark() { OralMark = 91, TotalMark = 99 }; StudentAssignmentMark m84 = new StudentAssignmentMark() { OralMark = 91.5, TotalMark = 78 }; StudentAssignmentMark m85 = new StudentAssignmentMark() { OralMark = 92, TotalMark = 22 }; StudentAssignmentMark m86 = new StudentAssignmentMark() { OralMark = 92.5, TotalMark = 51 }; StudentAssignmentMark m87 = new StudentAssignmentMark() { OralMark = 93, TotalMark = 4 }; StudentAssignmentMark m88 = new StudentAssignmentMark() { OralMark = 93.5, TotalMark = 14 }; StudentAssignmentMark m89 = new StudentAssignmentMark() { OralMark = 94, TotalMark = 17 }; StudentAssignmentMark m90 = new StudentAssignmentMark() { OralMark = 94.5, TotalMark = 8 }; StudentAssignmentMark m91 = new StudentAssignmentMark() { OralMark = 95, TotalMark = 35 }; StudentAssignmentMark m92 = new StudentAssignmentMark() { OralMark = 95.5, TotalMark = 82 }; StudentAssignmentMark m93 = new StudentAssignmentMark() { OralMark = 96, TotalMark = 5 }; StudentAssignmentMark m94 = new StudentAssignmentMark() { OralMark = 96.5, TotalMark = 96 }; StudentAssignmentMark m95 = new StudentAssignmentMark() { OralMark = 97, TotalMark = 56 }; StudentAssignmentMark m96 = new StudentAssignmentMark() { OralMark = 97.5, TotalMark = 63 }; StudentAssignmentMark m97 = new StudentAssignmentMark() { OralMark = 98, TotalMark = 26 }; StudentAssignmentMark m98 = new StudentAssignmentMark() { OralMark = 98.5, TotalMark = 37 }; StudentAssignmentMark m99 = new StudentAssignmentMark() { OralMark = 99, TotalMark = 33 }; StudentAssignmentMark m100 = new StudentAssignmentMark() { OralMark = 99.5, TotalMark = 96 }; StudentAssignmentMark m101 = new StudentAssignmentMark() { OralMark = 100, TotalMark = 61 }; StudentAssignmentMark m102 = new StudentAssignmentMark() { OralMark = 49, TotalMark = 33 }; //StudentAssignmentMark m = new StudentAssignmentMark() { OralMark = , TotalMark = }; #endregion #region Add Trainers, Assignments & Students to Courses //==========Add Trainers to Courses c1.Trainers = new List <Trainer>() { t1, t4, t5 }; c2.Trainers = new List <Trainer>() { t2, t4 }; c3.Trainers = new List <Trainer>() { t4, t5 }; c4.Trainers = new List <Trainer>() { t3, t6 }; c5.Trainers = new List <Trainer>() { t3, t6 }; //==========Add Assignments to Courses c1.Assignments = new List <Assignment>() { a1, a2, a3 }; c2.Assignments = new List <Assignment>() { a4, a5, a6 }; c3.Assignments = new List <Assignment>() { a7, a8, a9 }; c4.Assignments = new List <Assignment>() { a10, a11, a12 }; c5.Assignments = new List <Assignment>() { a13, a14, a15 }; //==========Add Students to Courses c1.Students = new List <Student>() { s1, s2, s3, s4, s5, s6 }; c2.Students = new List <Student>() { s7, s8, s9, s10, s11, s12, s26 }; c3.Students = new List <Student>() { s1, s13, s14, s15, s16, s17, s18 }; c4.Students = new List <Student>() { s2, s19, s20, s21, s22, s23, s24 }; c5.Students = new List <Student>() { s3, s25, s26, s27, s28, s29, s30 }; #endregion #region Add Marks to Student & Assignment //==========Add Marks to Student & Assignment m1.Assignment = a1; m1.Student = s1; m2.Assignment = a2; m2.Student = s1; m3.Assignment = a3; m3.Student = s1; m4.Assignment = a1; m4.Student = s2; m5.Assignment = a2; m5.Student = s2; m6.Assignment = a3; m6.Student = s2; m7.Assignment = a1; m7.Student = s3; m8.Assignment = a2; m8.Student = s3; m9.Assignment = a3; m9.Student = s3; m10.Assignment = a1; m10.Student = s4; m11.Assignment = a2; m11.Student = s4; m12.Assignment = a3; m12.Student = s4; m13.Assignment = a1; m13.Student = s5; m14.Assignment = a2; m14.Student = s5; m15.Assignment = a3; m15.Student = s5; m16.Assignment = a1; m16.Student = s6; m17.Assignment = a2; m17.Student = s6; m18.Assignment = a3; m18.Student = s6; m19.Assignment = a4; m19.Student = s7; m20.Assignment = a5; m20.Student = s7; m21.Assignment = a6; m21.Student = s7; m22.Assignment = a4; m22.Student = s8; m23.Assignment = a5; m23.Student = s8; m24.Assignment = a6; m24.Student = s8; m25.Assignment = a4; m25.Student = s9; m26.Assignment = a5; m26.Student = s9; m27.Assignment = a6; m27.Student = s9; m28.Assignment = a4; m28.Student = s10; m29.Assignment = a5; m29.Student = s10; m30.Assignment = a6; m30.Student = s10; m31.Assignment = a4; m31.Student = s11; m32.Assignment = a5; m32.Student = s11; m33.Assignment = a6; m33.Student = s11; m34.Assignment = a4; m34.Student = s12; m35.Assignment = a5; m35.Student = s12; m36.Assignment = a6; m36.Student = s12; m37.Assignment = a7; m37.Student = s13; m38.Assignment = a8; m38.Student = s13; m39.Assignment = a9; m39.Student = s13; m40.Assignment = a7; m40.Student = s14; m41.Assignment = a8; m41.Student = s14; m42.Assignment = a9; m42.Student = s14; m43.Assignment = a7; m43.Student = s15; m44.Assignment = a8; m44.Student = s15; m45.Assignment = a9; m45.Student = s15; m46.Assignment = a7; m46.Student = s16; m47.Assignment = a8; m47.Student = s16; m48.Assignment = a9; m48.Student = s16; m49.Assignment = a7; m49.Student = s17; m50.Assignment = a8; m50.Student = s17; m51.Assignment = a9; m51.Student = s17; m52.Assignment = a7; m52.Student = s18; m53.Assignment = a8; m53.Student = s18; m54.Assignment = a9; m54.Student = s18; m55.Assignment = a10; m55.Student = s19; m56.Assignment = a11; m56.Student = s19; m57.Assignment = a12; m57.Student = s19; m58.Assignment = a10; m58.Student = s20; m59.Assignment = a11; m59.Student = s20; m60.Assignment = a12; m60.Student = s20; m61.Assignment = a10; m61.Student = s21; m62.Assignment = a11; m62.Student = s21; m63.Assignment = a12; m63.Student = s21; m64.Assignment = a10; m64.Student = s22; m65.Assignment = a11; m65.Student = s22; m66.Assignment = a12; m66.Student = s22; m67.Assignment = a10; m67.Student = s23; m68.Assignment = a11; m68.Student = s23; m69.Assignment = a12; m69.Student = s23; m70.Assignment = a10; m70.Student = s24; m71.Assignment = a11; m71.Student = s24; m72.Assignment = a12; m72.Student = s24; m73.Assignment = a13; m73.Student = s25; m74.Assignment = a14; m74.Student = s25; m75.Assignment = a15; m75.Student = s25; m76.Assignment = a13; m76.Student = s26; m77.Assignment = a14; m77.Student = s26; m78.Assignment = a15; m78.Student = s26; m79.Assignment = a13; m79.Student = s27; m80.Assignment = a14; m80.Student = s27; m81.Assignment = a15; m81.Student = s27; m82.Assignment = a13; m82.Student = s28; m83.Assignment = a14; m83.Student = s28; m84.Assignment = a15; m84.Student = s28; m85.Assignment = a13; m85.Student = s29; m86.Assignment = a14; m86.Student = s29; m87.Assignment = a15; m87.Student = s29; m88.Assignment = a13; m88.Student = s30; m89.Assignment = a14; m89.Student = s30; m90.Assignment = a15; m90.Student = s30; m91.Assignment = a7; m91.Student = s1; m92.Assignment = a8; m92.Student = s1; m93.Assignment = a9; m93.Student = s1; m94.Assignment = a10; m94.Student = s2; m95.Assignment = a11; m95.Student = s2; m96.Assignment = a12; m96.Student = s2; m97.Assignment = a13; m97.Student = s3; m98.Assignment = a14; m98.Student = s3; m99.Assignment = a15; m99.Student = s3; m100.Assignment = a4; m100.Student = s26; m101.Assignment = a5; m101.Student = s26; m102.Assignment = a6; m102.Student = s26; #endregion //========== Upsert Tables(Course, Trainer, Student, Assignment, StudentAssignmentMarks--Automaticly creation of University) context.StudentAssignmentMarks.AddOrUpdate(x => x.OralMark, m1, m2, m3, m4, m5, m6, m7, m8, m9, m10, m11, m12, m13, m14, m15, m16, m17, m18, m19, m20, m21, m22, m23, m24, m25, m26, m27, m28, m29, m30, m31, m32, m33, m34, m35, m36, m37, m38, m39, m40, m41, m42, m43, m44, m45, m46, m47, m48, m49, m50, m51, m52, m53, m54, m55, m56, m57, m58, m59, m60, m61, m62, m63, m64, m65, m66, m67, m68, m69, m70, m71, m72, m73, m74, m75, m76, m77, m78, m79, m80, m81, m82, m83, m84, m85, m86, m87, m88, m89, m90, m91, m92, m93, m94, m95, m96, m97, m98, m99, m100, m101, m102); context.Trainers.AddOrUpdate(x => x.LastName, t1, t2, t3, t4, t5, t6); context.Students.AddOrUpdate(x => x.LastName, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13, s14, s15, s16, s17, s18, s19, s20, s21, s22, s23, s24, s25, s26, s27, s28, s29, s30); context.Assignments.AddOrUpdate(x => x.Title, a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15); context.Courses.AddOrUpdate(x => x.Title, c1, c2, c3, c4, c5); context.SaveChanges(); #endregion }
public void Delete(StudentAssignmentMark studentAssignmentMark) { db.Entry(studentAssignmentMark).State = EntityState.Deleted; db.SaveChanges(); }
public void Update(StudentAssignmentMark studentAssignmentMark) { db.Entry(studentAssignmentMark).State = EntityState.Modified; db.SaveChanges(); }
public void Insert(StudentAssignmentMark studentAssignmentMark) { db.Entry(studentAssignmentMark).State = EntityState.Added; db.SaveChanges(); }