public ActionResult Create(AcadamicMasterModel model) { var studentId = UserProfileMasterBAL.GetStudentProfileData(User.Identity.Name).StudentId; model.CollageName = CollageMasterBAL.GetCollage(studentId.ToString()).CollageName; model.SemesterList = AcademicMasterBAL.BindSamester(); model.GradeList = AcademicMasterBAL.BindGrade(); if (ModelState.IsValid) { try { // TODO: Add insert logic here AcademicMasterBAL.CreateProfile(model, studentId.ToString()); return(RedirectToAction("Index")); } catch (Exception Ex) { return(View(Ex)); } } else { return(View(model)); } }
public static void UpdateAcademic(AcadamicMasterModel model, string StudentId, int Id) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.ConString("DefaultConnection"))) { connection.Execute("update AcadamicMaster set CollageName = @CollageName,FromYear=@FromYear,ToYear=@ToYear,CourseName=@CourseName,Semester=@Semester,Credit=@Credit,Grade=@Grade,StudentId=@StudentId where StudentId = @StudentId and Id = @Id", new { model.CollageName, model.FromYear, model.ToYear, model.CourseName, model.Semester, model.Credit, model.Grade, StudentId, Id }); } }
public static void CreateProfile(AcadamicMasterModel model, string StudentId) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.ConString("DefaultConnection"))) { connection.Execute("insert into AcadamicMaster(CollageName,FromYear,ToYear,CourseName,Semester,Credit,Grade,StudentId) values(@CollageName,@FromYear,@ToYear,@CourseName,@Semester,@Credit,@Grade,@StudentId)", new { model.CollageName, model.FromYear, model.ToYear, model.CourseName, model.Semester, model.Credit, model.Grade, StudentId }); } }
// GET: Academic/Create public ActionResult Create() { var studentId = UserProfileMasterBAL.GetStudentProfileData(User.Identity.Name).StudentId; AcadamicMasterModel model = new AcadamicMasterModel(); model.CollageName = CollageMasterBAL.GetCollage(studentId.ToString()).CollageName; model.SemesterList = AcademicMasterBAL.BindSamester(); model.GradeList = AcademicMasterBAL.BindGrade(); return(View(model)); }
public ActionResult Edit(int id, AcadamicMasterModel model) { try { // TODO: Add update logic here var studentId = UserProfileMasterBAL.GetStudentProfileData(User.Identity.Name).StudentId; AcademicMasterBAL.UpdateAcademic(model, studentId.ToString(), id); return(RedirectToAction("Index")); } catch { return(View()); } }