private void btnviewchart_Click(object sender, EventArgs e)
{
Lab_Total.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_Expanse.Hide();
chart_EXpanse.Show();
btngrddailytreatment.Visible = true;
chart_EXpanse.Location = new Point(22, 50);
chart_EXpanse.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_Expanse.Rows.Count;
Lab_Total.Text = row.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 to date", "From Date is grater ", MessageBoxButtons.OK, MessageBoxIcon.Information);
dateTimePickerdailytreatment1.Value = DateTime.Today;
return;
}
fill_grid();
if (Dgv_Expanse.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();
}
int row = Dgv_Expanse.Rows.Count;
Lab_Total.Text = row.ToString();
Dgv_Expanse.Show();
chart_EXpanse.Hide();
btngrddailytreatment.Visible = true;
chart_EXpanse.Location = new Point(22, 50);
chart_EXpanse.Size = new Size(1306, 378);
}
else
{
Dgv_Expanse.Hide();
chart_EXpanse.Show();
btngrddailytreatment.Visible = true;
chart_EXpanse.Location = new Point(22, 50);
chart_EXpanse.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_Expanse.Rows.Count;
Lab_Total.Text = row.ToString();
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 btngrddailytreatment_Click(object sender, EventArgs e)
{
Dgv_Expanse.Show();
chart_EXpanse.Hide();
Dgv_Expanse.Location = new Point(45, 51);
Dgv_Expanse.Size = new Size(1312, 308);
label2.Text = 0.ToString();
label2.Visible = true;
foreach (var series in chart_EXpanse.Series)
{
series.Points.Clear();
}
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_Expanse.Columns["Amountincom"].Visible = false;
Dgv_Expanse.Columns["Amount"].Visible = true;
}
else if (rad_Income.Checked)
{
Dgv_Expanse.Columns["Amount"].Visible = false;
Dgv_Expanse.Columns["Amountincom"].Visible = true;
}
else
{
Dgv_Expanse.Columns["Amount"].Visible = true;
Dgv_Expanse.Columns["Amountincom"].Visible = true;
}
int count = Dgv_Expanse.Rows.Count;
label2.Text = count.ToString();
}
private void btngrddailytreatment_Click(object sender, EventArgs e)
{
Dgv_Expanse.Show();
chart_EXpanse.Hide();
Dgv_Expanse.Location = new Point(45, 51);
Dgv_Expanse.Size = new Size(1312, 308);
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();
}
int count = Dgv_Expanse.Rows.Count;
Lab_Total.Text = count.ToString();
}
private void Expense_Category_Wise_Report_Load(object sender, EventArgs e)
{
this.Dgv_Expanse.RowPostPaint += new DataGridViewRowPostPaintEventHandler(Dgv_Expanse_RowPostPaint);
Dgv_Expanse.Hide();
comboflag = true;
this.Dgv_ChartExpanse.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False;
//AddStaff.Select s = new AddStaff.Select();
this.chart_EXpanse.Titles.Add("Category Wise 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_EXpanse.Location = new Point(22, 50);
chart_EXpanse.Size = new Size(1306, 378);
foreach (var series in chart_EXpanse.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.load_type();// 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;
Cmb_Ledger.Items.Add("All Ledger");
Cmb_Ledger.ValueMember = "0";
Cmb_Ledger.DisplayMember = "All Ledger";
System.Data.DataTable Ledger = this.cntrl.load_ledger();
if (doctor_rs.Rows.Count > 0)
{
for (int i = 0; i < Ledger.Rows.Count; i++)
{
Cmb_Ledger.Items.Add(Ledger.Rows[i]["Group_Name"].ToString());
Cmb_Ledger.ValueMember = Ledger.Rows[i]["id"].ToString();
Cmb_Ledger.DisplayMember = Ledger.Rows[i]["Group_Name"].ToString();
}
}
Cmb_Ledger.SelectedIndex = 0;
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;
}
comboflag = false;
}
private void Expense_Daily_Report_Load(object sender, EventArgs e)
{
this.Dgv_Expanse.RowPostPaint += new DataGridViewRowPostPaintEventHandler(Dgv_Expanse_RowPostPaint);
Dgv_Expanse.Hide();
comboflag = true;
this.Dgv_ChartExpanse.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False;
this.chart_EXpanse.Titles.Add("Daily Expense Count");
var dateFrom = dateTimePickerdailytreatment2.Value.ToShortDateString();
var dateTo = dateTimePickerdailytreatment2.Value.ToShortDateString();
if (Convert.ToDateTime(dateFrom).Date > Convert.ToDateTime(dateTo).Date)
{
MessageBox.Show("From date should be less than to date", "From Date is grater ", MessageBoxButtons.OK, MessageBoxIcon.Information);
dateTimePickerdailytreatment2.Value = DateTime.Today;
return;
}
DateTime now = DateTime.Now;
DateTime date = new DateTime(now.Year, now.Month, 1);
dateTimePickerdailytreatment1.Value = date;
string date1 = dateTimePickerdailytreatment1.Value.ToString("yyyy-MM-dd");
string date2 = dateTimePickerdailytreatment2.Value.ToString("yyyy-MM-dd");
chart_EXpanse.Location = new Point(10, 50);
chart_EXpanse.Size = new Size(1306, 378);
foreach (var series in chart_EXpanse.Series)
{
series.Points.Clear();
}
Cmb_AccountName.Items.Add("All Accounts");
Cmb_AccountName.ValueMember = "0";
Cmb_AccountName.DisplayMember = "All Accounts";
DataTable doctor_rs = this.ctrlr.getdctrdtls();
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_Expanse.ColumnHeadersDefaultCellStyle.BackColor = Color.DimGray;
Dgv_Expanse.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
Dgv_Expanse.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Sego UI", 8, FontStyle.Bold);
Dgv_Expanse.EnableHeadersVisualStyles = false;
Dgv_Expanse.Columns[6].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
Dgv_Expanse.Columns[5].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
Dgv_Expanse.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Dgv_Expanse.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Dgv_Expanse.Columns[7].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
Dgv_Expanse.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
foreach (DataGridViewColumn cl in Dgv_Expanse.Columns)
{
cl.SortMode = DataGridViewColumnSortMode.NotSortable;
cl.Width = 100;
}
comboflag = false;
}