public async Task <MyServiceResult> CapNhat(string maMinhChung, CapNhatMinhChungDPEntity model)
{
try
{
if (string.IsNullOrWhiteSpace(maMinhChung))
{
return(new MyServiceResult
{
Successed = false,
Content = "Lỗi cập nhật Minh chứng"
});
}
if (model is null)
{
return(new MyServiceResult
{
Successed = false,
Content = "Lỗi cập nhật Minh chứng"
});
}
IDbConnection dbConnection = _IMyDapper.GetConnection();
if (dbConnection.State == ConnectionState.Closed)
{
dbConnection.Open();
}
using (IDbTransaction dbTransaction = dbConnection.BeginTransaction())
{
try
{
MinhChungDPEntity objMinhChungDPEntity = await dbConnection.QueryFirstOrDefaultAsync <MinhChungDPEntity>("[LayMinhChungTheoMa]", new { @MaMinhChung = maMinhChung }, transaction : dbTransaction, commandType : CommandType.StoredProcedure);
if (objMinhChungDPEntity is null)
{
return(new MyServiceResult
{
Successed = false,
Content = "Không tìm thấy Minh chứng"
});
}
int effectedRows = await dbConnection.ExecuteAsync("[CapNhatMinhChung]", new { @MaMinhChung = maMinhChung, @SoKyHieu = model.SoKyHieu, @TrichYeu = model.TrichYeu, @CoQuanBanHanh = model.CoQuanBanHanh, @NoiNhanCacVanBan = model.NoiNhanCacVanBan, @NoiLuuBanChinh = model.NoiLuuBanChinh, @MucDo = model.MucDo, @NguoiKyVanBan = model.NguoiKyVanBan, @SoPhatHanh = model.SoPhatHanh, @LinhVucVanBan = model.LinhVucVanBan, @LoaiVanBan = model.LoaiVanBan, @MaNguoiTao = model.MaNguoiTao, @MaTieuChi = model.MaTieuChi, @MaTieuChuan = model.MaTieuChuan }, transaction : dbTransaction, commandType : CommandType.StoredProcedure);
dbTransaction.Commit();
if (effectedRows > 0)
{
return(new MyServiceResult
{
Successed = true,
Content = $"Cập nhật thành công Minh chứng {objMinhChungDPEntity.MaMinhChung}"
});
}
else
{
return(new MyServiceResult
{
Successed = false,
Content = $"Cập nhật thất bại Minh chứng {objMinhChungDPEntity.MaMinhChung}"
});
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
return(new MyServiceResult
{
Successed = false,
Content = ex.Message
});
}
}
}
catch (Exception ex)
{
return(new MyServiceResult
{
Successed = false,
Content = ex.Message
});
}
}
public async Task <MyServiceResult> Xoa(string maMinhChung)
{
try
{
if (string.IsNullOrWhiteSpace(maMinhChung))
{
return(new MyServiceResult
{
Successed = false,
Content = "Lỗi xoá Minh chứng"
});
}
IDbConnection dbConnection = _IMyDapper.GetConnection();
if (dbConnection.State == ConnectionState.Closed)
{
dbConnection.Open();
}
using (IDbTransaction dbTransaction = dbConnection.BeginTransaction())
{
try
{
MinhChungDPEntity objMinhChungDPEntity = await dbConnection.QueryFirstOrDefaultAsync <MinhChungDPEntity>("[LayMinhChungTheoMa]", new { @MaMinhChung = maMinhChung }, transaction : dbTransaction, commandType : CommandType.StoredProcedure);
if (objMinhChungDPEntity is null)
{
return(new MyServiceResult
{
Successed = false,
Content = "Không tìm thấy Minh chứng"
});
}
int effectedRows = await dbConnection.ExecuteAsync("[XoaMinhChung]", new { @MaMinhChung = maMinhChung }, transaction : dbTransaction, commandType : CommandType.StoredProcedure);
dbTransaction.Commit();
if (effectedRows > 0)
{
return(new MyServiceResult
{
Successed = true,
Content = $"Xoá thành công Minh chứng {objMinhChungDPEntity.MaTieuChuan}"
});
}
else
{
return(new MyServiceResult
{
Successed = false,
Content = $"Xoá thất bại Minh chứng {objMinhChungDPEntity.MaTieuChuan}"
});
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
return(new MyServiceResult
{
Successed = false,
Content = ex.Message
});
}
}
}
catch (Exception ex)
{
return(new MyServiceResult
{
Successed = false,
Content = ex.Message
});
}
}
public async Task <MyServiceObjectResult <MinhChungDPEntity> > LayTheoMa(string maMinhChung)
{
try
{
if (string.IsNullOrWhiteSpace(maMinhChung))
{
return(new MyServiceObjectResult <MinhChungDPEntity>
{
Successed = false,
Content = "Lỗi lấy Minh chứng"
});
}
IDbConnection dbConnection = _IMyDapper.GetConnection();
if (dbConnection.State == ConnectionState.Closed)
{
dbConnection.Open();
}
using (IDbTransaction iDbTransaction = dbConnection.BeginTransaction())
{
try
{
MinhChungDPEntity objMinhChungDPEntity = await dbConnection.QueryFirstOrDefaultAsync <MinhChungDPEntity>("[LayMinhChungTheoMa]", new { @MaMinhChung = maMinhChung }, transaction : iDbTransaction, commandType : CommandType.StoredProcedure);
iDbTransaction.Commit();
if (objMinhChungDPEntity is null)
{
return(new MyServiceObjectResult <MinhChungDPEntity>
{
Successed = false,
Content = "Không tìm thấy Minh chứng",
Object = null
});
}
else
{
return(new MyServiceObjectResult <MinhChungDPEntity>
{
Successed = true,
Content = "Lấy Minh chứng thành công",
Object = objMinhChungDPEntity
});
}
}
catch (Exception ex)
{
iDbTransaction.Rollback();
return(new MyServiceObjectResult <MinhChungDPEntity>
{
Successed = false,
Content = ex.Message
});
}
}
}
catch (Exception ex)
{
return(new MyServiceObjectResult <MinhChungDPEntity>
{
Successed = false,
Content = ex.Message
});
}
}
