Exemplos de OpacEntities.FPT_SP_GET_LANGUAGE_CODE_ITEM em C# (CSharp)

Exemplo n.º 1

        /// <summary>
        /// Get number day for extend date
        /// </summary>
        /// <param name="itemID"></param>
        /// <param name="copyNumber"></param>
        /// <returns></returns>
        public static int GetRenewalPeriod(int itemID, string copyNumber)
        {
            using (var dbContext = new OpacEntities())
            {
                //Renew day for Textbooks are 1 week, Reference books with "Eng" language is 2 weeks, "Vie" is 1 week
                var renewalPeriod = 7;
                var bookType      = dbContext.HOLDINGs.Where(t => t.ItemID == itemID).Select(t => t.CopyNumber).FirstOrDefault();

                if (bookType != null)
                {
                    bookType = bookType.Substring(0, 2);

                    if (bookType.ToLower().Contains("tk"))
                    {
                        var book = dbContext.FPT_SP_GET_LANGUAGE_CODE_ITEM(itemID).FirstOrDefault();

                        if (book != null && !book.ToLower().Trim().Contains("vie"))
                        {
                            renewalPeriod = 14;
                        }
                    }
                }

                return(renewalPeriod);
            }
        }