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