/// <summary>
        /// GetRequisitionDetailsByID is providing List of RequisitionDetails ByID
        /// </summary>
        /// <returns></returns>
        ///
        public tPartReqDetail GetRequisitionDetailsByPRD_ID(long RecID, string[] conn)
        {
            BISPL_CRMDBEntities ce         = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));;
            tPartReqDetail      ReqDetails = new tPartReqDetail();

            ReqDetails = ce.tPartReqDetails.Where(p => p.PRM_ID == RecID).First();
            ce.Detach(ReqDetails);
            return(ReqDetails);
        }
        public long UpdateReqDetails(tPartReqDetail objReqDetails, string[] conn)
        {
            BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));

            ce.tPartReqDetails.Attach(objReqDetails);
            ce.ObjectStateManager.ChangeObjectState(objReqDetails, EntityState.Modified);
            ce.SaveChanges();

            return(1);
        }