private void managerDriverToolStripMenuItem_Click(object sender, EventArgs e) { frmDrivers driver = new frmDrivers(); driver.Show(); this.Hide(); }
private void btnOk_Click(object sender, EventArgs e) { SqlConnection conn = connect.Getconect(); conn.Open(); //if(txtAdd.Text=="" || txtDrivercode.Text=="" || txtDrivername.Text==""||txtTelephone.Text=="") { //MessageBox.Show("You must enter full information");} //else{ if (rbMale.Checked == true) { gender = "true"; } //if(txtAdd.Text=="" || txtDrivercode.Text=="" || txtDrivername.Text==""||txtTelephone.Text=="") { //MessageBox.Show("You must enter full information");} //else{ string sql = "update tblDrivers set Driver_name='" + txtDrivername.Text + "',DoB='" + dateTimePicker1.Text + "',gender='" + gender + "',address='" + txtAdd.Text + "',telephone='" + txtTelephone.Text + "' where driver_code='" + frmDrivers.Code + "'"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader sdr = cmd.ExecuteReader(); MessageBox.Show("Update successfull"); frmDrivers view = new frmDrivers(); view.Show(); this.Dispose(); //} }
private void btnCancel_Click(object sender, EventArgs e) { this.Dispose(); frmDrivers view = new frmDrivers(); view.Show(); }
private void btnAdd_Click(object sender, EventArgs e) { string drivercode = txtDrivercode.Text; string drivername = txtDrivername.Text; string dob = dateTimePicker1.Text; string gender; if (rbMale.Checked == true) { gender = "1"; } else { gender = "0"; } string add = txtAdd.Text; string telephone = txtTelephone.Text; DateTime dt1 = dtpRentDate.Value; DateTime dt2 = dtpIntendedDate.Value; DateTime dt3 = dtpReturnDate.Value; if (txtDrivercode.Text != "" && txtDrivername.Text != "" && txtAdd.Text != "" && txtTelephone.Text != "" && txtCarCode.Text != "" && txtCarName.Text != "" && txtUnitPrice.Text != "" && txtRentPrice.Text != "") { if (DateTime.Compare(dt1, dt2) < 0 && DateTime.Compare(dt1, dt3) < 0) { try { SqlConnection conn = connect.Getconect(); conn.Open(); string sql = "insert into tblDrivers values ('" + drivercode + "','" + drivername + "','" + dob + "','" + gender + "','" + add + "','" + telephone + "')"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); SqlConnection conn1 = connect.Getconect(); conn1.Open(); string sql1 = "insert into tblCar_Driver values ('" + txtCarCode.Text + "','" + drivercode + "','" + dtpRentDate.Text + "','" + dtpIntendedDate.Text + "','" + dtpReturnDate.Text + "',null,null,null)"; SqlCommand cmd1 = new SqlCommand(sql1, conn1); cmd1.ExecuteNonQuery(); MessageBox.Show("Add successfull"); frmDrivers frm = new frmDrivers(); frm.Show(); this.Dispose(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("Intend date or Return date must greater than Rent date!"); } } else { MessageBox.Show("You must enter full information!"); } }