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