public List <RecieverPeople> GetallRecieverPeople() { string query = "SELECT RecieverId,RecieverName,RecieverArea,RecieverPhoneNo from RecieverPeopleTable "; List <RecieverPeople> asamList = new List <RecieverPeople>(); DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query); while (sdr.Read()) { RecieverPeople ba = new RecieverPeople(); ba.RecieverId = sdr["RecieverId"].ToString(); ba.RecieverName = sdr["RecieverName"].ToString(); ba.RecieverArea = sdr["RecieverArea"].ToString(); ba.RecieverPhoneNo = sdr["RecieverPhoneNo"].ToString(); asamList.Add(ba); } return(asamList); }
public List <RecieverPeople> searchRecieverPeople(string text) { string query13 = "SELECT RecieverId,RecieverName,RecieverArea,RecieverPhoneNo from RecieverPeopleTable WHERE RecieverId LIKE '%" + text + "%' OR RecieverName LIKE '%" + text + "%' OR RecieverArea LIKE '%" + text + "%' OR RecieverPhoneNo LIKE '%" + text + "%' "; List <RecieverPeople> modifiedNewList = new List <RecieverPeople>(); DatabaseConnectionClass dcc = new DatabaseConnectionClass(); dcc.ConnectWithDB(); SqlDataReader sdr = dcc.GetData(query13); while (sdr.Read()) { RecieverPeople obj = new RecieverPeople(); obj.RecieverId = sdr["RecieverId"].ToString(); obj.RecieverName = sdr["RecieverName"].ToString(); obj.RecieverArea = sdr["RecieverArea"].ToString(); obj.RecieverPhoneNo = sdr["RecieverPhoneNo"].ToString(); modifiedNewList.Add(obj); } return(modifiedNewList); }