protected void dgvTicket_OnRowDeleting(object sender, GridViewDeleteEventArgs e) { if (dgvTicket.Rows[e.RowIndex].Cells[9].Text != "False") { Utilities.editId = int.Parse(dgvTicket.DataKeys[e.RowIndex].Value.ToString()); string _txtName = dgvTicket.Rows[e.RowIndex].Cells[1].Text; int _currencyId = int.Parse(dgvTicket.Rows[e.RowIndex].Cells[4].Text); string _currency = dgvTicket.Rows[e.RowIndex].Cells[3].Text; string _txtPrice = dgvTicket.Rows[e.RowIndex].Cells[5].Text; string _txtMaxSession = dgvTicket.Rows[e.RowIndex].Cells[6].Text; string _txtMaxEntries = dgvTicket.Rows[e.RowIndex].Cells[7].Text; string _txtNumDays = dgvTicket.Rows[e.RowIndex].Cells[8].Text; bool _chkDuplicates = bool.Parse(dgvTicket.Rows[e.RowIndex].Cells[9].Text); string _txtDescription = dgvTicket.Rows[e.RowIndex].Cells[2].Text; EventTicketDataSet ticket = new EventTicketDataSet(); ticket.EventTicket.AddEventTicketRow(Utilities.editId, _txtName, decimal.Parse(_txtPrice), _currencyId, eventId, eventName, int.Parse(_txtMaxEntries), int.Parse(_txtNumDays), _chkDuplicates, false, _currency, int.Parse(_txtMaxSession), _txtDescription); dataProvider.UpdateEventTicketPrice(userToken, ticket); SetToast("success", "Currency deactivated succesfully"); } else { SetToast("info", "Currency already deactivated"); } DisplayTicketsInGrid(); }
public override global::System.Data.DataSet Clone() { EventTicketDataSet cln = ((EventTicketDataSet)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { EventTicketDataSet ds = new EventTicketDataSet(); 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 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(); EventTicketDataSet ds = new EventTicketDataSet(); 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 = "EventTicketDataTable"; 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 static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { EventTicketDataSet ds = new EventTicketDataSet(); 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; }
/// <summary> /// Returns the active events in the database /// </summary> /// <param name="userToken">The userToken of the user performing the request</param> ///<param name="eventId">The id of the event</param> /// <returns>An collection of inner variable which is an <see cref="SysParameterDataSet"/></returns> public EventTicketDataSet GetAllEventTicketPricesByEvent(string userToken, int eventId) { var retDataset = new EventTicketDataSet(); if (IsUserTokenValid(userToken)) { try { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "spGetAllEventTicketPricesByEvent"; var p = new SqlParameter("eventId", eventId); cmd.Parameters.Add(p); SqlDataReader reader = cmd.ExecuteReader(); if (reader != null) { while (reader.Read()) { var sysParam = retDataset.EventTicket.NewEventTicketRow(); sysParam.Id = int.Parse(reader["Id"].ToString()); sysParam.Name = reader["Name"].ToString(); sysParam.Price = Decimal.Parse(reader["Price"].ToString()); sysParam.CurrencyId = int.Parse(reader["CurrencyId"].ToString()); sysParam.EventName = reader["EventName"].ToString(); sysParam.EventId = int.Parse(reader["EventId"].ToString()); sysParam.NumDays = int.Parse(reader["NumDays"].ToString()); sysParam.MaxEntries = int.Parse(reader["MaxEntries"].ToString()); sysParam.Duplicates = bool.Parse(reader["Duplicates"].ToString()); sysParam.Active = bool.Parse(reader["Active"].ToString()); sysParam.MaxSession = int.Parse(reader["MaxSession"].ToString()); sysParam.Currency = reader["Currency"].ToString(); sysParam.Description = reader["Description"].ToString(); retDataset.EventTicket.AddEventTicketRow(sysParam); } reader.Close(); } } catch (Exception ex) { throw new OperationFailedException(ex.Message, ex); } finally { if (conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } } } return retDataset; }
/// <summary> /// Updates an event ticket and saves it in the database /// </summary> /// <param name="userToken">The userToken of the user performing the request</param> /// <param name="sysParameter">The system parameter to be added</param> /// <returns>An integer whih is the id of the newly created user</returns> public int UpdateEventTicketPrice(string userToken, EventTicketDataSet sysParameter) { int newId = -1; if (IsUserTokenValid(userToken)) { try { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "spUpdateEventTicketPrice"; var p2 = new SqlParameter[12]; for (int i = 0; i < 12; i++) p2[i] = new SqlParameter(); p2[0] = new SqlParameter("name", sysParameter.EventTicket[0].Name); p2[1] = new SqlParameter("eventId", sysParameter.EventTicket[0].EventId); p2[2] = new SqlParameter("price", sysParameter.EventTicket[0].Price); p2[3] = new SqlParameter("currencyId", sysParameter.EventTicket[0].CurrencyId); p2[4] = new SqlParameter("maxEntries", sysParameter.EventTicket[0].MaxEntries); p2[5] = new SqlParameter("numDays", sysParameter.EventTicket[0].NumDays); p2[6] = new SqlParameter("updateUser", _userId); p2[7] = new SqlParameter("duplicates", sysParameter.EventTicket[0].Duplicates); p2[8] = new SqlParameter("id", sysParameter.EventTicket[0].Id); p2[9] = new SqlParameter("active", sysParameter.EventTicket[0].Active); p2[10] = new SqlParameter("maxSession", sysParameter.EventTicket[0].MaxSession); p2[11] = new SqlParameter("description", sysParameter.EventTicket[0].Description); cmd.Parameters.AddRange(p2); newId = int.Parse(cmd.ExecuteScalar().ToString()); } catch (Exception ex) { throw new OperationFailedException(ex.Message, ex); } finally { if (conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } } } return newId; }
protected void dgvTicket_OnRowDeleting(object sender, GridViewDeleteEventArgs e) { if (dgvTicket.Rows[e.RowIndex].Cells[9].Text != "False") { Utilities.editId = int.Parse(dgvTicket.DataKeys[e.RowIndex].Value.ToString()); string _txtName = dgvTicket.Rows[e.RowIndex].Cells[1].Text; int _currencyId = int.Parse(dgvTicket.Rows[e.RowIndex].Cells[4].Text); string _currency = dgvTicket.Rows[e.RowIndex].Cells[3].Text; string _txtPrice = dgvTicket.Rows[e.RowIndex].Cells[5].Text; string _txtMaxSession = dgvTicket.Rows[e.RowIndex].Cells[6].Text; string _txtMaxEntries = dgvTicket.Rows[e.RowIndex].Cells[7].Text; string _txtNumDays = dgvTicket.Rows[e.RowIndex].Cells[8].Text; bool _chkDuplicates = bool.Parse(dgvTicket.Rows[e.RowIndex].Cells[9].Text); string _txtDescription = dgvTicket.Rows[e.RowIndex].Cells[2].Text; EventTicketDataSet ticket = new EventTicketDataSet(); ticket.EventTicket.AddEventTicketRow(Utilities.editId, _txtName, decimal.Parse(_txtPrice), _currencyId, eventId, eventName, int.Parse(_txtMaxEntries), int.Parse(_txtNumDays), _chkDuplicates,false, _currency, int.Parse(_txtMaxSession),_txtDescription); dataProvider.UpdateEventTicketPrice(userToken, ticket); SetToast("success", "Currency deactivated succesfully"); } else { SetToast("info", "Currency already deactivated"); } DisplayTicketsInGrid(); }
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(); EventTicketDataSet ds = new EventTicketDataSet(); 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 = "EventTicketDataTable"; 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); }