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