Esempio n. 1
0
 public IActionResult CreateShipmentLine(ShipmentLineInsert shipmentline)
 {
     try
     {
         return(new JsonResult(ShipmentBAL.CreateShipmentLine(shipmentline)));
     }
     catch (Exception ex)
     {
         return(StatusCode(StatusCodes.Status500InternalServerError, "Failed to create Shipment Line"));
     }
 }
Esempio n. 2
0
        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);
            }
        }
Esempio n. 3
0
 public ShipmentLine CreateShipmentLine(ShipmentLineInsert shipmentline)
 {
     return(ShipmentDAL.CreateShipmentLine(shipmentline));
 }