bool Save()
{
var productMappingChanges = grdMap
.Rows
.Cast <GridViewRow>()
.Select(row => new
{
productId = (int)grdMap.DataKeys[row.DataItemIndex].Values["ProductID"],
currentMapping = (int)grdMap.DataKeys[row.DataItemIndex].Values["IsMapped"] == 1,
desiredMapping = row.FindControl <CheckBox>("chkIsMapped").Checked
})
.Where(o => o.currentMapping != o.desiredMapping);
using (var connection = new SqlConnection(DB.GetDBConn()))
{
connection.Open();
foreach (var mapping in productMappingChanges)
{
SetMap(connection, EntityType, EntityId, mapping.productId, mapping.desiredMapping);
}
}
AlertMessageControl.PushAlertMessage("Mappings successfully updated", AlertMessage.AlertType.Success);
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
ShowLocaleSetting = Localization.CheckLocaleSettingForProperCase(CommonLogic.QueryStringCanBeDangerousContent("ShowLocaleSetting"));
var isMasterStringResource = CommonLogic.QueryStringBool("master");
if (isMasterStringResource)
{
if (!StringResourceManager.CheckStringResourceExcelFileExists(ShowLocaleSetting))
{
AlertMessageControl.PushAlertMessage(AppLogic.GetString("admin.StringResources.NoFileFound", SkinID, ShowLocaleSetting), AlertMessage.AlertType.Error);
return;
}
ImportFiles = StringResourceManager.GetStringResourceFilesForLocale(ShowLocaleSetting);
}
else
{
ImportFiles = new[] { CommonLogic.SafeMapPath("~/images/" + CommonLogic.QueryStringCanBeDangerousContent("SpreadsheetName")) };
}
if (!IsPostBack)
{
CancelLink.NavigateUrl = String.Format("{0}?filterlocale={1}", AppLogic.AdminLinkUrl("stringresources.aspx"), ShowLocaleSetting);
if (isMasterStringResource)
{
btnProcessFile.Text = AppLogic.GetString("admin.importstringresourcefile2.BeginReload", SkinID, LocaleSetting);
ltProcessing.Text = String.Format(AppLogic.GetString("admin.importstringresourcefile2.ReloadLocale", SkinID, LocaleSetting), ShowLocaleSetting);
}
else
{
btnProcessFile.Text = AppLogic.GetString("admin.importstringresourcefile2.BeginImport", SkinID, LocaleSetting);
ltProcessing.Text = String.Format(AppLogic.GetString("admin.importstringresourcefile2.ProcessingFile", SkinID, LocaleSetting), ImportFiles.First());
}
// Preview the data
try
{
var validationResult = StringResourceImporter.Validate(ShowLocaleSetting, ImportFiles, (StringResourceImporter.ImportOption)CommonLogic.QueryStringUSInt("option"));
DataReportGrid.DataSource = validationResult;
}
catch (Exception exception)
{
while (exception.InnerException != null)
{
exception = exception.InnerException;
}
AlertMessageControl.PushAlertMessage(exception.Message, AlertMessage.AlertType.Error);
ActionsPanel.Visible = false;
}
}
}
protected void btnProcessFile_Click(object sender, EventArgs e)
{
ActionsPanel.Visible = false;
try
{
var importResult = StringResourceImporter.Import(ShowLocaleSetting, ImportFiles, (StringResourceImporter.ImportOption)CommonLogic.QueryStringUSInt("option"));
DataReportGrid.DataSource = importResult;
StringResourceManager.LoadAllStrings(false);
AlertMessageControl.PushAlertMessage(AppLogic.GetString("admin.importstringresourcefile2.Done", SkinID, LocaleSetting), AlertMessage.AlertType.Success);
}
catch (Exception exception)
{
AlertMessageControl.PushAlertMessage(String.Format(AppLogic.GetString("admin.importstringresourcefile2.ErrorProcessingStrings", SkinID, LocaleSetting), exception), AlertMessage.AlertType.Error);
}
}
