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