public string AddPlinks(tbl_MCE_PrimaryLink mce_Primarylink)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "PRIMARYLINKINSERT");
param.Add("@p_vchPLinkName", mce_Primarylink.vchPLinkName);
param.Add("@p_intGLinkID", mce_Primarylink.intGLinkID);
param.Add("@p_intFunctionID", mce_Primarylink.intFunctionID);
param.Add("@p_intSlNo", mce_Primarylink.intSlNo);
param.Add("@p_vchExternalURL", mce_Primarylink.vchExternalURL);
param.Add("@p_bitLinkType ", mce_Primarylink.bitLinkType);
param.Add("@p_bitShowOnHomePage", mce_Primarylink.bitShowOnHomePage);
param.Add("@p_intAccessID", mce_Primarylink.intAccessID);
param.Add("@p_intAccess ", mce_Primarylink.intAccess);
param.Add("@p_intUserID", mce_Primarylink.intUserID);
param.Add("@p_vchAction1", mce_Primarylink.vchAction1);
param.Add("@p_vchIcon", mce_Primarylink.vchIcon);
param.Add("@P_vchRemarks", mce_Primarylink.vchRemarks);
param.Add("@P_intCreatedBy", mce_Primarylink.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Primarylink_DML", param, "@P_VCHMSGOUT"));
throw new NotImplementedException();
}
//FOR DETAILS OF PRIMARY LINK TABLE PAGE
public ActionResult PrimarylinkDetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_MCE_PrimaryLink Primarylink = _plinks.PrimarylinkDetails((int)id);
return(View(Primarylink));
}
public ActionResult CreatePlink(tbl_MCE_PrimaryLink mce_Primarylink)
{
_plinks.AddPlinks(mce_Primarylink);
//CLEAR THE MODEL
ModelState.Clear();
ViewBag.GlinkList = _glinks.GlobalLinkList().ToList();
ViewBag.FlinkList = _flinks.FunctionList().ToList();
TempData["Success"] = "Primary Link Created Successfully";
return(View());
}
public string DeletePrimarylink(tbl_MCE_PrimaryLink mce_Primarylink)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "PRIMARYLINKDELETE");
param.Add("@p_intPLinkID", mce_Primarylink.intPLinkID);
param.Add("@P_intUpdatedBy", mce_Primarylink.intUpdatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Primarylink_DML", param, "@P_VCHMSGOUT"));
throw new NotImplementedException();
}
//FOR PRIMARY LINK DELETE PAGE
public ActionResult DeletePrimarylink(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_MCE_PrimaryLink Primarylink = _plinks.PrimarylinkDetails((int)id);
ViewBag.GlinkList = _glinks.GlobalLinkList().ToList();
ViewBag.FlinkList = _flinks.FunctionList().ToList();
//ViewBag.DefaultGlink = _plinks.int;
//ViewBag.DefaultRole = _plinks.intRoleID;
return(View(Primarylink));
}
public ActionResult DeletePrimarylink(tbl_MCE_PrimaryLink mce_Primarylink)
{
_plinks.DeletePrimarylink(mce_Primarylink);
TempData["Success"] = "Data Deleted Successfully";
return(RedirectToAction("ViewDataTableWithSearchPanel", "PrimaryLink"));
}
