public static bool InsertDichVu(DichVuDTO dichvu)
{
bool result = false;
try
{
//create a list parameter
List <MySqlParameter> parameters = new List <MySqlParameter>();
//parameters.Add(new MySqlParameter("@MaTK", taikhoan.MaTK));
parameters.Add(new MySqlParameter("@MaDV", dichvu.MaDV));
parameters.Add(new MySqlParameter("@NgayBD", dichvu.NgayDV));
parameters.Add(new MySqlParameter("@FK_SoXe", dichvu.SoXe));
//call store Procedure
int n = MySqlDataAccessHelper.ExecuteNonQuery("INSERT INTO dichvu (MaDV, NgayBD, FK_SoXE) VALUES(@MaDV, @NgayBD, @FK_SoXe)", parameters);
if (n == 1)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool InsertTaiKhoan(TaiKhoanDTO taikhoan)
{
bool result = false;
try
{
//create a list parameter
List <MySqlParameter> parameters = new List <MySqlParameter>();
//parameters.Add(new MySqlParameter("@MaTK", taikhoan.MaTK));
parameters.Add(new MySqlParameter("@UserName", taikhoan.UserName));
parameters.Add(new MySqlParameter("@Password", taikhoan.Password));
parameters.Add(new MySqlParameter("@FK_NV", taikhoan.MaNhanVien));
parameters.Add(new MySqlParameter("@TinhTrang", taikhoan.TinhTrang));
//call store Procedure
int n = MySqlDataAccessHelper.ExecuteNonQuery("INSERT INTO taikhoan (UserName, Password, FK_NV, TinhTrang) VALUES(@UserName, @Password, @FK_NV, @TinhTrang)", parameters);
if (n == 1)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool InsertChiTietBaoDuong(ChiTietBaoDuongDTO chitietbaoduong)
{
bool result = false;
try
{
//create a list parameter
List <MySqlParameter> parameters = new List <MySqlParameter>();
//parameters.Add(new MySqlParameter("@MaTK", taikhoan.MaTK));
parameters.Add(new MySqlParameter("@MaCTBD", chitietbaoduong.MaCTBD));
parameters.Add(new MySqlParameter("@TrangThai", chitietbaoduong.TrangThai));
parameters.Add(new MySqlParameter("@Phi", chitietbaoduong.Phi));
parameters.Add(new MySqlParameter("@FK_MaPT", chitietbaoduong.MaPT));
parameters.Add(new MySqlParameter("@FK_MaDV_CTBD", chitietbaoduong.MaDV));
parameters.Add(new MySqlParameter("@FK_MaHD", chitietbaoduong.MaHD));
parameters.Add(new MySqlParameter("@FK_MaCV", chitietbaoduong.MaCV));
parameters.Add(new MySqlParameter("@SoLuong", chitietbaoduong.SoLuong));
parameters.Add(new MySqlParameter("@DonGia", chitietbaoduong.DonGia));
//call store Procedure
int n = MySqlDataAccessHelper.ExecuteNonQuery("INSERT INTO chitietbaoduong (MaCTBD, TrangThai, Phi, FK_MaPT, FK_MaDV_CTBD, FK_MaHD, FK_MaCV,SoLuong, DonGia) VALUES(@MaCTBD, @TrangThai, @Phi, @FK_MaPT, @FK_MaDV_CTBD, @FK_MaHD, @FK_MaCV, @SoLuong, @DonGia)", parameters);
if (n == 1)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool InsertHoaDon(HoaDonDTO hoadon)
{
bool result = false;
try
{
//create a list parameter
List <MySqlParameter> parameters = new List <MySqlParameter>();
//parameters.Add(new MySqlParameter("@MaTK", taikhoan.MaTK));
parameters.Add(new MySqlParameter("@MaHD", hoadon.MaHD));
parameters.Add(new MySqlParameter("@NgayLapHD", hoadon.NgayLapHD));
parameters.Add(new MySqlParameter("@TongTien", hoadon.TongTien));
parameters.Add(new MySqlParameter("@MaKH", hoadon.MaKH));
parameters.Add(new MySqlParameter("@ThanhTien", hoadon.ThanhTien));
parameters.Add(new MySqlParameter("@GiamGia", hoadon.GiamGia));
//call store Procedure
int n = MySqlDataAccessHelper.ExecuteNonQuery("INSERT INTO hoadon (MaHD, NgayLapHD, TongTien, FK_MaKH, GiamGia, ThanhTien) VALUES(@MaHD, @NgayLapHD, @TongTien, @MaKH, @GiamGia, @ThanhTien)", parameters);
if (n == 1)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool InsertPhanCong(PhanCongDTO phancong)
{
bool result = false;
try
{
//create a list parameter
List <MySqlParameter> parameters = new List <MySqlParameter>();
//parameters.Add(new MySqlParameter("@MaTK", taikhoan.MaTK));
parameters.Add(new MySqlParameter("@MaPC", phancong.MaPC));
parameters.Add(new MySqlParameter("@ThoiGian", phancong.ThoiGian));
parameters.Add(new MySqlParameter("@GhiChu", phancong.GhiChu));
parameters.Add(new MySqlParameter("@FK_MaCV", phancong.MaCV));
parameters.Add(new MySqlParameter("@FK_MaNV", phancong.MaNV));
parameters.Add(new MySqlParameter("@FK_MaDV", phancong.MaDV));
//call store Procedure
int n = MySqlDataAccessHelper.ExecuteNonQuery("INSERT INTO phancong (MaPC, NgayPC, GhiChu, MaCV, MaNV, MaDV) VALUES(@MaPC, @ThoiGian, @GhiChu, @FK_MaCV, @FK_MaNV, @FK_MaDV)", parameters);
if (n == 1)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}