/// <summary> /// Update a WorkType /// </summary> /// <param name="ds"></param> public void Update(WorkTypeDS ds) { string sql; SqlConnection conn = new SqlConnection(this.DBConnectionString); sql = "insert into WorkType (WorkTypeName) values (@WorkTypeName)"; SqlCommand insertCommand = new SqlCommand(sql, conn); insertCommand.Parameters.Add("@WorkTypeName", System.Data.SqlDbType.VarChar, 255, "WorkTypeName"); insertCommand.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord; sql = "update WorkType set WorkTypeName = @WorkTypeName Where WorkTypeID = @WorkTypeID"; SqlCommand updateCommand = new SqlCommand(sql, conn); updateCommand.Parameters.Add("@WorkTypeName", System.Data.SqlDbType.VarChar, 50, "WorkTypeName"); updateCommand.Parameters.Add("@WorkTypeID", System.Data.SqlDbType.Int, 4, "WorkTypeID"); sql = "delete from WorkType Where WorkTypeID= @WorkTypeID"; SqlCommand deleteCommand = new SqlCommand(sql, conn); deleteCommand.Parameters.Add("@WorkTypeID", System.Data.SqlDbType.Int, 4, "WorkTypeID"); try { SqlHelper.UpdateDataset(insertCommand, deleteCommand, updateCommand, ds, "WorkType"); } catch { throw new Exception(); } }
public override global::System.Data.DataSet Clone() { WorkTypeDS cln = ((WorkTypeDS)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { WorkTypeDS ds = new WorkTypeDS(); 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 LineItem() : base(new Point(0, 0), new Size(724, 28), "LineItem", false) { // get the client lookup datea //_clientdata = TEMPOServerProxy.Instance.GetAllClients(); // get the project lookup datea _projectdata = TEMPOServerProxy.Instance.GetProjectsList(); // get all the worktype data _worktypedata = TEMPOServerProxy.Instance.GetAllWorkTypes(); // initialize the user interface UserInterfaceInitialization(); }
private void createRecord(object o, EventArgs e) { if (validateRecord()) { // perform save action WorkTypeDS ds = new WorkTypeDS(); WorkTypeDS.WorkTypeRow row = ds.WorkType.NewWorkTypeRow(); row.WorkTypeName = typename.Text; ds.WorkType.AddWorkTypeRow(row); try { RequestBroker.TEMPOServerProxy.Instance.UpdateWorkTypes(ds); } catch { MessageBox.Show(this.getStringResource("68")); return; } // success message MessageBox.Show(this.getStringResource("69")); // notify the world onRecordMaintained(); // then reset the panel resetPanel(); } }
/// <summary> /// Get all the WorkTypes /// </summary> /// <returns>a strongly typed data set</returns> public WorkTypeDS GetAllWorkTypes() { string sql; sql = "select * from WorkType;"; WorkTypeDS ds = new WorkTypeDS(); string[] tables = new string[] { "WorkType" }; SqlParameter[] sqlparams = new SqlParameter[2]; SqlParameter temp = new SqlParameter("@WorkTypeID", SqlDbType.Int, 4, "WorkTypeID"); temp.Direction = System.Data.ParameterDirection.Output; sqlparams[0] = temp; temp = new SqlParameter("@WorkTypeName", SqlDbType.VarChar, 4, "WorkTypeName"); temp.Direction = System.Data.ParameterDirection.Output; sqlparams[1] = temp; SqlHelper.FillDataset(this.DBConnectionString, System.Data.CommandType.Text, sql, ds, tables, sqlparams); return(ds); }
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(); WorkTypeDS ds = new WorkTypeDS(); 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 = "WorkTypeDataTable"; 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 void UpdateWorkTypes(WorkTypeDS ds) { WorkTypeDALC dalc = new WorkTypeDALC(); dalc.Update(ds); }