protected void GridView_Currency_Sorting(object sender, GridViewSortEventArgs e) { CurrencyMgr myCurrencyMgr = new CurrencyMgr(); GridView_Currency.DataSource = myCurrencyMgr.Get_Currency_OriginRates(_currencyid, e.SortExpression); GridView_Currency.DataBind(); }
protected void lbtn_Edit_Command(object sender, CommandEventArgs e) { if (!DataEval.IsEmptyQuery(e.CommandArgument.ToString())) { CurrencyMgr myCurrencyMgr = new CurrencyMgr(); Currency_Rate myCurrency_Rate = myCurrencyMgr.Get_Currency_Rate(e.CommandArgument.ToString()); lbl_Origin_Currency.Text = myCurrency_Rate.Origin_Currency_Name; lbl_Target_Currency.Text = myCurrency_Rate.Target_Currency_Name; tbx_Exchange_Rate.Text = myCurrency_Rate.Exchange_Rate.ToString(); lbtn_ExchangeRate_Update.CommandArgument = myCurrency_Rate.RateID; Panel_EditExchangeRate.Visible = true; } }
protected void lbtn_Currency_Select_Command(object sender, CommandEventArgs e) { if (!DataEval.IsEmptyQuery(e.CommandArgument.ToString())) { _currencyid = e.CommandArgument.ToString(); ViewState["CurrencyID"] = _currencyid; CurrencyMgr myCurrencyMgr = new CurrencyMgr(); Currency myCurrency = myCurrencyMgr.Get_Currency(_currencyid); lbl_Currency_Name.Text = string.Format("{0} ({1})", myCurrency.Currency_Name, myCurrency.Currency_ShortName); GridView_Currency.DataSource = myCurrencyMgr.Get_Currency_OriginRates(_currencyid); GridView_Currency.DataBind(); } }
protected void lbtn_ExchangeRate_Update_Command(object sender, CommandEventArgs e) { if (Page.IsValid && !DataEval.IsEmptyQuery(e.CommandArgument.ToString())) { CurrencyMgr myCurrencyMgr = new CurrencyMgr(); e2Data[] UpdateData = { new e2Data("RateID", e.CommandArgument.ToString()), new e2Data("Exchange_Rate", tbx_Exchange_Rate.Text), new e2Data("LastUpdate_Date", DateTime.Now.ToString()), new e2Data("LastUpdate_UserID", Security.Users.UserStatus.Current_UserID(this.Page)) }; myCurrencyMgr.Edit_Currency_Rate(UpdateData); Control_Init(); } }
protected void btn_Edit_Currency_Click(object sender, EventArgs e) { if (!DataEval.IsEmptyQuery(_currencyid)) { Control_FillData(); CurrencyMgr myCurrencyMgr = new CurrencyMgr(); Currency myCurrency = myCurrencyMgr.Get_Currency(_currencyid); tbx_EditCurrency_Name.Text = myCurrency.Currency_Name; tbx_EditCurrency_ShortName.Text = myCurrency.Currency_ShortName; tbx_EditCurrency_WebCode.Text = myCurrency.Currency_WebCode; tbx_EditCurrency_Description.Text = myCurrency.Currency_Description; chkbox_EditCurrency_IsActive.Checked = myCurrency.IsActive; btn_EditCurrency_Update.CommandArgument = myCurrency.CurrencyID; MultiView_Currency.SetActiveView(View_Edit); } }
protected void btn_EditCurrency_Update_Command(object sender, CommandEventArgs e) { if (Page.IsValid && !DataEval.IsEmptyQuery(e.CommandArgument.ToString())) { CurrencyMgr myCurrencyMgr = new CurrencyMgr(); e2Data[] UpdateData = { new e2Data("CurrencyID", e.CommandArgument.ToString()), new e2Data("Currency_Name", tbx_EditCurrency_Name.Text), new e2Data("Currency_ShortName", tbx_EditCurrency_ShortName.Text), new e2Data("Currency_WebCode", tbx_EditCurrency_WebCode.Text), new e2Data("Currency_Description", tbx_EditCurrency_Description.Text), new e2Data("IsActive", chkbox_EditCurrency_IsActive.Checked.ToString()) }; myCurrencyMgr.Edit_Currency(UpdateData); Control_FillData(); Control_Init(); } }
static string ProcessEnvironmental() { PSsqmEntities entities = new PSsqmEntities(); SETTINGS setting = null; string nextStep = ""; DateTime toDate = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, 1); DateTime fromDate = toDate.AddMonths(-3); int status = 0; DateTime currencyDate = DateTime.MinValue; WriteLine("ENVIRONMENTAL Rollup Started: " + DateTime.UtcNow.ToString("hh:mm MM/dd/yyyy")); List <SETTINGS> sets = SQMSettings.SelectSettingsGroup("AUTOMATE", ""); // ABW 20140805 try { setting = sets.Where(x => x.SETTING_CD == "ROLLUP_ENV_PERIODSPAN").FirstOrDefault(); if (setting != null) { fromDate = toDate.AddMonths(Convert.ToInt32(setting.VALUE) * -1); } setting = sets.Where(x => x.SETTING_CD == "ROLLUP_ENV_NEXTPAGE").FirstOrDefault(); if (setting != null && !string.IsNullOrEmpty(setting.VALUE) && setting.VALUE.Length > 1) { nextStep = setting.VALUE; } CURRENCY_XREF latestCurrency = CurrencyMgr.GetLatestRecord(entities); if (latestCurrency != null) { currencyDate = new DateTime(latestCurrency.EFF_YEAR, latestCurrency.EFF_MONTH, DateTime.DaysInMonth(latestCurrency.EFF_YEAR, latestCurrency.EFF_MONTH)); } WriteLine("Max Currency Date = " + currencyDate.ToShortDateString()); List <EHSProfile> profileList = new List <EHSProfile>(); foreach (decimal plantID in (from p in entities.EHS_PROFILE select p.PLANT_ID).ToList()) { profileList.Add(new EHSProfile().Load(Convert.ToDecimal(plantID), false, true)); } foreach (EHSProfile profile in profileList) // do each plant having a metric profile { WriteLine(profile.Plant.PLANT_NAME); DateTime periodDate = fromDate; while (periodDate <= toDate) // do each month within the rollup span { WriteLine(" " + periodDate.Year.ToString() + "/" + periodDate.Month.ToString()); if (profile.InputPeriod == null || profile.InputPeriod.PeriodDate != periodDate) { profile.LoadPeriod(periodDate); } if (profile.ValidPeriod()) { if (!profile.InputPeriod.PlantAccounting.APPROVAL_DT.HasValue) { profile.InputPeriod.PlantAccounting.APPROVAL_DT = toDate; profile.InputPeriod.PlantAccounting.APPROVER_ID = 1m; // default to the sysadmin user } status = profile.UpdateMetricHistory(periodDate); // new roll-up logic WriteLine(" ... " + status.ToString()); } periodDate = periodDate.AddMonths(1); } } WriteLine("ENVIRONMENTAL Rollup Completed: " + DateTime.UtcNow.ToString("hh:mm MM/dd/yyyy")); } catch (Exception ex) { WriteLine("ENVIRONMENTAL RollUp Error: " + ex.ToString()); } return(nextStep); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { System.Web.UI.ScriptManager.RegisterStartupScript(this, GetType(), "closePage", "window.onunload = CloseWindow();", true); return; } output = new StringBuilder(); SETTINGS setting = null; bool validIP = true; string pageURI = HttpContext.Current.Request.Url.AbsoluteUri; string nextPage = ""; DateTime toDate = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, 1); DateTime fromDate = toDate.AddMonths(-3); WriteLine("ENV Data Rollup Started: " + DateTime.UtcNow.ToString("hh:mm MM/dd/yyyy")); WriteLine(pageURI); try { string currentIP = GetIPAddress(); List <SETTINGS> sets = SQMSettings.SelectSettingsGroup("AUTOMATE", ""); // ABW 20140805 string strValidIP = sets.Find(x => x.SETTING_CD == "ValidIP").VALUE.ToString(); setting = sets.Where(x => x.SETTING_CD == "ROLLUP_ENV_PERIODSPAN").FirstOrDefault(); if (setting != null) { fromDate = toDate.AddMonths(Convert.ToInt32(setting.VALUE) * -1); } setting = sets.Where(x => x.SETTING_CD == "ROLLUP_ENV_NEXTPAGE").FirstOrDefault(); if (setting != null && !string.IsNullOrEmpty(setting.VALUE) && setting.VALUE.Length > 1) { nextPage = setting.VALUE; } /* * if (strValidIP.Equals(currentIP)) * { * WriteLine("Main Incident RollUp being accessed from a valid IP address " + currentIP); * validIP = true; * * if (Request.QueryString["validation"] != null) * { * if (Request.QueryString["validation"].ToString().Equals("Vb12M11a4")) * validIP = true; * } * else * { * WriteLine("Main Incident RollUp requested from incorrect source."); * validIP = false; * } * } * else * { * WriteLine("Main Incident RollUp being accessed from invalid IP address " + currentIP); * validIP = false; * } */ } catch (Exception ex) { validIP = false; WriteLine("Main ENV Data RollUp Error validating IP Address: " + ex.ToString()); } // make sure this code is NOT moved to production //validIP = true; if (!validIP) { WriteLine("Main ENV Data RollUp Invalid IP Address"); ltrStatus.Text = output.ToString().Replace("\n", "<br/>"); WriteLogFile(); System.Web.UI.ScriptManager.RegisterStartupScript(this, GetType(), "closePage", "window.onunload = CloseWindow();", true); return; } try { PSsqmEntities entities = new PSsqmEntities(); int status = 0; DateTime currencyDate = DateTime.MinValue; CURRENCY_XREF latestCurrency = CurrencyMgr.GetLatestRecord(entities); if (latestCurrency != null) { currencyDate = new DateTime(latestCurrency.EFF_YEAR, latestCurrency.EFF_MONTH, DateTime.DaysInMonth(latestCurrency.EFF_YEAR, latestCurrency.EFF_MONTH)); } WriteLine("Max Currency Date = " + currencyDate.ToShortDateString()); List <EHSProfile> profileList = new List <EHSProfile>(); foreach (decimal plantID in (from p in entities.EHS_PROFILE select p.PLANT_ID).ToList()) { profileList.Add(new EHSProfile().Load(Convert.ToDecimal(plantID), false, true)); } foreach (EHSProfile profile in profileList) // do each plant having a metric profile { WriteLine(profile.Plant.PLANT_NAME); DateTime periodDate = fromDate; while (periodDate <= toDate) // do each month within the rollup span { WriteLine(" " + periodDate.Year.ToString() + "/" + periodDate.Month.ToString()); if (profile.InputPeriod == null || profile.InputPeriod.PeriodDate != periodDate) { profile.LoadPeriod(periodDate); } if (profile.ValidPeriod()) { if (!profile.InputPeriod.PlantAccounting.APPROVAL_DT.HasValue) { profile.InputPeriod.PlantAccounting.APPROVAL_DT = toDate; profile.InputPeriod.PlantAccounting.APPROVER_ID = 1m; // default to the sysadmin user } status = profile.UpdateMetricHistory(periodDate); // new roll-up logic WriteLine(" ... " + status.ToString()); periodDate = periodDate.AddMonths(1); } } } } catch (Exception ex) { WriteLine("Main ENV Data RollUp Error - " + ex.ToString()); } WriteLine(""); WriteLine("Completed: " + DateTime.UtcNow.ToString("hh:mm MM/dd/yyyy")); ltrStatus.Text = output.ToString().Replace("\n", "<br/>"); WriteLogFile(); try { if (!string.IsNullOrEmpty(nextPage)) { int s1 = pageURI.LastIndexOf('/'); int s2 = pageURI.LastIndexOf('.') > -1 ? pageURI.LastIndexOf('.') : pageURI.Length; string nextPageURI = pageURI.Substring(0, s1 + 1) + nextPage + pageURI.Substring(s2, pageURI.Length - s2); Response.Redirect(nextPageURI); } } catch (Exception ex) { output = new StringBuilder(); WriteLine("RollUp Redirect Error - " + ex.ToString()); WriteLogFile(); } System.Web.UI.ScriptManager.RegisterStartupScript(this, GetType(), "closePage", "window.onunload = CloseWindow();", true); }
private void Control_Init() { CurrencyMgr myCurrencyMgr = new CurrencyMgr(); List <Currency> myCurrencies = myCurrencyMgr.Get_Currencies(); DataList_CurrencyList.DataSource = myCurrencies; DataList_CurrencyList.DataBind(); if (DataEval.IsEmptyQuery(_currencyid)) { _currencyid = myCurrencies[0].CurrencyID; ViewState["CurrencyID"] = _currencyid; } Currency selectCurrency = myCurrencyMgr.Get_Currency(_currencyid); GridView_Currency.DataSource = myCurrencyMgr.Get_Currency_OriginRates(selectCurrency.CurrencyID); GridView_Currency.DataBind(); lbl_Currency_Name.Text = string.Format("{0} ({1})", selectCurrency.Currency_Name, selectCurrency.Currency_ShortName); MultiView_Currency.SetActiveView(View_CurrencyList); Panel_EditExchangeRate.Visible = false; #region Create Exchange Rate Table // Header Literal_ExchangeRate.Text = "<Table class='exchangeRate'> \n" + "<tr>\n <td></td> \n"; foreach (Currency myCurrency in myCurrencies) { Literal_ExchangeRate.Text += "<td>" + myCurrency.Currency_ShortName + "</td> \n"; } Literal_ExchangeRate.Text += "</tr> \n"; // Sider foreach (Currency myCurrency in myCurrencies) { Literal_ExchangeRate.Text += "<tr>\n <td>" + myCurrency.Currency_ShortName + "</td> \n"; List <Currency_Rate> myCurrency_Rates = myCurrencyMgr.Get_Currency_OriginRates(myCurrency.CurrencyID); // Body foreach (Currency_Rate myCurrency_Rate in myCurrency_Rates) { Literal_ExchangeRate.Text += "<td>" + string.Format("{0:f}", myCurrency_Rate.Exchange_Rate) + "</td> \n"; } Literal_ExchangeRate.Text += "</tr> \n"; } // Footer Literal_ExchangeRate.Text += "</Table> \n"; #endregion }
protected void btn_Add_Currency_Create_Click(object sender, EventArgs e) { if (Page.IsValid) { string nowDateTime = DateTime.Now.ToString(); string UserID = Nexus.Security.Users.UserStatus.Current_UserID(this.Page); CurrencyMgr myCurrencyMgr = new CurrencyMgr(); List <Currency> myCurrencies = myCurrencyMgr.Get_Currencies(); // Add Currency string CurrencyID = Nexus.Core.Tools.IDGenerator.Get_New_GUID(); e2Data[] UpdateData = { new e2Data("CurrencyID", CurrencyID), new e2Data("Currency_Name", tbx_AddCurrency_Name.Text), new e2Data("Currency_ShortName", tbx_AddCurrency_ShortName.Text), new e2Data("Currency_WebCode", tbx_AddCurrency_WebCode.Text), new e2Data("Currency_Description", tbx_AddCurrency_Description.Text), new e2Data("IsActive", chkbox_AddCurrency_IsActive.Checked.ToString()) }; myCurrencyMgr.Add_Currency(UpdateData); Thread.Sleep(100); // Add Currency 1:1 Rate e2Data[] UpdateData_SelfRate = { new e2Data("Origin_CurrencyID", CurrencyID), new e2Data("Target_CurrencyID", CurrencyID), new e2Data("Exchange_Rate", "1"), new e2Data("LastUpdate_Date", nowDateTime), new e2Data("LastUpdate_UserID", UserID) }; myCurrencyMgr.Add_Currency_Rate(UpdateData_SelfRate); Thread.Sleep(100); // Add All other Currency foreach (Currency myCurrency in myCurrencies) { e2Data[] UpdateData_Origin = { new e2Data("Origin_CurrencyID", CurrencyID), new e2Data("Target_CurrencyID", myCurrency.CurrencyID), new e2Data("Exchange_Rate", "1"), new e2Data("LastUpdate_Date", nowDateTime), new e2Data("LastUpdate_UserID", UserID) }; myCurrencyMgr.Add_Currency_Rate(UpdateData_Origin); Thread.Sleep(100); e2Data[] UpdateData_Target = { new e2Data("Origin_CurrencyID", myCurrency.CurrencyID), new e2Data("Target_CurrencyID", CurrencyID), new e2Data("Exchange_Rate", "1"), new e2Data("LastUpdate_Date", nowDateTime), new e2Data("LastUpdate_UserID", UserID) }; myCurrencyMgr.Add_Currency_Rate(UpdateData_Target); Thread.Sleep(100); } // Finish Update Control_FillData(); Control_Init(); } }
protected void Page_Load(object sender, EventArgs e) { string baseCurrencyCode = "EUR"; // todo: read from database CurrencyMgr.CheckForUpdates(baseCurrencyCode); }
private void Control_FillData() { ProductVariantMgr myProductVariantMgr = new ProductVariantMgr(); ProductMgr myProductMgr = new ProductMgr(); CurrencyMgr myCurrencyMgr = new CurrencyMgr(); // Step 1 Product Variant droplist_Product_VariantID.DataSource = myProductVariantMgr.Get_Product_Variants(); droplist_Product_VariantID.DataTextField = "Variant_Name"; droplist_Product_VariantID.DataValueField = "Product_VariantID"; droplist_Product_VariantID.DataBind(); droplist_Product_VariantID.SelectedIndex = 0; tbx_Filter_ProductIndex_Title.Text = ""; droplist_Filter_OrderBy.SelectedIndex = 0; droplist_Filter_Direction.SelectedIndex = 0; lbl_Selected_Product_Index.Text = "Unselected"; // Step 2 Product Index tbx_Index_Title.Text = ""; tbx_Index_Short_Description.Text = ""; tbx_Index_Admin_Comment.Text = ""; chkbox_Index_IsActive.Checked = true; // Step 3 Product lbl_Product_Index.Text = ""; #region Product Title Format //Gets your enum names and adds it to a string array Array enumTitleNames = Enum.GetValues(typeof(Title_Type)); //Creates an ArrayList ArrayList myTitleFormats = new ArrayList(); //Loop through your string array and poppulates the ArrayList foreach (Title_Type myTitle_Type in enumTitleNames) { myTitleFormats.Add(new { Value = myTitle_Type.ToString(), Name = StringEnum.GetStringValue(myTitle_Type) }); } //Bind the ArrayList to your DropDownList rbtn_Product_Title_Type.DataSource = myTitleFormats; rbtn_Product_Title_Type.DataTextField = "Name"; rbtn_Product_Title_Type.DataValueField = "Value"; rbtn_Product_Title_Type.DataBind(); // Set Default value rbtn_Product_Title_Type.SelectedValue = Title_Type.Override.ToString(); #endregion tbx_Product_Title.Text = ""; tbx_Product_SKU.Text = ""; droplist_Product_ManufacturerID.DataSource = myProductMgr.Get_Manufacturers("Name", true.ToString()); droplist_Product_ManufacturerID.DataTextField = "Name"; droplist_Product_ManufacturerID.DataValueField = "ManufacturerID"; droplist_Product_ManufacturerID.DataBind(); droplist_Product_ManufacturerID.SelectedIndex = 0; tbx_Product_Manufacturer_SKU.Text = ""; droplist_Product_CurrencyID.DataSource = myCurrencyMgr.Get_Currencies("Currency_Name", true.ToString()); droplist_Product_CurrencyID.DataTextField = "Currency_ShortName"; droplist_Product_CurrencyID.DataValueField = "CurrencyID"; droplist_Product_CurrencyID.DataBind(); droplist_Product_CurrencyID.SelectedIndex = 0; RadNumericTextBox_Product_RRP.Text = "0.00"; chkbox_Product_IsActive.Checked = true; }
public void Control_FillData() { ProductMgr myProductMgr = new ProductMgr(); CurrencyMgr myCurrencyMgr = new CurrencyMgr(); Product.Product myProduct = myProductMgr.Get_Product(_productid); #region Product Title Format //Gets your enum names and adds it to a string array Array enumTitleNames = Enum.GetValues(typeof(Title_Type)); //Creates an ArrayList ArrayList myTitleFormats = new ArrayList(); //Loop through your string array and poppulates the ArrayList foreach (Title_Type myTitle_Type in enumTitleNames) { myTitleFormats.Add(new { Value = myTitle_Type.ToString(), Name = StringEnum.GetStringValue(myTitle_Type) }); } //Bind the ArrayList to your DropDownList rbtn_Product_Title_Type.DataSource = myTitleFormats; rbtn_Product_Title_Type.DataTextField = "Name"; rbtn_Product_Title_Type.DataValueField = "Value"; rbtn_Product_Title_Type.DataBind(); // Set Default value rbtn_Product_Title_Type.SelectedValue = Title_Type.Override.ToString(); #endregion tbx_Product_Title.Text = ""; tbx_Product_SKU.Text = ""; droplist_Product_ManufacturerID.Items.Clear(); droplist_Product_ManufacturerID.DataSource = myProductMgr.Get_Manufacturers("Name", true.ToString()); droplist_Product_ManufacturerID.DataTextField = "Name"; droplist_Product_ManufacturerID.DataValueField = "ManufacturerID"; droplist_Product_ManufacturerID.DataBind(); droplist_Product_ManufacturerID.SelectedIndex = 0; tbx_Product_Manufacturer_SKU.Text = ""; droplist_Product_CurrencyID.Items.Clear(); droplist_Product_CurrencyID.DataSource = myCurrencyMgr.Get_Currencies("Currency_Name", true.ToString()); droplist_Product_CurrencyID.DataTextField = "Currency_ShortName"; droplist_Product_CurrencyID.DataValueField = "CurrencyID"; droplist_Product_CurrencyID.DataBind(); droplist_Product_CurrencyID.SelectedIndex = 0; RadNumericTextBox_Product_RRP.Text = "0.00"; chkbox_Product_IsActive.Checked = true; // Load Product Data rbtn_Product_Title_Type.SelectedValue = myProduct.Title_Type.ToString(); tbx_Product_Title.Text = myProduct.Product_Title; tbx_Product_SKU.Text = myProduct.Product_SKU; droplist_Product_ManufacturerID.SelectedValue = myProduct.ManufacturerID; tbx_Product_Manufacturer_SKU.Text = myProduct.Manufacturer_SKU; droplist_Product_CurrencyID.SelectedValue = myProduct.CurrencyID; RadNumericTextBox_Product_RRP.Text = myProduct.RRP_Price.ToString(); chkbox_Product_IsActive.Checked = myProduct.IsActive; _product_variantid = myProduct.Product_VariantID; ViewState["Product_VariantID"] = _product_variantid; // Load Product Specification Panel_Updated.Visible = false; Product_Control_Init(); }