public ActionResult NewSave(string exam, string institute, string group, string year, string grade, string studentNid) { // StudentEducationInfo objStudentEducationInfo = new StudentEducationInfo(); StudentEducationalQualification objStudentEducationalQualification = new StudentEducationalQualification(); if (ModelState.IsValid) { var stdId = studentNid; //var frmSlNo = Convert.ToInt64(FormSaleInfo_FormSerial); objStudentEducationalQualification.NidOrBirtgRegNo = stdId; objStudentEducationalQualification.ExamOrDegree = exam; objStudentEducationalQualification.InstituteName = institute; objStudentEducationalQualification.Group = group; objStudentEducationalQualification.PassingYear = year; objStudentEducationalQualification.GpaOrDivison = grade; db.StudentEducationalQualifications.Add(objStudentEducationalQualification); db.SaveChanges(); //var Id = db.StudentEducationInfos.Where(S => S.StudentId == stdId && S.Exam == Exam && S.InstitutionName == Institute && // S.GroupName == Group && S.PassingYear == Year && S.DivisionClass == Grade).Select(S => S.Id); var Id = db.StudentEducationalQualifications.Where( s => s.NidOrBirtgRegNo == stdId && s.ExamOrDegree == exam && s.InstituteName == institute && s.Group == group && s.PassingYear == year && s.GpaOrDivison == grade) .Select(s => s.Id) .FirstOrDefault(); return(Json(new { result = Id }, JsonRequestBehavior.AllowGet)); } return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet)); }
public ActionResult StudentEducationDelete(long id) { StudentEducationalQualification objStudentEducationalQualification = db.StudentEducationalQualifications.Find(id); // StudentEducationalQualification objStudentEducationalQualification = new StudentEducationalQualification(); if (objStudentEducationalQualification != null) { db.StudentEducationalQualifications.Remove(objStudentEducationalQualification); db.SaveChanges(); return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet)); } return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "StudentAccount,Nid,FirstName,LastName,Phone,AccountId,DateOfBirth")] ViewStudentAccount objStudentAccount, FormCollection collection, HttpPostedFileBase image) { SMS.Models.MediaModels.Image objImage = new SMS.Models.MediaModels.Image(); StudentEducationalQualification objStudentEducationalQualification = new StudentEducationalQualification(); var exam = collection["Exam"].Split(','); var institute = collection["Institute"].Split(','); var regNo = collection["Registration"].Split(','); var rollNo = collection["Roll"].Split(','); var group = collection["Group"].Split(','); var year = collection["Year"].Split(','); var grade = collection["Grade"].Split(','); //var registration = collection["Registration"].Split(','); if (image != null) { ////attach the uploaded image to the object before saving to Database //objImage.ImageMimeType = image.ContentLength; objImage.ImageFile = new byte[image.ContentLength]; image.InputStream.Read(objImage.ImageFile, 0, image.ContentLength); //Save image to file var filename = image.FileName; var filePathOriginal = Server.MapPath("/Data/Image"); var filePathThumbnail = Server.MapPath("/Data/Thumbnails"); string savedFileName = Path.Combine(filePathOriginal, filename); image.SaveAs(savedFileName); //Read image back from file and create thumbnail from it var imageFile = Path.Combine(Server.MapPath("~/Data/Image"), filename); using (var srcImage = System.Drawing.Image.FromFile(imageFile)) using (var newImage = new Bitmap(100, 100)) using (var graphics = Graphics.FromImage(newImage)) using (var stream = new MemoryStream()) { graphics.SmoothingMode = SmoothingMode.AntiAlias; graphics.InterpolationMode = InterpolationMode.HighQualityBicubic; graphics.PixelOffsetMode = PixelOffsetMode.HighQuality; graphics.DrawImage(srcImage, new Rectangle(0, 0, 200, 200)); newImage.Save(stream, ImageFormat.Png); var thumbNew = File(stream.ToArray(), "image/png"); //artwork.ArtworkThumbnail = thumbNew.FileContents; } objImage.TrackingId = objStudentAccount.Nid; //Save model object to database imagedb.Images.Add(objImage); imagedb.SaveChanges(); } objStudentAccount.StudentAccount.NidOrBirtgRegNo = objStudentAccount.Nid; objStudentAccount.StudentAccount.AccountId = objStudentAccount.AccountId; objStudentAccount.StudentAccount.FirstName = objStudentAccount.FirstName; objStudentAccount.StudentAccount.LasttName = objStudentAccount.LastName; objStudentAccount.StudentAccount.MobileNumber = objStudentAccount.Phone; objStudentAccount.StudentAccount.DateOfBirth = objStudentAccount.DateOfBirth; for (int i = 0; i < exam.Count(); i++) { if (exam[i] != "") { objStudentEducationalQualification.NidOrBirtgRegNo = objStudentAccount.StudentAccount.NidOrBirtgRegNo; objStudentEducationalQualification.ExamOrDegree = exam[i]; objStudentEducationalQualification.RegNumber = regNo[i]; objStudentEducationalQualification.RollNumber = rollNo[i]; objStudentEducationalQualification.InstituteName = institute[i]; objStudentEducationalQualification.PassingYear = year[i]; objStudentEducationalQualification.Group = group[i]; objStudentEducationalQualification.GpaOrDivison = grade[i]; db.StudentEducationalQualifications.Add(objStudentEducationalQualification); db.SaveChanges(); } } if (ModelState.IsValid) { db.StudentAccounts.Add(objStudentAccount.StudentAccount); db.SaveChanges(); return(RedirectToAction("Index")); } objStudentAccount.Class = new SelectList(db.ClassOrYears, "Code", "Name", objStudentAccount.StudentAccount.ClassOrYearId); objStudentAccount.Group = new SelectList(db.Groups, "GroupCode", "Name", objStudentAccount.StudentAccount.GroupId); return(View(objStudentAccount)); }