public string InsertOrderdetails(orderdetails order)
{
MySqlConnection con = new MySqlConnection(constr);
MySqlCommand cmd = new MySqlCommand("Insert Into orderdetails(ProductId,Quantity,orderid) values (@ProductId,@Quantity,@orderid)", con);
MySqlDataAdapter sda = new MySqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@ProductId", order.ProductId);
cmd.Parameters.AddWithValue("@Quantity", "1");
cmd.Parameters.AddWithValue("@orderid", order.orderid);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i == 1)
{
return("success");
}
return("failed");
}
public List <orderdetails> getorderbyorderid(string oid)
{
List <orderdetails> detaillst = new List <orderdetails>();
MySqlConnection con = new MySqlConnection(constr);
MySqlCommand cmd = new MySqlCommand("Select * from orderdetails where orderid=@orderid", con);
cmd.Parameters.AddWithValue("@orderid", oid);
con.Open();
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
orderdetails details = new orderdetails();
//details.orderdetailid = Convert.ToInt64(dr.GetValue(0));
details.ProductId = dr.GetValue(1).ToString();
details.Quantity = dr.GetValue(2).ToString();
details.orderid = dr.GetValue(3).ToString();
detaillst.Add(details);
}
con.Close();
return(detaillst);
}