public void updateOrder([FromBody] OrderMS orderMS)
{
SqlConnection con = new SqlConnection("Data Source=.; Initial Catalog=OrderManagement;User ID=sa;Password=123");
SqlCommand cmd = new SqlCommand("sp_name", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderID", orderMS.OrderID); ;
cmd.Parameters.AddWithValue("@BuyerName", orderMS.BuyerInfo.BuyerName);
cmd.Parameters.AddWithValue("@Mobile", orderMS.BuyerInfo.Mobile);
cmd.Parameters.AddWithValue("@product", orderMS.product);
cmd.Parameters.AddWithValue("@Street", orderMS.Address.Street);
cmd.Parameters.AddWithValue("@State", orderMS.Address.State);
cmd.Parameters.AddWithValue("@OrderStatus", orderMS.OrderStatus);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public OrderMS GetOrderData(int? id)
{
OrderMS order = new OrderMS();
SqlConnection con = new SqlConnection("Data Source=.; Initial Catalog=OrderManagement;User ID=sa;Password=123");
SqlCommand cmd = new SqlCommand("sp_name", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
order.OrderID = Convert.ToInt32(rdr["OrderID"]);
order.BuyerInfo.BuyerName = rdr["BuyerName"].ToString();
order.BuyerInfo.Mobile = rdr["Mobile"].ToString();
//order.product = ;
order.Address.Street = rdr["Street"].ToString();
order.Address.State = rdr["State"].ToString();
}
return order;
}
