private void btnAdd_Click(object sender, EventArgs e)
{
int found = 0;
if (txtfname.Text.Equals("") || rtxtmob.Text.Equals(""))
{
MessageBox.Show("Insert Data Please");
}
else
{
DataTable dt = ClassReports.allphone();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (txtfname.Text.Equals(dt.Rows[i][1].ToString()) || rtxtmob.Text.Equals(dt.Rows[i][5].ToString()))
{
if (!rtxtmob.Text.Equals("0"))
{
found = 1;
}
}
}
if (found == 0)
{
int i = ClassReports.sp_addphonenum(txtret.Text, txtfname.Text, txtwaz.Text, rtxtmob.Text, txtland.Text, txtfax.Text, txtT.Text);
display();
txtfax.Text = txtfname.Text = txtland.Text = txtret.Text = txtwaz.Text = rtxtmob.Text = txtT.Text = "";
txtfax.Enabled = txtfname.Enabled = txtland.Enabled = txtret.Enabled = txtwaz.Enabled = rtxtmob.Enabled = txtT.Enabled = false;
MessageBox.Show("Done");
}
else
{
MessageBox.Show("الاسم او رقم الخليوي موجود مسبقا ..");
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtfname.Text.Equals("") || rtxtmob.Text.Equals("") || id == 0)
{
MessageBox.Show("Selected One");
}
else
{
txtfax.Enabled = txtfname.Enabled = txtland.Enabled = txtret.Enabled = txtwaz.Enabled = rtxtmob.Enabled = txtT.Enabled = true;
int i = ClassReports.UpdatePhone(id, txtret.Text, txtfname.Text, txtwaz.Text, rtxtmob.Text, txtland.Text, txtfax.Text, txtT.Text);
display();
txtfax.Text = txtfname.Text = txtland.Text = txtret.Text = txtwaz.Text = rtxtmob.Text = txtT.Text = "";
txtfax.Enabled = txtfname.Enabled = txtland.Enabled = txtret.Enabled = txtwaz.Enabled = rtxtmob.Enabled = txtT.Enabled = false;
MessageBox.Show("Done");
}
}
void displayOrder()
{
dgvOrders.DataSource = ClassReports.sp_orderRep(firstl, secondl, thirdl);
}
void displayQuotNotExe()
{
dgvQuotationNotExe.DataSource = ClassReports.sp_quotNotexeRep(firstl, secondl, thirdl);
}
private void txtsearch_TextChanged(object sender, EventArgs e)
{
dgvPhoneNumber.DataSource = ClassReports.searchphone(txtsearch.Text);
}
void display()
{
dgvPhoneNumber.DataSource = ClassReports.allphone();
}
