private void comoUser_SelectedIndexChanged(object sender, EventArgs e) { AnbarDataContext Bank = new AnbarDataContext(); SqlDataReader DataReader; if (comboUser.Text != "") { objCommand.CommandText = "Select * From Users Where UserName='******'"; objCommand.Connection = objcon; objcon.Open(); DataReader = objCommand.ExecuteReader(); if (DataReader.Read()) { txtName2.Text = DataReader[0].ToString(); txtPass2.Text = DataReader[2].ToString(); txtRePass2.Text = DataReader[2].ToString(); chkUser2.Checked = Convert.ToBoolean(DataReader[12]); chkSaveImport2.Checked = Convert.ToBoolean(DataReader[3]); chkSaveExport2.Checked = Convert.ToBoolean(DataReader[4]); ChkRemoveImort2.Checked = Convert.ToBoolean(DataReader[5]); chkRemoveExport2.Checked = Convert.ToBoolean(DataReader[6]); chkLockAccountDay2.Checked = Convert.ToBoolean(DataReader[7]); ChkAccountCustomer2.Checked = Convert.ToBoolean(DataReader[8]); chkaccountSeller2.Checked = Convert.ToBoolean(DataReader[9]); chkReach2.Checked = Convert.ToBoolean(DataReader[10]); chkReport2.Checked = Convert.ToBoolean(DataReader[11]); } objCommand.Dispose(); DataReader.Close(); objcon.Close(); } }
private void textBox8_TextChanged(object sender, EventArgs e) { if (textBox8.Text != "") { AnbarDataContext Bank = new AnbarDataContext(); var query = from TableOrder in Bank.Orders join TableCustomer in Bank.Customers on TableOrder.CustomerID equals TableCustomer.CustomerID select TableCustomer.CustomerName; SqlDataReader DataReader; ObjCommand.CommandText = query.ToString() + " where OrderID=" + Convert.ToInt32(textBox8.Text) + ""; ObjCommand.Connection = objConnection; objConnection.Open(); DataReader = ObjCommand.ExecuteReader(); if (DataReader.Read()) { textBox7.Text = DataReader[0].ToString(); } else { textBox7.Text = "Not Define"; } ObjCommand.Dispose(); DataReader.Close(); objConnection.Close(); } else { textBox7.Clear(); } }
// private void toolStripButton3_Click(object sender, EventArgs e) { objDataSet.Tables["TableCheque"].Clear(); AnbarDataContext Bank = new AnbarDataContext(); var query = from table in Bank.Cheques select table; objDataAdapter.SelectCommand.CommandText = query.ToString(); objDataAdapter.Fill(objDataSet, "TableCheque"); objBindingSource.DataSource = objDataSet.Tables["TableCheque"]; bindingNavigator1.BindingSource = objBindingSource; //TextBox DataBinding textBox9.DataBindings.Clear(); textBox9.DataBindings.Add("Text", objBindingSource, "ChequeNumber"); textBox2.DataBindings.Clear(); textBox2.DataBindings.Add("Text", objBindingSource, "ChequeQuantity"); textBox8.DataBindings.Clear(); textBox8.DataBindings.Add("Text", objBindingSource, "OrderID"); textBox4.DataBindings.Clear(); textBox4.DataBindings.Add("Text", objBindingSource, "AcountNumber"); textBox3.DataBindings.Clear(); textBox3.DataBindings.Add("Text", objBindingSource, "BankName"); textBox5.DataBindings.Clear(); textBox5.DataBindings.Add("Text", objBindingSource, "OwnerAcounnt"); textBox1.DataBindings.Clear(); textBox1.DataBindings.Add("Text", objBindingSource, "DateCheque"); comboBox1.DataBindings.Clear(); comboBox1.DataBindings.Add("Text", objBindingSource, "Status"); textBox8_TextChanged(sender, e); }
private void textBox5_Leave(object sender, EventArgs e) { SqlConnection objcon = new SqlConnection(@"Data Source=(local);Initial Catalog=Anbar;Integrated Security=True"); SqlDataReader objDataReader; if (textBox5.Text != "") { AnbarDataContext objBank = new AnbarDataContext(); var query = from table in objBank.Products select new { table.ProductID, table.SellPrice, table.Discountable }; objCommand.CommandType = CommandType.Text; objCommand.CommandText = query.ToString(); objCommand.Connection = objcon; objcon.Open(); objDataReader = objCommand.ExecuteReader(); bool myfound = false; while (objDataReader.Read()) { if (textBox5.Text == objDataReader[0].ToString()) { myfound = true; textBox6.Text = objDataReader[1].ToString(); if (Convert.ToBoolean(objDataReader[2]) == false) { textBox8.Text = "0"; textBox8.ReadOnly = true; } else { textBox8.Text = "0"; textBox8.ReadOnly = false; } break; } } objDataReader.Dispose(); objDataReader.Close(); objcon.Close(); if (myfound == false) { textBox5.Focus(); } } }
private void button4_Click(object sender, EventArgs e) { try { AnbarDataContext objBank = new AnbarDataContext(); CustomerAccount objTableCustomerAccount = new CustomerAccount(); objTableCustomerAccount.OrderID = Convert.ToInt64(textBox7.Text); objTableCustomerAccount.Date = faDatePicker3.Text; objTableCustomerAccount.Debit = 0; objTableCustomerAccount.Creditor = Convert.ToInt64(textBox9.Text); objBank.CustomerAccounts.InsertOnSubmit(objTableCustomerAccount); objBank.SubmitChanges(); textBox7_Leave(sender, e); MessageBox.Show("Commit Transaction."); } catch { MessageBox.Show("Rollback Transaction."); } }
private void frmDocumentreach_Load(object sender, EventArgs e) { InputLanguage.CurrentInputLanguage = InputLanguage.InstalledInputLanguages[1]; AnbarDataContext Bank = new AnbarDataContext(); var query = from table in Bank.Cheques select table; objDataAdapter.SelectCommand.CommandText = query.ToString(); objDataAdapter.Fill(objDataSet, "TableCheque"); objBindingSource.DataSource = objDataSet.Tables["TableCheque"]; bindingNavigator1.BindingSource = objBindingSource; //TextBox DataBinding textBox9.DataBindings.Add("Text", objBindingSource, "ChequeNumber"); textBox2.DataBindings.Add("Text", objBindingSource, "ChequeQuantity"); textBox8.DataBindings.Add("Text", objBindingSource, "OrderID"); textBox4.DataBindings.Add("Text", objBindingSource, "AcountNumber"); textBox3.DataBindings.Add("Text", objBindingSource, "BankName"); textBox5.DataBindings.Add("Text", objBindingSource, "OwnerAcounnt"); textBox1.DataBindings.Add("Text", objBindingSource, "DateCheque"); comboBox1.DataBindings.Add("Text", objBindingSource, "Status"); // // PersianCalendar pcalender = new PersianCalendar(); year = pcalender.GetYear(DateTime.Now).ToString(); month = pcalender.GetMonth(DateTime.Now).ToString(); day = pcalender.GetDayOfMonth(DateTime.Now).ToString(); if (month.Length == 1) { month = "0" + month; } if (day.Length == 1) { day = "0" + day; } toolStripStatusLabel6.Text = year + "/" + month + "/" + day; }