public void ADDDeliveryStatus(Deliverystats Deliverystats) { conn.Open(); string query = "INSERT INTO DeliveryStatus (OrderNO,Delivery_Status) VALUES('" + Deliverystats.OrderNo + "','" + Deliverystats.Delivery_Status + "')"; SqlCommand cmd = new SqlCommand(query, conn); int result = cmd.ExecuteNonQuery(); conn.Close(); }
public ArrayList GetAllstatus() { ArrayList DeliveryStatus = new ArrayList(); conn.Open(); string query = "SELECT * FROM DeliveryStatus"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Deliverystats d = new Deliverystats() { OrderNo = reader.GetString(reader.GetOrdinal("OrderNO")), Delivery_Status = reader.GetString(reader.GetOrdinal("Delivery_Status")), }; DeliveryStatus.Add(d); } conn.Close(); return(DeliveryStatus); }
public Deliverystats Getstatus(string Delivery_Status) { Deliverystats f = new Deliverystats(); return(f); }