private void AddGroup2(GroupItemDM groupItem)
{
string sAPIInput = "";
APIRunner oAPI = new APIRunner(m);
string[] aParamData = new string[10];
int iAPINumber = c.API04_ADD_GROUP;
aParamData[0] = JsonSerializer.Serialize <GroupItemDM>(groupItem);
sAPIInput = m.ArrayToString(aParamData);
oAPI.ActionCode = iAPINumber;
oAPI.InputParameters = sAPIInput;
oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
if (oAPI.ErrorOccured)
{
ErrorMessage = oAPI.APIErrorMessage;
SecretErrorDetails = oAPI.APIErrorSecretInfo;
return;
}
ds1 = oAPI.DatasetReturned;
if (m.GetFieldStr("ResultCode", ds1) == c.BATCH_RESULT_OK)
{
InfoMessage = "";
}
else
{
groupItem.ValidationFailMessage = m.GetFieldStr("ResultMsg", ds1);
}
}
private void UpdateGroup(GroupItemDM gItem)
{
string sSQL;
int i2;
if (m.IsEmpty(gItem.GroupName))
{
SetResultCode(c.BATCH_RESULT_FAIL, "Group Name cannot be blank.");
return;
}
if (m.IsEmpty(gItem.GroupDescription))
{
SetResultCode(c.BATCH_RESULT_FAIL, "Group Description cannot be blank.");
return;
}
sSQL = "UPDATE [dbo].[W_Groups] ";
sSQL = sSQL + " SET ";
sSQL = sSQL + " [GroupName] = " + m.InQuote(gItem.GroupName, 50);
sSQL = sSQL + " ,[GroupDescription] = " + m.InQuote(gItem.GroupDescription, 100);
sSQL = sSQL + " ,[GroupPin] = " + m.InQuote(gItem.GroupPin);
sSQL = sSQL + " ,[GroupPhone] = " + m.InQuote(gItem.GroupPhone);
sSQL = sSQL + " ,[GroupEmail] = " + m.InQuote(gItem.GroupEmail, 500);
sSQL = sSQL + " ,[GroupActive] = " + m.InQuoteN(gItem.GroupActive);
sSQL = sSQL + " ,[GroupIsDefault] = " + m.InQuoteN(gItem.GroupIsDefault);
sSQL = sSQL + " ,[GroupShowAllGroups] = " + m.InQuoteN(gItem.GroupShowAllGroups);
sSQL = sSQL + " ,[GroupColor] = " + m.InQuoteN(gItem.GroupColor);
sSQL = sSQL + " WHERE GroupGUID = " + m.InQuote(gItem.GroupGUID);
i2 = m.SQLExecuteCommand(sSQL, c.DB.WhosIn);
SetResultCode(c.BATCH_RESULT_OK, "TeeTime updated.");
return;
}
protected void OpenAddDialog()
{
GroupsVM VM = new GroupsVM(m);
gItem = new GroupItemDM();
dialogEditIsOpen = true;
ModalInAddMode = true;
}
protected void OpenDeleteDialog(string sGroupGuid)
{
GroupsVM VM = new GroupsVM(m);
dialogDeleteIsOpen = true;
gItem = new GroupItemDM();
gItem.GroupGUID = sGroupGuid;
VM.GetSingleGroup(gItem);
PutMessagesInView(VM.ErrorMessage, VM.InfoMessage, VM.SecretErrorDetails);
}
protected void OpenEditDialog(string sGroupGuid)
{
GroupsVM VM = new GroupsVM(m);
dialogEditIsOpen = true;
ModalInAddMode = false;
gItem = new GroupItemDM();
gItem.GroupGUID = sGroupGuid;
VM.GetSingleGroup(gItem);
PutMessagesInView(VM.ErrorMessage, VM.InfoMessage, VM.SecretErrorDetails);
}
public void GetSingleGroup(GroupItemDM groupItem)
{
try
{
GetSingleGroup2(groupItem);
}
catch (Exception e)
{
ErrorMessage = e.Message;
SecretErrorDetails = m.ShortenStack(e.StackTrace, true);
}
}
private List <GroupItemDM> GetGroups2(bool bAll)
{
List <GroupItemDM> GroupList = new List <GroupItemDM>();
GroupItemDM GroupItem;
string sAPIInput = "";
APIRunner oAPI = new APIRunner(m);
string[] aParamData = new string[10];
int iAPINumber = c.API04_GET_GROUPS;
if (bAll)
{
aParamData[0] = "1";
}
else
{
aParamData[0] = "0";
}
sAPIInput = m.ArrayToString(aParamData);
oAPI.ActionCode = iAPINumber;
oAPI.InputParameters = sAPIInput;
oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
if (oAPI.ErrorOccured)
{
ErrorMessage = oAPI.APIErrorMessage;
SecretErrorDetails = oAPI.APIErrorSecretInfo;
return(GroupList);
}
ds1 = oAPI.DatasetReturned;
foreach (DataRow r in ds1.Tables[0].Rows)
{
GroupItem = new GroupItemDM();
GroupItem.GroupGUID = m.GetFieldStr("GroupGUID", r);
GroupItem.GroupName = m.GetFieldStr("GroupName", r);
GroupItem.GroupDescription = m.GetFieldStr("GroupDescription", r);
GroupItem.GroupPin = m.GetFieldStr("GroupPin", r);
GroupItem.GroupPhone = m.GetFieldStr("GroupPhone", r);
GroupItem.GroupEmail = m.GetFieldStr("GroupEmail", r);
GroupItem.GroupActive = m.GetFieldBol("GroupActive", r);
GroupItem.GroupIsDefault = m.GetFieldBol("GroupIsDefault", r);
GroupItem.GroupShowAllGroups = m.GetFieldBol("GroupShowAllGroups", r);
GroupItem.GroupColor = m.GetFieldStr("GroupColor", r);
GroupList.Add(GroupItem);
}
return(GroupList);
}
private void AddGroup(GroupItemDM gItem)
{
string sSQL;
int i2;
if (m.IsEmpty(gItem.GroupName))
{
SetResultCode(c.BATCH_RESULT_FAIL, "Group Name cannot be blank.");
return;
}
if (m.IsEmpty(gItem.GroupDescription))
{
SetResultCode(c.BATCH_RESULT_FAIL, "Group Description cannot be blank.");
return;
}
sSQL = " INSERT INTO [dbo].[W_Groups] ";
sSQL = sSQL + " ([GroupGUID] ";
sSQL = sSQL + " ,[GroupName] ";
sSQL = sSQL + " ,[GroupDescription] ";
sSQL = sSQL + " ,[GroupPin] ";
sSQL = sSQL + " ,[GroupPhone] ";
sSQL = sSQL + " ,[GroupEmail] ";
sSQL = sSQL + " ,[GroupActive] ";
sSQL = sSQL + " ,[GroupIsDefault] ";
sSQL = sSQL + " ,[GroupShowAllGroups] ";
sSQL = sSQL + " ,[GroupColor]) ";
sSQL = sSQL + " VALUES (";
sSQL = sSQL + m.InQuote(m.CreateGuid()) + ", ";
sSQL = sSQL + m.InQuote(gItem.GroupName, 50) + ", ";
sSQL = sSQL + m.InQuote(gItem.GroupDescription, 100) + ", ";
sSQL = sSQL + m.InQuote(gItem.GroupPin) + ", ";
sSQL = sSQL + m.InQuote(gItem.GroupPhone) + ", ";
sSQL = sSQL + m.InQuote(gItem.GroupEmail, 500) + ", ";
sSQL = sSQL + m.InQuoteN(gItem.GroupActive) + ", ";
sSQL = sSQL + m.InQuoteN(gItem.GroupIsDefault) + ", ";
sSQL = sSQL + m.InQuoteN(gItem.GroupShowAllGroups) + ", ";
sSQL = sSQL + m.InQuote(gItem.GroupColor, 100);
sSQL = sSQL + " )";
i2 = m.SQLExecuteCommand(sSQL, c.DB.WhosIn);
SetResultCode(c.BATCH_RESULT_OK, "TeeTime added.");
return;
}
private void GetSingleGroup2(GroupItemDM groupItem)
{
string sAPIInput = "";
APIRunner oAPI = new APIRunner(m);
string[] aParamData = new string[10];
int iAPINumber = c.API04_GET_SINGLE_GROUP;
aParamData[0] = groupItem.GroupGUID;
sAPIInput = m.ArrayToString(aParamData);
oAPI.ActionCode = iAPINumber;
oAPI.InputParameters = sAPIInput;
oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
if (oAPI.ErrorOccured)
{
ErrorMessage = oAPI.APIErrorMessage;
SecretErrorDetails = oAPI.APIErrorSecretInfo;
return;
}
ds1 = oAPI.DatasetReturned;
if (m.EmptyTable(ds1))
{
ErrorMessage = "Error. Group not found. (" + groupItem.GroupGUID + ")";
return;
}
groupItem.GroupGUID = m.GetFieldStr("GroupGUID", ds1);
groupItem.GroupName = m.GetFieldStr("GroupName", ds1);
groupItem.GroupDescription = m.GetFieldStr("GroupDescription", ds1);
groupItem.GroupPin = m.GetFieldStr("GroupPin", ds1);
groupItem.GroupPhone = m.GetFieldStr("GroupPhone", ds1);
groupItem.GroupEmail = m.GetFieldStr("GroupEmail", ds1);
groupItem.GroupActive = m.GetFieldBol("GroupActive", ds1);
groupItem.GroupIsDefault = m.GetFieldBol("GroupIsDefault", ds1);
groupItem.GroupShowAllGroups = m.GetFieldBol("GroupShowAllGroups", ds1);
groupItem.GroupColor = m.GetFieldStr("GroupColor", ds1);
}