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