public LicenceType Get(string code, string lang = "")
{
DBConnection dbConnection = new DBConnection(lang);
_licenceType = dbConnection.GetLicenceTypeByCode(code);
return(_licenceType);
}
public LicenceType GetLicenceTypeByCode(string code)
{
var type = new LicenceType();
string commandText = "SELECT LICENCE_TYPE_CD, ";
if (Lang.Equals("fr"))
{
commandText += " LICENCE_TYPE_DESC_F AS LICENCE_TYPE_DESC";
}
else {
commandText += " LICENCE_TYPE_DESC_E AS LICENCE_TYPE_DESC";
}
commandText += " FROM PUB_ACS.PAS_LICENCE_TYPE";
commandText += " WHERE LICENCE_TYPE_CD = '" + code.Trim() + "'";
using ( OracleConnection con = new OracleConnection(MdallDBConnection))
{
OracleCommand cmd = new OracleCommand(commandText, con);
try
{
con.Open();
using (OracleDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
var item = new LicenceType();
item.licence_type_cd = dr["LICENCE_TYPE_CD"] == DBNull.Value ? string.Empty : dr["LICENCE_TYPE_CD"].ToString().Trim();
item.licence_type_desc = dr["LICENCE_TYPE_DESC"] == DBNull.Value ? string.Empty : dr["LICENCE_TYPE_DESC"].ToString().Trim();
type = item;
}
}
}
}
catch (Exception ex)
{
string errorMessages = string.Format("DbConnection.cs - GetLicenceTypeByCode()");
ExceptionHelper.LogException(ex, errorMessages);
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}
}
return type;
}
public LicenceType Get(string code, string lang = "")
{
DBConnection dbConnection = new DBConnection(lang);
_licenceType = dbConnection.GetLicenceTypeByCode(code);
return _licenceType;
}
