public bool ThemKH(string MaKH, string TenKH, string GioiTinh, string SDT, string CMND, string DiaChi, ref string err) { string sqlString = "Insert Into KhachHang Values( @MaKH,@TenKH,@CMND,@GioiTinh,@DiaChi,@SDT )"; SqlParameter[] para = { new SqlParameter("@MaKH", MaKH), new SqlParameter("@TenKH", TenKH), new SqlParameter("@CMND", GioiTinh), new SqlParameter("@GioiTinh", SDT), new SqlParameter("@DiaChi", CMND), new SqlParameter("@SDT", DiaChi) }; return(db.MyExecuteNonQuery(sqlString, para, CommandType.Text, ref err)); }
public bool ThemXe(string MaXe, string TenXe, string DongXe, string NamRaMat, string MauSac, string SoLuong, int GiaXe, ref string err) { string sqlString = "Insert Into Xe (MaXe,TenXe,MaDongXe,NamRaMat,MauSac,SoLuong,GiaXe) Values( @MaXe,@TenXe,@DongXe,@NamRaMat,@MauSac,@SoLuong,@GiaXe )"; SqlParameter[] para = { new SqlParameter("@MaXe", MaXe), new SqlParameter("@TenXe", TenXe), new SqlParameter("@DongXe", DongXe), new SqlParameter("@NamRaMat", NamRaMat), new SqlParameter("@MauSac", MauSac), new SqlParameter("@SoLuong", SoLuong), new SqlParameter("@GiaXe", GiaXe) }; return(db.MyExecuteNonQuery(sqlString, para, CommandType.Text, ref err)); }
public bool ThemNV(string MaNV, string TenNV, string Congviec, string gioitinh, string sdt, string DiaChi, int luong, ref string err) { string sqlString = "Insert Into NhanVien Values( @MaNV,@TenNV,@CongViec,@GioiTinh,@SDT,@DiaChi,@Luong )"; SqlParameter[] para = { new SqlParameter("@MaNV", MaNV), new SqlParameter("@TenNV", TenNV), new SqlParameter("@CongViec", Congviec), new SqlParameter("@GioiTinh", gioitinh), new SqlParameter("@SDT", sdt), new SqlParameter("@DiaChi", DiaChi), new SqlParameter("@Luong", luong) }; return(db.MyExecuteNonQuery(sqlString, para, CommandType.Text, ref err)); }
public bool ThemHD_Xe(string MaHD, string MaXe, int Gia, int slXe, ref string err) { string sqlString = "Insert Into HD_Xe (MaHD,MaXe,Gia,SLXe) Values ( @MaHD , @MaXe , @Gia , @slXe ) ; Update Xe set SoLuong = SoLuong - @slXe where MaXe = @MaXe "; //string sqlString = "Insert Into HD_Xe Values( 'HD6',@MaXe,@Gia,@slXe )"; SqlParameter[] para = { new SqlParameter("@MaHD", MaHD), new SqlParameter("@MaXe", MaXe), new SqlParameter("@Gia", Gia), new SqlParameter("@slXe", slXe) }; return(db.MyExecuteNonQuery(sqlString, para, CommandType.Text, ref err)); //string sqlString = "Insert into HD_Xe (MaHD,MaXe) Values('HD4','X01')"; //return db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err); //string sqlString = "Insert into HD_Xe Values('" + MaHD+"','"+MaXe+"',"+Gia+","+slXe +")" ; //return db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err); //string sqlString = "Insert Into KHACHHANG Values(" + "N'" + //MaHD + "',N'" + //MaXe + "',N'" + //Gia + "',N'" + //slXe + "')"; //return db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err); }