public OrderMaster Search()
{
// string q = "Select * from Delivery";
SqlCommand cmd = new SqlCommand("SP_OrderMasterSearch", connection.GetConnection());
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderId", OrderId);
SqlDataReader sdr = cmd.ExecuteReader();
OrderMaster Om = new OrderMaster();
while (sdr.Read())
{
Om.OrderId = (int)sdr["OrderId"];
Om.CltId = (int)sdr["CltId"];
Om.Size = (int)sdr["Size"];
Om.Quantity = (int)sdr["Quantity"];
Om.Price = (int)sdr["Price"];
Om.OrderDate = (int)sdr["OrderDate"];
Om.RequiredDate = (int)sdr["RequiredDate"];
Om.PrinterId = (int)sdr["PrinterId"];
}
sdr.Close();
return(Om);
}
public List <OrderMaster> ShowAll()
{
// string q = "Select * from Delivery";
SqlCommand cmd = new SqlCommand("OrderMAsterShowAll", connection.GetConnection());
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sdr = cmd.ExecuteReader();
List <OrderMaster> lst = new List <OrderMaster>();
while (sdr.Read())
{
OrderMaster Om = new OrderMaster();
Om.OrderId = (int)sdr["OrderId"];
Om.CltId = (int)sdr["CltId"];
Om.Size = (int)sdr["Size"];
Om.Quantity = (int)sdr["Quantity"];
Om.Price = (int)sdr["Price"];
Om.OrderDate = (int)sdr["OrderDate"];
Om.RequiredDate = (int)sdr["RequiredDate"];
Om.PrinterId = (int)sdr["PrinterId"];
lst.Add(Om);
}
sdr.Close();
return(lst);
}
