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