public customer customerByProductOrderID() { customer customer = new customer(); createConnection(); SqlDataAdapter adapter = new SqlDataAdapter("Select customerId,ProductOrderID from productOrderSell", connection); adapter.Fill(customerByProductOrderId); DataTable table = new DataTable(); SqlDataAdapter adapter2 = new SqlDataAdapter("Select * from customerdb", connection); adapter2.Fill(table); for (int i = 0; i < customerByProductOrderId.Rows.Count; i++) { for (int j = 0; j < table.Rows.Count; j++) { if (Convert.ToInt32(table.Rows[j][0])==Convert.ToInt32(customerByProductOrderId.Rows[i][0])) { customer.code = Convert.ToInt32(customerByProductOrderId.Rows[i][0]); customer.name= table.Rows[j][1].ToString(); customer.surname = table.Rows[j][2].ToString(); } } } return customer; }
public void customerAdd(customer customer) { createConnection(); if (connection.State==ConnectionState.Closed) { connection.Open(); } SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "customerAdd"; command.Parameters.Add("@name", SqlDbType.NVarChar, 50); command.Parameters["@name"].Value = customer.name; command.Parameters.Add("@surname", SqlDbType.NVarChar, 50); command.Parameters["@surname"].Value = customer.surname; command.Parameters.Add("@title", SqlDbType.NVarChar, 50); command.Parameters["@title"].Value = customer.title; command.Parameters.Add("@accountNumber", SqlDbType.Int, 50); command.Parameters["@accountNumber"].Value = customer.accountNumber; command.Parameters.Add("@bankName", SqlDbType.NVarChar, 50); command.Parameters["@bankName"].Value = customer.bankName; command.Parameters.Add("@officeName", SqlDbType.NVarChar, 50); command.Parameters["@officeName"].Value = customer.officeName; command.Parameters.Add("@officeCode", SqlDbType.Int, 50); command.Parameters["@officeCode"].Value = customer.officeCode; command.Parameters.Add("@billTitle", SqlDbType.NVarChar, 50); command.Parameters["@billTitle"].Value = customer.billTitle; command.Parameters.Add("@taxDepartment", SqlDbType.NVarChar, 50); command.Parameters["@taxDepartment"].Value = customer.taxDepartment; command.Parameters.Add("@taxNumber", SqlDbType.Int, 50); command.Parameters["@taxNumber"].Value = customer.taxNumber; command.Parameters.Add("@billAdress", SqlDbType.NVarChar, 50); command.Parameters["@billAdress"].Value = customer.billAdress; command.Parameters.Add("@tel1", SqlDbType.Int, 50); command.Parameters["@tel1"].Value = customer.tel1; command.Parameters.Add("@tel1code", SqlDbType.Int, 50); command.Parameters["@tel1code"].Value = customer.tel1code; command.Parameters.Add("@tel2", SqlDbType.Int, 50); command.Parameters["@tel2"].Value = customer.tel2; command.Parameters.Add("@tel2code", SqlDbType.Int, 50); command.Parameters["@tel2code"].Value = customer.tel2code; command.Parameters.Add("@tel3", SqlDbType.Int, 50); command.Parameters["@tel3"].Value = customer.tel3; command.Parameters.Add("@tel3code", SqlDbType.Int, 50); command.Parameters["@tel3code"].Value = customer.tel3code; command.Parameters.Add("@tel4", SqlDbType.Int, 50); command.Parameters["@tel4"].Value = customer.tel4; command.Parameters.Add("@tel4code", SqlDbType.Int, 50); command.Parameters["@tel4code"].Value = customer.tel4code; command.Parameters.Add("@tel5", SqlDbType.Int, 50); command.Parameters["@tel5"].Value = customer.tel5; command.Parameters.Add("@tel5code", SqlDbType.Int, 50); command.Parameters["@tel5code"].Value = customer.tel5code; command.Parameters.Add("@tel6", SqlDbType.Int, 50); command.Parameters["@tel6"].Value = customer.tel6; command.Parameters.Add("@tel6code", SqlDbType.Int, 50); command.Parameters["@tel6code"].Value = customer.tel6code; command.Parameters.Add("@addhood", SqlDbType.NVarChar, 50); command.Parameters["@addhood"].Value = customer.addhood; command.Parameters.Add("@addstreet", SqlDbType.NVarChar, 50); command.Parameters["@addstreet"].Value = customer.addstreet; command.Parameters.Add("@addstreeet", SqlDbType.NVarChar, 50); command.Parameters["@addstreeet"].Value = customer.addstreeet; command.Parameters.Add("@addno", SqlDbType.Int, 50); command.Parameters["@addno"].Value = customer.addno; command.Parameters.Add("@addbuilding", SqlDbType.NVarChar, 50); command.Parameters["@addbuilding"].Value = customer.addbuilding; command.Parameters.Add("@addfloor", SqlDbType.Int, 50); command.Parameters["@addfloor"].Value = customer.addfloor; command.Parameters.Add("@addnoo", SqlDbType.Int, 50); command.Parameters["@addnoo"].Value = customer.addnoo; command.Parameters.Add("@addtown", SqlDbType.NVarChar, 50); command.Parameters["@addtown"].Value = customer.addtown; command.Parameters.Add("@addcity", SqlDbType.NVarChar, 50); command.Parameters["@addcity"].Value = customer.addcity; command.Parameters.Add("@adddescrip", SqlDbType.NVarChar, 50); command.Parameters["@adddescrip"].Value = customer.adddescrip; command.ExecuteNonQuery(); connection.Close(); connection.Dispose(); }
public void customerAdd(customer customer) { createConnection(); if (connection.State == ConnectionState.Closed) { connection.Open(); } SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "customerAdd"; command.Parameters.Add("@name", SqlDbType.NVarChar, 50); command.Parameters["@name"].Value = customer.name; command.Parameters.Add("@surname", SqlDbType.NVarChar, 50); command.Parameters["@surname"].Value = customer.surname; command.Parameters.Add("@title", SqlDbType.NVarChar, 50); command.Parameters["@title"].Value = customer.title; command.Parameters.Add("@accountNumber", SqlDbType.Int, 50); command.Parameters["@accountNumber"].Value = customer.accountNumber; command.Parameters.Add("@bankName", SqlDbType.NVarChar, 50); command.Parameters["@bankName"].Value = customer.bankName; command.Parameters.Add("@officeName", SqlDbType.NVarChar, 50); command.Parameters["@officeName"].Value = customer.officeName; command.Parameters.Add("@officeCode", SqlDbType.Int, 50); command.Parameters["@officeCode"].Value = customer.officeCode; command.Parameters.Add("@billTitle", SqlDbType.NVarChar, 50); command.Parameters["@billTitle"].Value = customer.billTitle; command.Parameters.Add("@taxDepartment", SqlDbType.NVarChar, 50); command.Parameters["@taxDepartment"].Value = customer.taxDepartment; command.Parameters.Add("@taxNumber", SqlDbType.Int, 50); command.Parameters["@taxNumber"].Value = customer.taxNumber; command.Parameters.Add("@billAdress", SqlDbType.NVarChar, 50); command.Parameters["@billAdress"].Value = customer.billAdress; command.Parameters.Add("@tel1", SqlDbType.Int, 50); command.Parameters["@tel1"].Value = customer.tel1; command.Parameters.Add("@tel1code", SqlDbType.Int, 50); command.Parameters["@tel1code"].Value = customer.tel1code; command.Parameters.Add("@tel2", SqlDbType.Int, 50); command.Parameters["@tel2"].Value = customer.tel2; command.Parameters.Add("@tel2code", SqlDbType.Int, 50); command.Parameters["@tel2code"].Value = customer.tel2code; command.Parameters.Add("@tel3", SqlDbType.Int, 50); command.Parameters["@tel3"].Value = customer.tel3; command.Parameters.Add("@tel3code", SqlDbType.Int, 50); command.Parameters["@tel3code"].Value = customer.tel3code; command.Parameters.Add("@tel4", SqlDbType.Int, 50); command.Parameters["@tel4"].Value = customer.tel4; command.Parameters.Add("@tel4code", SqlDbType.Int, 50); command.Parameters["@tel4code"].Value = customer.tel4code; command.Parameters.Add("@tel5", SqlDbType.Int, 50); command.Parameters["@tel5"].Value = customer.tel5; command.Parameters.Add("@tel5code", SqlDbType.Int, 50); command.Parameters["@tel5code"].Value = customer.tel5code; command.Parameters.Add("@tel6", SqlDbType.Int, 50); command.Parameters["@tel6"].Value = customer.tel6; command.Parameters.Add("@tel6code", SqlDbType.Int, 50); command.Parameters["@tel6code"].Value = customer.tel6code; command.Parameters.Add("@addhood", SqlDbType.NVarChar, 50); command.Parameters["@addhood"].Value = customer.addhood; command.Parameters.Add("@addstreet", SqlDbType.NVarChar, 50); command.Parameters["@addstreet"].Value = customer.addstreet; command.Parameters.Add("@addstreeet", SqlDbType.NVarChar, 50); command.Parameters["@addstreeet"].Value = customer.addstreeet; command.Parameters.Add("@addno", SqlDbType.Int, 50); command.Parameters["@addno"].Value = customer.addno; command.Parameters.Add("@addbuilding", SqlDbType.NVarChar, 50); command.Parameters["@addbuilding"].Value = customer.addbuilding; command.Parameters.Add("@addfloor", SqlDbType.Int, 50); command.Parameters["@addfloor"].Value = customer.addfloor; command.Parameters.Add("@addnoo", SqlDbType.Int, 50); command.Parameters["@addnoo"].Value = customer.addnoo; command.Parameters.Add("@addtown", SqlDbType.NVarChar, 50); command.Parameters["@addtown"].Value = customer.addtown; command.Parameters.Add("@addcity", SqlDbType.NVarChar, 50); command.Parameters["@addcity"].Value = customer.addcity; command.Parameters.Add("@adddescrip", SqlDbType.NVarChar, 50); command.Parameters["@adddescrip"].Value = customer.adddescrip; command.ExecuteNonQuery(); connection.Close(); connection.Dispose(); }
private void button11_Click(object sender, EventArgs e) { if (selectname == 1) { customer cu = new customer(); cu.cusIDlabel.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); cu.Nic.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); cu.name.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); cu.richAddress.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); cu.ContNumber.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString(); cu.Email.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString(); cu.Show(); cu.button2.Visible = true; cu.button1.Visible = false; } else if (selectname == 2) { Orders or = new Orders(); or.orderIDlabel.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); or.cusIDtextBox.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); or.typecomboBox.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); or.sizecomboBox.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); or.ColortextBox.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString(); or.DesigntextBox.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString(); or.QuantytextBox.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString(); or.ortypecomboBox.Text = this.dataGridView1.CurrentRow.Cells[7].Value.ToString(); or.ordateTimePicker.Text = this.dataGridView1.CurrentRow.Cells[8].Value.ToString(); or.duedateTimePicker.Text = this.dataGridView1.CurrentRow.Cells[9].Value.ToString(); or.comstatecomboBox.Text = this.dataGridView1.CurrentRow.Cells[10].Value.ToString(); or.fullpaytextBox.Text = this.dataGridView1.CurrentRow.Cells[11].Value.ToString(); or.advancetextBox.Text = this.dataGridView1.CurrentRow.Cells[12].Value.ToString(); or.labelarrear.Text = this.dataGridView1.CurrentRow.Cells[13].Value.ToString(); or.substatuscomboBox.Text = this.dataGridView1.CurrentRow.Cells[15].Value.ToString(); or.subdatetextBox.Text = this.dataGridView1.CurrentRow.Cells[14].Value.ToString(); or.Show(); or.button3.Visible = true; or.button2.Visible = false; } else if (selectname == 4) { payHistory ph = new payHistory(); ph.ortextBox.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); ph.cidlabel.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); ph.tpaylabel.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); ph.advalabel.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); ph.dateTimePicker1.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString(); ph.labelArear.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString(); ph.paymethodtextBox.Text = this.dataGridView1.CurrentRow.Cells[7].Value.ToString(); ph.rentallabel.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString(); ph.donecomboBox.Text = this.dataGridView1.CurrentRow.Cells[10].Value.ToString(); ph.fullpaystatuscomboBox.Text = this.dataGridView1.CurrentRow.Cells[8].Value.ToString(); ph.Show(); ph.button3.Visible = true; ph.button1.Visible = false; } else { MessageBox.Show("Please select right button", "Error window", MessageBoxButtons.OK); } }