public static Boolean CheckSaMIProfileByUser(int UserID, int SaMIProfileID)
 {
     Boolean blnExists = false;
     DataView dv = new SaMIProfileDAO().Select("SaMIProfileID", "", "CreatedBy = " + UserID + " AND SaMIProfileID = " + SaMIProfileID);
     if (dv.Count > 0)
     {
         blnExists = true;
     }
     return blnExists;
 }
        public static List<List<String>> GetCountRecord(String ethnicityName, String Gender, String date, int DistrictID)
        {
            List<String> lstRegion = new List<String>();
            String Region = "", countRecord = "";
            List<String> lstRecord = new List<String>();
            List<String> lstCountRecord = new List<String>();
            List<List<String>> lstCombined = new List<List<string>>();
            DataView dv = new SaMIProfileDAO().SelectValidRegions(ethnicityName);
            if (dv.Count > 0)
            {
                String validRegions = dv.Table.Rows[0]["validRegions"].ToString();
                int len = dv.Table.Rows[0]["validRegions"].ToString().Length;
                if (len > 0)
                {
                    for (int i = 0; i < len; i++)
                    {
                        lstRegion.Add(validRegions.Substring(i, 1));
                    }
                    foreach (String region in lstRegion)
                    {
                        if (region != ",")
                        {
                            DataView dvRecords = new SaMIProfileDAO().SelectRecords(ethnicityName, region, Gender, date, DistrictID);
                            if (dvRecords.Count > 0)
                            {
                                Region = dvRecords.Table.Rows[0]["Region"].ToString();
                                countRecord = dvRecords.Table.Rows[0]["countRecord"].ToString();

                                lstRecord.Add(Region);
                                lstCountRecord.Add(countRecord);

                            }
                        }
                    }
                }
                else
                {
                    DataView dvRecordsforOther = new SaMIProfileDAO().SelectRecords(ethnicityName, "", Gender, date, DistrictID);
                    if (dvRecordsforOther.Count > 0)
                    {
                        countRecord = dvRecordsforOther.Table.Rows[0]["countRecord"].ToString();

                        lstRecord.Add(Region);
                        lstCountRecord.Add(countRecord);

                    }
                }
            }
            lstCombined.Add(lstRecord);
            lstCombined.Add(lstCountRecord);
            return lstCombined;
        }
 public static Boolean CheckSaMIProfileByDistrict(int DistrictID, int SaMIProfileID)
 {
     Boolean blnExists = false;
     DataView dv = new SaMIProfileDAO().Select("SaMIProfileID", "", "DistrictID = " + DistrictID + " AND SaMIProfileID = " + SaMIProfileID);
     if (dv.Count > 0)
     {
         blnExists = true;
     }
     return blnExists;
 }