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));
}
