public void ChuyenObjectBDOThanhObjectDTO(BaiSanPhamBDO objBDO, BaiSanPhamModel objDTO) { Mapper.Initialize(cfg => cfg.AddProfile <BaiSanPhamBDOBaiSanPhamModelProfile>()); //Khác null 2 cái tạo liền if (objBDO != null && objDTO != null) { objDTO = Mapper.Map <BaiSanPhamModel>(objBDO); } }
public void Sua(BaiSanPhamBDO entityBDO) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(tenDB))) { var p = new DynamicParameters(); //Của dapper p.Add("@id", entityBDO.Id); p.Add("@SoDonHang", entityBDO.SoDonHang); p.Add("@TenSanPham", entityBDO.TenSanPham); p.Add("@YeuCau", entityBDO.YeuCau); p.Add("@DuongDanFile01", entityBDO.DuongDanFile01); p.Add("@DuongDanFile02", entityBDO.DuongDanFile02); p.Add("@DuongDanFile03", entityBDO.DuongDanFile03); p.Add("@TinhTrangBaiSanPham", entityBDO.TinhTrangBaiSanPham); p.Add("@ThoiHan", entityBDO.ThoiHan); //Excecute connection.Execute("dbo.spBaiSanPham_SuaTheoId", p, commandType: CommandType.StoredProcedure); } }
public void Them(BaiSanPhamBDO entityBDO) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(tenDB))) { var p = new DynamicParameters(); //Của dapper p.Add("@SoDonHang", entityBDO.SoDonHang); p.Add("@TenSanPham", entityBDO.TenSanPham); p.Add("@YeuCau", entityBDO.YeuCau); p.Add("@DuongDanFile01", entityBDO.DuongDanFile01); p.Add("@DuongDanFile02", entityBDO.DuongDanFile02); p.Add("@DuongDanFile03", entityBDO.DuongDanFile03); p.Add("@TinhTrangBaiSanPham", entityBDO.TinhTrangBaiSanPham); p.Add("@ThoiHan", entityBDO.ThoiHan); p.Add("@id", dbType: DbType.Int32, direction: ParameterDirection.Output); //Excecute connection.Execute("dbo.spBaiSanPham_Them", p, commandType: CommandType.StoredProcedure); //xử lý id out entityBDO.Id = p.Get <int>("@id"); ///nếu cần có thể ///đặt return ở đay cũng được } }
public void Sua(BaiSanPhamBDO baiSP) { dataDAO.Sua(baiSP); }
public void Them(BaiSanPhamBDO baiSP) { dataDAO.Them(baiSP); }