private void showbtn_Click(object sender, EventArgs e) { using (BikkuInfo b = new BikkuInfo(true)) { CurrenStatus sts = sitiRadio.Checked ? CurrenStatus.Siti : otherPlaceRadio.Checked ? CurrenStatus.OtherPlace : upavidiRadio.Checked ? CurrenStatus.Upavidi : CurrenStatus.Apawath; AddData(b.SelectAllList(sts)); } this.reportViewer1.RefreshReport(); }
public List <BikkuInfo> SelectAllList(CurrenStatus currentStatus) { List <BikkuInfo> list = new List <BikkuInfo>(); AddParameter("@p_CurrentStatus", (int)currentStatus); using (MySqlDataReader reader = ExecuteReader("Bikku_SelAllDictionary")) { while (reader.Read()) { BikkuInfo bInfo = new BikkuInfo(); bInfo.NameAssumedAtRobing = reader.GetString(1); bInfo.ID = reader.GetInt32(0); bInfo.IsUpasampanna = reader.GetBoolean(2); bInfo.Post = (BhikkuPost)reader.GetInt32(3); bInfo.Number = reader.GetInt32(4); bInfo.SortListOrdeNumber = list.Count + 1; list.Add(bInfo); } } 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); } }