/// <summary> /// Method to Get Menus. /// </summary> /// <param name="argEn">Menu Entity is an Input.MenuID is an Input Property</param> /// <returns>List of Menu Entity</returns> public ConnectionEn GetConnectionString(ConnectionEn argEn) { ConnectionEn loEnList = new ConnectionEn(); string sqlCmd = "select CF_Conn from SAS_CF where CF_Code ='" + argEn.Code + "'"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { loEnList = LoadObject(loReader); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Load Kolej Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns Kolej Entity</returns> private ConnectionEn LoadObject(IDataReader argReader) { ConnectionEn loItem = new ConnectionEn(); loItem.ConnectionStrings = GetValue <string>(argReader, "CF_Conn"); return(loItem); }
/// <summary> /// Method to Get ConnectionString. /// </summary> /// <param name="argEn">Menu Entity is an Input.MenuID is an Input Property</param> /// <returns>List of Menu Entity</returns> public ConnectionEn GetConnectionString(ConnectionEn argEn) { try { ConnectionDAL loDs = new ConnectionDAL(); return(loDs.GetConnectionString(argEn)); } catch (Exception ex) { throw ex; } }