private void SaveContent() { if (!ContentChanged) { return; } String cID = String.Empty; String sQuery = String.Concat("SELECT ContentID FROM [Employers] WHERE EmployerID = ", ddlEmployers.SelectedValue); String uQuery = "UPDATE [EmployerContent] SET "; try { using (BaseCCHData b = new BaseCCHData(sQuery, true)) { b.GetFrontEndData(); if (b.HasErrors) { throw new Exception("Error finding Content in database"); } cID = b.Tables[0].Rows[0][0].ToString(); } List <KeyValuePair <String, object> > l = Changes.Where(kvp => kvp.Value != null).ToList <KeyValuePair <String, object> >(); l.ForEach(delegate(KeyValuePair <String, object> kvp) { uQuery = String.Concat(uQuery, kvp.Key, " = '", kvp.Value, "'"); if (kvp.Key != l.Last().Key) { uQuery = String.Concat(uQuery, ", "); } }); if (cID == String.Empty) { throw new Exception("Could not find content ID in the table"); } uQuery = String.Concat(uQuery, " WHERE CMID = '", cID, "'"); using (BaseCCHData b = new BaseCCHData(uQuery, true)) { b.PostFrontEndData(); if (b.HasErrors) { throw new Exception("Error updating content with changes"); } } this.feedback = feedback.Append("Changes Saved Successfully"); } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Page.Header.Controls.Add(new LiteralControl("<link rel=\"stylesheet\" href=\"" + ResolveUrl("~/Styles/Notify.css") + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString() + "\" type=\"text/css\" />")); ThisSession.UserLogginID = Membership.GetUser().ProviderUserKey.ToString(); using (BaseCCHData employees = new BaseCCHData("GetBNCUserInfoForAdmin")) { employees.GetFrontEndData(); if (employees.Tables.Count >= 1 && employees.Tables[0].Rows.Count > 0) { this.Employees = (from employee in employees.Tables[0].AsEnumerable() select new EmployeeData() { UserId = employee.Field<object>("userid"), UserName = employee.Field<object>("username"), Locked = employee.Field<object>("IsLockedOut"), EmployerID = employee.Field<object>("employerid"), ConnectionString = employee.Field<object>("connectionstring"), DataBase = employee.Field<object>("DataBase"), CCHID = employee.Field<object>("CCHID") }).ToDictionary(k => k.UserId.ToString(), v => v); } var t = this.Employees.Select(Em => new { Em.Value.UserName, Em.Value.UserId }).OrderBy(Em => Em.UserName).ToList(); ddlUsers.DataBind(t); if (employees.Tables.Count >= 2 && employees.Tables[1].Rows.Count > 0) { this.EmployeesInRoles = (from role in employees.Tables[1].AsEnumerable() select new RoleData() { UserId = role.Field<object>("userid"), RoleName = role.Field<object>("rolename"), UserName = role.Field<object>("username") }).ToLookup(k => k.UserId.ToString(), v => v); } if (employees.Tables.Count >= 3 && employees.Tables[2].Rows.Count > 0) { this.Orphans = (from orphan in employees.Tables[2].AsEnumerable() select new EmployeeData() { UserId = orphan.Field<object>("userid"), UserName = orphan.Field<object>("username") }).ToDictionary(k => k.UserId.ToString(), v => v); } t = this.Orphans.Select(Or => new { Or.Value.UserName, Or.Value.UserId }).ToList(); ddlOrphans.DataBind(t); } } }
private void SetContent() { String cmQuery = "select " + String.Concat <String>( emptyChanges .Keys .Where <String>(key => key == "employerid" || key == "EmployerName" || key == "Insurer" || key == "RXProvider" || key == "ShowYourCostColumn") .Select <String, String>(key => "e." + key + ", ")) + String.Concat <String>( emptyChanges .Keys .Where(k => k != "ContentManagementEnabled" && k != "employerid" && k != "EmployerName" && k != "Insurer" && k != "RXProvider" && k != "ShowYourCostColumn") .Select <String, String>(k => "ec." + k + ", ")) + "CASE WHEN ec.cmid is null THEN 0 ELSE 1 END as ContentManagementEnabled " + "from employers e " + "left join employercontent ec on e.contentid = ec.cmid"; using (BaseCCHData b = new BaseCCHData(cmQuery, true)) { b.GetFrontEndData(); if (b.Tables.Count > 0) { this.content = b.Tables[0]; } } }
private void DisableCM() { String oldID = String.Empty; String qUpdateEmpEntry = String.Concat( "UPDATE [Employers] SET ContentID = NULL OUTPUT Deleted.ContentID WHERE EmployerID = ", ddlEmployers.SelectedValue); String qRemCMEntry = "DELETE FROM [EmployerContent] WHERE CMID = '{0}'"; try { using (BaseCCHData b = new BaseCCHData(qUpdateEmpEntry, true)) { b.GetFrontEndData(); if (b.HasErrors) { throw new Exception("Error unlinking content from employer"); } oldID = b.Tables[0].Rows[0][0].ToString(); } if (oldID == String.Empty) { throw new Exception("Could not find previous content ID"); } using (BaseCCHData b = new BaseCCHData(String.Format(qRemCMEntry, oldID), true)) { b.PostFrontEndData(); if (b.HasErrors) { throw new Exception("Error removing old content from table"); } } this.feedback = feedback.Append( String.Concat( "Content Management Removed from ", ddlEmployers.SelectedItem.Text, " Successfully")); } catch (Exception ex) { } }
private void SetContent() { String cmQuery = "select " + String.Concat<String>( emptyChanges .Keys .Where<String>(key => key == "employerid" || key == "EmployerName" || key == "Insurer" || key == "RXProvider" || key == "ShowYourCostColumn") .Select<String, String>(key => "e." + key + ", ")) + String.Concat<String>( emptyChanges .Keys .Where(k => k != "ContentManagementEnabled" && k != "employerid" && k != "EmployerName" && k != "Insurer" && k != "RXProvider" && k != "ShowYourCostColumn") .Select<String, String>(k => "ec." + k + ", ")) + "CASE WHEN ec.cmid is null THEN 0 ELSE 1 END as ContentManagementEnabled " + "from employers e " + "left join employercontent ec on e.contentid = ec.cmid"; using (BaseCCHData b = new BaseCCHData(cmQuery, true)) { b.GetFrontEndData(); if(b.Tables.Count > 0) this.content = b.Tables[0]; } }
private void SaveContent() { if (!ContentChanged) return; String cID = String.Empty; String sQuery = String.Concat("SELECT ContentID FROM [Employers] WHERE EmployerID = ", ddlEmployers.SelectedValue); String uQuery = "UPDATE [EmployerContent] SET "; try { using (BaseCCHData b = new BaseCCHData(sQuery, true)) { b.GetFrontEndData(); if (b.HasErrors) throw new Exception("Error finding Content in database"); cID = b.Tables[0].Rows[0][0].ToString(); } List<KeyValuePair<String, object>> l = Changes.Where(kvp => kvp.Value != null).ToList<KeyValuePair<String, object>>(); l.ForEach(delegate(KeyValuePair<String, object> kvp) { uQuery = String.Concat(uQuery, kvp.Key, " = '", kvp.Value, "'"); if (kvp.Key != l.Last().Key) uQuery = String.Concat(uQuery, ", "); }); if (cID == String.Empty) throw new Exception("Could not find content ID in the table"); uQuery = String.Concat(uQuery, " WHERE CMID = '", cID, "'"); using (BaseCCHData b = new BaseCCHData(uQuery, true)) { b.PostFrontEndData(); if (b.HasErrors) throw new Exception("Error updating content with changes"); } this.feedback = feedback.Append("Changes Saved Successfully"); } catch (Exception ex) { } }
private void DisableCM() { String oldID = String.Empty; String qUpdateEmpEntry = String.Concat( "UPDATE [Employers] SET ContentID = NULL OUTPUT Deleted.ContentID WHERE EmployerID = ", ddlEmployers.SelectedValue); String qRemCMEntry = "DELETE FROM [EmployerContent] WHERE CMID = '{0}'"; try { using (BaseCCHData b = new BaseCCHData(qUpdateEmpEntry, true)) { b.GetFrontEndData(); if (b.HasErrors) throw new Exception("Error unlinking content from employer"); oldID = b.Tables[0].Rows[0][0].ToString(); } if (oldID == String.Empty) throw new Exception("Could not find previous content ID"); using (BaseCCHData b = new BaseCCHData(String.Format(qRemCMEntry, oldID), true)) { b.PostFrontEndData(); if (b.HasErrors) throw new Exception("Error removing old content from table"); } this.feedback = feedback.Append( String.Concat( "Content Management Removed from ", ddlEmployers.SelectedItem.Text, " Successfully")); } catch (Exception ex) { } }