HYTOS

        public int ExistsDocument(string projectGroupID, List<string> newDwgNos)

        {

            var dynamicParameters = new DynamicParameters();

            StringBuilder sbWhere = new StringBuilder();

            var parameters = new Dictionary<string, object>();

            if (!string.IsNullOrEmpty(projectGroupID))

            {

                sbWhere.Append(" and doc.RefProjectCode in (select Code from dbo.Projects where ParentID=@RefGroupID) ");

                parameters.Add("RefGroupID", projectGroupID);

            }

            if (newDwgNos.Count > 0)

            {

                string dwgNoList = string.Join("','", newDwgNos.Where(x => !string.IsNullOrEmpty(x)).Select(x => x).ToList());

                if (dwgNoList.Length > 0)

                {

                    if (!string.IsNullOrEmpty(projectGroupID))

                    {

                        sbWhere.Append($@" and doc.DocumentNo in ('{dwgNoList}') ");

                    }

                }

            }

            try

            {

                string query = $@"

select   count(*) cnt

from     dbo.Documents doc

where    doc.IsDeleted=0 {sbWhere}";

                if (parameters.Count > 0)

                {

                    dynamicParameters.AddDynamicParams(parameters);

                }

                return ExecuteScalar<int>(query, dynamicParameters);

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }