public override global::System.Data.DataSet Clone() { dsSecurity cln = ((dsSecurity)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { dsSecurity ds = new dsSecurity(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public void ReportViewer() { var session = Session["DSsecurity"]; try { if (Session["DSsecurity"] == null) { var pResult = string.Empty; var dsDiseño = new dsSecurity(); var dsEjecucion = _privilegioServicio.ObtenerPrivilegiosPorRol(HttpContext.Current.Session["connectionString"].ToString(), ref pResult); for (int i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++) { var row = dsDiseño.SWIFT_SECURITY.NewRow(); row[0] = dsEjecucion.Tables[0].Rows[i]["NAME"]; row[1] = dsEjecucion.Tables[0].Rows[i]["PARENT_ID"]; row[2] = dsEjecucion.Tables[0].Rows[i]["DISPLAY_NAME"]; /* row[3] = dsEjecucion.Tables[0].Rows[i]["NAME"]; * row[4] = dsEjecucion.Tables[0].Rows[i]["PRIVILEGE_TYPE"]; * row[5] = dsEjecucion.Tables[0].Rows[i]["DISPLAY_NAME"]; * row[6] = dsEjecucion.Tables[0].Rows[i]["IMAGE_URL"]; * row[7] = dsEjecucion.Tables[0].Rows[i]["DESCRIPTION"]; */ dsDiseño.SWIFT_SECURITY.Rows.Add(row); } var reporte = new Report.ReportSecurity { DataSource = dsDiseño }; Session["DSDISEÑO"] = dsDiseño; UiVisualizarReporte.Report = reporte; UiVisualizarReporte.DataBind(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); dsSecurity ds = new dsSecurity(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "SWIFT_SECURITYDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
private void SaveFlexGrid() { try { // delete existing role-application data if (mRoleID != -1) // edit existing role-application data { this.BindingContext[dsSecurity1, "Roles"].EndCurrentEdit(); this.BindingContext[dsSecurity1, "ApplicationRoles"].EndCurrentEdit(); // update database daRoles.Update(dsSecurity1.Roles); daApplicationRoles.Update(dsSecurity1.ApplicationRoles); // inform user RibbonMessageBox.Show("Changes SUCCESSFULLY saved to database. New Role setting will affect new session. You need to restart this application for changes to take affect", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } else // save NEW Role data { if (c1TextBox1.Text.Trim() == "") { RibbonMessageBox.Show("Please provide Role Name", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { this.BindingContext[dsSecurity1, "Roles"].EndCurrentEdit(); this.BindingContext[dsSecurity1, "ApplicationRoles"].EndCurrentEdit(); // set code DataRowView dr = (DataRowView)this.BindingContext[this.dsSecurity1, "Roles"].Current; dr["Code"] = dr["Name"]; // copy master record dari main dataset // harus dilakukan krena main dataset sebelumnya sudah // AcceptChanges padahal belum diupdate ke database dsSecurity dsChanges = new dsSecurity(); dsChanges.EnforceConstraints = false; dsChanges.Roles.Rows.Add(((DataRowView)this.BindingContext[dsSecurity1, "Roles"].Current).Row.ItemArray); // copy juga detail record dari main dataset for (int i = 0; i < dsSecurity1.ApplicationRoles.Rows.Count; i++) { dsChanges.ApplicationRoles.Rows.Add(dsSecurity1.ApplicationRoles.Rows[i].ItemArray); } // update master table daRoles.Update(dsChanges.Roles); // get new id dsSecurity ds = new dsSecurity(); daRoles.FillByCode(ds.Roles, c1TextBox1.Text); foreach (dsSecurity.ApplicationRolesRow row in dsChanges.ApplicationRoles.Rows) { row.RoleID = ds.Roles[0].ID; } // update detail table daApplicationRoles.Update(dsChanges.ApplicationRoles); // inform user RibbonMessageBox.Show("Data SUCCESSFULLY saved to database", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { Logger.ErrorRoutine(ex); RibbonMessageBox.Show("ERROR saving Role to database, probably duplicate Role Name: " + ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } // clean up this.Cursor = Cursors.Default; this.Close(); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); dsSecurity ds = new dsSecurity(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "RolesDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; }
public virtual int Update(dsSecurity dataSet) { return this.Adapter.Update(dataSet, "ApplicationRoles"); }
public virtual int Update(dsSecurity.ApplicationRolesDataTable dataTable) { return this.Adapter.Update(dataTable); }
public virtual int FillByUserID(dsSecurity.ApplicationRolesDataTable dataTable, int UserID) { this.Adapter.SelectCommand = this.CommandCollection[2]; this.Adapter.SelectCommand.Parameters[0].Value = ((int)(UserID)); if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int Fill(dsSecurity.ApplicationRolesDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int Update(dsSecurity dataSet) { return this.Adapter.Update(dataSet, "Users"); }
public virtual int Update(dsSecurity.UsersDataTable dataTable) { return this.Adapter.Update(dataTable); }
public virtual int FillDenormalized(dsSecurity.UsersDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[4]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int FillByUserName(dsSecurity.UsersDataTable dataTable, string p1) { this.Adapter.SelectCommand = this.CommandCollection[3]; if ((p1 == null)) { throw new global::System.ArgumentNullException("p1"); } else { this.Adapter.SelectCommand.Parameters[0].Value = ((string)(p1)); } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { dsSecurity ds = new dsSecurity(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; }
public virtual int FillByCode(dsSecurity.RolesDataTable dataTable, string p1) { this.Adapter.SelectCommand = this.CommandCollection[2]; if ((p1 == null)) { this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[0].Value = ((string)(p1)); } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }