public ActionResult CreateCourse(tbl_MCE_Course mce_Course)
{
course.AddCourse(mce_Course);
ModelState.Clear();
TempData["Success"] = "Data Created Successfully";
return(View());
}
public ActionResult EditCourse(tbl_MCE_Course mce_Course)
{
course.Editcourse(mce_Course);
TempData["Success"] = "Data Updated Successfully";
return(RedirectToAction("CourseDataTable", "Course"));
}
public ActionResult EditCourse(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_MCE_Course _course = course.CourseDetails((int)id);
return(View(_course));
}
public string Deletecourse(tbl_MCE_Course mce_Course)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "COURSEDELETE");
param.Add("@P_intCourseID", mce_Course.intCourseID);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Course_DML", param, "@P_VCHMSGOUT"));
}
public string Editcourse(tbl_MCE_Course mce_Course)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "COURSEUPDATE");
param.Add("@P_intCourseID", mce_Course.intCourseID);
param.Add("@P_vchCourseName", mce_Course.vchCourseName);
param.Add("@P_vchCourseDescription", mce_Course.vchCourseDescription);
param.Add("@P_intNoOfYears", mce_Course.intNoOfYears);
param.Add("@P_intNoOfSemesters", mce_Course.intNoOfSemesters);
param.Add("@P_intSemesterDuration", mce_Course.intSemesterDuration);
param.Add("@P_dtmStartDate", mce_Course.dtmStartDate);
param.Add("@P_dtmEndDate", mce_Course.dtmEndDate);
param.Add("@P_vchRemarks", mce_Course.vchRemarks);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Course_DML", param, "@P_VCHMSGOUT"));
}
public ActionResult DeleteCourse(tbl_MCE_Course mce_Course)
{
course.Deletecourse(mce_Course);
TempData["Success"] = "Data Deleted Successfully";
return(RedirectToAction("CourseDataTable", "Course"));
}
