private async Task GetFieldsAsync()
{
ReportFields.Clear();
SelectedFields.Clear();
if (SelectedLayer == null)
{
return;
}
await QueuedTask.Run((Action)(() =>
{
foreach (FieldDescription fd in SelectedLayer?.GetFieldDescriptions())
{
string shapeField = SelectedLayer.GetFeatureClass().GetDefinition().GetShapeField();
if (fd.Name == shapeField)
{
continue; //filter out the shape field.
}
var defFieldAction = (Action)(() =>
{
var field = new ReportField {
IsSelected = false, DisplayName = fd.Alias, Name = fd.Name
};
ReportFields.Add(field);
field.FieldSelectionChanged += this.Field_FieldSelectionChanged;
//field.IsSelected = true;
});
ActionOnGuiThread(defFieldAction);
}
}));
}
/// <summary>
/// Creates a column model for a report
/// </summary>
/// <param name="fields">The visible columns</param>
public static ColumnModel CreateColumnModel(ReportFields fields)
{
ImageColumn reportTypeImageColumn = CreateImageColumn(string.Empty, 20, "");
ImageColumn reportStatusImageColumn = CreateImageColumn(string.Empty, 20, "");
TextColumn reportVillageColumn = CreateTextColumn("Village", 50);
TextColumn reportPlayerColumn = CreateTextColumn("Player", 100);
DateTimeColumn reportDateColumn = CreateDateTimeColumn("Date", 70);
ImageColumn reportFlagImageColumn = CreateImageColumn(string.Empty, 20, "");
reportTypeImageColumn.Visible = (fields & ReportFields.Type) != 0;
reportStatusImageColumn.Visible = (fields & ReportFields.Status) != 0;
reportVillageColumn.Visible = (fields & ReportFields.Village) != 0;
reportPlayerColumn.Visible = (fields & ReportFields.Player) != 0;
reportDateColumn.Visible = (fields & ReportFields.Date) != 0;
reportFlagImageColumn.Visible = (fields & ReportFields.Flag) != 0;
return(new ColumnModel(new Column[] {
reportTypeImageColumn,
reportStatusImageColumn,
reportVillageColumn,
reportPlayerColumn,
reportDateColumn,
reportFlagImageColumn
}));
}
protected void dlVersionList_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lblTitle = e.Item.FindControl("lblTitle") as Label;
Label lblTotalOrder = e.Item.FindControl("lblTotalOrder") as Label;
Label lblAvgOrder = e.Item.FindControl("lblAvgOrder") as Label;
Label lblTotalRev = e.Item.FindControl("lblTotalRev") as Label;
ReportFields item = e.Item.DataItem as ReportFields;
lblTitle.Text = item.ShortName;
lblTotalOrder.Text = item.TotalOrders.ToString();
lblAvgOrder.Text = String.Format("${0:0.##}", item.AverageOrder);
lblTotalRev.Text = String.Format("${0:0.##}", item.TotalRevenue);
}
if (e.Item.ItemType == ListItemType.Footer)
{
Label lblSumTotalOrder = e.Item.FindControl("lblSumTotalOrder") as Label;
Label lblSumAvgOrder = e.Item.FindControl("lblSumAvgOrder") as Label;
Label lblSumTotalRev = e.Item.FindControl("lblSumTotalRev") as Label;
ReportFields foundItem = dtCollectionList[0].Find(y => y.CatgoryId == CategoryId);
if (foundItem != null)
{
lblSumTotalOrder.Text = foundItem.TotalOrders.ToString();
lblSumAvgOrder.Text = String.Format("${0:0.##}", foundItem.AverageOrder);
lblSumTotalRev.Text = String.Format("${0:0.##}", foundItem.TotalRevenue);
}
}
}
/// <summary>
/// Creates the report
/// </summary>
/// <returns></returns>
private async Task CreateReport()
{
ReportDataSource reportDataSource = null;
Report report = null;
_isCreateReport = false;
var reportTemplate = await GetReportTemplate(SelectedReportTemplate);
await QueuedTask.Run(() =>
{
//Adding all fields to the report
List <CIMReportField> reportFields = new List <CIMReportField>();
var selectedReportFields = ReportFields.Where((fld) => fld.IsSelected);
foreach (var rfld in selectedReportFields)
{
var cimReportField = new CIMReportField()
{
Name = rfld.Name
};
reportFields.Add(cimReportField);
//Defining grouping field
if (rfld.Name == SelectedGroupField?.Name)
{
cimReportField.Group = true;
}
//To DO: Do sort info here.
}
//Report field statistics
List <ReportFieldStatistic> reportFieldStats = new List <ReportFieldStatistic>();
if (SelectedStatsField != null)
{
ReportFieldStatistic reportStat = new ReportFieldStatistic();
reportStat.Field = SelectedStatsField.Name;
reportStat.Statistic = (FieldStatisticsFlag)Enum.Parse(typeof(FieldStatisticsFlag), SelectedStatsOption);
reportFieldStats.Add(reportStat);
}
//Set Datasource
reportDataSource = new ReportDataSource(SelectedLayer, "", IsUseSelection, reportFields);
try
{
report = ReportFactory.Instance.CreateReport(ReportName, reportDataSource, null, reportFieldStats, reportTemplate, SelectedReportStyle);
_isCreateReport = true;
}
catch (System.InvalidOperationException e)
{
if (e.Message.Contains("Group field defined for a non-grouping template"))
{
MessageBox.Show("A group field cannot be defined for a non-grouping template.");
}
else if (e.Message.Contains("Grouping template specified but no group field defined"))
{
MessageBox.Show("A group field should be defined for a grouping template.");
}
}
});
}
private bool IsDuplicateColumnName()
{
var query = ReportFields.GroupBy(x => x.FieldName.ToString())
.Where(g => g.Count() > 1)
.Select(y => y.Key)
.ToList();
return(query.Count > 0);
}
private void ReportFields_ItemPropertyChanged(object sender, ItemPropertyChangedEventArgs e)
{
if (e.PropertyName != "IsChecked")
{
CheckValidation();
isdirty = true;
ReportFields[e.CollectionIndex].IsSelected = true;
}
IsSelected = ReportFields.Where(x => x.IsChecked).Count() > 0;
}
public static string GetReportField(RestCommand command, int reportFieldID)
{
ReportField reportField = ReportFields.GetReportField(command.LoginUser, reportFieldID);
if (reportField.OrganizationID != command.Organization.OrganizationID)
{
throw new RestException(HttpStatusCode.Unauthorized);
}
return(reportField.GetXml("ReportField", true));
}
protected void dlVersionList_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lblTitle = e.Item.FindControl("lblTitle") as Label;
Label lblTotalOrder = e.Item.FindControl("lblTotalOrder") as Label;
Label lblTotalRev = e.Item.FindControl("lblTotalRev") as Label;
Label lbHitLinkVisitor = e.Item.FindControl("lbHitLinkVisitor") as Label;
Label lblConversion = e.Item.FindControl("lblConversion") as Label;
ReportFields item = e.Item.DataItem as ReportFields;
lblTitle.Text = item.Title;
lblTotalOrder.Text = item.TotalOrders.ToString();
if (item.UniqueVisitors > 0)
{
lbHitLinkVisitor.Text = string.Format("{0:##,##}", item.UniqueVisitors);
}
else
{
lbHitLinkVisitor.Text = "0";
}
lblConversion.Text = String.Format("{0}", item.Conversion);
lblTotalRev.Text = String.Format("{0:0.##}", Math.Round(item.TotalRevenue, 2).ToString("n2"));
CategoryUniqueVistiors += item.UniqueVisitors;
totalOrders += item.TotalOrders;
totalRevenue += item.TotalRevenue;
}
if (e.Item.ItemType == ListItemType.Footer)
{
Label lblSumTotalOrder = e.Item.FindControl("lblSumTotalOrder") as Label;
Label lblSumTotalRev = e.Item.FindControl("lblSumTotalRev") as Label;
Label lblSumHitLinkVisitor = e.Item.FindControl("lblSumHitLinkVisitor") as Label;
Label lblSumTotalConversion = e.Item.FindControl("lblSumTotalConversion") as Label;
if (CategoryUniqueVistiors > 0)
{
lblSumTotalConversion.Text = String.Format("{0}", Math.Round((totalOrders * 100) / CategoryUniqueVistiors, 2));
lblSumHitLinkVisitor.Text = string.Format("{0:##,##}", CategoryUniqueVistiors);
}
else
{
lblSumTotalConversion.Text = "0";
lblSumHitLinkVisitor.Text = "0";
}
lblSumTotalOrder.Text = totalOrders.ToString();
lblSumTotalRev.Text = String.Format("{0:C}", totalRevenue);
}
}
public static string GetReportFields(RestCommand command)
{
ReportFields reportFields = new ReportFields(command.LoginUser);
reportFields.LoadByOrganizationID(command.Organization.OrganizationID);
if (command.Format == RestFormat.XML)
{
return(reportFields.GetXml("ReportFields", "ReportField", true, command.Filters));
}
else
{
throw new RestException(HttpStatusCode.BadRequest, "Invalid data format");
}
}
protected void dlUrlList_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lblTitle = e.Item.FindControl("lblTitle") as Label;
Label lblTotalOrder = e.Item.FindControl("lblTotalOrder") as Label;
Label lblAvgOrder = e.Item.FindControl("lblAvgOrder") as Label;
Label lblTotalRev = e.Item.FindControl("lblTotalRev") as Label;
Label lbHitLinkVisitor = e.Item.FindControl("lbHitLinkVisitor") as Label;
Label lblConversion = e.Item.FindControl("lblConversion") as Label;
Label lblRevenuePerVisit = e.Item.FindControl("lblRevenuePerVisit") as Label;
ReportFields item = e.Item.DataItem as ReportFields;
lblTitle.Text = item.ShortName;
try
{
lblTitle.Text = " " + item.ShortName.Split('-')[0];
}
catch
{
}
if (item.TotalOrders > 0)
{
lblTotalOrder.Text = string.Format("{0:##,##}", item.TotalOrders);
}
else
{
lblTotalOrder.Text = "0";
}
if (item.UniqueVisitors > 0)
{
lbHitLinkVisitor.Text = string.Format("{0:##,##}", item.UniqueVisitors);
}
else
{
lbHitLinkVisitor.Text = "0";
}
lblConversion.Text = String.Format("{0}%", item.Conversion);
lblRevenuePerVisit.Text = String.Format("{0:C}", item.RevenuePerVisit);
lblAvgOrder.Text = String.Format("{0:C}", item.AverageOrder);
lblTotalRev.Text = String.Format("{0:C}", item.TotalRevenue);
}
}
protected void dlTransactionList_ItemDataBound(object sender, DataListItemEventArgs e)
{
ReportFields item = e.Item.DataItem as ReportFields;
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lblOrderNo = e.Item.FindControl("lblOrderNo") as Label;
Label lblOrderStatus = e.Item.FindControl("lblOrderStatus") as Label;
Label lblAmount = e.Item.FindControl("lblAmount") as Label;
Label lblAuthCode = e.Item.FindControl("lblAuthCode") as Label;
Label lblTransaction = e.Item.FindControl("lblTransaction") as Label;
Label lblTransactionDate = e.Item.FindControl("lblTransactionDate") as Label;
Label lblAffiliate = e.Item.FindControl("lblAffiliate") as Label;
lblOrderNo.Text = item.orderId.ToString();
lblOrderStatus.Text = item.OrderStatus;
lblAmount.Text = String.Format("{0:C}", item.TotalRevenue);
if (item.AuthorizationCode != null)
{
lblAuthCode.Text = item.AuthorizationCode;
}
else
{
lblAuthCode.Text = String.Empty;
}
if (item.TransactionCode != null)
{
lblTransaction.Text = item.TransactionCode;
}
else
{
lblTransaction.Text = String.Empty;
}
if (item.TransactionDate.Length > 0)
{
lblTransactionDate.Text = Convert.ToDateTime(item.TransactionDate).AddHours(3).ToString();
}
else
{
lblTransactionDate.Text = String.Empty;
}
}
}
private void ExecuteAddNew(object parameter)
{
ReportFields.Add(new ReportFields()
{
ID = 0,
Name = SelectedReportName.Name,
Caption = string.Empty,
Alignment = string.Empty,
DataTypeID = 0,
FieldName = string.Empty,
System = false,
FieldType = -999,
IsChecked = false,
IsEnabled = true
});
ScrollToIndex = ReportFields.Count() - 1;
CheckValidation();
}
private void ExecuteDelete(object parameter)
{
IMessageBoxService msg = new MessageBoxService();
string title = "Deleting Report Field";
string confirmtxt = "Do you want to delete the selected item";
if (ReportFields.Where(x => x.IsChecked).Count() > 1)
{
title = title + "s";
confirmtxt = confirmtxt + "s";
}
if (msg.ShowMessage(confirmtxt + "?", title, GenericMessageBoxButton.OKCancel, GenericMessageBoxIcon.Question).Equals(GenericMessageBoxResult.OK))
{
foreach (ReportFields si in ReportFields)
{
if (si.IsSelected)
{
if (si.ID > 0)
{
DeleteReportField(si.ID);
}
deleteditems.Add(si);
si.IsSelected = false;
}
}
foreach (ReportFields pm in deleteditems)
{
ReportFields.Remove(pm);
}
deleteditems.Clear();
CheckValidation();
}
msg = null;
}
private bool IsAlignmentMissing()
{
int nummissing = ReportFields.Where(x => string.IsNullOrEmpty(x.Alignment)).Count();
return(nummissing > 0);
}
protected void BindData(DateTime?startDate, DateTime?endDate)
{
DateTime?timezoneStartDate = new DateTime();
DateTime?timezoneEndDate = new DateTime();
if (OrderHelper.IsReportEST())
{
timezoneStartDate = DateTimeUtil.GetEastCoastStartDate(rangeDateControlCriteria.StartDateValueLocal);
timezoneEndDate = DateTimeUtil.GetEastCoastDate(rangeDateControlCriteria.EndDateValueLocal);
}
else//PST
{
timezoneStartDate = rangeDateControlCriteria.StartDateValueLocal;
timezoneEndDate = DateTimeUtil.GetEndDate(rangeDateControlCriteria.EndDateValueLocal);
//liSubHeader.Text = DateTime.Now.DayOfWeek + " " + DateTime.Now.ToShortTimeString() + " (PST)";
}
//Passsing custom field value as 1000 which is combination of mid and sid. Special case for dermwand.com only
List <ReportFields> ItemList = new OrderManager().GetOrderCustomFieldReport(timezoneStartDate, timezoneEndDate, 1, false);
try
{
Data rptData = new ReportWSSoapClient().GetDataFromTimeframe(hitsLinkUserName, hitsLinkPassword, ReportsEnum.eCommerceActivitySummary, TimeFrameEnum.Daily, Convert.ToDateTime(startDate), Convert.ToDateTime(endDate), 100000000, 0, 0);
for (int i = 0; i <= rptData.Rows.GetUpperBound(0); i++)
{
HitLinkVisitor.Add(rptData.Rows[i].Columns[0].Value.ToLower(), rptData.Rows[i].Columns[3].Value);
}
}
catch (Exception ex)
{ }
List <string> keysAdded = new List <string>();
//Update Version List information
foreach (ReportFields item in ItemList)
{
if (HitLinkVisitor.ContainsKey(item.Title))
{
keysAdded.Add(item.Title);
decimal visitor = Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
visitor = Math.Abs(visitor);
item.UniqueVisitors = visitor;
if (visitor > 0)
{
item.Conversion = Math.Round((Convert.ToDecimal(item.TotalOrders) * 100) / visitor, 1);
item.RevenuePerVisit = Convert.ToDecimal(item.TotalRevenue) / visitor;
}
else
{
item.UniqueVisitors = 0;
item.Conversion = 0;
item.RevenuePerVisit = 0;
}
}
else
{
item.UniqueVisitors = 0;
item.Conversion = 0;
item.RevenuePerVisit = 0;
}
if (string.IsNullOrEmpty(item.Title))
{
item.Title = "(none)";
}
}
// add keys not already list (visits but no orders)
foreach (string key in HitLinkVisitor.Keys)
{
if (!keysAdded.Contains(key))
{
ReportFields item = new ReportFields();
item.Title = key;
decimal visitor = Convert.ToDecimal(HitLinkVisitor[item.Title].ToString());
visitor = Math.Abs(visitor);
item.UniqueVisitors = visitor;
item.Conversion = 0;
item.RevenuePerVisit = 0;
ItemList.Add(item);
}
}
dlVersionList.DataSource = ItemList;
dlVersionList.DataBind();
//FCLiteral.Text = CreateCharts(dtCollectionList[1dtCollectionList
}
public Dictionary <int, List <ReportFields> > GetVersionSummary(DateTime?startDate, DateTime?endDate, bool includeArchiveData)
{
Dictionary <int, List <ReportFields> > item = new Dictionary <int, List <ReportFields> >();
dtCollectionList = new OrderManager().GetVersionSummary(startDate, endDate, false);
using (SqlDataReader reader = GetVersionSummaryData(startDate, endDate, includeArchiveData))
{
List <ReportFields> CategorySummary = new List <ReportFields>();
while (reader.Read())
{
ReportFields rowitem = new ReportFields();
rowitem.CatgoryId = Int32.Parse(reader["CategoryId"].ToString());
rowitem.TotalOrders = Int32.Parse(reader["TotalOrders"].ToString());
rowitem.TotalRevenue = Convert.ToDecimal(reader["TotalRevenue"]);
rowitem.AverageOrder = Convert.ToDecimal(reader["AverageOrder"]);
CategorySummary.Add(rowitem);
}
item.Add(0, CategorySummary);
reader.NextResult();
List <ReportFields> VersionSummary = new List <ReportFields>();
while (reader.Read())
{
ReportFields rowitem = new ReportFields();
rowitem.VersionId = Int32.Parse(reader["VersionId"].ToString());
rowitem.CatgoryId = Int32.Parse(reader["CategoryId"].ToString());
rowitem.Title = reader["Title"].ToString().ToLower();
rowitem.ShortName = reader["ShortName"].ToString();
rowitem.TotalOrders = Int32.Parse(reader["TotalOrders"].ToString());
rowitem.TotalRevenue = Convert.ToDecimal(reader["TotalRevenue"]);
rowitem.AverageOrder = Convert.ToDecimal(reader["AverageOrder"]);
VersionSummary.Add(rowitem);
}
item.Add(1, VersionSummary);
reader.NextResult();
//while (reader.Read())
//{
// ReportFields rowitem = new ReportFields();
// rowitem.VersionId = Int32.Parse(reader["VersionId"].ToString());
// rowitem.Title = reader["URL"].ToString().ToLower();
// rowitem.ShortName = reader["URL"].ToString();
// rowitem.TotalOrders = Int32.Parse(reader["TotalOrders"].ToString());
// rowitem.TotalRevenue = Convert.ToDecimal(reader["TotalRevenue"]);
// rowitem.AverageOrder = Convert.ToDecimal(reader["AverageOrder"]);
// UrlSummary.Add(rowitem);
//}
//reader.NextResult();
}
using (SqlDataReader reader = GetURLSummaryData(startDate, endDate, includeArchiveData))
{
List <ReportFields> UrlSummary = new List <ReportFields>();
while (reader.Read())
{
ReportFields rowitem = new ReportFields();
rowitem.VersionId = Int32.Parse(reader["VersionId"].ToString());
rowitem.Title = reader["URL"].ToString().ToLower();
rowitem.CategoryTitle = reader["Title"].ToString().ToLower();
rowitem.ShortName = reader["URL"].ToString();
rowitem.TotalOrders = Int32.Parse(reader["TotalOrders"].ToString());
rowitem.TotalRevenue = Convert.ToDecimal(reader["TotalRevenue"]);
rowitem.AverageOrder = Convert.ToDecimal(reader["AverageOrder"]);
UrlSummary.Add(rowitem);
}
item.Add(2, UrlSummary);
}
return(item);
}
protected void dlVersionList_ItemDataBound(object sender, DataListItemEventArgs e)
{
CSBusiness.VersionCategory versionItem = e.Item.DataItem as CSBusiness.VersionCategory;
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lblTitle = e.Item.FindControl("lblTitle") as Label;
Label lblTotalOrder = e.Item.FindControl("lblTotalOrder") as Label;
Label lblAvgOrder = e.Item.FindControl("lblAvgOrder") as Label;
Label lblTotalRev = e.Item.FindControl("lblTotalRev") as Label;
Label lbHitLinkVisitor = e.Item.FindControl("lbHitLinkVisitor") as Label;
Label lblConversion = e.Item.FindControl("lblConversion") as Label;
Label lblRevenuePerVisit = e.Item.FindControl("lblRevenuePerVisit") as Label;
ReportFields item = e.Item.DataItem as ReportFields;
lblTitle.Text = item.ShortName;
if (item.TotalOrders > 0)
{
lblTotalOrder.Text = string.Format("{0:##,##}", item.TotalOrders);
}
else
{
lblTotalOrder.Text = "0";
}
if (item.UniqueVisitors > 0)
{
lbHitLinkVisitor.Text = string.Format("{0:##,##}", item.UniqueVisitors);
}
else
{
lbHitLinkVisitor.Text = "0";
}
lblConversion.Text = String.Format("{0}%", item.Conversion);
lblRevenuePerVisit.Text = String.Format("{0:C}", item.RevenuePerVisit);
lblAvgOrder.Text = String.Format("{0:C}", item.AverageOrder);
lblTotalRev.Text = String.Format("{0:C}", item.TotalRevenue);
CategoryUniqueVistiors += item.UniqueVisitors;
DataList dlUrlList = (DataList)e.Item.FindControl("dlUrlList");
List <ReportFields> items = dtCollectionList[2].FindAll(y => y.VersionId == item.VersionId);
if (items.Count > 0)
{
dlUrlList.DataSource = items;
dlUrlList.DataBind();
}
}
if (e.Item.ItemType == ListItemType.Footer)
{
Label lblSumTotalOrder = e.Item.FindControl("lblSumTotalOrder") as Label;
Label lblSumAvgOrder = e.Item.FindControl("lblSumAvgOrder") as Label;
Label lblSumTotalRev = e.Item.FindControl("lblSumTotalRev") as Label;
Label lblSumHitLinkVisitor = e.Item.FindControl("lblSumHitLinkVisitor") as Label;
Label lblSumTotalConversion = e.Item.FindControl("lblSumTotalConversion") as Label;
Label lblSumRevenuePerClick = e.Item.FindControl("lblSumRevenuePerClick") as Label;
HtmlContainerControl versionFooter = e.Item.FindControl("versionFooter") as HtmlContainerControl;
ReportFields foundItem = dtCollectionList[0].Find(y => y.CatgoryId == CategoryId);
if (dtCollectionList[0].Count == 1)
{
versionFooter.Visible = false;
}
else
{
versionFooter.Visible = true;
}
if (foundItem != null)
{
if (CategoryUniqueVistiors > 0)
{
lblSumHitLinkVisitor.Text = string.Format("{0:##,##}", CategoryUniqueVistiors);
lblSumTotalConversion.Text = String.Format("{0}%", Math.Round((foundItem.TotalOrders * 100) / CategoryUniqueVistiors, 1));
lblSumRevenuePerClick.Text = String.Format("{0:C}", Math.Round(foundItem.TotalRevenue / CategoryUniqueVistiors, 2));
}
else
{
lblSumHitLinkVisitor.Text = "0";
lblSumTotalConversion.Text = "0";
lblSumRevenuePerClick.Text = "0";
}
if (foundItem.TotalOrders > 0)
{
lblSumTotalOrder.Text = string.Format("{0:##,##}", foundItem.TotalOrders);
}
else
{
lblSumTotalOrder.Text = "0";
}
lblSumAvgOrder.Text = String.Format("{0:C}", foundItem.AverageOrder);
lblSumTotalRev.Text = String.Format("{0:C}", foundItem.TotalRevenue);
TotalCategoryUniqueVistiors += CategoryUniqueVistiors;
TotalOrders += foundItem.TotalOrders;
TotalRevenue += foundItem.TotalRevenue;
}
}
}
/// <summary>
/// Creates a column model for a report
/// </summary>
/// <param name="fields">The visible columns</param>
public static ColumnModel CreateColumnModel(ReportFields fields)
{
ImageColumn reportTypeImageColumn = CreateImageColumn(string.Empty, 20, "");
ImageColumn reportStatusImageColumn = CreateImageColumn(string.Empty, 20, "");
TextColumn reportVillageColumn = CreateTextColumn("Village", 50);
TextColumn reportPlayerColumn = CreateTextColumn("Player", 100);
DateTimeColumn reportDateColumn = CreateDateTimeColumn("Date", 70);
ImageColumn reportFlagImageColumn = CreateImageColumn(string.Empty, 20, "");
reportTypeImageColumn.Visible = (fields & ReportFields.Type) != 0;
reportStatusImageColumn.Visible = (fields & ReportFields.Status) != 0;
reportVillageColumn.Visible = (fields & ReportFields.Village) != 0;
reportPlayerColumn.Visible = (fields & ReportFields.Player) != 0;
reportDateColumn.Visible = (fields & ReportFields.Date) != 0;
reportFlagImageColumn.Visible = (fields & ReportFields.Flag) != 0;
return new ColumnModel(new Column[] {
reportTypeImageColumn,
reportStatusImageColumn,
reportVillageColumn,
reportPlayerColumn,
reportDateColumn,
reportFlagImageColumn});
}
private bool IsCaptionMissing()
{
int nummissing = ReportFields.Where(x => string.IsNullOrEmpty(x.Caption)).Count();
return(nummissing > 0);
}
private void CreateColumns(Report report)
{
DataTable table = new DataTable();
using (SqlCommand command = new SqlCommand())
{
command.CommandText = report.GetSqlOld(true, filterControl.ReportConditions);
command.CommandType = CommandType.Text;
Report.CreateParameters(UserSession.LoginUser, command, UserSession.LoginUser.UserID);
using (SqlConnection connection = new SqlConnection(GetReportConnectionString()))
{
connection.Open();
command.Connection = connection;
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
adapter.FillSchema(table, SchemaType.Source);
adapter.Fill(table);
}
connection.Close();
}
}
ReportFields fields = new ReportFields(UserSession.LoginUser);
fields.LoadByReportID(_reportID);
foreach (ReportField field in fields)
{
if (field.IsCustomField == false && (field.LinkedFieldID == 30 || field.LinkedFieldID == 146))
{
GridButtonColumn column = new GridButtonColumn();
gridReport.MasterTableView.Columns.Add(column);
column.ButtonType = GridButtonColumnType.ImageButton;
column.ImageUrl = "../images/icons/open.png";
column.UniqueName = "ButtonOpen";
column.CommandName = "OpenItem";
column.HeaderStyle.Width = new Unit(32, UnitType.Pixel);
column.Resizable = false;
break;
}
}
if (fields.IsEmpty)
{
if (table.Columns.Contains("Ticket_Number"))
{
GridButtonColumn column = new GridButtonColumn();
gridReport.MasterTableView.Columns.Add(column);
column.ButtonType = GridButtonColumnType.ImageButton;
column.ImageUrl = "../images/icons/open.png";
column.UniqueName = "ButtonOpen";
column.CommandName = "OpenItem";
column.HeaderStyle.Width = new Unit(32, UnitType.Pixel);
column.Resizable = false;
}
}
foreach (DataColumn dataColumn in table.Columns)
{
GridBoundColumn gridColumn;
if (dataColumn.DataType == typeof(System.DateTime))
{
gridColumn = new GridDateTimeColumn();
gridColumn.DataFormatString = "{0:MM/dd/yyyy hh:mm tt}";
}
else if (dataColumn.DataType == typeof(System.Decimal) ||
dataColumn.DataType == typeof(System.Double)
)
{
gridColumn = new GridNumericColumn();
gridColumn.DataFormatString = "{0:0.00}";
}
else if (dataColumn.DataType == typeof(System.Int16) ||
dataColumn.DataType == typeof(System.Int32) ||
dataColumn.DataType == typeof(System.Int64))
{
gridColumn = new GridNumericColumn();
gridColumn.DataFormatString = "{0:0}";
}
else
{
gridColumn = new GridBoundColumn();
}
gridReport.MasterTableView.Columns.Add(gridColumn);
gridColumn.DataType = dataColumn.DataType;
gridColumn.DataField = dataColumn.ColumnName.Replace(' ', '_');
gridColumn.UniqueName = gridColumn.DataField;
gridColumn.HeaderText = dataColumn.ColumnName.Replace('_', ' ');
gridColumn.HeaderStyle.Width = new Unit(200, UnitType.Pixel);
}
}
private bool IsFieldTypeMissing()
{
int nummissing = ReportFields.Where(x => x.FieldType < -90).Count();
return(nummissing > 0);
}
private bool IsDataTypeMissing()
{
int nummissing = ReportFields.Where(x => x.DataTypeID == 0).Count();
return(nummissing > 0);
}
private bool IsFieldNameMissing()
{
int nummissing = ReportFields.Where(x => string.IsNullOrEmpty(x.FieldName)).Count();
return(nummissing > 0);
}
