C# (CSharp) Khabardaan.Code.DAL DBToolsDataContext Examples

Example #1

File: BaseBOLGarbageWords.cs Project: bidaad/KhabardaanWebsite

    int IBaseBOL.GetCount(SearchFilterCollection sFilterCols)
    {
        int    RecordCount = 1;
        string WhereCond   = Tools.GetCondition(sFilterCols).Replace("''", "'");
        var    ResultQuery = new Khabardaan.Code.DAL.DBToolsDataContext().spGetCount(TableOrViewName, WhereCond);

        RecordCount = (int)ResultQuery.ReturnValue;
        return(RecordCount);
    }

Example #2

File: BaseBOLNewsNewsFlows.cs Project: bidaad/KhabardaanWebsite

    public int GetCount(SearchFilterCollection sFilterCols)
    {
        string             WhereCond;
        int                RecordCount = 1;
        DBToolsDataContext dcTools     = new DBToolsDataContext();

        WhereCond = Tools.GetCondition(sFilterCols);
        if (WhereCond == "")
        {
            WhereCond = " NewsCode = " + MasterCode;
        }
        else
        {
            WhereCond = " NewsCode = " + MasterCode + " and " + WhereCond;
        }

        WhereCond = WhereCond.Replace("''", "'");
        var ResultQuery = dcTools.spGetCount(TableOrViewName, WhereCond);

        RecordCount = (int)ResultQuery.ReturnValue;
        return(RecordCount);
    }