public static void SaveHeader(MySql.Data.MySqlClient.MySqlCommand cmd, StockCard sc) { cmd.CommandText = sc.GetInsertSQL(); cmd.ExecuteNonQuery(); cmd.CommandText = StockCard.SelectMaxIDSQL(); sc.ID = Convert.ToInt32(cmd.ExecuteScalar()); }
public static void Save(MySql.Data.MySqlClient.MySqlCommand cmd, StockCard sc) { cmd.CommandText = sc.GetInsertSQL(); cmd.ExecuteNonQuery(); cmd.CommandText = StockCard.SelectMaxIDSQL(); sc.ID = Convert.ToInt32(cmd.ExecuteScalar()); foreach (StockCardEntry sce in sc.STOCK_CARD_ENTRIES) { cmd.CommandText = sce.GetInsertSQL(); cmd.ExecuteNonQuery(); cmd.CommandText = StockCardEntry.SelectMaxIDSQL(); sce.ID = Convert.ToInt32(cmd.ExecuteScalar()); } }