public ActionResult AddEditOPM(int OPM_ID = 0)
        {
            BuyerReferenceManager objBuyerReferenceManager = new BuyerReferenceManager(new DataContext());
            ParticipiantManager   objParticipiantManager   = new ParticipiantManager(new DataContext());
            BuyerNameManager      objBuyerNameManager      = new BuyerNameManager(new DataContext());
            OPMManager            context  = new OPMManager(new DataContext());
            OPM_Model             objModel = new OPM_Model();

            if (OPM_ID != 0)
            {
                objModel.Table = context.GetOPMById(OPM_ID);
                if (objModel.Table.Participants != null)
                {
                    objModel.Participant = objModel.Table.Participants.Split(',');
                }
                if (objModel.Table.BuyerReferenceName != null)
                {
                    objModel.BuyerReferenceName = objModel.Table.BuyerReferenceName.Split(',');
                }
            }
            else
            {
                objModel.Table              = new OPM();
                objModel.Participant        = null;
                objModel.BuyerReferenceName = null;
            }
            objModel.BuyerReferenceNameList = Extens.ToSelectList(objBuyerReferenceManager.GetDtBuyerReferenceName(), "BuyerReferenceName", "BuyerReferenceName");
            objModel.BuyerStoryNameList     = Extens.ToSelectList(objBuyerReferenceManager.GetDtBuyerStoryName(), "StoryName", "StoryName");
            objModel.BuyerNameList          = Extens.ToSelectList(objBuyerNameManager.GetDtBuyerName(), "Buyername", "Buyername");
            objModel.ParticipantList        = Extens.ToSelectList(objParticipiantManager.GetDtParticipiantName(), "Name", "Name");

            return(PartialView("OPMCRUD", objModel));
        }
        public void BindOPMGrid(OPM_Model objModel, int page, int pageSize)
        {
            BuyerReferenceManager objBuyerReferenceManager = new BuyerReferenceManager(new DataContext());
            StringBuilder         query = new StringBuilder();
            var colName = common.GetColumns(CommonFunction.module.OPM.ToString());

            query = common.GetSqlTableQuery(CommonFunction.module.OPM.ToString());
            if (objModel != null)
            {
                objModel.StaticPageSize = pageSize;
            }

            objModel.BuyerReferenceNameList = Extens.ToSelectList(objBuyerReferenceManager.GetDtBuyerReferenceName(), "BuyerReferenceName", "BuyerReferenceName");
            //objModel.BuyerStoryNameList = Extens.ToSelectList(objBuyerReferenceManager.GetDtBuyerReferenceName(), "StoryName", "StoryName");
            OPMManager context = new OPMManager(new DataContext());

            objModel.sortOrder = "desc";
            objModel.fieldName = "OPM_ID";
            context.setModel(query, objModel, colName, "OPM_ID", page, pageSize);
        }