private void Btn_Reset_Click(object sender, EventArgs e)
{
Com_NameS.SelectedIndex = -1;
RText_Paid.ResetText();
RText_Rest.ResetText();
RText_Total.ResetText();
DTP_history.Value = Convert.ToDateTime(DateTime.Now);
DGV_Bill.ClearSelection();
}
private void Btn_Symptoms_Click(object sender, EventArgs e)
{
SqlDataAdapter ad = new SqlDataAdapter("select Bill.Id_Bill as'الرقم' , Students.Name as'اسم الطالب', Bill.Paid as 'المبلغ المدفوع' ,Bill.Rest as 'الباقي',Bill.Date as 'تاريخ الدفع' from Bill inner join Students on Students.Id_S = Bill.Id_S where Students.Name like '%" + RText_Search.Text + "%' or Bill.Date like '%" + RText_Search.Text + "%' ", DB.sqlconnection);
DataTable dt = new DataTable();
ad.Fill(dt);
DGV_Bill.DataSource = dt;
DGV_Bill.ClearSelection();
}
private void DGV_Bill_DoubleClick(object sender, EventArgs e)
{
if (DGV_Bill.SelectedRows.Count == 0)
{
return;
}
Com_NameS.Text = DGV_Bill.CurrentRow.Cells[1].Value.ToString();
RText_Paid.Text = DGV_Bill.CurrentRow.Cells[2].Value.ToString();
RText_Rest.Text = DGV_Bill.CurrentRow.Cells[3].Value.ToString();
DTP_history.Value = Convert.ToDateTime(DGV_Bill.CurrentRow.Cells[4].Value.ToString());
DGV_Bill.ClearSelection();
}
private void Btn_Search_Click(object sender, EventArgs e)
{
DGV_Bill.DataSource = bill.ShowDGV_Search(RText_Search.Text);
DGV_Bill.ClearSelection();
}
private void Frm_Bill_Load(object sender, EventArgs e)
{
DGV_Bill.ClearSelection();
}
