public string[] UpdateColumn_DesignedReportsSelectColumnPage(string state, string SelectedColumnID, string Title, string Active, string ReportID, string ConceptID, string Order, string ColumnType, string TrafficColumnsCount, string KeyColumn) { this.InitializeCulture(); string[] retMessage = new string[4]; try { decimal ColumnID = 0; decimal selectedColumnID = decimal.Parse(this.StringBuilder.CreateString(SelectedColumnID), CultureInfo.InvariantCulture); string title = this.StringBuilder.CreateString(Title); bool active = Convert.ToBoolean(this.StringBuilder.CreateString(Active) == "" ? "false" : this.StringBuilder.CreateString(Active)); decimal reportID = decimal.Parse(this.StringBuilder.CreateString(ReportID), CultureInfo.InvariantCulture); decimal fieldId = decimal.Parse(this.StringBuilder.CreateString(ConceptID), CultureInfo.InvariantCulture); Int16 order = Int16.Parse(this.StringBuilder.CreateString(Order)); int trafficColumnsCount = int.Parse(this.StringBuilder.CreateString(TrafficColumnsCount), CultureInfo.InvariantCulture); bool isConcept = false; UIActionType uam = (UIActionType)Enum.Parse(typeof(UIActionType), this.StringBuilder.CreateString(state).ToUpper()); DesignedReportTrafficKeyColumn keyColumn = DesignedReportTrafficKeyColumn.AllTraffic; GTS.Clock.Model.Report.DesignedReportColumn columnObj = new GTS.Clock.Model.Report.DesignedReportColumn(); columnObj.ID = selectedColumnID; GTS.Clock.Model.Report.Report reportObj = new GTS.Clock.Model.Report.Report(); reportObj.ID = reportID; columnObj.Report = reportObj; if (uam != UIActionType.DELETE) { DesignedReportColumnType columnType = DesignedReportColumnType.None; if (ColumnType != string.Empty) { columnType = (DesignedReportColumnType)Enum.Parse(typeof(DesignedReportColumnType), this.StringBuilder.CreateString(ColumnType)); } if (columnType == DesignedReportColumnType.Traffic) { keyColumn = (DesignedReportTrafficKeyColumn)Enum.Parse(typeof(DesignedReportTrafficKeyColumn), this.StringBuilder.CreateString(KeyColumn)); } GTS.Clock.Model.Concepts.SecondaryConcept conceptObj = null; DesignedReportPersonInfoColumn personInfoObj = null; DesignedReportTrafficColumn trafficObj = null; PersonParamField personParamFieldObj = null; switch (columnType) { case DesignedReportColumnType.Concept: conceptObj = new SecondaryConcept(); conceptObj.ID = fieldId; columnObj.ColumnType = DesignedReportColumnType.Concept; isConcept = true; break; case DesignedReportColumnType.Traffic: trafficObj = new DesignedReportTrafficColumn(); trafficObj.ID = fieldId; trafficObj.Key = keyColumn; columnObj.ColumnType = DesignedReportColumnType.Traffic; break; case DesignedReportColumnType.PersonInfo: personInfoObj = new DesignedReportPersonInfoColumn(); personInfoObj.ID = fieldId; columnObj.ColumnType = DesignedReportColumnType.PersonInfo; break; case DesignedReportColumnType.PersonParam: personParamFieldObj = new PersonParamField(); personParamFieldObj.ID = fieldId; columnObj.ColumnType = DesignedReportColumnType.PersonParam; break; default: break; } columnObj.Title = title; columnObj.Active = active; columnObj.Concept = conceptObj; columnObj.PersonInfo = personInfoObj; columnObj.Traffic = trafficObj; columnObj.PersonParam = personParamFieldObj; columnObj.Order = order; columnObj.IsConcept = isConcept; columnObj.TrafficColumnCount = trafficColumnsCount; if (uam != UIActionType.EDIT) { IList <GTS.Clock.Model.Report.DesignedReportColumn> designedReportColumnList = DesignedReportsColumnBusiness.GetDesignedReportsColumnsByReportID(reportID); Int16 lastOrder = 0; if (designedReportColumnList.Count > 0) { lastOrder = designedReportColumnList.OrderByDescending(o => o.Order).FirstOrDefault().Order; } columnObj.Order = (Int16)(lastOrder + 1); } } switch (uam) { case UIActionType.ADD: ColumnID = this.DesignedReportsColumnBusiness.InsertColumn(columnObj); break; case UIActionType.EDIT: if (selectedColumnID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, new Exception(GetLocalResourceObject("NoColumnSelectedforEdit").ToString()), retMessage); return(retMessage); } ColumnID = this.DesignedReportsColumnBusiness.UpdateColumn(columnObj); break; case UIActionType.DELETE: if (selectedColumnID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, new Exception(GetLocalResourceObject("NoColumnSelectedforEdit").ToString()), retMessage); return(retMessage); } ColumnID = this.DesignedReportsColumnBusiness.DeleteColumn(columnObj); break; } retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString(); string SuccessMessageBody = string.Empty; switch (uam) { case UIActionType.ADD: SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString(); break; case UIActionType.EDIT: SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString(); break; case UIActionType.DELETE: SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString(); break; default: break; } retMessage[1] = SuccessMessageBody; retMessage[2] = "success"; retMessage[3] = ColumnID.ToString(); return(retMessage); } catch (UIValidationExceptions ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage); return(retMessage); } catch (UIBaseException ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage); return(retMessage); } catch (Exception ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage); return(retMessage); } }
public string[] UpdateGroupColumn_ReportParametersConditionsPage(string state, string GroupColumnID, string ReportID, string DesignedColumnID, string GroupingNewPage) { this.InitializeCulture(); string[] retMessage = new string[4]; try { decimal groupColumnID = 0; decimal seletedGroupColumnID = decimal.Parse(this.StringBuilder.CreateString(GroupColumnID), CultureInfo.InvariantCulture); decimal designedColumnID = decimal.Parse(this.StringBuilder.CreateString(DesignedColumnID), CultureInfo.InvariantCulture); decimal reportID = decimal.Parse(this.StringBuilder.CreateString(ReportID), CultureInfo.InvariantCulture); bool groupingNewPage = bool.Parse(StringBuilder.CreateString(GroupingNewPage)); UIActionType uam = (UIActionType)Enum.Parse(typeof(UIActionType), this.StringBuilder.CreateString(state).ToUpper()); GTS.Clock.Model.Report.DesignedReportGroupColumn groupColumnObj = new GTS.Clock.Model.Report.DesignedReportGroupColumn(); groupColumnObj.ID = seletedGroupColumnID; if (uam != UIActionType.DELETE) { GTS.Clock.Model.Report.Report reportObj = new GTS.Clock.Model.Report.Report(); reportObj.ID = reportID; decimal personId = BUser.CurrentUser.Person.ID; GTS.Clock.Model.Person personObj = new GTS.Clock.Model.Person(); personObj.ID = personId; GTS.Clock.Model.Report.DesignedReportColumn designedColumnObj = new DesignedReportColumn(); designedColumnObj.ID = designedColumnID; groupColumnObj.Person = personObj; groupColumnObj.Report = reportObj; groupColumnObj.Column = designedColumnObj; groupColumnObj.IsGroupingNewPage = groupingNewPage; if (uam != UIActionType.EDIT) { IList <GTS.Clock.Model.Report.DesignedReportGroupColumn> designedReportGroupColumnList = GroupColumnBusiness.GetDesignedReportGroupColumns(reportID, personId); Int16 lastOrder = 0; if (designedReportGroupColumnList.Count > 0) { lastOrder = designedReportGroupColumnList.OrderByDescending(o => o.Order).FirstOrDefault().Order; } groupColumnObj.Order = (Int16)(lastOrder + 1); } } switch (uam) { case UIActionType.ADD: groupColumnID = this.GroupColumnBusiness.InsertGroupColumn(groupColumnObj); break; case UIActionType.DELETE: if (seletedGroupColumnID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, new Exception(GetLocalResourceObject("NoColumnSelectedforEdit").ToString()), retMessage); return(retMessage); } groupColumnID = this.GroupColumnBusiness.DeleteGroupColumn(groupColumnObj); break; } retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString(); string SuccessMessageBody = string.Empty; switch (uam) { case UIActionType.ADD: SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString(); break; case UIActionType.EDIT: SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString(); break; case UIActionType.DELETE: SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString(); break; default: break; } retMessage[1] = SuccessMessageBody; retMessage[2] = "success"; retMessage[3] = groupColumnID.ToString(); return(retMessage); } catch (UIValidationExceptions ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage); return(retMessage); } catch (UIBaseException ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage); return(retMessage); } catch (Exception ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage); return(retMessage); } }
public string[] UpdateReport_DesignedReportsPage(string state, string SelectedReportID, string ReportName, string ReportDescription, string DesignedTypeID, string ParentReportID, string DateParameterTypeID, string ParentPath) { this.InitializeCulture(); string[] retMessage = new string[4]; try { decimal ReportID = 0; decimal selectedReportID = decimal.Parse(this.StringBuilder.CreateString(SelectedReportID), CultureInfo.InvariantCulture); string reportName = this.StringBuilder.CreateString(ReportName); string reportDescription = this.StringBuilder.CreateString(ReportDescription); decimal designedTypeID = decimal.Parse(this.StringBuilder.CreateString(DesignedTypeID), CultureInfo.InvariantCulture); decimal parentReportID = decimal.Parse(this.StringBuilder.CreateString(ParentReportID), CultureInfo.InvariantCulture); string parentPath = this.StringBuilder.CreateString(ParentPath); UIActionType uam = (UIActionType)Enum.Parse(typeof(UIActionType), this.StringBuilder.CreateString(state).ToUpper()); GTS.Clock.Model.Report.Report report = new GTS.Clock.Model.Report.Report(); report.ID = selectedReportID; ReportParameterDesigned reportParameterDesignedObj = null; if (uam != UIActionType.DELETE) { GTS.Clock.Model.Report.DesignedReportType designedType = new BDesignedReportsColumn().GetAllDesignedReportsTypes().SingleOrDefault(d => d.ID == designedTypeID); report.Name = reportName; report.Description = reportDescription; report.DesignedType = designedType; report.ParentId = parentReportID; report.IsReport = true; report.IsDesignedReport = true; report.ParentPath = parentPath; decimal dateParamID = decimal.Parse(this.StringBuilder.CreateString(DateParameterTypeID), CultureInfo.InvariantCulture); if (designedType != null && designedType.CustomCode == DesignedReportTypeEnum.Person) { reportParameterDesignedObj = ReportParameterBusiness.GetAllReportParameterDesigned().SingleOrDefault(p => p.CustomCode == "None"); } else { reportParameterDesignedObj = ReportParameterBusiness.GetAllReportParameterDesigned().SingleOrDefault(p => p.ID == dateParamID); } report.ReportParameterDesigned = reportParameterDesignedObj; } BReportParameter reportParameterBusiness = new BReportParameter(); switch (uam) { case UIActionType.ADD: ReportID = this.ReportBusiness.InsertReport(report, uam); if (reportParameterDesignedObj != null) { foreach (ReportParameterDesignedParam item in reportParameterDesignedObj.ReportParameterDesignedParam) { GTS.Clock.Model.Report.ReportParameter reportParameterObj = new GTS.Clock.Model.Report.ReportParameter(); reportParameterObj.ID = 0; reportParameterObj.Report = new GTS.Clock.Model.Report.Report() { ID = ReportID }; reportParameterObj.Name = item.Parameter; reportParameterObj.ReportUIParameter = reportParameterDesignedObj.ReportUIParameter; decimal param1Id = reportParameterBusiness.InsertReportParameter(reportParameterObj); } } break; case UIActionType.EDIT: if (selectedReportID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoReportSelectedforEdit").ToString()), retMessage); return(retMessage); } ReportID = this.ReportBusiness.UpdateReport(report, uam); ReportParameterBusiness.DeleteReportParameterByReportID(ReportID); foreach (ReportParameterDesignedParam item in reportParameterDesignedObj.ReportParameterDesignedParam) { GTS.Clock.Model.Report.ReportParameter reportParameterObj = new GTS.Clock.Model.Report.ReportParameter(); reportParameterObj.ID = 0; reportParameterObj.Report = new GTS.Clock.Model.Report.Report() { ID = ReportID }; reportParameterObj.Name = item.Parameter; reportParameterObj.ReportUIParameter = reportParameterDesignedObj.ReportUIParameter; decimal param1Id = reportParameterBusiness.InsertReportParameter(reportParameterObj); } break; case UIActionType.DELETE: if (selectedReportID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoReportSelectedforEdit").ToString()), retMessage); return(retMessage); } this.ReportBusiness.CheckDeleteAccess(); ReportID = this.ReportBusiness.DeleteReport(selectedReportID); break; } retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString(); string SuccessMessageBody = string.Empty; switch (uam) { case UIActionType.ADD: SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString(); break; case UIActionType.EDIT: SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString(); break; case UIActionType.DELETE: SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString(); break; default: break; } retMessage[1] = SuccessMessageBody; retMessage[2] = "success"; retMessage[3] = ReportID.ToString(); return(retMessage); } catch (UIValidationExceptions ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage); return(retMessage); } catch (UIBaseException ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage); return(retMessage); } catch (Exception ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage); return(retMessage); } }
public string[] UpdateConditions_ReportParametersConditionsPage(string ConditionID, string ReportID, string ConditionText, string ConditionValue, string OrderText, string OrderValue, string TrafficConditionValue) { this.InitializeCulture(); string[] retMessage = new string[4]; try { decimal conditionID = decimal.Parse(this.StringBuilder.CreateString(ConditionID), CultureInfo.InvariantCulture); decimal reportID = decimal.Parse(this.StringBuilder.CreateString(ReportID), CultureInfo.InvariantCulture); string conditionText = ""; if (ConditionText != null) { conditionText = this.StringBuilder.CreateString(ConditionText, StringGeneratorExceptionType.ReportCondition); } string conditionValue = ""; if (ConditionValue != null) { conditionValue = this.StringBuilder.CreateString(ConditionValue, StringGeneratorExceptionType.ReportCondition); } string trafficConditionValue = ""; if (trafficConditionValue != null) { trafficConditionValue = this.StringBuilder.CreateString(TrafficConditionValue, StringGeneratorExceptionType.ReportCondition); } string orderText = ""; if (OrderText != null) { orderText = this.StringBuilder.CreateString(OrderText, StringGeneratorExceptionType.ReportCondition); } string orderValue = ""; if (OrderValue != null) { orderValue = this.StringBuilder.CreateString(OrderValue, StringGeneratorExceptionType.ReportCondition); } GTS.Clock.Model.Security.User currentUser = BUser.CurrentUser; GTS.Clock.Model.Report.DesignedReportCondition conditionObj = new GTS.Clock.Model.Report.DesignedReportCondition(); conditionObj.ID = conditionID; GTS.Clock.Model.Report.Report reportObj = new GTS.Clock.Model.Report.Report(); GTS.Clock.Model.Person personObj = new GTS.Clock.Model.Person() { ID = currentUser.Person.ID }; reportObj.ID = reportID; conditionObj.ConditionText = conditionText; conditionObj.ConditionValue = conditionValue; conditionObj.TrafficConditionValue = trafficConditionValue; conditionObj.Report = reportObj; conditionObj.Person = personObj;; conditionObj.OrderText = orderText; conditionObj.OrderValue = orderValue; UIActionType uam; if (conditionID == 0) { conditionID = ConditionBusiness.InsertCondition(conditionObj); uam = UIActionType.ADD; } else { conditionID = ConditionBusiness.UpdateCondition(conditionObj); uam = UIActionType.EDIT; } retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString(); string SuccessMessageBody = string.Empty; switch (uam) { case UIActionType.ADD: SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString(); break; case UIActionType.EDIT: SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString(); break; case UIActionType.DELETE: SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString(); break; default: break; } retMessage[1] = SuccessMessageBody; retMessage[2] = "success"; retMessage[3] = conditionID.ToString(); return(retMessage); } catch (UIValidationExceptions ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage); return(retMessage); } catch (UIBaseException ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage); return(retMessage); } catch (Exception ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage); return(retMessage); } }