private void Save()
{
using (Database dbObj = Utils.GetMainDB())
{
// *************************************************************************
// Update user localizations scope
// *************************************************************************
if (dg.Rows.Count > 0)
{
string updateSQL = string.Empty;
string cultureCode;
lbError.Visible = false;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow r in dg.Rows)
{
Infragistics.WebUI.UltraWebGrid.TemplatedColumn col = (Infragistics.WebUI.UltraWebGrid.TemplatedColumn)r.Cells.FromKey("Select").Column;
CheckBox cb = (CheckBox)((Infragistics.WebUI.UltraWebGrid.CellItem)col.CellItems[r.Index]).FindControl("g_sd");
cultureCode = r.Cells.FromKey("CultureCode").Text;
updateSQL += "DELETE from UserCultures WHERE UserId = " + userId + " AND CultureCode='" + cultureCode + "'; ";
if (cb.Checked)
{
updateSQL += "INSERT INTO UserCultures(UserId, CultureCode) VALUES(" + userId + ", '" + cultureCode + "'); ";
}
}
dbObj.RunSQL(updateSQL);
dbObj.CloseConnection();
if (dbObj.LastError.Length > 0)
{
lbError.CssClass = "hc_error";
lbError.Text = dbObj.LastError;
lbError.Visible = true;
}
else
{
lbError.Text = "Data saved!";
lbError.CssClass = "hc_success";
lbError.Visible = true;
}
}
else
{
lbError.CssClass = "hc_error";
lbError.Text = "No Culture found";
lbError.Visible = true;
}
UITools.RefreshTab(Page, "Cultures", Utils.GetCount(dbObj, string.Format("SELECT COUNT(*) FROM UserCultures Where UserId = {0}", userId)));
}
}
private void dg_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
Infragistics.WebUI.UltraWebGrid.TemplatedColumn col = (Infragistics.WebUI.UltraWebGrid.TemplatedColumn)e.Row.Cells.FromKey("Select").Column;
CheckBox cb = (CheckBox)((Infragistics.WebUI.UltraWebGrid.CellItem)col.CellItems[e.Row.Index]).FindControl("g_sd");
cb.Checked = Convert.ToBoolean(e.Row.Cells.FromKey("InScope").Value);
string sIndent = string.Empty;
Infragistics.WebUI.UltraWebGrid.UltraGridRow r = e.Row;
for (int i = 0; i < Convert.ToInt32(r.Cells.FromKey("CultureTypeId").Value); i++)
{
sIndent += " ";
}
r.Cells.FromKey("CultureName").Value = sIndent + "[" + r.Cells.FromKey("CultureCode").Value + "] " + r.Cells.FromKey("CultureName").Value;
r.Cells.FromKey("CultureName").Style.CssClass = "culture_" + r.Cells.FromKey("CultureTypeId").Value;
r.Cells.FromKey("CountryCode").Value = "<img src='/hc_v4/img/flags/" + r.Cells.FromKey("CountryCode").Value + ".gif'/>";
}