public int addCategory(AMP010 value)
{
using (var conn = new OracleConnection(_connStr))
{
try
{
conn.Open();
using (var cmd = new OracleCommand(Constant.SqlCmd.AMP010.add, conn)
{
CommandType = CommandType.Text
})
{
cmd.Parameters.Add("cate_id", value.cate_id);
cmd.Parameters.Add("cate_name", value.cate_name);
var result = cmd.ExecuteNonQuery();
cmd.Dispose();
return(result);
}
}
catch (Exception e)
{
Console.WriteLine($"Add category by id error => {e.Message}");
return(0);
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
public IHttpActionResult PostAddCategory([FromBody] AMP010 value)
{
try
{
var result = _job.addCategory(value);
return(Ok(result));
}
catch (Exception e)
{
return(InternalServerError(e));
}
}
public AMP010 getCategoryById(string cate_id)
{
using (var conn = new OracleConnection(_connStr))
{
try
{
conn.Open();
using (var cmd = new OracleCommand(Constant.SqlCmd.AMP010.getById, conn)
{
CommandType = CommandType.Text
})
{
cmd.Parameters.Add("cate_id", cate_id);
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
//List<AMP010> data = new List<AMP010>();
reader.Read();
AMP010 data = new AMP010
{
cate_id = reader["CATE_ID"].ToString(),
cate_name = reader["CATE_NAME"].ToString()
};
cmd.Dispose();
reader.Dispose();
return(data);
}
cmd.Dispose();
reader.Dispose();
return(null);
}
}
catch (Exception e)
{
Console.WriteLine($"Get category by id error => {e.Message}");
return(null);
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
