/// <summary>
/// Method create the sql string with the List of ordrelines
/// </summary>
/// <param name="lines">Input list of orderlines</param>
/// <returns>Output a string of a sql string</returns>
private string CreateOrderLines(List <OrdreLine> lines)
{
OrdreLine ordreLines = new OrdreLine();
string hugeSql = "INSERT INTO OrderLines (ordersID, voulume, salesPrice, waresID, volumeTypeID) VALUES ('";
string secondLine = "('";
string endOfLIne = "'),";
string middelLine = "', '";
string dasSql = "";
for (int i = 0; i < lines.Count; i++)
{
if (i == 0)
{
dasSql += hugeSql + lines[i].Ordreid + middelLine + lines[i].Volume + middelLine + lines[i].salesPrice + middelLine + lines[i].Waresid + middelLine + lines[i].volumeTypeid + endOfLIne;
}
else
{
dasSql += secondLine + lines[i].Ordreid + middelLine + lines[i].Volume + middelLine + lines[i].salesPrice + middelLine + lines[i].Waresid + middelLine + lines[i].volumeTypeid + endOfLIne;
}
}
// Replace the last , with a ;
dasSql = dasSql.Remove(dasSql.Length - 1, 1) + ";";
return(dasSql);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="line"></param>
/// <returns></returns>
public bool UpdateOrdreLine(int id, OrdreLine line)
{
bool updated = false;
return(updated);
}
