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