/// <summary>
/// Hàm chuyển dữ liệu trả về từ DataBase kiểu MySqlDataReader thành Jobposition
/// </summary>
/// CreatedBy: NDVIET
/// CreatedDate: 23/11/2020
/// <param name="reader">một biến kiểu MySqlDataReader</param>
/// <returns>Danh sách chức danh chức vụ </returns>
public static List <Jobposition> ReaderToJobposition(dynamic reader)
{
List <Jobposition> _result = new List <Jobposition>();
while (reader.Read())
{
Jobposition _jobposition = new Jobposition();
_jobposition.JobPositionId = Guid.Parse(reader["jobPositionID"].ToString());
_jobposition.JobPositionName = reader["jobPositionName"].ToString();
_jobposition.CreatedDate = DateTime.Parse(reader["createdDate"].ToString());
if (reader["modifiedDate"].ToString() != "")
{
_jobposition.ModifiedDate = DateTime.Parse(reader["modifiedDate"].ToString());
}
_result.Add(_jobposition);
}
if (_result.Count == 0)
{
return(null);
}
return(_result);
}
public Jobposition UpdateEntity(Jobposition entity, string oldJobpositionId, string oganizationType)
{
var tmp = Convertor.ReaderToJobposition(this.dBContext.ExecuteSQL("call Proc_Organizationtypejobposition_Update('" + oganizationType + "','" + oldJobpositionId + "','" + entity.JobPositionId + "','" + entity.JobPositionName + "')"));
if (tmp == null)
{
return(null);
}
else
{
return(tmp[0]);
}
}
public ActionServiceResult Post([FromBody] Jobposition entity, [FromQuery] String organizationTypeId)
{
dynamic tmp = null;
if (organizationTypeId == "" || organizationTypeId == null)
{
// tmp = new JobpositionBL().InsertEntity(entity);
}
else
{
//tmp = new OrganizationtypejobpositionBL(organizationTypeId).InsertEntity(entity);
}
if (tmp == null)
{
return(new ActionServiceResult("", Message.ErrorMess, Common.Code.Exception, tmp));
}
else
{
return(new ActionServiceResult("", Message.SuccessMess, Common.Code.Success, tmp));
}
}
public ActionServiceResult Put(Guid id, [FromBody] Jobposition entity, [FromQuery] String organizationTypeId)
{
dynamic tmp = null;
if (organizationTypeId == "" || organizationTypeId == null)
{
entity.JobPositionId = id;
tmp = new JobpositionBL().UpdateEntity(entity);
}
else
{
tmp = new OrganizationtypejobpositionBL(organizationTypeId).UpdateEntity(entity, id.ToString());;
}
if (tmp == null)
{
return(new ActionServiceResult("", Message.ErrorMess, Common.Code.Exception, tmp));
}
else
{
return(new ActionServiceResult("", Message.SuccessMess, Common.Code.Success, tmp));
}
}
public Jobposition UpdateEntity(Jobposition entity, string oldJobpositionId)
{
return(_organizationtypejobposition.UpdateEntity(entity, oldJobpositionId, OganizationType));
}
public Jobposition InsertEntity(Jobposition entity)
{
return(_organizationtypejobposition.InsertEntity(entity, OganizationType));
}
