/// <summary>
 /// Create a new L_SECU_SECTION_OPERATION_MAP object.
 /// </summary>
 /// <param name="pK_ID">Initial value of the PK_ID property.</param>
 /// <param name="oPERATION_NAME">Initial value of the OPERATION_NAME property.</param>
 /// <param name="fK_SCE_CONFIG_ID">Initial value of the FK_SCE_CONFIG_ID property.</param>
 /// <param name="fK_ACTION_ID">Initial value of the FK_ACTION_ID property.</param>
 /// <param name="rOW_STATUS">Initial value of the ROW_STATUS property.</param>
 /// <param name="cREATION_DATE">Initial value of the CREATION_DATE property.</param>
 public static L_SECU_SECTION_OPERATION_MAP CreateL_SECU_SECTION_OPERATION_MAP(global::System.Int64 pK_ID, global::System.String oPERATION_NAME, global::System.Int64 fK_SCE_CONFIG_ID, global::System.Int64 fK_ACTION_ID, global::System.Int16 rOW_STATUS, global::System.DateTime cREATION_DATE)
 {
     L_SECU_SECTION_OPERATION_MAP l_SECU_SECTION_OPERATION_MAP = new L_SECU_SECTION_OPERATION_MAP();
     l_SECU_SECTION_OPERATION_MAP.PK_ID = pK_ID;
     l_SECU_SECTION_OPERATION_MAP.OPERATION_NAME = oPERATION_NAME;
     l_SECU_SECTION_OPERATION_MAP.FK_SCE_CONFIG_ID = fK_SCE_CONFIG_ID;
     l_SECU_SECTION_OPERATION_MAP.FK_ACTION_ID = fK_ACTION_ID;
     l_SECU_SECTION_OPERATION_MAP.ROW_STATUS = rOW_STATUS;
     l_SECU_SECTION_OPERATION_MAP.CREATION_DATE = cREATION_DATE;
     return l_SECU_SECTION_OPERATION_MAP;
 }
 /// <summary>
 /// Deprecated Method for adding a new object to the L_SECU_SECTION_OPERATION_MAP EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToL_SECU_SECTION_OPERATION_MAP(L_SECU_SECTION_OPERATION_MAP l_SECU_SECTION_OPERATION_MAP)
 {
     base.AddObject("L_SECU_SECTION_OPERATION_MAP", l_SECU_SECTION_OPERATION_MAP);
 }
        /// <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;
            }
        }