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;
            }
        }
Exemple #7
0
        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";
            }
        }
Exemple #8
0
 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 = "";
     }
 }