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;
}
