public IActionResult CreateShipmentLine(ShipmentLineInsert shipmentline) { try { return(new JsonResult(ShipmentBAL.CreateShipmentLine(shipmentline))); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, "Failed to create Shipment Line")); } }
public ShipmentLine CreateShipmentLine(ShipmentLineInsert shipmentline) { using (SqlConnection connection = new SqlConnection(DefaultConnection)) { DynamicParameters p = new DynamicParameters(); p.Add("shipmentid", shipmentline.ShipmentID); p.Add("itemid", shipmentline.ItemID); p.Add("quantity", shipmentline.Quantity); p.Add("unitprice", shipmentline.UnitPrice); ShipmentLine result = connection.Query <ShipmentLine>("spCreateShipmentLine", p, commandType: CommandType.StoredProcedure).Single(); return(result); } }
public ShipmentLine CreateShipmentLine(ShipmentLineInsert shipmentline) { return(ShipmentDAL.CreateShipmentLine(shipmentline)); }