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);
}