/// <summary>
/// Get define entity
/// </summary>
/// <param name="controlName">Control name</param>
/// <returns>Define entity</returns>
public static DefineEntity GetDefineValue(string controlName)
{
string sql = "SELECT * FROM M_DEFINE WHERE CONTROL_NAME = '" + controlName + "'";
DataTable data = SqlHelper.FillData(sql);
DefineEntity entity = new DefineEntity();
if (data.Rows.Count > 0)
{
entity.controlName = controlName;
entity.dataType = decimal.Parse(data.Rows[0]["DATA_TYPE"].ToString());
entity.value = data.Rows[0]["VALUE"].ToString();
entity.memo = data.Rows[0]["MEMO"].ToString();
}
return(entity);
}
public ActionResult GetCommonList()
{
List <M_DEFINE> emps = _context.M_DEFINES.ToList();
List <DefineEntity> list = new List <DefineEntity>();
foreach (M_DEFINE denfine in emps)
{
DefineEntity entity = new DefineEntity();
entity.controlName = denfine.CONTROL_NAME;
entity.dataType = denfine.DATA_TYPE;
entity.value = denfine.VALUE;
entity.memo = denfine.MEMO;
list.Add(entity);
}
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = list
}));
}
public ActionResult GetCommonList(string language)
{
CommonEntity commonEntity = new CommonEntity();
List <M_DEFINE> emps = _context.M_DEFINES.ToList();
List <DefineEntity> list = new List <DefineEntity>();
foreach (M_DEFINE denfine in emps)
{
DefineEntity entity = new DefineEntity();
entity.controlName = denfine.CONTROL_NAME;
entity.dataType = denfine.DATA_TYPE;
entity.value = denfine.VALUE;
entity.memo = denfine.MEMO;
list.Add(entity);
}
commonEntity.commonList = list;
var query2 = from d in _context.M_UNITS
where d.DELETE_FLG == 0 &&
d.SHOW_FLG == (int)ShowFlg.Show
orderby d.DISP_ORDER ascending
select d;
List <M_UNIT> empsUnit = query2.ToList();
List <UnitEntity> unitList = new List <UnitEntity>();
foreach (M_UNIT unit in empsUnit)
{
UnitEntity unitEntity = new UnitEntity();
unitEntity.cd = unit.UNIT_CD;
if (string.IsNullOrEmpty(language) || language.Equals(Constant.LANGUAGE_VN))
{
unitEntity.name = unit.UNIT_NAME;
}
else
{
unitEntity.name = unit.UNIT_NAME_EN;
}
unitEntity.dispOrder = unit.DISP_ORDER;
unitList.Add(unitEntity);
}
commonEntity.unitList = unitList;
var query3 = from d in _context.M_CATALOGS
where d.DELETE_FLG == Constant.USING_FLG &&
d.SHOW_FLG == (int)ShowFlg.Show
orderby d.DISP_ORDER ascending
select d;
List <M_CATALOG> empsCatalog = query3.ToList();
List <CatalogEntity> catalogList = new List <CatalogEntity>();
foreach (M_CATALOG catalog in empsCatalog)
{
CatalogEntity entity = new CatalogEntity();
entity.cd = catalog.CATALOG_CD;
if (string.IsNullOrEmpty(language) || language.Equals(Constant.LANGUAGE_VN))
{
entity.name = catalog.CATALOG_NAME;
}
else
{
entity.name = catalog.CATALOG_NAME_EN;
}
entity.dispOrder = catalog.DISP_ORDER;
catalogList.Add(entity);
}
commonEntity.catalogList = catalogList;
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = commonEntity
}));
}
public ActionResult GetEstimationByPartner([FromRoute] decimal id)
{
DefineEntity define = Utility.GetDefineValue(Constant.COMMENT_NUMBER_MAX);
List <ReviewEntity> entityList = new List <ReviewEntity>();
M_USER user = _context.M_USERS.FirstOrDefault(x => x.USER_ID == id);
List <D_REVIEW> estimationList = new List <D_REVIEW>();
var query = from d in _context.D_REVIEWS
join c in _context.V_CONTACT_INFOS on d.CONTACT_ID equals c.CONTACT_ID
where c.WORKER_ID == id &&
d.REVIEW_MODE_USER == (int)Mode.Hirer
orderby d.REVIEW_DATE descending
select d;
if (!query.Any())
{
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = null
}));
}
estimationList = query.ToList();
foreach (D_REVIEW estimation in estimationList)
{
ReviewEntity entity = new ReviewEntity();
entity.reviewId = estimation.REVIEW_ID;
entity.contactId = estimation.CONTACT_ID;
entity.reviewUserId = estimation.REVIEW_USER_ID;
entity.reviewModeUser = estimation.REVIEW_MODE_USER;
entity.reviewDate = estimation.REVIEW_DATE;
entity.score = estimation.SCORE;
entity.comment = estimation.COMMENT;
var queryName = from d in _context.M_USERS
where d.USER_ID == estimation.REVIEW_USER_ID
select d.NAME;
if (queryName.Any())
{
entity.reviewUserName = queryName.Single();
}
entityList.Add(entity);
if (entityList.Count == int.Parse(define.value))
{
break;
}
}
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = entityList
}));
}
