/// <summary>
        /// GetMaterialIssueDetailsByID is providing List of Material Issue Details ByID
        /// </summary>
        /// <returns></returns>
        ///
        public tMINDetail GetMaterialIssueDetailsByID(long RecID, string[] conn)
        {
            BISPL_CRMDBEntities ce           = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
            tMINDetail          IssueDetails = new tMINDetail();

            IssueDetails = ce.tMINDetails.Where(p => p.MIN_ID == RecID).FirstOrDefault();
            ce.Detach(IssueDetails);
            return(IssueDetails);
        }
        public long UpdateMaterialIssueDetail(tMINDetail objMaterialIssueDetails, string[] conn)
        {
            BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));

            ce.tMINDetails.Attach(objMaterialIssueDetails);
            ce.ObjectStateManager.ChangeObjectState(objMaterialIssueDetails, EntityState.Modified);
            ce.SaveChanges();

            return(1);
        }