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