protected void DispatchGridCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName != DeleteOrderOptionCommand) { return; } int orderOptionId; if (!Int32.TryParse((string)e.CommandArgument, out orderOptionId)) { return; } var result = DeletedOrderOption(orderOptionId); if (result) { FilteredListing.Rebind(); } ctlAlertMessage.PushAlertMessage( message: String.Format("{0} {1} {2}", AppLogic.GetString("admin.common.OrderOption", Locale), orderOptionId, AppLogic.GetString(result ? "admin.common.HasBeenDeleted" : "admin.common.CouldNotBeDeleted", Locale)), type: AlertMessage.AlertType.Success); }
protected void gMain_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteItem") { DeleteState(Localization.ParseNativeInt(e.CommandArgument.ToString())); AlertMessage.PushAlertMessage("Item Deleted", AspDotNetStorefrontControls.AlertMessage.AlertType.Success); FilteredListing.Rebind(); } }
/// <summary> /// Row Command /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ShippingZoneGrid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteItem") { if (DeleteZone(Localization.ParseNativeInt(e.CommandArgument.ToString()))) { FilteredListing.Rebind(); } } }
protected void btnAddToLevel_Click(object sender, EventArgs e) { string addValue = txtNewEmail.Text.Trim(); if (!string.IsNullOrEmpty(addValue)) { int customerIdToAdd = 0; int parsedCustomerID; if (int.TryParse(addValue, out parsedCustomerID)) //Admin entered a customer ID { customerIdToAdd = parsedCustomerID; if (!CheckForValidCustomer(customerIdToAdd)) { customerIdToAdd = 0; } } else //Admin entered an email { customerIdToAdd = Customer.GetIDFromEMail(addValue); } if (customerIdToAdd != 0) { string customerLevelNameToAdd = DisplayLevelName(CustomerLevelId); if (!CheckIfCustomerLevelCustomerExists(customerIdToAdd, CustomerLevelId)) { // clear the carts for this customer. This is to ensure their product pricing is correct // their current cart can have customer level pricing, not retail pricing, and this prevents that: DB.ExecuteSQL(String.Format("delete from shoppingcart where customerid={0}", customerIdToAdd)); DB.ExecuteSQL(String.Format("delete from kitcart where customerid={0}", customerIdToAdd)); DB.ExecuteSQL(String.Format("Update customer set CustomerLevelID={0} where CustomerID={1}", CustomerLevelId, customerIdToAdd)); AlertMessageDisplay.PushAlertMessage(string.Format("{0}{1}", AppLogic.GetString("admin.customerlevel.CustomerAdded", ThisCustomer.LocaleSetting), string.IsNullOrEmpty(customerLevelNameToAdd) ? string.Empty : string.Format(": {0} ({1}={2})", customerLevelName, AppLogic.GetString("admin.common.id", ThisCustomer.LocaleSetting), CustomerLevelId)), AspDotNetStorefrontControls.AlertMessage.AlertType.Success); } else { AlertMessageDisplay.PushAlertMessage(string.Format("{0}{1}", AppLogic.GetString("admin.customerlevel.AlreadyExistsInLevel", ThisCustomer.LocaleSetting), string.IsNullOrEmpty(customerLevelNameToAdd) ? string.Empty : string.Format(": {0} ({1}={2})", customerLevelName, AppLogic.GetString("admin.common.id", ThisCustomer.LocaleSetting), CustomerLevelId)), AspDotNetStorefrontControls.AlertMessage.AlertType.Error); } } else { AlertMessageDisplay.PushAlertMessage(AppLogic.GetString("admin.customerlevel.NotInDatabase", ThisCustomer.LocaleSetting), AspDotNetStorefrontControls.AlertMessage.AlertType.Warning); } txtNewEmail.Text = string.Empty; FilteredListing.Rebind(); } else { AlertMessageDisplay.PushAlertMessage(AppLogic.GetString("admin.customerlevel.IdOrEmailRequired", ThisCustomer.LocaleSetting), AspDotNetStorefrontControls.AlertMessage.AlertType.Error); } }
protected void grdCustomersInLevel_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "ClearLevel") { grdCustomersInLevel.EditIndex = -1; DB.ExecuteSQL(String.Format("update Customer set CustomerLevelID=0 where CustomerID={0}", e.CommandArgument)); AlertMessageDisplay.PushAlertMessage(AppLogic.GetString("admin.customerlevel.RemovedFromLevel", ThisCustomer.LocaleSetting), AspDotNetStorefrontControls.AlertMessage.AlertType.Success); } FilteredListing.Rebind(); }
void BulkClearSalesPrice() { using (var connection = new SqlConnection(DB.GetDBConn())) { connection.Open(); var whereClause = FilteredListing.GetFilterWhereClause(); var setClause = "null"; var command = new SqlCommand(BuildBatchUpdateCommandString(setClause, whereClause.Sql), connection); command.Parameters.AddRange(whereClause.Parameters.ToArray()); DB.ExecuteSQL(command); } }
void BulkSaveSalesPrice(double discount) { using (var connection = new SqlConnection(DB.GetDBConn())) { connection.Open(); var whereClause = FilteredListing.GetFilterWhereClause(); var setClause = ("Price * @discount"); var command = new SqlCommand(BuildBatchUpdateCommandString(setClause, whereClause.Sql), connection); command.Parameters.Add(new SqlParameter("discount", (100 - discount) / 100)); command.Parameters.AddRange(whereClause.Parameters.ToArray()); DB.ExecuteSQL(command); } }
void Save() { using (var connection = new SqlConnection(DB.GetDBConn())) { connection.Open(); var items = repeatMap.Items.Cast <RepeaterItem>().Where(item => item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem); foreach (var item in items) { var variantId = int.Parse((item.FindControl("lblVariantId") as Label).Text); var variantName = (item.FindControl("txtVariantName") as TextBox).Text; var variantSKUSuffix = (item.FindControl("txtVariantSKUSuffix") as TextBox).Text; var price = decimal.Parse((item.FindControl("txtPrice") as TextBox).Text); var inventory = int.Parse((item.FindControl("txtInventory") as TextBox).Text); var published = (item.FindControl("chkPublished") as CheckBox).Checked; var where = FilteredListing.GetFilterWhereClause(); decimal?salePrice = null; decimal result; if (decimal.TryParse((item.FindControl("txtSalePrice") as TextBox).Text, out result)) { salePrice = result; } using (var command = new SqlCommand(@" update ProductVariant set Name = dbo.SetMlValue(Name, @Name, @_locale), SKUSuffix = @SKUSuffix, Price = @Price, SalePrice = @SalePrice, Inventory = @Inventory, Published = @published where VariantID = @VariantID" , connection)) { command.Parameters.Add(new SqlParameter("VariantID", variantId)); command.Parameters.Add(new SqlParameter("Name", variantName)); command.Parameters.Add(new SqlParameter("SKUSuffix", variantSKUSuffix)); command.Parameters.Add(new SqlParameter("Price", price)); command.Parameters.Add(new SqlParameter("SalePrice", (object)salePrice ?? DBNull.Value)); command.Parameters.Add(new SqlParameter("Inventory", inventory)); command.Parameters.Add(new SqlParameter("Published", published)); command.Parameters.Add(new SqlParameter("_locale", where.Parameters.Where(p => p.ParameterName == "_locale").FirstOrDefault().Value)); DB.ExecuteSQL(command); } } } }
protected void gMain_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteItem") { try { DeleteProductType(Localization.ParseNativeInt(e.CommandArgument.ToString())); ctlAlertMessage.PushAlertMessage("Item Deleted", AspDotNetStorefrontControls.AlertMessage.AlertType.Success); } catch (Exception ex) { ctlAlertMessage.PushAlertMessage(ex.Message, AspDotNetStorefrontControls.AlertMessage.AlertType.Error); } FilteredListing.Rebind(); } }
void RemoveCustomerLevelCommandHandler(object sender, CommandEventArgs e) { int customerLevelId; if (!Int32.TryParse((string)e.CommandArgument, out customerLevelId)) { return; } if (RemoveCustomerLevel(customerLevelId)) { AlertMessageDisplay.PushAlertMessage("admin.Common.ItemDeleted".StringResource(), AlertMessage.AlertType.Success); FilteredListing.Rebind(); } }
protected void btnExport_Click(object sender, EventArgs e) { var exportContents = new StringBuilder(); exportContents.AppendLine("Action, Description, Date, CustomerID, Email"); // Can't use the grid as a datasource as it's paged, so query the DB with the same filters the grid is currently displaying using (var connection = new SqlConnection(DB.GetDBConn())) using (var command = connection.CreateCommand()) { var whereClause = FilteredListing.GetFilterWhereClause(); command.CommandText = string.Format( @"select SecurityAction Action, Description, ActionDate Date, UpdatedBy CustomerID, c.EMail from SecurityLog with (NOLOCK) left outer join Customer c with (NOLOCK) on SecurityLog.UpdatedBy = c.CustomerID where {0}" , whereClause.Sql); command.Parameters.AddRange(whereClause.Parameters.ToArray()); connection.Open(); using (var reader = command.ExecuteReader()) while (reader.Read()) { var shippedOn = DB.RSFieldDateTime(reader, "Date"); exportContents.AppendFormat(@"""{0}"",""{1}"",{2},{3},{4}{5}", DecryptValue(reader.Field("Action")).Replace("\"", "\"\""), DecryptValue(reader.Field("Description").Replace("\"", "\"\"")), shippedOn == DateTime.MinValue ? string.Empty : shippedOn.ToString(), reader.FieldInt("CustomerID"), reader.Field("Email"), Environment.NewLine); } } // Send the CSV Response.Clear(); Response.AddHeader("content-disposition", "attachment; filename=SecurityLogExport.csv"); Response.BufferOutput = false; Response.ContentType = "text/csv"; Response.Output.Write(exportContents); Response.Flush(); Response.End(); }
void PublishAffiliateCommandHandler(object sender, CommandEventArgs e, bool published, string successStringResource) { int affiliateId; if (!Int32.TryParse((string)e.CommandArgument, out affiliateId)) { return; } if (SetPublishedFlag(affiliateId, published)) { AlertMessageDisplay.PushAlertMessage( BuildAffiliateAlertMessage(affiliateId, successStringResource), AlertMessage.AlertType.Success); FilteredListing.Rebind(); } }
void SetDefaultVariantCommandHandler(object sender, CommandEventArgs e) { int variantId; if (!Int32.TryParse((string)e.CommandArgument, out variantId)) { return; } if (SetDefaultVariant(variantId)) { AlertMessageDisplay.PushAlertMessage( String.Format("Variant {0} set as default variant", variantId), AlertMessage.AlertType.Success); FilteredListing.Rebind(); } }
void CloneVariantCommandHandler(object sender, CommandEventArgs e) { int variantId; if (!Int32.TryParse((string)e.CommandArgument, out variantId)) { return; } if (CloneVariant(variantId)) { AlertMessageDisplay.PushAlertMessage( AppLogic.GetString("admin.entityProductVariantsOverview.VariantCloned", ThisCustomer.SkinID, ThisCustomer.LocaleSetting), AlertMessage.AlertType.Success); FilteredListing.Rebind(); } }
void DeleteVariantCommandHandler(object sender, CommandEventArgs e, bool deleted, string successStringResource) { int variantId; if (!Int32.TryParse((string)e.CommandArgument, out variantId)) { return; } if (SetDeletedFlag(variantId, deleted)) { AlertMessageDisplay.PushAlertMessage( BuildAlertMessage(variantId, successStringResource), AlertMessage.AlertType.Success); FilteredListing.Rebind(); } }
protected void Save(object sender, EventArgs e) { try { var items = repeatMap.Items.Cast <RepeaterItem>().Where(item => item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem); foreach (var item in items) { var variantId = int.Parse(((Label)item.FindControl("lblVariantId")).Text); var where = FilteredListing.GetFilterWhereClause(); string dimensions = BuildDimensions(item); var isShipSeparately = ((CheckBox)item.FindControl("chkIsShipSeparately")).Checked; decimal?weight = null; decimal result; if (decimal.TryParse(((TextBox)item.FindControl("txtWeight")).Text, out result) && result > 0) { weight = result; } using (var connection = new SqlConnection(DB.GetDBConn())) { if (weight != null) { SaveWeight(weight.Value, variantId, connection); } if (dimensions != null) { SaveDimensions(dimensions, variantId, connection); } SaveShipSeparately(isShipSeparately, variantId, connection); } } AlertMessage.PushAlertMessage(AppLogic.GetString("admin.bulkeditweights.weightsupdated", ThisCustomer.LocaleSetting), AspDotNetStorefrontControls.AlertMessage.AlertType.Success); } catch (Exception ex) { AlertMessage.PushAlertMessage(ex.Message, AspDotNetStorefrontControls.AlertMessage.AlertType.Error); } }
protected void RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == DeleteCommand) { var salesPromptId = Localization.ParseNativeInt((string)e.CommandArgument); try { DB.ExecuteSQL( "update SalesPrompt set Deleted = 1 where SalesPromptID = @id", new[] { new SqlParameter("@id", salesPromptId) }); ctrlAlertMessage.PushAlertMessage("Sales prompt deleted", AlertMessage.AlertType.Success); } catch (Exception exception) { ctrlAlertMessage.PushAlertMessage("Unable to delete sales prompt:<br />" + exception.ToString(), AlertMessage.AlertType.Error); } FilteredListing.Rebind(); } }
void CloneProductCommandHandler(object sender, CommandEventArgs e) { int productId; if (!Int32.TryParse((string)e.CommandArgument, out productId)) { return; } if (CloneProduct(productId)) { AlertMessageDisplay.PushAlertMessage( BuildProductAlertMessage(productId, "admin.productgrid.ProductCloned"), AlertMessage.AlertType.Success); FilteredListing.Rebind(); } else { AlertMessageDisplay.PushAlertMessage( BuildProductAlertMessage(productId, "admin.productgrid.ProductNotCloned"), AlertMessage.AlertType.Error); } }
protected void Save_Click(object sender, EventArgs e) { var customerAnonymizeSuccesses = new StringBuilder(); var cannotBeAnonymized = new StringBuilder(); var customerAnonymizeErrors = new StringBuilder(); var customerDeleteSuccesses = new StringBuilder(); var cannotBeDeleted = new StringBuilder(); var customerDeleteErrors = new StringBuilder(); var orderAnonymizeSuccesses = new StringBuilder(); var orderAnonymizeErrors = new StringBuilder(); foreach (GridViewRow row in Grid.Rows) { if (row.RowType != DataControlRowType.DataRow) { continue; } // We're getting the customer id through a hidden field because the grid data keys are cleared in the GridLoad() sorting above. var customerId = Convert.ToInt32(((HiddenField)row.FindControl("hidCustomerId")).Value); var chkAnonymize = (CheckBox)row.FindControl("chkAnonymizeCustomer"); var chkRemove = (CheckBox)row.FindControl("chkRemoveCustomer"); var customerInfo = ((HiddenField)row.FindControl("hidCustomerInfo")).Value; if (chkAnonymize.Checked) { if (!DataRetentionService.CustomerCanBeAnonymized(customerId)) { cannotBeAnonymized .Append(customerInfo) .Append("<br />"); continue; } var result = DataRetentionService.AnonymizeCustomer(customerId); if (!result.Success) { customerAnonymizeErrors .Append(customerInfo) .Append("<br />"); SysLog.LogException(result.Error, MessageTypeEnum.GeneralException, MessageSeverityEnum.Error); continue; } if (!result.Value) { customerAnonymizeErrors .Append(customerInfo) .Append("<br />"); continue; } customerAnonymizeSuccesses .Append(customerInfo) .Append("<br />"); foreach (var orderResult in DataRetentionService.AnonymizeOrders(customerId)) { if (!orderResult.Success) { orderAnonymizeErrors .Append(customerInfo) .Append("<br />"); SysLog.LogException(result.Error, MessageTypeEnum.GeneralException, MessageSeverityEnum.Error); continue; } if (!orderResult.Value) { orderAnonymizeErrors .Append(customerInfo) .Append("<br />"); continue; } orderAnonymizeSuccesses .Append(customerInfo) .Append("<br />"); } } } if (customerAnonymizeSuccesses.Length > 0) { AlertMessageDisplay.PushAlertMessage( string.Concat("The following customer(s) have been anonymized:<br />", customerAnonymizeSuccesses.ToString()), AlertMessage.AlertType.Success); } if (cannotBeAnonymized.Length > 0) { AlertMessageDisplay.PushAlertMessage( string.Concat("The following customer(s) and their orders could not be anonymized:<br />", cannotBeAnonymized.ToString()), AlertMessage.AlertType.Error); } if (customerAnonymizeErrors.Length > 0) { AlertMessageDisplay.PushAlertMessage( string.Concat("The following customer(s) could not be anonymized:<br />", customerAnonymizeErrors.ToString()), AlertMessage.AlertType.Error); } if (customerDeleteSuccesses.Length > 0) { AlertMessageDisplay.PushAlertMessage( string.Concat("The following customer(s) have been removed:<br />", customerDeleteSuccesses.ToString()), AlertMessage.AlertType.Success); } if (cannotBeDeleted.Length > 0) { AlertMessageDisplay.PushAlertMessage( string.Concat("The following customer(s) and their orders could not be removed:<br />", cannotBeDeleted.ToString()), AlertMessage.AlertType.Error); } if (customerDeleteErrors.Length > 0) { AlertMessageDisplay.PushAlertMessage( string.Concat("The following customer(s) could not be removed:<br />", customerDeleteErrors.ToString()), AlertMessage.AlertType.Error); } if (orderAnonymizeSuccesses.Length > 0) { AlertMessageDisplay.PushAlertMessage( string.Concat("The following customer(s) orders have been anonymized:<br />", orderAnonymizeSuccesses.ToString()), AlertMessage.AlertType.Success); } if (orderAnonymizeErrors.Length > 0) { AlertMessageDisplay.PushAlertMessage( string.Concat("The following customer's orders could not be anonymized:<br />", orderAnonymizeErrors.ToString()), AlertMessage.AlertType.Error); } FilteredListing.Rebind(); }
protected void btnExport_Click(object sender, EventArgs e) { var exportContents = new StringBuilder(); exportContents.AppendLine(MakeHeaderRow()); //Can't use the grid as a datasource as it's paged, so query the DB with the same filters the grid is currently displaying using (var conn = new SqlConnection(DB.GetDBConn())) { conn.Open(); var whereClause = FilteredListing.GetFilterWhereClause(); var sql = string.Format( @"SELECT OrderNumber, ShippedOn, ShippedVIA, ShippingTrackingNumber, ShippingMethod, ShippingFirstName, ShippingLastName, ShippingAddress1, ShippingAddress2, ShippingSuite, ShippingCity, ShippingState, ShippingZip, ShippingCountry, ShippingPhone, Phone, Email FROM Orders WHERE {0}" , whereClause.Sql); using (var command = new SqlCommand(sql, conn)) { command.Parameters.AddRange(whereClause.Parameters.ToArray()); using (IDataReader rs = command.ExecuteReader()) { while (rs.Read()) { exportContents.Append(DB.RSFieldInt(rs, "OrderNumber").ToString()); exportContents.Append(","); var shippedOn = DB.RSFieldDateTime(rs, "ShippedOn"); exportContents.Append(shippedOn == DateTime.MinValue ? string.Empty : shippedOn.ToString()); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippedVIA")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingTrackingNumber")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingMethod")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingFirstName")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingLastName")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingAddress1")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingAddress2")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingSuite")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingCity")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingState")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingZip")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingCountry")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "ShippingPhone")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "Phone")); exportContents.Append(","); exportContents.Append(DB.RSField(rs, "Email")); exportContents.Append("\r\n"); } } } } //Save a copy in images var filepath = CommonLogic.SafeMapPath("~/images") + "\\"; var filename = "ShippingExport_" + Localization.ToNativeDateTimeString(DateTime.Now).Replace(" ", "_").Replace(",", "_").Replace("/", "_").Replace(":", "_").Replace(".", "_") + ".csv"; var fullFilePath = filepath + filename; File.WriteAllText(fullFilePath, exportContents.ToString()); // Send the CSV Response.Clear(); Response.ClearHeaders(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=ShippingExport.csv"); Response.BufferOutput = false; Response.ContentType = "text/csv"; Response.TransmitFile(fullFilePath); Response.Flush(); Response.End(); }
protected void btnExport_Click(Object sender, EventArgs e) { Response.Clear(); Response.ContentType = "application/octet-stream"; Response.AddHeader("Content-Disposition", "attachment; filename=SystemLog.txt"); Response.Write("----------------------------------------------------------------------\r\n"); Response.Write("----------------------------------------------------------------------\r\n"); Response.Write("SYSTEM INFORMATION \r\n"); Response.Write("----------------------------------------------------------------------\r\n"); Response.Write("----------------------------------------------------------------------\r\n"); Response.Write("\r\n"); Response.Write("Version: " + CommonLogic.GetVersion() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("On Live Server: " + AppLogic.OnLiveServer().ToString() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("UseSSL: " + AppLogic.UseSSL().ToString() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Is Secure Page: " + CommonLogic.IsSecureConnection().ToString() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Changed Admin Dir: " + CommonLogic.IIF(AppLogic.AppConfig("AdminDir").ToLowerInvariant() == "admin", "No", "Yes") + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Caching: " + (AppLogic.AppConfigBool("CacheMenus") ? AppLogic.GetString("admin.common.OnUC", AppLogic.GetStoreSkinID(AppLogic.StoreID()), Localization.GetDefaultLocale()) : AppLogic.GetString("admin.common.OffUC", AppLogic.DefaultSkinID(), Localization.GetDefaultLocale())) + "\r\n"); Response.Write("\r\n"); Response.Write("----------------------LOCALIZATION----------------------\r\n"); Response.Write("\r\n"); Response.Write("Web Config Locale: " + Localization.GetDefaultLocale() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("SQL Server Locale: " + Localization.GetSqlServerLocale() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Store Currency: " + AppLogic.AppConfig("Localization.StoreCurrency") + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Store Currency Code:" + AppLogic.AppConfig("Localization.StoreCurrencyNumericCode") + "\r\n"); Response.Write("\r\n"); Response.Write("----------------------GATEWAY INFO----------------------\r\n"); Response.Write("\r\n"); Response.Write("Payment Gateway: " + AppLogic.ActivePaymentGatewayRAW() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Use Live Transactions:" + (AppLogic.AppConfigBool("UseLiveTransactions") ? AppLogic.GetString("admin.splash.aspx.20", AppLogic.GetStoreSkinID(AppLogic.StoreID()), Localization.GetDefaultLocale()) : AppLogic.GetString("admin.splash.aspx.21", AppLogic.DefaultSkinID(), Localization.GetDefaultLocale())) + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Transaction Mode: " + AppLogic.AppConfig("TransactionMode").ToString() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Payment Methods: " + AppLogic.AppConfig("PaymentMethods").ToString() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Primary Currency: " + Localization.GetPrimaryCurrency() + "\r\n"); Response.Write("\r\n"); Response.Write("----------------------SHIPPING INFO----------------------\r\n"); Response.Write("\r\n"); Response.Write("Shipping Rates Table:" + DB.GetSqlS("select Name as S from dbo.ShippingCalculation where Selected=1") + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Origin State: " + AppLogic.AppConfig("RTShipping.OriginState") + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Origin Zip: " + AppLogic.AppConfig("RTShipping.OriginZip") + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Origin Country: " + AppLogic.AppConfig("RTShipping.OriginCountry") + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Free Shipping Threshold: " + AppLogic.AppConfigNativeDecimal("FreeShippingThreshold").ToString() + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Free Shipping Method:" + AppLogic.AppConfig("ShippingMethodIDIfFreeShippingIsOn") + "\r\n"); Response.Write("----------------------\r\n"); Response.Write("Allow Rate Selection:" + CommonLogic.IIF(AppLogic.AppConfigBool("FreeShippingAllowsRateSelection"), "On", "Off") + "\r\n"); Response.Write("\r\n\r\n"); var whereClause = FilteredListing.GetFilterWhereClause(); var sql = String.Format("select * from aspdnsf_SysLog where {0}", whereClause.Sql); using (var connection = new SqlConnection(DB.GetDBConn())) using (var command = new SqlCommand(sql, connection)) { connection.Open(); command.Parameters.AddRange(whereClause.Parameters.ToArray()); using (var reader = command.ExecuteReader()) while (reader.Read()) { Response.Write("----------------------------------------------------------------------\r\n"); Response.Write("----------------------------------------------------------------------\r\n"); Response.Write(AppLogic.GetString("admin.systemlog.aspx.1", AppLogic.GetStoreSkinID(AppLogic.StoreID()), Localization.GetDefaultLocale()) + ": "); Response.Write(DB.RSFieldInt(reader, "SysLogID").ToString() + " " + DB.RSFieldDateTime(reader, "CreatedOn").ToString() + " \r\n"); Response.Write("----------------------------------------------------------------------\r\n"); Response.Write("----------------------------------------------------------------------\r\n"); Response.Write("\r\n\r\n"); Response.Write(DB.RSField(reader, "Message")); Response.Write("\r\n\r\n"); Response.Write(DB.RSField(reader, "Details")); Response.Write("\r\n\r\n"); } } Response.Flush(); Response.Close(); }