public PrinterReg Search()
{
// string q = "Select * from PrinterReg";
SqlCommand cmd = new SqlCommand("SP_PrinterRegSearch", connection.GetConnection());
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PrinterID", PrinterID);
SqlDataReader sdr = cmd.ExecuteReader();
PrinterReg pr = new PrinterReg();
while (sdr.Read())
{
pr.PrinterID = (int)sdr["PrinterId"];
pr.OwnerName = (string)sdr["OwnerName"];
pr.Country = (string)sdr["Country"];
pr.Address = (string)sdr["Address"];
pr.City = (string)sdr["City"];
pr.Country = (string)sdr["Country"];
}
sdr.Close();
return(pr);
}
public List <PrinterReg> ShowAll()
{
// string q = "Select * from PrinterReg";
SqlCommand cmd = new SqlCommand("PrinterRegShowAll", connection.GetConnection());
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sdr = cmd.ExecuteReader();
List <PrinterReg> lst = new List <PrinterReg>();
while (sdr.Read())
{
PrinterReg pr = new PrinterReg();
pr.PrinterID = (int)sdr["PrinterId"];
pr.OwnerName = (string)sdr["OwnerName"];
pr.Country = (string)sdr["Country"];
pr.Address = (string)sdr["Address"];
pr.City = (string)sdr["City"];
pr.Country = (string)sdr["Country"];
lst.Add(pr);
}
sdr.Close();
return(lst);
}