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