/// <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;
}
}
