//[Route("GetEmployeeProfile")]
//[HttpGet]
public IHttpActionResult GetEmployeeProfile(getCustomerDetail gorder)
{
// OracleConnection _connection = new Oracle.DataAccess.Client.OracleConnection("DATA SOURCE = localhost:1521 / XE; User ID = SYSTEM; Password = nml; Persist Security Info = True");
// _connection.Open();
// try
// {
// //var result = 0;
// var sql = "Select pressureseal, jackseal, scaanerflatbed Into P_pressureseal, P_jackseal, P_scaanerflatbed from CORDERTABLE where brakecylander =124";
// //String sql = "Select * from CUSTOMERORDER.CORDERTABLE";
// OracleCommand command = new OracleCommand(sql, _connection);
// }
//catch (Exception ex)
// {
// Log.Error("Method in context SaveCustomer(): " + ex.Message);
// }
// _connection.Close();
// //var abc = 124;
// //string result = _customerOrder.GetEmployeeProfile(abc);
// //if (result != null)
// //{
// // return Ok(result);
// //}
// //else
// //{
return(NotFound());
// //}
// return null;
}
public string GetEmployeeProfile(int user)
{
var Obj = new getCustomerDetail();
try
{
var sParameter = new List <OracleParameter>();
sParameter.Add(new OracleParameter {
ParameterName = "@brakecylander", Value = user
});
sParameter.Add(new OracleParameter {
ParameterName = "@pressureseal", Value = -1
});
sParameter.Add(new OracleParameter {
ParameterName = "@jackseal", Value = -1
});
sParameter.Add(new OracleParameter {
ParameterName = "@scaanerflatbed", Value = -1
});
var result = Convert.ToInt32(ADOManager.Instance.DataSet("CUSTOMERORDER.CgetorderProcedure", CommandType.StoredProcedure, sParameter));
return(result > 0 ? DataValidation.success : DataValidation.dbError);
}
catch (Exception ex)
{
Log.Error("Method in context GetEmployeeProfile(): " + ex.Message);
return(null);
}
}