public ActionResult CreateBranch(tbl_MCE_Branch mce_Branch)
{
_branches.AddBranch(mce_Branch);
ViewBag.courseList = course.CourseList().ToList();
TempData["Success"] = "Data Inserted Successfully";
ModelState.Clear();
return(View());
}
public ActionResult DeleteBranch(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_MCE_Branch branch = _branches.BranchDetails((int)id);
ViewBag.courseList = course.CourseList().ToList();
ViewBag.DefaultCourse = branch.intCourseID;
return(View(branch));
}
public string DeleteBranch(tbl_MCE_Branch mce_Branch)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "BRANCHDELETE");
param.Add("@P_intBranchID", mce_Branch.intBranchID);
param.Add("@P_intCreatedBy", mce_Branch.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Branch_DML", param, "@P_VCHMSGOUT"));
}
//update
public string EditBranch(tbl_MCE_Branch mce_Branch)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "BRANCHUPDATE");
param.Add("@P_intBranchID", mce_Branch.intBranchID);
param.Add("@P_vchBranchName", mce_Branch.vchBranchName);
param.Add("@P_vchBranchDescription", mce_Branch.vchBranchDescription);
param.Add("@P_vchRemarks", mce_Branch.vchRemarks);
param.Add("@P_intCreatedBy", mce_Branch.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Branch_DML", param, "@P_VCHMSGOUT"));
}
public string AddBranch(tbl_MCE_Branch mce_Branch)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "BRANCHINSERT");
param.Add("@P_vchBranchCode", mce_Branch.vchBranchCode);
param.Add("@P_vchBranchName", mce_Branch.vchBranchName);
param.Add("@P_vchBranchDescription", mce_Branch.vchBranchDescription);
param.Add("@P_intCourseID", mce_Branch.intCourseID);
param.Add("@P_vchCourseName", mce_Branch.vchCourseName);
param.Add("@P_vchRemarks", mce_Branch.vchRemarks);
param.Add("@P_intCreatedBy", mce_Branch.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Branch_DML", param, "@P_VCHMSGOUT"));
throw new NotImplementedException();
}
public ActionResult DeleteBranch(tbl_MCE_Branch mce_Branch)
{
_branches.DeleteBranch(mce_Branch);
TempData["Success"] = "Data Deleted Successfully";
return(RedirectToAction("ViewBranchDataTableWithSearchPanel", "Branch"));
}
public ActionResult TestData(tbl_MCE_Branch tbl_MCE_Branch)
{
return(View());
}
