public IList <AppSettingsData> GetRelatedDataCount(IList <AppSettingsData> oAppSettingParams)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("sw_sp_get_screen_desc_count", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("as_uwbi", oAppSettingParams.ElementAt(0).uwbi);
objCmd.Parameters.AddWithValue("as_level", oAppSettingParams.ElementAt(0).RowLevel);
objCmd.Parameters.AddWithValue("as_module", oAppSettingParams.ElementAt(0).ScreenModule);
objCmd.Parameters.AddWithValue("as_user", oAppSettingParams.ElementAt(0).UserName);
objCmd.Parameters.Add("p_cur_screen_desc", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> AppSettingsTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.uwbi = oAppSettingParams.ElementAt(0).uwbi;
OutTemp.ScreenCode = dr["SCREEN_CODE"].ToString();
OutTemp.ScreenName = dr["SCREEN_NAME"].ToString();
OutTemp.RowLevel = oAppSettingParams.ElementAt(0).RowLevel;
OutTemp.ColorCode = dr["MENU_COLOR"].ToString();
AppSettingsTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
AppSettingsTemp.Cast <AppSettingsData>().ToList();
return(AppSettingsTemp);
}
/// <summary>
/// THIS IS TO PULL THE ALL SCREEN NAMES FOR GIVEN MODULE DC/DV.
/// </summary>
/// <param name="ScreenModule"></param>
/// <returns></returns>
public IList <AppSettingsData> GetScreenList(string ScreenModule)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("sw_pkg_user.p_get_screen_list", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("as_module", ScreenModule);
objCmd.Parameters.Add("p_cur_screen", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> CodesTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.ScreenModule = ScreenModule;///this is used while saving screen data from user profile data
OutTemp.ScreenCode = Convert.ToString(dr["SCREEN_CODE"]);
OutTemp.ScreenName = Convert.ToString(dr["SCREEN_NAME"]);
CodesTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
CodesTemp.Cast <AppSettingsData>().ToList();
return(CodesTemp);
}
public IList <AppSettingsData> GetResUnitCode(int FiledCode)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("sw_pkg_system_setting.p_get_reservoir_unit_code", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("an_field_code", FiledCode);
objCmd.Parameters.Add("p_cur_codes", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> CodesTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.PickCode = Convert.ToString(dr["PICK_CODE"]);
OutTemp.PickName = Convert.ToString(dr["PICK_NAME"]);
OutTemp.ResUnitCode = Convert.ToString(dr["RES_UNIT_CODE"]);
OutTemp.ResUnitName = Convert.ToString(dr["RES_UNIT_NAME"]);
OutTemp.UpdateBy = Convert.ToString(dr["UPDATE_BY"]);
OutTemp.UpdateDate = Convert.ToString(dr["UPDATE_DATE"]);
CodesTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
CodesTemp.Cast <AppSettingsData>().ToList();
return(CodesTemp);
}
public IList <AppSettingsData> GetUserRight(string UserId, string ScreenModule)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("sw_pkg_user.p_get_user_right", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("an_user_id", UserId);
objCmd.Parameters.AddWithValue("as_module", ScreenModule);
objCmd.Parameters.Add("p_user_right", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> CodesTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.ScreenCode = Convert.ToString(dr["SCREEN_CODE"]);
CodesTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
CodesTemp.Cast <AppSettingsData>().ToList();
return(CodesTemp);
}
public IList <AppSettingsData> GetFields(string CountryCode)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("sw_sp_Get_Fields", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("p_CountryCode", OracleType.VarChar).Value = CountryCode;
objCmd.Parameters.Add("p_cur_Fields", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> FieldsTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.FieldCode = dr["FIELD_CODE"].ToString();
OutTemp.FieldName = dr["FIELD_NAME"].ToString();
OutTemp.FieldShortName = dr["FIELD_SHORT_NAME"].ToString();
OutTemp.UpdateBy = dr["UPDATE_BY"].ToString();
OutTemp.UpdateDate = dr["UPDATE_DATE"].ToString();
// OutTemp.IsDataChecked = true;
FieldsTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
FieldsTemp.Cast <AppSettingsData>().ToList();
return(FieldsTemp);
}
public IList <AppSettingsData> GetRoles()
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("sw_pkg_user.p_get_role", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("p_cur_role", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> CodesTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.RoleId = Convert.ToString(dr["ROLE_ID"]);
OutTemp.RoleName = Convert.ToString(dr["ROLE_NAME"]);
OutTemp.AccessFlag = false;
CodesTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
CodesTemp.Cast <AppSettingsData>().ToList();
return(CodesTemp);
}
public IList <AppSettingsData> GetCodes(string GroupName, string parent)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("ld_pkg_system_setting.p_get_drop_down_list", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("as_group_name", Convert.ToString(GroupName));
objCmd.Parameters.AddWithValue("as_parent", Convert.ToString(parent));
objCmd.Parameters.Add("p_cur_codes", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> CodesTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.CodesCode = Convert.ToString(dr["CODE"]);
OutTemp.CodeDescription = Convert.ToString(dr["DESCRIPTION"]);
OutTemp.GroupName = Convert.ToString(dr["GROUP_NAME"]);
OutTemp.CodeActive = Convert.ToString(dr["CODE_ACTIVE"]).Equals("Y");
OutTemp.DisplaySeq = Convert.ToInt16(dr["DISPLAY_SEQ"].ToString());
CodesTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
CodesTemp.Cast <AppSettingsData>().ToList();
return(CodesTemp);
}
public IList <AppSettingsData> GetCodeList(string GroupName)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("ld_pkg_system_setting.p_get_code_list", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("as_group_name", OracleType.VarChar).Value = GroupName;
objCmd.Parameters.Add("p_cur_codes", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> CodesTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.Parent_Flag = Convert.ToString(dr["parent_flag"]);
OutTemp.GroupName = Convert.ToString(dr["GROUP_NAME"]);
OutTemp.CodesCode = dr["code"].ToString();
OutTemp.CodeActive = dr["code_active"].ToString().Equals("Y");
OutTemp.CodeDescription = dr["description"].ToString();
OutTemp.DisplaySeq = Convert.ToInt16(dr["display_seq"].ToString());
OutTemp.Parent_Code = dr["parent_code"].ToString();
CodesTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
CodesTemp.Cast <AppSettingsData>().ToList();
return(CodesTemp);
}
/// <summary>
/// Initializes the singleton application object. This is the first line of authored code
/// executed, and as such is the logical equivalent of main() or WinMain().
/// </summary>
public App()
{
AppSettingsData.AppSettingsDataInit();
viewModel = new ViewModel();
this.InitializeComponent();
this.Suspending += OnSuspending;
}
void StartGettingFeed(Frame frame)
{
getWeatherReportsSource = new CancellationTokenSource();
CancellationToken WRtoken = getWeatherReportsSource.Token;
getTweetsSource = new CancellationTokenSource();
CancellationToken TweetsToken = getTweetsSource.Token;
AppDataManager.viewModel = viewModel;
getWeatherReportsTask = new Task(async() =>
{
viewModel.LoadReportCache = await AppDataManager.RestoreFromLocalCacheAsync <ObservableCollection <WeatherReport> >("reports");
while (!WRtoken.IsCancellationRequested)
{
await frame.Dispatcher.RunAsync(CoreDispatcherPriority.Normal,
async() =>
{
viewModel.ReportsList = await FeedFetch.GetWeatherFeedAsync(AppSettingsData.GetReportQuery);
await AppDataManager.SaveToLocalCacheAsync <ObservableCollection <WeatherReport> >
(viewModel.ReportsList, AppSettingsData.reportsFileName);
});
WRtoken.WaitHandle.WaitOne(AppSettingsData.UpdatesIntervalMsec);
}
});
getTweetsTask = new Task(async() =>
{
while (!TweetsToken.IsCancellationRequested)
{
AppSettingsData.TweetsToLoad = await AppSettingsData.LoadTweets();
await frame.Dispatcher.RunAsync(CoreDispatcherPriority.Normal,
async() =>
{
viewModel.TweetList = await FeedFetch.GetTweetsAsync(AppSettingsData.TweetsToLoad);
});
TweetsToken.WaitHandle.WaitOne(AppSettingsData.UpdatesIntervalMsec);
}
});
getWeatherReportsTask.Start();
getTweetsTask.Start();
}
public string SaveUserSession(AppSettingsData oSessionData)
{
using (OracleConnection objConn = new OracleConnection(connectionString))
{
objConn.Open();
if (oSessionData != null)
{
// in number, as_user_id in varchar2, in varchar2,
OracleCommand objCmd = new OracleCommand("sw_pkg_user.p_insupd_user_session", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("as_user_id", oSessionData.UserName);
objCmd.Parameters.AddWithValue("an_session_id", oSessionData.SessionId);
objCmd.Parameters.AddWithValue("as_module", oSessionData.ModuleName);
objCmd.Parameters.AddWithValue("as_mversion", oSessionData.VersionNumber);
objCmd.ExecuteNonQuery();
}
objConn.Close();
}
return("");
}
public IList <AppSettingsData> GetAuditTrailData(AppSettingsData oAuditTrial)
{
DataTable dtList = new DataTable();
using (OracleConnection objConn = new OracleConnection(connectionString))
{
OracleCommand objCmd = new OracleCommand("sw_pkg_user.p_get_audit_trail", objConn);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("as_user", oAuditTrial.UserId);
objCmd.Parameters.AddWithValue("adt_from", oAuditTrial.AuditTrailFrom);
objCmd.Parameters.AddWithValue("adt_to", oAuditTrial.AuditTrailTo);
objCmd.Parameters.Add("p_cur_audit", OracleType.Cursor).Direction = ParameterDirection.Output;
objConn.Open();
dtList.Load(objCmd.ExecuteReader());
objConn.Close();
}
AppSettingsData OutTemp = new AppSettingsData();
List <AppSettingsData> CodesTemp = new List <AppSettingsData>();
foreach (DataRow dr in dtList.Rows)
{
OutTemp.UserId = Convert.ToString(dr["USER_ID"]);
OutTemp.uwbi = Convert.ToString(dr["UWBI"]);
OutTemp.TableName = Convert.ToString(dr["TABLE_NAME"]);
OutTemp.ColumnName = Convert.ToString(dr["COL_NAME"]);
//OutTemp.TablePKey = Convert.ToString(dr["TABLE_PKEY"]);
//OutTemp.TablePKeyValue = Convert.ToString(dr["TABLE_PKEY_VALUE"]);
OutTemp.TransDate = Convert.ToString(dr["TRANS_DATE"]);
OutTemp.OperationType = Convert.ToString(dr["OPR_TYPE"]);
OutTemp.OldValue = Convert.ToString(dr["OLD_VALUE"]);
OutTemp.NewValue = Convert.ToString(dr["NEW_VALUE"]);
CodesTemp.Add(OutTemp);
OutTemp = new AppSettingsData();
}
CodesTemp.Cast <AppSettingsData>().ToList();
return(CodesTemp);
}
public void simply_pull_data()
{
AppSettingsData.GetValue("FakeSettings.Name").ShouldEqual("Cedric");
}
