private void btnviewchart_Click(object sender, EventArgs e) { label2.Visible = true; fill_grid(); if (Dgv_ChartExpanse.Rows.Count < 1) { int x = (panel3.Size.Width - Lab_Msg.Size.Width) / 2; Lab_Msg.Location = new Point(x, Lab_Msg.Location.Y); Lab_Msg.Show(); } else { Lab_Msg.Hide(); } Dgv_Expense.Hide(); chart_monthlyExpense.Show(); btngrddailytreatment.Visible = true; chart_monthlyExpense.Location = new Point(22, 50); chart_monthlyExpense.Size = new Size(1306, 378); this.Dgv_ChartExpanse.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False; dateTimePickerdailytreatment1.MaxDate = DateTime.Now; dateTimePickerdailytreatment2.MaxDate = DateTime.Now; DateTime now = DateTime.Now; DateTime date = new DateTime(now.Year, now.Month, 1); int row = Dgv_Expense.Rows.Count; label2.Text = row.ToString(); }
private void btngrddailytreatment_Click(object sender, EventArgs e) { Dgv_Expense.Show(); chart_monthlyExpense.Hide(); Dgv_Expense.Location = new Point(45, 51); Dgv_Expense.Size = new Size(1312, 308); label2.Text = 0.ToString(); label2.Visible = true; fill_grid(); if (Dgv_ChartExpanse.Rows.Count < 1) { int x = (panel3.Size.Width - Lab_Msg.Size.Width) / 2; Lab_Msg.Location = new Point(x, Lab_Msg.Location.Y); Lab_Msg.Show(); } else { Lab_Msg.Hide(); } if (rad_Expanse.Checked) { Dgv_Expense.Columns["colAmountdr"].Visible = false; Dgv_Expense.Columns["CoAmountCr"].Visible = true; } else if (rad_Income.Checked) { Dgv_Expense.Columns["CoAmountCr"].Visible = false; Dgv_Expense.Columns["colAmountdr"].Visible = true; } else { Dgv_Expense.Columns["CoAmountCr"].Visible = true; Dgv_Expense.Columns["colAmountdr"].Visible = true; } int count = Dgv_Expense.Rows.Count; label2.Text = count.ToString(); }
private void btnselect_Click(object sender, EventArgs e) { var d1 = dateTimePickerdailytreatment1.Value.ToShortDateString(); var d2 = dateTimePickerdailytreatment2.Value.ToShortDateString(); if (Convert.ToDateTime(d1).Date > Convert.ToDateTime(d2).Date) { MessageBox.Show("From date should be less than two date"); dateTimePickerdailytreatment1.Value = DateTime.Today; return; } fill_grid(); if (Dgv_Expense.Visible) { if (Dgv_ChartExpanse.Rows.Count < 1) { int x = (panel3.Size.Width - Lab_Msg.Size.Width) / 2; Lab_Msg.Location = new Point(x, Lab_Msg.Location.Y); Lab_Msg.Show(); } else { Lab_Msg.Hide(); } if (rad_Expanse.Checked) { Dgv_Expense.Columns["colAmountdr"].Visible = false; Dgv_Expense.Columns["CoAmountCr"].Visible = true; } else if (rad_Income.Checked) { Dgv_Expense.Columns["CoAmountCr"].Visible = false; Dgv_Expense.Columns["colAmountdr"].Visible = true; } else { Dgv_Expense.Columns["CoAmountCr"].Visible = true; Dgv_Expense.Columns["colAmountdr"].Visible = true; } int row = Dgv_Expense.Rows.Count; label2.Text = row.ToString(); Dgv_Expense.Show(); chart_monthlyExpense.Hide(); btngrddailytreatment.Visible = true; chart_monthlyExpense.Location = new Point(22, 50); chart_monthlyExpense.Size = new Size(1306, 378); } else { Dgv_Expense.Hide(); chart_monthlyExpense.Show(); btngrddailytreatment.Visible = true; chart_monthlyExpense.Location = new Point(22, 50); chart_monthlyExpense.Size = new Size(1306, 378); this.Dgv_ChartExpanse.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False; dateTimePickerdailytreatment1.MaxDate = DateTime.Now; dateTimePickerdailytreatment2.MaxDate = DateTime.Now; DateTime now = DateTime.Now; DateTime date = new DateTime(now.Year, now.Month, 1); if (Dgv_ChartExpanse.Rows.Count < 1) { int x = (panel3.Size.Width - Lab_Msg.Size.Width) / 2; Lab_Msg.Location = new Point(x, Lab_Msg.Location.Y); Lab_Msg.Show(); } else { Lab_Msg.Hide(); } } }
private void Monthly_Expense_Report_Load(object sender, EventArgs e) { try { this.Dgv_Expense.RowPostPaint += new DataGridViewRowPostPaintEventHandler(Dgv_Expense_RowPostPaint); Dgv_Expense.Hide(); comboFlag = true; this.Dgv_ChartExpanse.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False; //AddStaff.Select s = new AddStaff.Select(); this.chart_monthlyExpense.Titles.Add("Daily Expense Count"); dateTimePickerdailytreatment1.MaxDate = DateTime.Now; dateTimePickerdailytreatment2.MaxDate = DateTime.Now; DateTime now = DateTime.Now; DateTime date = new DateTime(now.Year, now.Month, 1); dateTimePickerdailytreatment1.Value = date; string date1 = dateTimePickerdailytreatment1.Value.ToString("MM/dd/yyyy"); string date2 = dateTimePickerdailytreatment2.Value.ToString("MM/dd/yyyy"); chart_monthlyExpense.Location = new Point(22, 50); chart_monthlyExpense.Size = new Size(1306, 378); foreach (var series in chart_monthlyExpense.Series) { series.Points.Clear(); } Cmb_AccountName.Items.Add("All Accounts"); Cmb_AccountName.ValueMember = "0"; Cmb_AccountName.DisplayMember = "All Accounts"; System.Data.DataTable doctor_rs = this.cntrl.Expense_type_data(); // db.table("select distinct id,name from tbl_expense_type"); if (doctor_rs.Rows.Count > 0) { for (int i = 0; i < doctor_rs.Rows.Count; i++) { Cmb_AccountName.Items.Add(doctor_rs.Rows[i]["name"].ToString()); Cmb_AccountName.ValueMember = doctor_rs.Rows[i]["id"].ToString(); Cmb_AccountName.DisplayMember = doctor_rs.Rows[i]["name"].ToString(); } } Cmb_AccountName.SelectedIndex = 0; fill_grid(); if (Dgv_ChartExpanse.Rows.Count < 1) { int x = (panel3.Size.Width - Lab_Msg.Size.Width) / 2; Lab_Msg.Location = new Point(x, Lab_Msg.Location.Y); Lab_Msg.Show(); } else { Lab_Msg.Hide(); } Dgv_ChartExpanse.ColumnHeadersDefaultCellStyle.BackColor = Color.DimGray; Dgv_ChartExpanse.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; Dgv_ChartExpanse.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Sego UI", 8, FontStyle.Bold); Dgv_ChartExpanse.EnableHeadersVisualStyles = false; foreach (DataGridViewColumn cl in Dgv_ChartExpanse.Columns) { cl.SortMode = DataGridViewColumnSortMode.NotSortable; } Dgv_Expense.ColumnHeadersDefaultCellStyle.BackColor = Color.DimGray; Dgv_Expense.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; Dgv_Expense.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Sego UI", 8, FontStyle.Bold); Dgv_Expense.EnableHeadersVisualStyles = false; foreach (DataGridViewColumn cl in Dgv_Expense.Columns) { cl.SortMode = DataGridViewColumnSortMode.NotSortable; } comboFlag = false; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error !..", MessageBoxButtons.OK, MessageBoxIcon.Information); } }