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