DELIMITER $$

DROP PROCEDURE IF EXISTS `prosidex`.`SP_tblOrder_INSERT` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_tblOrder_INSERT`(
    inOrderNumber   VARCHAR(45),
    inFK_CustomerID INT,
    inFK_PaymentTypeID  INT,
    inOrderDate     VARCHAR(15),
    inLCShipmentDate    VARCHAR(15),
    inLCExpiryDate  VARCHAR(15),
    inTurnover      DECIMAL(10,2),
    inCurrency      INT,
    inCurrencyRate  DECIMAL(3,2),
    inProfit        DECIMAL(10,2),
    inInstrDasbach  VARCHAR(15))
BEGIN
  INSERT INTO tblOrder (OrderNumber, FK_CustomerID, FK_PaymentTypeID, OrderDate, LCShipmentDate, LCExpiryDate, Turnover, Currency, CurrencyRate, Profit, InstrDasbach)
  VALUES(   inOrderNumber, inFK_CustomerID, inFK_PaymentTypeID, STR_TO_DATE(inOrderDate, '%d-%m-%Y'),
            STR_TO_DATE(inLCShipmentDate, '%d-%m-%Y'), STR_TO_DATE(inLCExpiryDate, '%d-%m-%Y'),
            inTurnover, inCurrency, inCurrencyRate, inProfit, STR_TO_DATE(inInstrDasbach, '%d-%m-%Y'));
END $$

DELIMITER ;