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