private void DisplayTimeEvent(object source, ElapsedEventArgs e)
{
using (var frm = new mainForm())
{
this.tmrLabel = DateTime.Now.ToString();
}
}
public resultPage(mainForm frm)
{
InitializeComponent();
this.MainForm = frm;
dataGridView1.Focus();
sqlConnection();
sqlCon.Open();
query = "SELECT clusterIndex, recencyDOM, frequencyDOM, monetaryDOM, rfmScore, clusterSegment, segmentID from clusterResult order by clusterIndex";
command = new SqlCommand(query, sqlCon);
command.CommandText = query;
command.CommandType = CommandType.Text;
command.Connection = sqlCon;
sa = new SqlDataAdapter(command);
sa.Fill(ds1, "clusterResult");
sa.Fill(dt);
//Fill data grid with cluster result\\
dataGridView1.DataSource = ds1.Tables[0].DefaultView;
cltr = dt.Rows.Count;
//Data grid summary properties setting\\
dataGridView3.ColumnCount = 6;
dataGridView3.Columns[0].Name = "Cluster";
dataGridView3.Columns[1].Name = "Number of Customers";
dataGridView3.Columns[2].Name = "Total Purchase Amount";
dataGridView3.Columns[3].Name = "Highest Purchase Amount";
dataGridView3.Columns[4].Name = "Highest Purchase Customer Name";
dataGridView3.Columns[5].Name = "Percentage";
dataGridView3.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView3.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView3.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView3.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView3.Columns[0].Width = 45;
dataGridView3.Columns[4].MinimumWidth = 150;
for (int k = 0; k < cltr; k++)
{
query2 = "SELECT CID, customerName, Frequency, totalPurchase, lastPurchase from [CSS].[dbo].customer where clusterIndex=" + (k + 1) + " ORDER BY totalPurchase DESC";
query3 = "SELECT CID, customerName, Frequency, totalPurchase, lastPurchase from [CSS].[dbo].customer";
command = new SqlCommand(query2, sqlCon);
command.CommandText = query2;
command.CommandType = CommandType.Text;
command.Connection = sqlCon;
sa = new SqlDataAdapter(command);
dt = new DataTable();
sa.Fill(dt);
command = new SqlCommand(query3, sqlCon);
command.CommandText = query3;
command.CommandType = CommandType.Text;
command.Connection = sqlCon;
sa = new SqlDataAdapter(command);
dt2 = new DataTable();
sa.Fill(dt2);
totalPurchase = 0;
for (int j = 0; j < dt.Rows.Count; j++)
{
totalPurchase += Convert.ToDouble(dt.Rows[j][3]);
}
//Fill summary data grid with calculated records\\
dataGridView3.Rows.Add(k + 1, dt.Rows.Count, totalPurchase, dt.Rows[0][3], dt.Rows[0][1], (((float)dt.Rows.Count / (float)dt2.Rows.Count) * 100));
}
dataGridView3.Columns[1].DefaultCellStyle.Format = " ### 'customers'";
dataGridView3.Columns[2].DefaultCellStyle.Format = "'Rp.' ###,###,###',-'";
dataGridView3.Columns[3].DefaultCellStyle.Format = "'Rp.' ###,###,###',-'";
dataGridView3.Columns[5].DefaultCellStyle.Format = "#0.00'%'";
query2 = "SELECT CID, customerName, Frequency, totalPurchase, lastPurchase from customer where clusterIndex=" + i;
command = new SqlCommand(query2, sqlCon);
command.CommandText = query2;
command.CommandType = CommandType.Text;
command.Connection = sqlCon;
sa = new SqlDataAdapter(command);
ds2.Clear();
sa.Fill(ds2, "customer");
//Fill customer list data grid with list of customers based on selected cluster\\
dataGridView2.DataSource = ds2.Tables[0].DefaultView;
metroTabPage1.Text = "Customer List - " + ds1.Tables[0].Rows[i - 1][5];
dataGridView1.Columns[5].MinimumWidth = 100;
dataGridView1.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
dataGridView1.Columns["segmentID"].Visible = false;
dataGridView2.Columns[3].DefaultCellStyle.Format = "'Rp.' ###,###,###.00',-'";
dataGridView2.Columns[4].DefaultCellStyle.Format = "dd MMM yyyy";
dataGridView2.Columns[1].MinimumWidth = 225;
dataGridView2.Columns[2].Width = 40;
dataGridView2.Columns[3].MinimumWidth = 115;
dataGridView2.Columns[0].Width = 50;
dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView2.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
DataGridViewLinkColumn dgvlc = new DataGridViewLinkColumn();
dataGridView1.Columns.Add(dgvlc);
dgvlc.HeaderText = "Strategy";
dgvlc.Text = "View";
dgvlc.Name = "Strategy link";
dgvlc.UseColumnTextForLinkValue = true;
sqlCon.Close();
foreach (DataGridViewColumn dgvc in dataGridView1.Columns)
{
dgvc.SortMode = DataGridViewColumnSortMode.NotSortable;
dgvc.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
foreach (DataGridViewColumn dgvc in dataGridView2.Columns)
{
dgvc.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
dataGridView1.ColumnHeadersHeight = 25;
dataGridView1.Columns[0].HeaderText = "Cluster";
dataGridView1.Columns[0].Width = 30;
dataGridView1.Columns[1].Width = 60;
dataGridView1.Columns[1].DefaultCellStyle.Format = "0.0######";
dataGridView1.Columns[2].Width = 60;
dataGridView1.Columns[2].DefaultCellStyle.Format = "0.0######";
dataGridView1.Columns[3].Width = 60;
dataGridView1.Columns[3].DefaultCellStyle.Format = "0.0######";
dataGridView1.Columns[4].MinimumWidth = 85;
dataGridView1.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[1].HeaderText = "Recency Score";
dataGridView1.Columns[2].HeaderText = "Frequency Score";
dataGridView1.Columns[3].HeaderText = "Monetary Score";
dataGridView1.Columns[4].HeaderText = "RFM Score";
dataGridView1.Columns[5].HeaderText = "Cluster Segment";
this.metroTabControl1.SelectedTab = metroTabPage1;
}
private void backBtn_Click(object sender, EventArgs e)
{
MainForm = new mainForm();
MainForm.Show();
Hide();
}
