public bool ChangeWorkerStatus(PartnerInfoEntity entity)
{
IDbContextTransaction tran = _context.Database.BeginTransaction();
try
{
if (!Utility.CheckUserExists(_context, entity.userId))
{
return(false);
}
var query = from d in _context.M_PARTNER_INFOS
where d.USER_ID == entity.userId
select d;
M_PARTNER_INFO user = query.Single();
user.STATUS = entity.status;
_context.SaveChanges();
// Commit transaction.
tran.Commit();
return(true);
}
catch
{
// Rollback transaction.
tran.Rollback();
return(false);
}
}
/// <summary>
/// Get worker/ company info.
/// </summary>
/// <param name="workerId">Worker Id.</param>
/// <returns>Worker Info Entity</returns>
public static PartnerInfoEntity GetWorkerInfo(AloaiDataContext db, decimal workerId)
{
PartnerInfoEntity workerEntity = new PartnerInfoEntity();
// User info.
var user = from d in db.M_USERS
where d.USER_ID == workerId
select d;
if (user.Any())
{
// Worker info.
var workerInfo = from d in db.M_PARTNER_INFOS
where d.USER_ID == workerId
select d;
if (workerInfo.Any())
{
M_PARTNER_INFO info = workerInfo.Single();
workerEntity.userId = info.USER_ID;
workerEntity.score = info.SCORE.Value;
workerEntity.introduce = info.INTRODUCE;
workerEntity.fitLocationFlg = info.FIX_LOCATION_FLG;
Location loc = new Location();
loc.longitude = info.LONGITUDE;
loc.latitude = info.LATITUDE;
loc.address = info.ADDRESS;
workerEntity.location = loc;
workerEntity.verifyFlg = info.VERIFY_FLG;
workerEntity.verifyDate = info.VERIFY_DATE;
workerEntity.verifyDateFrom = info.VERIFY_DATE_FROM;
workerEntity.verifyDateTo = info.VERIFY_DATE_TO;
workerEntity.likeNum = info.LIKE_NUM;
workerEntity.status = info.STATUS;
workerEntity.regDatetime = info.REG_DATETIME;
workerEntity.updDatetime = info.UPD_DATETIME;
}
}
return(workerEntity);
}
