public List <UtilityData> SelectByIds(string _idList) { List <UtilityData> list = new List <UtilityData>(); AddParameter("@p_IDList", _idList); using (MySqlDataReader reader = ExecuteReader("Util_SelByIds")) { while (reader.Read()) { UtilityData utl = new UtilityData(); utl.ID = reader.GetInt32(0); utl.NameID = reader.GetInt32(1); utl.Value = reader.GetString(2); list.Add(utl); } } return(list); }
private void SetFields(MySqlDataReader reader) { NIC = reader.GetString(0); SamaneraNumber = reader.GetString(1); PassportNumber = reader.GetString(2); PlaceOfBirth = reader.GetString(3); LayNameInFull = reader.GetString(4); DateOfBirth = reader.GetDateTime(5); NameOfFatherInFull = reader.GetString(6); DateOfRobing = reader.GetDateTime(7); NameAssumedAtRobing = reader.GetString(8); NameOfRobingTutor = reader.GetInt32(9); TempleRobing = reader.GetInt32(10); TempleOfResidence = reader.GetInt32(11); NameOfViharadhipathi = reader.GetInt32(12); IsUpasampanna = reader.GetBoolean(13); PlaceOfHigherOrdination = reader.GetInt32(14); DateOfHigherOrdination = reader.GetDateTime(15); NameOfUpadyaAtHigherOrdination = reader.GetInt32(16); IsUpadyaThero = reader.GetBoolean(17); Post = (BhikkuPost)reader.GetInt32(18); District = reader.GetInt32(19); DateOfCame = reader.GetDateTime(20); ImageData = reader.IsDBNull(21) ? null : reader.GetString(21); BloodGroup = reader.GetString(22); Dharmadeshanaa = reader.GetBoolean(23); Vandanaa = reader.GetBoolean(24); Sajjayana = reader.GetBoolean(25); Sinhala = reader.GetBoolean(26); Tamil = reader.GetBoolean(27); English = reader.GetBoolean(28); Hindhi = reader.GetBoolean(29); OtheLanguage = reader.GetString(30);; UpasampadaNumber = reader.GetString(31);; UpasampadaRegDate = reader.GetDateTime(32); KarmacharyaHimi1 = reader.GetInt32(33); KarmacharyaHimi2 = reader.GetInt32(34); KarmacharyaHimi3 = reader.GetInt32(35); MahaNayakaHimidetails = reader.GetInt32(36); AcharyaHimiDetails = reader.GetInt32(37); UpadyaTheroName = reader.GetInt32(38); Nikaya = reader.GetInt32(39); HomeTP = reader.GetString(40); HomeAddress = reader.GetString(41); UpasampadaMahaNayakaHimidetails = reader.GetInt32(42); UpasampadaAcharyaHimiDetails = reader.GetInt32(43); UpasampadaNikaya = reader.GetInt32(44); Country = reader.GetInt32(45); OrderNumber = reader.GetInt32(46); Number = reader.GetInt32(47); CurrentStatus = (CurrenStatus)reader.GetInt32(48); CurrentStatusComment = reader.GetString(49); HomeTP2 = reader.GetString(50); using (UtilityData ud = new UtilityData(true)) { OtherLanguages = ud.SelectByIds(OtheLanguage); } }