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