private void BindGrid()
{
using (Medappz2_LiveEntities context = new Medappz2_LiveEntities())
{
var Sections = (from
//vComt in context.L_SECU_MNU_OP_MAP join
//vSecu in context.L_SECU_SECTION_OPERATION_MAP on vComt.FK_OPERATION_MAP_ID equals
//vSecu.PK_ID join
vMethod in context.L_SECU_ALL_METHODS
join vComparator in context.L_SECU_METHOD_ARG_COMPARATOR on vMethod.PK_ID equals
vComparator.FK_METHOD_ID join vVal in context.L_SECU_COMPARATOR_VALUE on vComparator.PK_ID equals
vVal.FK_COMPARATOR_ID
//join k in l.L_SECU_ALL_METHODS on v.PK_ID equals k.FK_CONFIG_ID
where vMethod.PK_ID == this.methodId
&& vVal.FK_MENU_MAP_ID == this.MenuMapId
select new
{
vComparator.PARAM_KEY,
vComparator.PARAM_INDEX,
vVal.PARAM_VALUE
}).Distinct();
//lstComparatorValue.DataSource = Sections;
//lstComparatorValue.DataBind();
}
}
protected void btnAddMethod_Click(object sender, EventArgs e)
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var MethodName = txtMethodName.Text.Trim();
long pkID = -1;
var className = txtClassName.Text.Trim();
if (btnAddMethod.Text == "Update Method")
{
var SelectedId= Convert.ToInt64(grdMethods.SelectedDataKey.Value);
var ObjMethod = (from vObj in l.L_SECU_ALL_METHODS where vObj.PK_ID == SelectedId select vObj).FirstOrDefault();
/// var ObjMethod = getMethodObj(SelectedId);
if(ObjMethod != null)
{
pkID = ObjMethod.PK_ID;
ObjMethod.CLASS_NAME = className;
ObjMethod.METHOD_NAME = MethodName;
}
l.SaveChanges();
}
else
{
var ObjMethod = (from vObj in l.L_SECU_ALL_METHODS where vObj.METHOD_NAME == MethodName select vObj).FirstOrDefault();
if (ObjMethod == null)
{
var objNewMethod = new L_SECU_ALL_METHODS()
{
// FK_CONFIG_ID = sectionId,
ROW_STATUS = 1,
METHOD_NAME = MethodName,
CLASS_NAME = className
};
l.L_SECU_ALL_METHODS.AddObject(objNewMethod);
l.SaveChanges();
pkID = objNewMethod.PK_ID;
}
else
{
lblErrorMessage.Text = "Method already exists";
}
}
txtMethodName.Text = "";
txtClassName.Text = "";
if (pkID > 0)
{
ucMethodArgumentComparator1.SaveComparator(pkID);
}
}
ucMethodArgumentComparator1.resetComparator();
ucMethodArgumentComparator1.bindComparator(-1);
BindGrid();
grdMethods.SelectedIndex = -1;
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
if (btnSave.Text == "Save")
{
var objName = txtName.Text.Trim();
var objType = Convert.ToInt64(hdnType.Value);
var objParentId = Convert.ToInt64(hdnParentId.Value);
var isExists = (from vConfig in l.L_SECU_CONFIG where vConfig.FK_SCE_CONFIG_TYPE == objType
&& vConfig.NAME == objName && vConfig.FK_PK_PARENT_ID == objParentId select vConfig).Count() > 0 ;
if (!isExists)
{
l.L_SECU_CONFIG.AddObject(new L_SECU_CONFIG()
{
CREATION_DATE = DateTime.Now,
DESCRIPTION = txtName.Text,
FK_PERMISSION_LEVEL_ID = Convert.ToInt64(ddlPermLevel.SelectedValue),
FK_PK_PARENT_ID = objParentId,
NAME = objName,
REFERANCE = "",
FK_SCE_CONFIG_TYPE = objType,
ROW_STATUS = 1
});
}
else
{
lblErrorMsg.Text = "Already exists";
}
}
else if (btnSave.Text == "Update")
{
var PkID = Convert.ToInt64(GridView1.SelectedDataKey.Value);
var obj = (from verSec in l.L_SECU_CONFIG
where verSec.PK_ID == PkID
select verSec).FirstOrDefault();
if (obj != null)
{
obj.NAME = txtName.Text.Trim();
obj.FK_PERMISSION_LEVEL_ID = Convert.ToInt64(ddlPermLevel.SelectedValue);
}
GridView1.SelectedIndex = -1;
}
l.SaveChanges();
bindGrid();
txtName.Text = "";
btnSave.Text = "Save";
}
}
private List<L_V_UTILITY_MENU> hasChild(long ParentID)
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var Op = (from v in l.L_V_UTILITY_MENU where v.FK_PARENT_ID == ParentID select v).ToList();
if (Op.Count == 0)
return null;
else
{
Op.Insert(0, new L_V_UTILITY_MENU() { PK_MENU_ID = -200, MENU_NAME = "---select----" });
return Op;
}
}
}
private void BindGrid()
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var selectMenu = Convert.ToInt64(hdnMenuID.Value);
var Items = (from vMap in l.L_SECU_MNU_OP_MAP
join
vSec in l.L_SECU_SECTION_OPERATION_MAP
on vMap.FK_OPERATION_MAP_ID equals vSec.PK_ID
where vMap.REFERANCE == selectMenu
select vSec.FK_METHOD_ID).Distinct().ToList();
DataList1.DataSource = Items;
DataList1.DataBind();
}
}
protected void btnAddMethod_Click(object sender, EventArgs e)
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var sectionId = Convert.ToInt64(this.Section);
var MethodName = txtMethodName.Text;
l.L_SECU_ALL_METHODS.AddObject(new L_SECU_ALL_METHODS()
{
// FK_CONFIG_ID = sectionId,
ROW_STATUS = 1,
METHOD_NAME = MethodName
});
l.SaveChanges();
txtMethodName.Text = "";
if (methodAdded != null)
{
methodAdded(this, new EventArgs());
}
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
Session["TempGrid"] = null;
if (Session["TempGrid"] == null)
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
_tempObj = (from v in l.L_SECU_MNU_OP_MAP
select new TempeltMap()
{
menuID = v.REFERANCE,
OperationMapID = v.FK_OPERATION_MAP_ID,
OperationMode = (int)v.OPERATION_MODE
}).ToList();
Session["TempGrid"] = _tempObj;
}
// ((List<TempeltMap>)Session["TempGrid"]).Clear();
BindGrid();
}
public void bindComparator(long pkId)
{
// resetComparator();
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var objComparators = (from v in l.L_SECU_METHOD_ARG_COMPARATOR
// join k in l.L_SECU_MNU_OP_MAP on v.FK_MENU_OP_MAP_ID equals k.PK_ID
where v.FK_METHOD_ID == pkId // k.REFERANCE == selecteScreenn && k.OPERATION_MODE == OpMode
select v).Distinct();
foreach (L_SECU_METHOD_ARG_COMPARATOR comPobj in objComparators)
{
addComparatorToSession(comPobj.PARAM_KEY, comPobj.PARAM_INDEX, comPobj.TYPE);
}
var comparator = getCurrentTempletMap();
if (comparator != null)
{
dtListCopm.DataSource = comparator;
dtListCopm.DataBind();
}
}
}
public void BindGrid()
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var ObjMethod = (from vObj in l.L_SECU_ALL_METHODS
// join vIn in l.L_SECU_METHOD_ARG_COMPARATOR.DefaultIfEmpty() on vObj.PK_ID equals vIn.FK_METHOD_ID
orderby vObj.METHOD_NAME
select new
{
vObj.PK_ID,
vObj.METHOD_NAME,
vObj.ROW_STATUS,
vObj.CLASS_NAME,
Comparator_Count = (from vIn in l.L_SECU_METHOD_ARG_COMPARATOR where vIn.FK_METHOD_ID == vObj.PK_ID select vIn.PK_ID).Count()
});
grdMethods.DataSource = ObjMethod;
grdMethods.DataBind();
}
}
public void bindGrid()
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var ConParentID = Convert.ToInt64(hdnParentId.Value);
var gridSrc = from vcnf in l.L_SECU_CONFIG
join vcnTp in l.L_SECU_CONFIG_TYPE
on vcnf.FK_SCE_CONFIG_TYPE equals vcnTp.PK_ID
join vplvl in l.L_SECU_PERMISSION_LEVEL on
vcnf.FK_PERMISSION_LEVEL_ID equals vplvl.PK_ID
where vcnf.FK_PK_PARENT_ID == ConParentID
select new {
vcnf.PK_ID,
Name=vcnf.NAME,
ConfigType = vcnTp.NAME,
PerMissionLevel=vplvl.NAME
};
GridView1.DataSource = gridSrc;
GridView1.DataBind();
}
}
public void SaveComparator(long PkID)
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
foreach (Comparator cmprObjs in getCurrentTempletMap())
{
var objCount = (from vCpObj in l.L_SECU_METHOD_ARG_COMPARATOR
where vCpObj.FK_METHOD_ID == PkID
&& vCpObj.PARAM_KEY == cmprObjs.ParamKey && vCpObj.PARAM_INDEX == cmprObjs.ParamIndex
select vCpObj).ToArray().Count();
if (objCount == 0)
{
l.AddToL_SECU_METHOD_ARG_COMPARATOR(new L_SECU_METHOD_ARG_COMPARATOR()
{
FK_METHOD_ID = PkID,
PARAM_INDEX = cmprObjs.ParamIndex,
PARAM_KEY = cmprObjs.ParamKey,
TYPE = cmprObjs.ParamType
});
}
}
l.SaveChanges();
}
}
private void addComparatorToSession(long ID, string value)
{
var OperationMenuMap = getCurrentTempletMap();
//if (Session["TempGrid"] != null)
//{
//_tempObj = (List<TempeltMap>)Session["TempGrid"];
//var OpMode = Convert.ToInt64(RadioButtonList2.SelectedValue);
//var selectedMenu = string.IsNullOrWhiteSpace(hdnMenuID.Value) ? -1 : Convert.ToInt64(hdnMenuID.Value);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
//var OperationMenuMap = (from v in _tempObj where v.menuID == selectedMenu && v.OperationMode == OpMode select v).FirstOrDefault();
if (OperationMenuMap != null)
{
var isExist = (from vObj in OperationMenuMap.comparator
where vObj.ComparatorID == ID
&& vObj.ParamValue == value
select vObj).FirstOrDefault();
if (isExist == null)
{
OperationMenuMap.comparator.Add(new ComparatorValue()
{
ComparatorID = ID,
ParamValue = value
});
}
}
}
}
protected void Menu_selected(object sender, EventArgs e)
{
// hdnLevel.Value = "-100";
var selectedValu = ((DropDownList)sender);
// var select = string.IsNullOrWhiteSpace(selectedValu) ? -1 : Convert.ToInt64(selectedValu);
if (selectedValu.ID == "ddlMenu")
{
hdnMenuID.Value = ddlMenu.SelectedValue;
ddlMenu_1.Items.Clear();
PopulateChiled(Convert.ToInt64(ddlMenu.SelectedValue), 2);
}
else if (selectedValu.ID == "ddlMenu_1")
{
hdnMenuID.Value = ddlMenu_1.SelectedValue;
ddlMenu_2.Items.Clear();
PopulateChiled(Convert.ToInt64(ddlMenu_1.SelectedValue), 3);
}
else if (selectedValu.ID == "ddlMenu_2")
{
hdnMenuID.Value = ddlMenu_2.SelectedValue;
// PopulateChiled(Convert.ToInt64(ddlMenu_2.SelectedValue), 4);
}
//if (select > 0)
// PopulateChiled(select);
if (Session["TempGrid"] == null)
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
_tempObj = (from v in l.L_SECU_MNU_OP_MAP
select new TempeltMap()
{
menuID = v.REFERANCE,
OperationMapID = v.FK_OPERATION_MAP_ID,
OperationMode = (int)v.OPERATION_MODE
}).ToList();
Session["TempGrid"] = _tempObj;
}
BindGrid();
bindComparator();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
if (Session["TempGrid"] != null)
{
_tempObj = (List<TempeltMap>)Session["TempGrid"];
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
long pk_id;
var AddObj = (from vObj in _tempObj
select new L_SECU_MNU_OP_MAP()
{
REFERANCE = vObj.menuID,
FK_OPERATION_MAP_ID = vObj.OperationMapID,
OPERATION_MODE = Convert.ToInt32(vObj.OperationMode)
});
foreach (TempeltMap itm in _tempObj)
{
var IsExist = (from v in l.L_SECU_MNU_OP_MAP
where
v.OPERATION_MODE == itm.OperationMode &&
v.FK_OPERATION_MAP_ID == itm.OperationMapID &&
v.REFERANCE == itm.menuID
select v
).FirstOrDefault();
if (IsExist == null)
{
L_SECU_MNU_OP_MAP objAddMap = new L_SECU_MNU_OP_MAP()
{
REFERANCE = itm.menuID,
FK_OPERATION_MAP_ID = itm.OperationMapID,
OPERATION_MODE = Convert.ToInt32(itm.OperationMode)
};
l.AddToL_SECU_MNU_OP_MAP(objAddMap);
l.SaveChanges();
pk_id = objAddMap.PK_ID;
}
else
{
pk_id = IsExist.PK_ID;
}
foreach (ComparatorValue cmprObjs in itm.comparator)//DataListItem dataItem in dtListCopm.Items)
{
//var hdPkID = Convert.ToInt64(((HiddenField)dataItem.FindControl("hdnComparatorID")).Value);
//TextBox txtVal = (TextBox)dataItem.FindControl("txtComparatorValue");
var HasItem = (from vCompVal in l.L_SECU_COMPARATOR_VALUE
where
vCompVal.PARAM_VALUE == cmprObjs.ParamValue && vCompVal.FK_COMPARATOR_ID == cmprObjs.ComparatorID
&& vCompVal.FK_MENU_MAP_ID == pk_id
select vCompVal).FirstOrDefault();
if (HasItem == null&& !string.IsNullOrWhiteSpace(cmprObjs.ParamValue))
{
l.AddToL_SECU_COMPARATOR_VALUE(new L_SECU_COMPARATOR_VALUE()
{
FK_COMPARATOR_ID = cmprObjs.ComparatorID,
FK_MENU_MAP_ID = pk_id,
PARAM_VALUE = cmprObjs.ParamValue
});
}
}
//foreach (Comparator cmprObjs in itm.comparator)
//{
// l.AddToL_SECU_MENU_MAP_COMPARATOR(new L_SECU_MENU_MAP_COMPARATOR()
// {
// FK_MENU_OP_MAP_ID = pk_id,
// PARAM_INDEX = cmprObjs.ParamIndex,
// PARAM_KEY = cmprObjs.ParamKey,
// PARAM_VALUE = cmprObjs.ParamValue,
// TYPE = cmprObjs.ParamType
// });
//}
}
l.SaveChanges();
Session["TempGrid"] = null;
}
}
BindGrid();
}
private void addComparatorToSession(string Key, int? index, int type)
{
var comparator = getCurrentTempletMap();
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
//var OperationMenuMap = (from v in _tempObj where v.menuID == selectedMenu && v.OperationMode == OpMode select v).FirstOrDefault();
if (comparator != null)
{
var isExist = (from vObj in comparator
where vObj.ParamKey == Key
&& vObj.ParamIndex == index
select vObj).FirstOrDefault();
if (isExist == null)
{
comparator.Add(new Comparator()
{
ParamIndex = index,
ParamKey = Key,
ParamType = type
});
}
}
}
//}
}
private void BindGrid()
{
if (Session["TempGrid"] != null)
{
_tempObj = (List<TempeltMap>)Session["TempGrid"];
var selectedMenu = string.IsNullOrWhiteSpace(hdnMenuID.Value) ? -1 : Convert.ToInt64(hdnMenuID.Value);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var menuName = (from v in _tempObj where v.menuID == selectedMenu select new { v.menuID, v.OperationMode}).Distinct();
var vMenu = new List<GridL>();
foreach (var menu in menuName)
{
var Items = (from s in _tempObj
join vk in l.L_SECU_SECTION_OPERATION_MAP
on s.OperationMapID equals vk.PK_ID
join kl in l.L_SECU_CONFIG on vk.FK_SCE_CONFIG_ID equals kl.PK_ID
join ac in l.l_SECU_OPERATION_ACTION on vk.FK_ACTION_ID equals ac.PK_ID
where s.menuID == menu.menuID && s.OperationMode == menu.OperationMode
select
kl.NAME +"("+vk.OPERATION_NAME+")"
).ToArray();
// var CommaSaperatedString =Items.Aggregate((a,b)=> a+","+b);
vMenu.Add(new GridL()
{
MenuName = (from vx in l.L_V_UTILITY_MENU where vx.PK_MENU_ID == menu.menuID select vx.MENU_NAME).FirstOrDefault(),
AssignedAction = Items.Aggregate((a, b) => a + ", " + b) ,
OperationMode = Enum.GetName(typeof(Mode), menu.OperationMode)
});
}
grvTemplet.DataSource = vMenu;
grvTemplet.DataBind();
}
}
}
private void bindSections()
{
var selecteScreenn = string.IsNullOrWhiteSpace(ddlScreen.SelectedValue) ? -1 : Convert.ToInt64(ddlScreen.SelectedValue);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var Sections = (from v in l.L_SECU_CONFIG
//join k in l.L_SECU_ALL_METHODS on v.PK_ID equals k.FK_CONFIG_ID
where v.ROW_STATUS == 1 &&
v.FK_SCE_CONFIG_TYPE == 4 &&
(from x in l.L_SECU_SECTION_OPERATION_MAP
where x.FK_SCE_CONFIG_ID != v.PK_ID
// //&& x.OPERATION_NAME == k.METHOD_NAME
select x).Count() > 0 &&
v.FK_PK_PARENT_ID == selecteScreenn
select new
{
v.PK_ID,
v.NAME
}).Distinct();
ddlSection.DataTextField = "NAME";
ddlSection.DataValueField = "PK_ID";
ddlSection.DataSource = Sections;
ddlSection.DataBind();
}
}
/// <summary>
/// event handller to save OpAction mapping
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void OpMapSave(object sender, EventArgs e)
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var selectedAction = Convert.ToInt64(RadioButtonList1.SelectedValue);
var selectedSection = Convert.ToInt64(ddlSection.SelectedValue);
var selectedMethod = Convert.ToInt64(ddlMethods.SelectedValue);
if (btnSave.Text == "Update")
{
var selectPk = Convert.ToInt64(grdOpAcMap.SelectedDataKey.Value);
var IsExistMap = (from vMap in l.L_SECU_SECTION_OPERATION_MAP
where vMap.FK_ACTION_ID == selectedAction
&& vMap.FK_METHOD_ID == selectedMethod
&& vMap.FK_SCE_CONFIG_ID == selectedSection && vMap.PK_ID != selectPk
select vMap).Count() > 0;
if (!IsExistMap)
{
var objSecuMap = (from vMap in l.L_SECU_SECTION_OPERATION_MAP where vMap.PK_ID == selectPk select vMap).FirstOrDefault();
objSecuMap.FK_ACTION_ID = selectedAction;
objSecuMap.FK_METHOD_ID = selectedMethod;
objSecuMap.OPERATION_NAME = ddlMethods.SelectedItem.Text;
objSecuMap.FK_SCE_CONFIG_ID = selectedSection;
}
}
else
{
var IsExistMap = (from vMap in l.L_SECU_SECTION_OPERATION_MAP
where vMap.FK_ACTION_ID == selectedAction
&& vMap.FK_METHOD_ID == selectedMethod
&& vMap.FK_SCE_CONFIG_ID == selectedSection
select vMap).Count() > 0;
if (!IsExistMap)
{
var objSectionActionMap = new L_SECU_SECTION_OPERATION_MAP()
{
CREATION_DATE = DateTime.Now,
FK_ACTION_ID = selectedAction,
ROW_STATUS = 1,
OPERATION_NAME = ddlMethods.SelectedItem.Text,
FK_METHOD_ID = selectedMethod,
FK_SCE_CONFIG_ID = selectedSection
};
l.L_SECU_SECTION_OPERATION_MAP.AddObject(objSectionActionMap);
}
}
l.SaveChanges();
bindSections();
bindGrid();
grdOpAcMap.SelectedIndex = -1;
}
}
protected void configSelected(object sender, EventArgs e)
{
var PkID = Convert.ToInt64(GridView1.SelectedDataKey.Value);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var obj = (from verSec in l.L_SECU_CONFIG
where verSec.PK_ID == PkID
select verSec).FirstOrDefault();
txtName.Text = obj.NAME;
ddlPermLevel.SelectedValue = obj.FK_PERMISSION_LEVEL_ID.ToString();
btnSave.Text = "Update";
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var PkID = Convert.ToInt64(e.Keys[0]);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var obj = (from verSec in l.L_SECU_CONFIG
where verSec.PK_ID == PkID
select verSec).FirstOrDefault();
l.L_SECU_CONFIG.DeleteObject(obj);
l.SaveChanges();
bindGrid();
txtName.Text = "";
}
}
private L_SECU_ALL_METHODS getMethodObj(long SelectedID)
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var ObjMethod = (from vObj in l.L_SECU_ALL_METHODS where vObj.PK_ID == SelectedID select vObj).FirstOrDefault();
return ObjMethod;
}
}
private void BindActionMap()
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var selectedSection = string.IsNullOrWhiteSpace(ddlSection.SelectedValue) ? -1 : Convert.ToInt64(ddlSection.SelectedValue);
var Sections = (from v in l.L_SECU_SECTION_OPERATION_MAP
join vMap in l.L_SECU_ALL_METHODS on v.FK_METHOD_ID equals vMap.PK_ID
join
ac in l.l_SECU_OPERATION_ACTION on v.FK_ACTION_ID equals ac.PK_ID
where v.FK_SCE_CONFIG_ID == selectedSection
select new
{
v.PK_ID,
ACTION_NAME= ac.ACTION_NAME +"("+ vMap.METHOD_NAME+")"
});
rdbAction.DataTextField = "ACTION_NAME";
rdbAction.DataValueField = "PK_ID";
rdbAction.DataSource = Sections;
rdbAction.DataBind();
}
}
private void bindComparator()
{
var selecteScreenn = string.IsNullOrWhiteSpace(rdbAction.SelectedValue) ? -1 : Convert.ToInt64(rdbAction.SelectedValue);
//var OpMode = Convert.ToInt64(RadioButtonList2.SelectedValue);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var objComparators = (from v in l.L_SECU_METHOD_ARG_COMPARATOR
join k in l.L_SECU_ALL_METHODS on v.FK_METHOD_ID equals k.PK_ID
join objSecMethod in l.L_SECU_SECTION_OPERATION_MAP on k.METHOD_NAME equals objSecMethod.OPERATION_NAME
where objSecMethod.PK_ID == selecteScreenn //&& k.OPERATION_MODE == OpMode
select v).Distinct();
foreach (L_SECU_METHOD_ARG_COMPARATOR comPobj in objComparators)
{
addComparatorToSession(comPobj.PK_ID, string.Empty);
}
var OperationMenuMap = getCurrentTempletMap();
//if (OperationMenuMap != null)
//{
dtListCopm.DataSource = objComparators;
dtListCopm.DataBind();
// }
}
}
private void DeleteMapping(long ID)
{
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
try
{
var DependentPermission = from vPer in l.l_SECU_MP_OPERATION_PERMISSION
where vPer.FK_OPERATION_MAP_ID == ID
select vPer;
foreach (l_SECU_MP_OPERATION_PERMISSION c in DependentPermission)
{
l.DeleteObject(c);
}
var DependendOp = from vOp in l.L_SECU_MNU_OP_MAP where vOp.FK_OPERATION_MAP_ID == ID select vOp;
foreach (L_SECU_MNU_OP_MAP c in DependendOp)
{
l.DeleteObject(c);
}
l.DeleteObject((from vObj in l.L_SECU_SECTION_OPERATION_MAP where vObj.PK_ID == ID select vObj).FirstOrDefault());
l.SaveChanges();
}
catch (Exception Eobj)
{
System.Diagnostics.Debug.WriteLine(Eobj.Message);
}
}
}
/// <summary>
/// method to bind opAction mapping grid
/// </summary>
private void bindGrid()
{
var selecteScreenn = string.IsNullOrWhiteSpace(ddlSection.SelectedValue) ? -1 : Convert.ToInt64(ddlSection.SelectedValue);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var Operations = from x in l.L_SECU_SECTION_OPERATION_MAP
join y in l.L_SECU_CONFIG on x.FK_SCE_CONFIG_ID equals y.PK_ID
join z in l.l_SECU_OPERATION_ACTION on x.FK_ACTION_ID equals z.PK_ID
join vMethod in l.L_SECU_ALL_METHODS on x.FK_METHOD_ID equals vMethod.PK_ID
where x.ROW_STATUS == 1 && y.ROW_STATUS == 1 && x.FK_SCE_CONFIG_ID == selecteScreenn
select new {
x.PK_ID,
SectionName = y.NAME,
OperationName = vMethod.METHOD_NAME,
ActionAssociated = z.ACTION_NAME
};
// where x.OPERATION_NAME == v.METHOD_NAME
grdOpAcMap.DataSource = Operations;
grdOpAcMap.DataBind();
}
}
protected void OpActionMapSelected(object sender, EventArgs e)
{
var selectPk = Convert.ToInt64(grdOpAcMap.SelectedDataKey.Value);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var objMethodMap = (from vMap in l.L_SECU_SECTION_OPERATION_MAP
where vMap.PK_ID == selectPk
select
new
{
vMap.FK_METHOD_ID,
vMap.FK_ACTION_ID
}).FirstOrDefault();
if (objMethodMap != null)
{
btnSave.Text = "Update";
ddlMethods.SelectedValue = objMethodMap.FK_METHOD_ID.ToString();
RadioButtonList1.SelectedValue = objMethodMap.FK_ACTION_ID.ToString();
}
}
}
private TempeltMap getCurrentTempletMap()
{
if (Session["TempGrid"] != null)
{
_tempObj = (List<TempeltMap>)Session["TempGrid"];
var OpMode = Convert.ToInt64(RadioButtonList2.SelectedValue);
var selectedMenu = string.IsNullOrWhiteSpace(hdnMenuID.Value) ? -1 : Convert.ToInt64(hdnMenuID.Value);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var OperationMenuMap = (from v in _tempObj
where v.menuID == selectedMenu && v.OperationMode == OpMode
select v).FirstOrDefault();
return OperationMenuMap;
}
}
else
{
return null;
}
}
/// <summary>
/// Bind Methods to ddl from database
/// </summary>
private void bindMethods()
{
var selecteScreenn = string.IsNullOrWhiteSpace(ddlSection.SelectedValue) ? -1 : Convert.ToInt64(ddlSection.SelectedValue);
using (Medappz2_LiveEntities l = new Medappz2_LiveEntities())
{
var Sections = (from v in l.L_SECU_ALL_METHODS
where v.ROW_STATUS == 1
orderby v.METHOD_NAME
//&&
// (from x in l.L_SECU_SECTION_OPERATION_MAP
// where x.OPERATION_NAME == v.METHOD_NAME
//select x).Count() < 1
///&& v.FK_CONFIG_ID == selecteScreenn
select new
{
NAME= v.METHOD_NAME,
PK_ID= v.PK_ID
}).Distinct();
ddlMethods.DataTextField = "NAME";
ddlMethods.DataValueField = "PK_ID";
ddlMethods.DataSource = Sections;
ddlMethods.DataBind();
}
}