public DeliveryBoyReg Search()
{
// string q = "Select * from DBoyDetail";
SqlCommand cmd = new SqlCommand("SP_DBoySearch", connection.GetConnection());
cmd.Parameters.AddWithValue("@DBoyID", DBoyID);
SqlDataReader sdr = cmd.ExecuteReader();
DeliveryBoyReg db = new DeliveryBoyReg();
while (sdr.Read())
{
db.DBoyID = (int)sdr[0];
db.DBoyName = (string)sdr[1];
db.DBCity = (string)sdr[2];
db.DBNic = (int)sdr[3];
db.DBCountry = (string)sdr[4];
db.DBAddress = (string)sdr[5];
}
sdr.Close();
return(db);
}
public List <DeliveryBoyReg> ShowAll()
{
//string q = "Select * from DBoyDetail";
SqlCommand cmd = new SqlCommand("SP_DBoyDetailShowAll", connection.GetConnection());
SqlDataReader sdr = cmd.ExecuteReader();
List <DeliveryBoyReg> lst = new List <DeliveryBoyReg>();
while (sdr.Read())
{
DeliveryBoyReg db = new DeliveryBoyReg();
db.DBoyID = (int)sdr[0];
db.DBoyName = (string)sdr[1];
db.DBCity = (string)sdr[2];
db.DBNic = (int)sdr[3];
db.DBCountry = (string)sdr[4];
db.DBAddress = (string)sdr[5];
lst.Add(db);
}
sdr.Close();
return(lst);
}
