public OutSalesChannel GetSalesChannel() { OutSalesChannel data = new OutSalesChannel(); try { ParametersDAO dao = new ParametersDAO(); data = dao.GetSalesChannel(); } catch (Exception ex) { //escribir en el log LogHelper.WriteLog("Models", "ManagerParameters", "GetSalesChannel", ex, ""); } return(data); }
public OutSalesChannel GetSalesChannel() { string connectionString = DataBaseHelper.GetConnectionString("DLG"); OutSalesChannel response = new OutSalesChannel(); var ora = new OracleServer(connectionString); SalesChannel salesChannel; List <SalesChannel> list = new List <SalesChannel>(); string command = string.Empty; try { command = " SELECT codigo_tipo, nombre_tipo FROM BBS_LIQCOM_V_CNL_VENTA"; var rdr = ora.ExecuteCommand(command); while (rdr.Read()) { salesChannel = new SalesChannel(); salesChannel.Code = DBNull.Value.Equals(rdr["codigo_tipo"]) ? 0 : double.Parse(rdr["codigo_tipo"].ToString()); salesChannel.Name = DBNull.Value.Equals(rdr["nombre_tipo"]) ? string.Empty : rdr["nombre_tipo"].ToString(); list.Add(salesChannel); } rdr.Close(); response.lstSalesChannel = list; response.msg = new Response(); response.msg.errorCode = "200"; response.msg.errorMessage = "OK"; } catch (Exception ex) { throw new Exception("ParametersDAO.GetSalesChannel", ex); } finally { ora.Dispose(); } return(response); }