public StatusExternal Get(int id, string lang)
{
statusExternal = dbConnection.GetStatusExternalByStatusCode(id, lang);
return statusExternal;
}
public StatusExternal GetStatusExternalByStatusCode(int id, string lang)
{
var externalStatus = new StatusExternal();
string commandText = "SELECT * FROM DPD_ONLINE_OWNER.WQRY_STATUS_EXTERNAL WHERE EXTERNAL_STATUS_CODE = " + id;
using (
OracleConnection con = new OracleConnection(DpdDBConnection))
{
OracleCommand cmd = new OracleCommand(commandText, con);
try
{
con.Open();
using (OracleDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
var item = new StatusExternal();
item.external_status_code = dr["EXTERNAL_STATUS_CODE"] == DBNull.Value ? 0 : Convert.ToInt32(dr["EXTERNAL_STATUS_CODE"]);
item.inactive_date = dr["INACTIVE_DATE"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(dr["INACTIVE_DATE"]);
if (lang.Equals("fr"))
{
item.external_status_name = dr["EXTERNAL_STATUS_FRENCH"] == DBNull.Value ? string.Empty : dr["EXTERNAL_STATUS_FRENCH"].ToString().Trim();
}
else
{
item.external_status_name = dr["EXTERNAL_STATUS_ENGLISH"] == DBNull.Value ? string.Empty : dr["EXTERNAL_STATUS_ENGLISH"].ToString().Trim();
}
externalStatus = item;
}
}
}
}
catch (Exception ex)
{
string errorMessages = string.Format("DbConnection.cs - GetStatusExternalByStatusCode()");
ExceptionHelper.LogException(ex, errorMessages);
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}
}
return externalStatus;
}
