public static List <Street> AllStreets() { string sqlStringRooms = "SELECT id, trim(NAME_STREET)||' '||trim(TYPE_STREET) as NAME_STREET FROM STREETS ORDER BY NAME_STREET"; DataTable dtp = FDBContext.Select(sqlStringRooms, Constants.connectionStringSites); List <Street> Streets = new List <Street>(); if (dtp.Rows.Count != 0) { foreach (DataRow dataRow in dtp.Rows) { Streets.Add(new Street { Id = (int)dataRow["ID"], NAME_STREET = dataRow["NAME_STREET"].ToString().Trim() }); } } return(Streets); }
//Проверка на дублирование паспортных данных public static int CheckPassport(string Passport) { string sqlStr = "SELECT FAM,IM,OT FROM VOTE WHERE PASSPORT='" + Passport + "'"; return(FDBContext.Select(sqlStr, Constants.connectionStringSites).Rows.Count); }