public void addOrderDetails(DTO.OrderDetails dto, int maphieu) { try { SqlConnection cn = DBConnection.connectDB(); SqlCommand cmd = new SqlCommand("sp_AddOrderDetails", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@maphieu", SqlDbType.Int); cmd.Parameters.Add("@manl", SqlDbType.Int); cmd.Parameters.Add("@soluongdat", SqlDbType.Decimal); cmd.Parameters["@maphieu"].Value = maphieu; cmd.Parameters["@manl"].Value = dto.Manl; cmd.Parameters["@soluongdat"].Value = dto.Soluongdat; cmd.ExecuteNonQuery(); cn.Close(); } catch (Exception e) { throw e; } }
public void addOrderDetails(DTO.OrderDetails dto, int maphieu) { DAO.OrderDetails dao = new DAO.OrderDetails(); dao.addOrderDetails(dto, maphieu); }