private row_data Set_Blocked_Color(row_data org, int month, string blocked_status) { row_data te = org; switch (month) { case 1: { te.v_Jan = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 2: { te.v_Feb = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 3: { te.v_Mar = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 4: { te.v_Apr = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 5: { te.v_May = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 6: { te.v_Jun = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 7: { te.v_Jul = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 8: { te.v_Aug = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 9: { te.v_Sep = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 10: { te.v_Oct = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 11: { te.v_Nov = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } case 12: { te.v_Dec = ((blocked_status == "True") || (blocked_status == "TRUE")) ? Color.Red : Color.Green; break; } default: break; } return(te); }
private void Show_Data() { string seperater = "\r\n"; string[] str_array = m_data.ToString().Split(seperater.ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToArray(); int data_list_index = -1; var data_list = new List <row_data>(); var unique_list = new List <string>(); bool flag_is_blocked = false; foreach (string line in str_array.AsEnumerable().Skip(1).ToArray()) { if (DateTime.Parse(line.Split(',')[3]).Year != DateTime.Now.Year) //Only Get Current Year's data from .csv file { continue; } string str_IMEI = line.Split(',')[1]; if (!unique_list.Contains(str_IMEI)) { flag_is_blocked = false; row_data te = new row_data(); te.v_IMEI = line.Split(',')[1]; te.v_PHONE = line.Split(',')[2]; te = Set_Blocked_Color(te, DateTime.Parse(line.Split(',')[3]).Month, line.Split(',')[4]); if ((line.Split(',')[4] == "True") || (line.Split(',')[4] == "TRUE")) { te.v_BLOCKED = DateTime.Parse(line.Split(',')[3]).ToString("MMM yyyy"); flag_is_blocked = true; } te.v_SIM_BLOCK = (m_dict_IMEI_SIM.FirstOrDefault(x => x.Key == te.v_IMEI).Value == "True") ? true : false; data_list_index++; data_list.Add(te); unique_list.Add(str_IMEI); } else { data_list[data_list_index] = Set_Blocked_Color(data_list[data_list_index], DateTime.Parse(line.Split(',')[3]).Month, line.Split(',')[4]); if (!flag_is_blocked) { if ((line.Split(',')[4] == "True") || (line.Split(',')[4] == "TRUE")) { data_list[data_list_index].v_BLOCKED = DateTime.Parse(line.Split(',')[3]).ToString("MMM yyyy"); } } } } CellStyle checkbox_cellstyle = new CellStyle(); checkbox_cellstyle.Padding = new CellPadding(60, 0, 0, 0); int i = 1; foreach (row_data row in data_list) { Row temp = new Row(new Cell[] { new Cell(i++), new Cell(row.v_IMEI), new Cell(row.v_PHONE), new Cell(row.v_Jan), new Cell(row.v_Feb), new Cell(row.v_Mar), new Cell(row.v_Apr), new Cell(row.v_May), new Cell(row.v_Jun), new Cell(row.v_Jul), new Cell(row.v_Aug), new Cell(row.v_Sep), new Cell(row.v_Oct), new Cell(row.v_Nov), new Cell(row.v_Dec), new Cell(row.v_BLOCKED), new Cell("", row.v_SIM_BLOCK, checkbox_cellstyle) }); this.table.TableModel.Rows.Add(temp); } m_data_list = data_list; }