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);
}
}
