public async Task <IActionResult> Create(InvoiceDetailsDTO InvoiceDetailsDTO)
{
var InvoiceDetails = _mapper.Map <InvoiceDetailsDTO, InvoiceDetails>(InvoiceDetailsDTO);
await _unitOfWork.Invoices.AddInvoiceDetails(InvoiceDetails);
return(CreatedAtAction(nameof(GetBy), new { id = InvoiceDetails.InvoiceDetailsId }, InvoiceDetails));
}
public List <InvoiceDetailsDTO> GetListInvoiceDetailByInvoiceID(int invoiceID)
{
List <InvoiceDetailsDTO> list = null;
string SQL = "SELECT ID, Car_ID, Invoice_ID, Unit_Price, Quantity FROM Invoice_Details WHERE Invoice_ID = @ID";
SqlConnection cnn = DBUtils.GetConnection();
SqlCommand cmd = new SqlCommand(SQL, cnn);
cmd.Parameters.AddWithValue("@ID", invoiceID);
try
{
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (rd.HasRows)
{
while (rd.Read())
{
if (list == null)
{
list = new List <InvoiceDetailsDTO>();
}
InvoiceDetailsDTO invoiceDetailsDTO = new InvoiceDetailsDTO
{
ID = rd.GetInt32(0),
Car_ID = rd.GetInt32(1),
Invoice_ID = rd.GetInt32(2),
Unit_Price = rd.GetDouble(3),
Quantity = rd.GetInt32(4)
};
list.Add(invoiceDetailsDTO);
}
}
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(list);
}
public async Task <IActionResult> Update(int id, InvoiceDetailsDTO InvoiceDetailsDTO)
{
if (InvoiceDetailsDTO.InvoiceDetailsId != id)
{
return(BadRequest());
}
try
{
var InvoiceDetails = _mapper.Map <InvoiceDetailsDTO, InvoiceDetails>(InvoiceDetailsDTO);
await _unitOfWork.Invoices.UpdateInvoiceDetails(InvoiceDetails);
}
catch (DbUpdateConcurrencyException)
{
if (!await InvoiceDetailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
