private void QuanLyVatTuPhuTungGUI_Load(object sender, EventArgs e) { //load CustomerID MySqlConnection Conncustomer = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmdcustomer = new MySqlCommand("select MaVatTuPhuTung from VATTUPHUTUNG", Conncustomer); Conncustomer.Open(); MySqlDataAdapter dacustomer = new MySqlDataAdapter(); dacustomer.SelectCommand = cmdcustomer; DataSet dscustomer = new DataSet(); dacustomer.Fill(dscustomer, "MaVatTuPhuTung"); cbbMaVatTuTraCuu.DataSource = dscustomer.Tables[0]; cbbMaVatTuTraCuu.DisplayMember = "MaVatTuPhuTung"; cbbMaVatTuTraCuu.ValueMember = "MaVatTuPhuTung"; cbbMaVatTuTraCuu.SelectedIndex = -1; tbDonGiaThaoTac.Text = "0"; tbSoLuongThaoTac.Text = "0"; tbDonGiaTraCuu.Text = "0"; tbSoLuongTraCuu.Text = "0"; }
//private void fillCboBienSo() //{ // TiepNhanXeSuaDAO.fillCBO("MaVatTuPhuTung", "VATTUPHUTUNG", cbbMaVatTuTraCuu); //} private void RefreshGUI() { MySqlConnection Conncustomer = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmdcustomer = new MySqlCommand("select MaVatTuPhuTung from VATTUPHUTUNG", Conncustomer); Conncustomer.Open(); MySqlDataAdapter dacustomer = new MySqlDataAdapter(); dacustomer.SelectCommand = cmdcustomer; DataSet dscustomer = new DataSet(); dacustomer.Fill(dscustomer, "MaVatTuPhuTung"); cbbMaVatTuTraCuu.DataSource = dscustomer.Tables[0]; cbbMaVatTuTraCuu.DisplayMember = "MaVatTuPhuTung"; cbbMaVatTuTraCuu.ValueMember = "MaVatTuPhuTung"; cbbMaVatTuTraCuu.SelectedIndex = -1; tbMaVatTuThaoTac.Text = ""; tbTenVatTuThaoTac.Text = ""; tbDonGiaThaoTac.Text = "0"; tbSoLuongThaoTac.Text = "0"; tbTenVatTuTraCuu.Text = ""; tbDonGiaTraCuu.Text = "0"; tbSoLuongTraCuu.Text = "0"; }
public static bool DisConnectToDatabase(string exception = "") { try { DatabaseConnectionDAO.DisConnectFromDatabase(); return(true); } catch (Exception ex) { exception = ex.Message; } return(false); }
private void fillCboBienSo() { MySqlConnection connection = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmd = new MySqlCommand("select BIENSO from XE", connection); connection.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DataSet dataset = new DataSet(); adapter.SelectCommand = cmd; adapter.Fill(dataset, "BIENSO"); cboBienSo.DataSource = dataset.Tables[0]; cboBienSo.DisplayMember = "BIENSO"; cboBienSo.ValueMember = "BIENSO"; cboBienSo.SelectedIndex = -1; }
public static bool ConnectToDatabase(string server, string database, string user, string password, ref string exception) { try { DatabaseConnectionDAO.connectionDatabase(server, database, user, password, ref exception); if (exception == "") { return(true); } } catch (Exception ex) { exception = ex.Message; } return(false); }
private void fillCboTenChuXe() { MySqlConnection connection = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmd = new MySqlCommand("select MAKHACHSUAXE, TENCHUXE from KHACHSUAXE", connection); connection.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DataSet dataset = new DataSet(); adapter.SelectCommand = cmd; adapter.Fill(dataset, "TENCHUXE"); cboTenChuXe.DataSource = dataset.Tables[0]; cboTenChuXe.DisplayMember = "TENCHUXE"; cboTenChuXe.ValueMember = "MAKHACHSUAXE"; cboTenChuXe.SelectedIndex = -1; }
private void fillCBOTIENCONG() { MySqlConnection connection = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmd = new MySqlCommand("select SOTIENCONG, TENTIENCONG from TIENCONG", connection); connection.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DataSet dataset = new DataSet(); adapter.SelectCommand = cmd; adapter.Fill(dataset, "TENTIENCONG"); cboTienCong.DataSource = dataset.Tables[0]; cboTienCong.DisplayMember = "TENTIENCONG"; cboTienCong.ValueMember = "SOTIENCONG"; cboTienCong.SelectedIndex = -1; }
private void fillCBOVatTuPhuTung() { MySqlConnection connection = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmd = new MySqlCommand("select MAVATTUPHUTUNG, TENVATTUPHUTUNG from VATTUPHUTUNG", connection); connection.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DataSet dataset = new DataSet(); adapter.SelectCommand = cmd; adapter.Fill(dataset, "TENVATTUPHUTUNG"); cboVatTuPhuTung.DataSource = dataset.Tables[0]; cboVatTuPhuTung.DisplayMember = "TENVATTUPHUTUNG"; cboVatTuPhuTung.ValueMember = "MAVATTUPHUTUNG"; cboVatTuPhuTung.SelectedIndex = -1; }
private void fillCboHieuXe() { MySqlConnection ConnCar = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmdCar = new MySqlCommand("select MAHIEUXE,TENHIEUXE from HIEUXE", ConnCar); ConnCar.Open(); MySqlDataAdapter daCar = new MySqlDataAdapter(); daCar.SelectCommand = cmdCar; DataSet dsCar = new DataSet(); daCar.Fill(dsCar, "TenHieuXe"); cboHieuXe.DataSource = dsCar.Tables[0]; cboHieuXe.DisplayMember = "TenHieuXe"; cboHieuXe.ValueMember = "MaHieuXe"; cboHieuXe.SelectedIndex = -1; }
public void insertPhieuSuaChua() { MySqlConnection connection = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand command = new MySqlCommand("InsertCHITIETPHIEUSUACHUA", connection); command.CommandType = CommandType.StoredProcedure; for (int i = 0; i < dgvPhieuSuaChua.Rows.Count - 1; i++) { command.Parameters.Add("@_MaPhieSuaChua", MySqlDbType.VarChar, 10); command.Parameters.Add(new MySqlParameter("@_NoiDung", dgvPhieuSuaChua.Rows[i].Cells["NoiDung"].Value)); command.Parameters.Add(new MySqlParameter("@_MaVatTuPhuTung", dgvPhieuSuaChua.Rows[i].Cells["VatTuPhuTung"].Value)); command.Parameters.Add(new MySqlParameter("@_SoLuongSuaChua", dgvPhieuSuaChua.Rows[i].Cells["SoLuong"].Value)); command.Parameters.Add(new MySqlParameter("@_TienCong", dgvPhieuSuaChua.Rows[i].Cells["TienCong"].Value)); command.Parameters.Add(new MySqlParameter("@_ThanhTien", dgvPhieuSuaChua.Rows[i].Cells["ThanhTien"].Value)); connection.Open(); command.ExecuteNonQuery(); connection.Close(); } }
public void RefreshTraCuuXeGUI() { MySqlConnection ConnIDCar = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmdIDCar = new MySqlCommand("select BIENSO from XE", ConnIDCar); ConnIDCar.Open(); MySqlDataAdapter daIDCar = new MySqlDataAdapter(); daIDCar.SelectCommand = cmdIDCar; DataSet dsIDCar = new DataSet(); daIDCar.Fill(dsIDCar, "BienSo"); cbbBienSoTraCuu.DataSource = dsIDCar.Tables[0]; cbbBienSoTraCuu.DisplayMember = "BienSo"; cbbBienSoTraCuu.ValueMember = "BienSo"; cbbBienSoTraCuu.SelectedIndex = -1; tbBienSoXe.Text = ""; tbTienNoTraCuu.Text = "0"; }
private void RefreshGUI() { #region Load car name and customer name //display customer name and set value ID customer MySqlConnection Conncustomer = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmdcustomer = new MySqlCommand("select MAKHACHSUAXE,TENCHUXE from KHACHSUAXE", Conncustomer); Conncustomer.Open(); MySqlDataAdapter dacustomer = new MySqlDataAdapter(); dacustomer.SelectCommand = cmdcustomer; DataSet dscustomer = new DataSet(); dacustomer.Fill(dscustomer, "TenChuXe"); cbbTenChuXe.DataSource = dscustomer.Tables[0]; cbbTenChuXe.DisplayMember = "TenChuXe"; cbbTenChuXe.ValueMember = "MaKhachSuaXe"; cbbTenChuXe.SelectedIndex = -1; tbTienNo.Text = "0"; #endregion }
public static void SaveChangeConection() { DatabaseConnectionDAO.SaveChangeConection(); }
private void QuanLyXeGUI_Load(object sender, EventArgs e) { #region Load and set up values //Setup cbbTienNo //cbbTienNoTraCuu.Items.Add("Bằng"); //cbbTienNoTraCuu.Items.Add("Lớn hơn"); //cbbTienNoTraCuu.Items.Add("Lớn hơn hoặc bằng"); //cbbTienNoTraCuu.Items.Add("Nhỏ hơn"); //cbbTienNoTraCuu.Items.Add("Nhỏ hơn hoặc bằng"); //cbbTienNoTraCuu.SelectedIndex = 2; //set up IDCar MySqlConnection ConnIDCar = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmdIDCar = new MySqlCommand("select BIENSO from XE", ConnIDCar); ConnIDCar.Open(); MySqlDataAdapter daIDCar = new MySqlDataAdapter(); daIDCar.SelectCommand = cmdIDCar; DataSet dsIDCar = new DataSet(); daIDCar.Fill(dsIDCar, "BienSo"); cbbBienSoTraCuu.DataSource = dsIDCar.Tables[0]; cbbBienSoTraCuu.DisplayMember = "BienSo"; cbbBienSoTraCuu.ValueMember = "BienSo"; cbbBienSoTraCuu.SelectedIndex = -1; //display car name and set value car //MySqlConnection ConnCar = DatabaseConnectionDAO.connectionDatabase(); //MySqlCommand cmdCar = new MySqlCommand("select MAHIEUXE,TENHIEUXE from HIEUXE", ConnCar); //ConnCar.Open(); //MySqlDataAdapter daCar = new MySqlDataAdapter(); //daCar.SelectCommand = cmdCar; //DataSet dsCar = new DataSet(); //daCar.Fill(dsCar, "TenHieuXe"); //cbbHieuXeTraCuu.DataSource = dsCar.Tables[0]; //cbbHieuXeTraCuu.DisplayMember = "TenHieuXe"; //cbbHieuXeTraCuu.ValueMember = "MaHieuXe"; ////display customer name and set value ID customer //MySqlConnection Conncustomer = DatabaseConnectionDAO.connectionDatabase(); //MySqlCommand cmdcustomer = new MySqlCommand("select MAKHACHSUAXE,TENCHUXE from KHACHSUAXE", Conncustomer); //Conncustomer.Open(); //MySqlDataAdapter dacustomer = new MySqlDataAdapter(); //dacustomer.SelectCommand = cmdcustomer; //DataSet dscustomer = new DataSet(); //dacustomer.Fill(dscustomer, "TenChuXe"); //cbbTenChuXeTraCuu.DataSource = dscustomer.Tables[0]; //cbbTenChuXeTraCuu.DisplayMember = "TenChuXe"; //cbbTenChuXeTraCuu.ValueMember = "MaKhachSuaXe"; tbTienNoTraCuu.Text = "0"; tbTienNo.Text = "0"; #endregion #region Load car name and customer name //display car name and set value car MySqlConnection ConnCar = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmdCar = new MySqlCommand("select MAHIEUXE,TENHIEUXE from HIEUXE", ConnCar); ConnCar.Open(); MySqlDataAdapter daCar = new MySqlDataAdapter(); daCar.SelectCommand = cmdCar; DataSet dsCar = new DataSet(); daCar.Fill(dsCar, "TenHieuXe"); cbbHieuXe.DataSource = dsCar.Tables[0]; cbbHieuXe.DisplayMember = "TenHieuXe"; cbbHieuXe.ValueMember = "MaHieuXe"; cbbHieuXe.SelectedIndex = -1; //display customer name and set value ID customer MySqlConnection Conncustomer = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand cmdcustomer = new MySqlCommand("select MAKHACHSUAXE,TENCHUXE from KHACHSUAXE", Conncustomer); Conncustomer.Open(); MySqlDataAdapter dacustomer = new MySqlDataAdapter(); dacustomer.SelectCommand = cmdcustomer; DataSet dscustomer = new DataSet(); dacustomer.Fill(dscustomer, "TenChuXe"); cbbTenChuXe.DataSource = dscustomer.Tables[0]; cbbTenChuXe.DisplayMember = "TenChuXe"; cbbTenChuXe.ValueMember = "MaKhachSuaXe"; cbbTenChuXe.SelectedIndex = -1; #endregion }