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();
}
