public IList <DesignedColumnProxy> GetAllDesignedReportsPersonInfoProxyColumns(decimal reportId) { try { IList <DesignedColumnProxy> designedColumnProxyList = new List <DesignedColumnProxy>(); IList <DesignedReportPersonInfoColumn> designedReportPersonInfoColumnList = repDesignedReportPersonInfoColumn.GetAll().ToList <DesignedReportPersonInfoColumn>(); IList <PersonReserveField> personReserveFieldList = new List <PersonReserveField>(); if (designedReportPersonInfoColumnList.Count(d => d != null && d.IsReserveField) > 0) { personReserveFieldList = new BPersonReservedField().GetAll(); } foreach (DesignedReportPersonInfoColumn item in designedReportPersonInfoColumnList) { DesignedColumnProxy columnProxy = new DesignedColumnProxy(); if (item.IsReserveField) { string itemKey = item.Key.ToString().Replace("prsTA_", ""); PersonReserveField personReserveFieldObj = personReserveFieldList.FirstOrDefault(r => r.OrginalName.ToLower().Trim() == itemKey.ToLower().Trim()); if (personReserveFieldObj != null) { columnProxy.Name = personReserveFieldObj.Lable; } else { switch (BLanguage.CurrentLocalLanguage) { case LanguagesName.Parsi: columnProxy.Name = item.FnName; break; case LanguagesName.English: columnProxy.Name = item.EnName; break; default: columnProxy.Name = item.FnName; break; } } } else { switch (BLanguage.CurrentLocalLanguage) { case LanguagesName.Parsi: columnProxy.Name = item.FnName; break; case LanguagesName.English: columnProxy.Name = item.EnName; break; default: columnProxy.Name = item.FnName; break; } } columnProxy.ColumnType = DesignedReportColumnType.PersonInfo; columnProxy.ID = item.ID; columnProxy.KeyColumn = item.Key.ToString(); designedColumnProxyList.Add(columnProxy); } designedColumnProxyList = designedColumnProxyList.OrderBy(o => o.Name).ToList <DesignedColumnProxy>(); Report reportObj = new BReport().GetByID(reportId); DesignedReportType reportTypeObj = GetAllDesignedReportsTypes().SingleOrDefault(d => d.CustomCode == DesignedReportTypeEnum.Daily); if (reportObj.DesignedType == reportTypeObj) { IList <PersonParamField> personParamFieldList = new BPersonParamFields().GetAll().Where(p => p.Active && p.SubSystemId == SubSystemIdentifier.TimeAtendance).ToList(); foreach (PersonParamField item in personParamFieldList) { DesignedColumnProxy columnProxy = new DesignedColumnProxy(); DesignedReportPersonInfoColumn designedReportPersonInfoColumnObj = new DesignedReportPersonInfoColumn(); columnProxy.EnName = item.EnTitle; columnProxy.FnName = item.FnTitle; switch (BLanguage.CurrentLocalLanguage) { case LanguagesName.Parsi: columnProxy.Name = item.FnTitle; break; case LanguagesName.English: columnProxy.Name = item.EnTitle; break; default: columnProxy.Name = item.FnTitle; break; } columnProxy.ColumnType = DesignedReportColumnType.PersonParam; columnProxy.ID = item.ID; columnProxy.KeyColumn = item.Key; designedColumnProxyList.Add(columnProxy); } } return(designedColumnProxyList); } catch (Exception ex) { LogException(ex, "BDesignedReportsColumn", "GetAllDesignedReportsPersonInfoColumns"); throw ex; } }
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 IList <DesignedReportPersonInfoColumn> GetAllDesignedReportsPersonInfoColumns() { try { IList <DesignedReportPersonInfoColumn> designedReportPersonInfoColumnList = new List <DesignedReportPersonInfoColumn>(); designedReportPersonInfoColumnList = repDesignedReportPersonInfoColumn.GetAll().ToList <DesignedReportPersonInfoColumn>(); IList <PersonReserveField> personReserveFieldList = new List <PersonReserveField>(); if (designedReportPersonInfoColumnList.Count(d => d != null && d.IsReserveField) > 0) { personReserveFieldList = new BPersonReservedField().GetAll(); } foreach (DesignedReportPersonInfoColumn item in designedReportPersonInfoColumnList) { if (item.IsReserveField) { string itemKey = item.Key.ToString().Replace("prsTA_", ""); PersonReserveField personReserveFieldObj = personReserveFieldList.FirstOrDefault(r => r.OrginalName.ToLower().Trim() == itemKey.ToLower().Trim()); if (personReserveFieldObj != null) { item.Name = personReserveFieldObj.Lable; } else { switch (BLanguage.CurrentLocalLanguage) { case LanguagesName.Parsi: item.Name = item.FnName; break; case LanguagesName.English: item.Name = item.EnName; break; default: item.Name = item.FnName; break; } } } else { switch (BLanguage.CurrentLocalLanguage) { case LanguagesName.Parsi: item.Name = item.FnName; break; case LanguagesName.English: item.Name = item.EnName; break; default: item.Name = item.FnName; break; } } } IList <PersonParamField> personParamFieldList = new BPersonParamFields().GetAll().Where(p => p.Active && p.SubSystemId == SubSystemIdentifier.TimeAtendance).ToList(); foreach (PersonParamField item in personParamFieldList) { DesignedReportPersonInfoColumn designedReportPersonInfoColumnObj = new DesignedReportPersonInfoColumn(); designedReportPersonInfoColumnObj.EnName = item.EnTitle; designedReportPersonInfoColumnObj.FnName = item.FnTitle; //switch (BLanguage.CurrentLocalLanguage) //{ // case LanguagesName.Unknown: // conceptProxy.Name = item.FnTitle; // break; // case LanguagesName.Parsi: // conceptProxy.Name = item.FnTitle; // break; // case LanguagesName.English: // conceptProxy.Name = item.EnTitle; // break; // default: // conceptProxy.Name = item.FnTitle; // break; //} //conceptProxyList.Add(conceptProxy); } designedReportPersonInfoColumnList = designedReportPersonInfoColumnList.OrderBy(o => o.Name).ToList <DesignedReportPersonInfoColumn>(); return(designedReportPersonInfoColumnList); } catch (Exception ex) { LogException(ex, "BDesignedReportsColumn", "GetAllDesignedReportsPersonInfoColumns"); throw ex; } }