private void UpdateInfo2(TeeTimeItem TT) { string sSQL; int i2; if (m.IsEmpty(TT.Owner)) { SetResultCode(c.BATCH_RESULT_FAIL, "Owner cannot be blank."); return; } if (m.IsEmpty(TT.Location)) { SetResultCode(c.BATCH_RESULT_FAIL, "Location cannot be blank."); return; } if (m.IsEmpty(TT.GroupGUID)) { SetResultCode(c.BATCH_RESULT_FAIL, "Group cannot be blank."); return; } if (TT.TTTime == null) { SetResultCode(c.BATCH_RESULT_FAIL, "Time cannot be blank."); return; } if (TT.TTDate == null) { SetResultCode(c.BATCH_RESULT_FAIL, "Date cannot be blank."); return; } if (m.BeforeToday(m.NoNullDate(TT.TTDate))) { SetResultCode(c.BATCH_RESULT_FAIL, "Date cannot be before today."); return; } if (m.FormatDT(TT.TTTime, "HH:mm") == "00:00") { SetResultCode(c.BATCH_RESULT_FAIL, "Time cannot be blank."); return; } WriteToAuditLog2(TT); sSQL = "UPDATE [dbo].[W_TeeTimes] "; sSQL += " SET [GroupGUID] =" + m.InQuote(TT.GroupGUID); sSQL += ", [TeeTimeDate] =" + m.InQuoteT(m.NoNullDate(TT.TTDate)); sSQL += ", [TeeTimeTime] =" + m.InQuoteT(m.NoNullDate(TT.TTTime)); sSQL += ", [OwnerComment] =" + m.InQuote(TT.OwnerComment); sSQL += ", [LockPlayer1] =" + m.InQuoteN(TT.LockPlayer1); sSQL += ", [LockPlayer2] =" + m.InQuoteN(TT.LockPlayer2); sSQL += ", [LockPlayer3] =" + m.InQuoteN(TT.LockPlayer3); sSQL += ", [LockPlayer4] =" + m.InQuoteN(TT.LockPlayer4); sSQL += ", [TeeTimeOwner] =" + m.InQuote(TT.Owner); sSQL += ", [TeeTimeLocation] =" + m.InQuote(TT.Location); sSQL += ", [LockMessages] =" + m.InQuoteN(TT.LockMessages); sSQL += ", [HideMessages] =" + m.InQuoteN(TT.HideMessages); sSQL += " WHERE TeeTimeGUID = " + m.InQuote(TT.TTGUID); i2 = m.SQLExecuteCommand(sSQL, c.DB.WhosIn); SetResultCode(c.BATCH_RESULT_OK, ""); return; }