public IHttpActionResult Putstudent(int id, student student) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != student.stu_id) { return(BadRequest()); } db.Entry(student).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!studentExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult studentFileUpload(HttpPostedFileBase file) { if (file != null && file.ContentLength > 0) { try { string path = Path.Combine(Server.MapPath("~/files"), Path.GetFileName(file.FileName)); int id = int.Parse(Session["studentId"].ToString()); studentEntities ctx = new studentEntities(); student_files sf = new student_files(); sf.create_date = DateTime.Now; sf.filepath = path; sf.studentId = id; sf.fileNameOld = file.FileName; ctx.student_files.Add(sf); ctx.SaveChanges(); string extension = Path.GetExtension(file.FileName); sf.fileName = sf.id.ToString() + extension; path = path.Replace(file.FileName, sf.id.ToString() + extension); ctx.Entry(sf).State = EntityState.Modified; sf.filepath = path; ctx.SaveChanges(); file.SaveAs(path); ViewBag.Message = "Dosya yüklendi."; using (var context = new studentEntities()) { ViewBag.PaymentsList = context.Student_Payments .Where(b => b.StudentId == id) .ToList(); } } catch (Exception ex) { ViewBag.Message = "ERROR:" + ex.Message.ToString(); } } else { ViewBag.Message = "You have not specified a file."; } return(View("General")); }
public async Task <ActionResult> save_payment(Student_Payments model, string returnUrl) { int studentId = int.Parse(Session["studentId"].ToString()); model.StudentId = studentId; //check for reportName parameter value now //to do : Return something studentEntities ee = new studentEntities(); if (model.Id > 0) { ee.Entry(model).State = EntityState.Modified; } else { ee.Student_Payments.Add(model); } ee.SaveChanges(); using (var context = new studentEntities()) { ViewBag.PaymentsList = context.Student_Payments .Where(b => b.StudentId == studentId) .ToList(); } return(View("General", ViewBag.PaymentsList)); }
public async Task <ActionResult> save(Student model, string returnUrl) { //check for reportName parameter value now //to do : Return something studentEntities ee = new studentEntities(); if (model.Id > 0) { ee.Entry(model).State = EntityState.Modified; } else { ee.Students.Add(model); Session["studentId"] = model.Id; } ee.SaveChanges(); General(model.Id); return(View("General")); }
public ActionResult Edit(int?id, string firstname, string lastname, string email, int group_id) { if (firstname != "" && lastname != "" && email != "") { User usr = db.Users.FirstOrDefault(us => us.id == id); usr.Firstname = firstname; usr.Lastname = lastname; usr.Email = email; usr.Group_id = group_id; db.SaveChanges(); return(RedirectToAction("Index", "Home")); } else { ViewBag.Error = "Zehmet olmasa butun xanalari doldurun"; } return(View()); }
public ActionResult General(int studentId) { Session["studentId"] = studentId; /* Entities1 ee = new Entities1(); * Student ss = new Student * { * Id = 1, * Active = true, * StudentName = "test", * StudentSurName = "testSurname", * Adres="", * StudentPapier=true, * StudentPrice=0, * StudentRestPrice=0, * StudentExtraInfo="", * StudentBirthDate="" * }; * ee.Students.Add(ss); * ee.SaveChanges(); * var std = ee.Students.Find(); */ /* * var std = new Models.Student { Id = 1, Email = "*****@*****.**", studentName = "STEFFY 1", studentSurName = "XYZ1" }; * var pymts = new List<Models.Student_Payments>(); * pymts.Add(new Models.Student_Payments { Id=1,Payment=100, date="1.1.2001"}); * pymts.Add(new Models.Student_Payments { Id = 2, Payment = 102, date = "1.1.2001" }); * pymts.Add(new Models.Student_Payments { Id = 3, Payment = 103, date = "1.1.2001" }); * std.payments=pymts.ToArray(); */ studentEntities ee = new studentEntities(); /* * ee.Students.Add( new Student { * Id=1, * StudentName ="test", * StudentSurName ="test", * StudentPrice=100, * PhoneNumber="12345678" * }); * ee.Students.Add(new Student * { * Id = 2, * StudentName = "test", * StudentSurName = "test2", * StudentPrice = 200, * PhoneNumber = "22345678" * }); * ee.Students.Add(new Student * { * Id = 3, * StudentName = "test2", * StudentSurName = "test2x", * StudentPrice = 300, * PhoneNumber = "xx345678" * }); * ee.Students.Add(new Student * { * Id = 4, * StudentName = "test2", * StudentSurName = "testy", * StudentPrice = 500, * PhoneNumber = "1R3T5Z78" * }); * ee.Student_Payments.Add(new Student_Payments { Payment = 100, StudentId = 1 }); * ee.Student_Payments.Add(new Student_Payments { Payment = 200, StudentId = 1 }); * ee.Student_Payments.Add(new Student_Payments { Payment = 300, StudentId = 3 }); * ee.Student_Payments.Add(new Student_Payments { Payment = 400, StudentId = 3 }); * ee.Student_Payments.Add(new Student_Payments { Payment = 500, StudentId = 2 }); * ee.Student_Payments.Add(new Student_Payments { Payment = 600, StudentId = 2 }); */ ee.SaveChanges(); Student sx = new Student(); using (var context = new studentEntities()) { /* * var ss = from b in context.Students * where b.Id == 1 * select b; */ // Query for the Blog named ADO.NET Blog sx = context.Students .Where(b => b.Id == 1) .FirstOrDefault(); ViewBag.PaymentsList = context.Student_Payments .Where(b => b.StudentId == studentId) .ToList(); } /* svm.Payments = new List<Student_Payments>(); * foreach (var item in ee.Student_Payments) * { * svm.Payments.Add( new Student_Payments { Id=item.Id, Payment=item.Payment, StudentId=item.StudentId} ); * } */ ViewBag.studentId = studentId; return(View()); }