public IHttpActionResult PostUpdateJob([FromBody] m_Job value) { try { var result = _job.updateJob(value); return(Ok(result)); } catch (Exception e) { return(InternalServerError(e)); } }
public int addJob(m_Job value) { using (var conn = new OracleConnection(_connStr)) { try { conn.Open(); if (value.created_by != null) { value.created_by = value.created_by.ToUpper(); } using (var cmd = new OracleCommand(Constant.SqlCmd.AMP100.add, conn) { CommandType = CommandType.Text }) { cmd.Parameters.Add("job_date", value.job_date); cmd.Parameters.Add("job_desc", value.job_desc); cmd.Parameters.Add("solution", value.solution); cmd.Parameters.Add("dept_id", value.dept_id); cmd.Parameters.Add("sect_id", value.sect_id); cmd.Parameters.Add("device_no", value.device_no); cmd.Parameters.Add("created_by", value.created_by); cmd.Parameters.Add("job_status", value.job_status); cmd.Parameters.Add(new OracleParameter { ParameterName = ":job_id", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.Output }); var result = cmd.ExecuteNonQuery(); cmd.Dispose(); return(Int32.Parse(cmd.Parameters[":job_id"].Value.ToString())); } } catch (Exception e) { Console.WriteLine($"Add job by id error => {e.Message}"); return(0); } finally { conn.Close(); conn.Dispose(); } } }
public int updateJob(m_Job value) { using (var conn = new OracleConnection(_connStr)) { try { conn.Open(); if (value.created_by != null) { value.created_by = value.created_by.ToUpper(); } using (var cmd = new OracleCommand(Constant.SqlCmd.AMP100.update, conn) { CommandType = CommandType.Text }) { cmd.Parameters.Add("job_date", value.job_date); cmd.Parameters.Add("job_desc", value.job_desc); cmd.Parameters.Add("solution", value.solution); cmd.Parameters.Add("dept_id", value.dept_id); cmd.Parameters.Add("sect_id", value.sect_id); cmd.Parameters.Add("device_no", value.device_no); cmd.Parameters.Add("created_by", value.created_by); cmd.Parameters.Add("job_status", value.job_status); cmd.Parameters.Add("job_id", value.job_id); var result = cmd.ExecuteNonQuery(); cmd.Dispose(); return(result); } } catch (Exception e) { Console.WriteLine($"Update job by id error => {e.Message}"); return(0); } finally { conn.Close(); conn.Dispose(); } } }
public IHttpActionResult PostAddJob([FromBody] m_Job value) { try { var result = _job.addJob(value); if (result > 0) { if (value.cate_id != null) { m_JobGroup group = new m_JobGroup(); group.job_id = result; group.cate_id = value.cate_id.ToArray(); var res = _job.addJobGroup(group); return(Ok(result)); } } return(Ok(result)); } catch (Exception e) { return(InternalServerError(e)); } }