void GanDuLieu(LoaiXe lx)
{
lx.Ma = txtMaLX.Text.Trim();
lx.Ten = txtTenThuongGoi.Text.Trim();
lx.Loai = cbbLoai.SelectedValue.ToString();
lx.Hang = cbbHangXe.SelectedValue.ToString();
lx.PhanKhoi = int.Parse(cbbPhanKhoi.SelectedValue.ToString());
lx.NamSX = int.Parse(txtNamSanXuat.Text.Trim());
lx.NguonNhap = cbbNguonNhap.SelectedValue.ToString();
}
public bool SuaLoaiXe(LoaiXe lx)
{
cmd.CommandText = "UPDATE LoaiXe SET TenThuongGoi = N'" + lx.Ten + "', Loai ='" + lx.Loai + "', HangXe ='" + lx.Hang + "', PhanKhoi ='" + lx.PhanKhoi + "', NamSanXuat ='" + lx.NamSX + "', NguonNhap='" + lx.NguonNhap + "' Where MaLX= '" + lx.Ma + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = cn.Connection;
try
{
cn.Connect();
cmd.ExecuteNonQuery();
cn.DisConnect();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
cn.DisConnect();
}
return(false);
}
public bool ThemLoaiXe(LoaiXe lx)
{
cmd.CommandText = "INSERT INTO LoaiXe values ('" + lx.Ma + "', N'" + lx.Ten + "', '" + lx.Loai + "', '" + lx.Hang + "', '" + lx.PhanKhoi + "', '" + lx.NamSX + "', '" + lx.NguonNhap + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = cn.Connection;
try
{
cn.Connect();
cmd.ExecuteNonQuery();
cn.DisConnect();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
cn.DisConnect();
}
return(false);
}
public bool SuaLoaiXe(LoaiXe lx)
{
return(lxMod.SuaLoaiXe(lx));
}
public bool ThemLoaiXe(LoaiXe lx)
{
return(lxMod.ThemLoaiXe(lx));
}
