public static void UpdateQuantityInHdTable(HdModel hd)
{
using (IDbConnection connection = new MySqlConnection(ConnectionHelper.CnnVall("vas_productivity_database")))
{
connection.Execute("UpdateQuantityInHdTable", new { HdNumber = hd.HdNumber, Quantity = hd.Quantity }, commandType: CommandType.StoredProcedure);
}
}
public static void InsertIntoScannedByPackStation(HdModel hd)
{
using (IDbConnection connection = new MySqlConnection(ConnectionHelper.CnnVall("vas_productivity_database")))
{
connection.Execute("InsertIntoScannedByPackStation", new { HdNumber = hd.HdNumber, ScanTimestamp = hd.ScanTimestamp, PackStationID = hd.PackStationID },
commandType: CommandType.StoredProcedure);
}
}
//public static void UpdateQuantityInHdTable(string hdNumber, int quantity)
//{
// using (IDbConnection connection = new MySqlConnection(ConnectionHelper.CnnVall("vas_productivity_database")))
// {
// connection.Execute("UpdateQuantityInHdTable", new { HdNumber = hdNumber, Quantity = quantity },
// commandType: CommandType.StoredProcedure);
// }
//}
public static void InsertVasesForOrder(HdModel hd)
{
using (IDbConnection connection = new MySqlConnection(ConnectionHelper.CnnVall("vas_productivity_database")))
{
foreach (var vas in hd.Order.Vases)
{
connection.Execute("InsertVasesForOrder", new { OrderName = hd.Order.OrderName, Flag = vas.Flag, FlagValue = vas.FlagValue }, commandType: CommandType.StoredProcedure);
}
}
}
