public static List <ChiTietBaoDuongDTO> SelectChiTietBaoDuongByMaHoaDon(String MaHoaDon)
{
List <ChiTietBaoDuongDTO> list = new List <ChiTietBaoDuongDTO>();
try
{
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("@FK_MaHD", MaHoaDon));
DataTable dt = DAO.MySqlDataAccessHelper.ExecuteQuery("SELECT * FROM chitietbaoduong WHERE FK_MaHD = @MaHD", parameters);
foreach (DataRow dr in dt.Rows)
{
ChiTietBaoDuongDTO chiTiet = new ChiTietBaoDuongDTO();
chiTiet.MaCTBD = dr["MaCTBD"].ToString();
chiTiet.MaCV = dr["FK_MaCV"].ToString();
chiTiet.MaDV = dr["FK_MaDV_CTBD"].ToString();
chiTiet.MaPT = dr["FK_MaPT"].ToString();
chiTiet.Phi = int.Parse(dr["Phi"].ToString());
chiTiet.SoLuong = int.Parse(dr["SoLuong"].ToString());
chiTiet.TrangThai = bool.Parse(dr["TrangThai"].ToString());
chiTiet.MaHD = dr["FK_MaHD"].ToString();
chiTiet.DonGia = int.Parse(dr["DonGia"].ToString());
list.Add(chiTiet);
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
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 bool InsertPhanCong()
{
//List<PhanCongDTO> listPhanCong = new List<PhanCongDTO>();
foreach (DataGridViewRow row in congViecdataGridView.Rows)
{
if (bool.Parse(row.Cells["Chọn"].Value.ToString()) == true)
{
PhanCongDTO phancong = new PhanCongDTO();
phancong.MaPC = BUS.PhanCongBUS.GenerateMaPhanCong();
phancong.MaDV = txtMaDV.Text;
phancong.MaNV = BUS.NhanVienBUS.SelectNhanVienByTenNhanVien(row.Cells["Nhân viên"].Value.ToString())[0].MaNV;
phancong.MaCV = (row.Cells["Công việc"].Value.ToString());
phancong.ThoiGian = dtbNgayLapHD.Value;
phancong.GhiChu = row.Cells["Ghi Chú"].Value.ToString();
if (!BUS.PhanCongBUS.InsertPhanCong(phancong))
{
return(false);
}
;
}
else
{
ChiTietBaoDuongDTO chiTiet = new ChiTietBaoDuongDTO
{
MaCTBD = BUS.ChiTietBaoDuongBUS.GenerateMaChiTietBaoDuong(),
MaPT = null,
SoLuong = 0,
DonGia = 0,
Phi = 0,
TrangThai = false,
MaHD = null,
MaCV = row.Cells["Mã CV"].Value.ToString(),
MaDV = txtMaDV.Text
};
}
}
return(true);
}
public bool InsertChiTietBaoDuong()
{
foreach (DataGridViewRow row in phuTungChiTietBDdataGridView.Rows)
{
ChiTietBaoDuongDTO chiTiet = new ChiTietBaoDuongDTO
{
MaCTBD = BUS.ChiTietBaoDuongBUS.GenerateMaChiTietBaoDuong(),
MaPT = row.Cells["MãPT"].Value.ToString(),
SoLuong = int.Parse(row.Cells["Số lượng"].Value.ToString()),
DonGia = int.Parse(row.Cells["Giá"].Value.ToString()),
Phi = int.Parse(row.Cells["Thành tiền"].Value.ToString()),
TrangThai = true,
MaHD = txtMaHD.Text,
MaCV = row.Cells["Mã CV"].Value.ToString(),
MaDV = txtMaDV.Text
};
if (!BUS.ChiTietBaoDuongBUS.InsertChiTietBaoDuong(chiTiet))
{
return(false);
}
;
}
return(true);
}
public static bool InsertChiTietBaoDuong(ChiTietBaoDuongDTO chiTiet)
{
return(DAO.ChiTietBaoDuongDAO.InsertChiTietBaoDuong(chiTiet));
}