private bool ColumnVisible(string headerText, Course.CourseType type) { var result = false; switch (headerText) { case "InterestMonthPercentage": case "InterestYearPercentage": switch (type) { case Course.CourseType.None: result = false; break; default: result = true; break; } break; case "PeriodDate": case "TotalFund": case "Period": case "InterestPayment": case "FundPayment": case "TotalPayment": result = true; break; case "FundPaymentWithPriceIndex": switch (type) { case Course.CourseType.Fix: case Course.CourseType.Prime: case Course.CourseType.Variable: result = false; break; case Course.CourseType.None: case Course.CourseType.FixPriceIndex: case Course.CourseType.VariablePriceIndex: default: result = true; break; } break; case "TotalFundWithPriceIndex": case "PriceIndex": switch (type) { case Course.CourseType.None: case Course.CourseType.Fix: case Course.CourseType.Prime: case Course.CourseType.Variable: result = false; break; case Course.CourseType.FixPriceIndex: case Course.CourseType.VariablePriceIndex: default: result = true; break; } break; default: break; } return(result); }
private void DesignGrid(DataGridView grid, Course.CourseType type) { _gridWith = 0; foreach (DataGridViewColumn col in grid.Columns) { var visible = ColumnVisible(col.HeaderText, type); if (visible == false) { col.Visible = false; } else { switch (col.HeaderText) { case "Period": col.HeaderText = "תקופה"; col.Width = 75; col.DisplayIndex = 0; break; case "InterestMonthPercentage": col.HeaderText = "% ריבית חודשי"; col.DefaultCellStyle.Format = "N4"; //col.Width = 125; break; case "InterestYearPercentage": col.HeaderText = "% ריבית שנתי"; col.DefaultCellStyle.Format = "N4"; //col.Width = 125; break; case "InterestPayment": col.HeaderText = "תשלום ריבית"; col.DefaultCellStyle.Format = "N2"; col.Width = 125; break; case "FundPayment": col.HeaderText = "תשלום קרן"; col.DefaultCellStyle.Format = "N2"; col.Width = 125; break; case "FundPaymentWithPriceIndex": col.HeaderText = "תשלום קרן צמוד"; col.DefaultCellStyle.Format = "N2"; col.Width = 125; break; case "TotalFund": col.HeaderText = "יתרת קרן"; col.DefaultCellStyle.Format = "N2"; break; case "TotalFundWithPriceIndex": col.HeaderText = "יתרת קרן צמודה"; col.DefaultCellStyle.Format = "N2"; col.Width = 125; break; case "TotalPayment": col.HeaderText = "החזר חודשי כולל"; col.DefaultCellStyle.Format = "N2"; col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; col.Width = 125; break; case "PriceIndex": col.HeaderText = "מדד חודשי"; col.DefaultCellStyle.Format = "N4"; col.DisplayIndex = 2; break; case "PeriodDate": col.HeaderText = "חודש"; col.DefaultCellStyle.Format = "MM/yyyy"; col.DisplayIndex = 1; col.Width = 75; break; default: break; } _gridWith += col.Width + 2; } } Application.DoEvents(); }