/// <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)); }