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