C# (CSharp) PartsHandler Examples

Example #1

File: mysqlpartsdb.cs Project: jnwatts/cs320_project2_group11

    public override void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler)
    {
        string sql = "SELECT * FROM Parts AS P NATURAL LEFT JOIN " + partType.name + "_attributes AS A WHERE P.Part_type_id = " + partType.typeId;

        Execute(sql, delegate(DataTable result) {
            PartCollection parts = new PartCollection(result);
            if (partsHandler != null)
            {
                partsHandler(parts);
            }
        }, errorHandler);
    }

Example #2

    public override void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler)
    {
        SqlCommandBuilder bld = new SqlCommandBuilder();
        SqlCommand        cmd = new SqlCommand();
        string            tableNameEscaped = bld.QuoteIdentifier(partType.name);

        cmd.CommandType = System.Data.CommandType.Text;
#if DEBUG
        cmd.CommandText = string.Format("SELECT TOP 4 * FROM {0} ORDER BY [Part Number] ASC", tableNameEscaped);
#else
        cmd.CommandText = string.Format("SELECT * FROM {0} ORDER BY [Part Number] ASC", tableNameEscaped);
#endif
        Execute(cmd, delegate(DataTable result) {
            result.Columns["Part Number"].ColumnName = "Part_num";
            //result.Columns.Remove("Part Type");
            PartCollection parts = new PartCollection(result);
            if (partsHandler != null)
            {
                partsHandler(parts);
            }
        }, errorHandler);
    }

Example #3

File: sqlpartsdb.cs Project: jnwatts/cs320_project2_group11

 public override void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler)
 {
     SqlCommandBuilder bld = new SqlCommandBuilder();
     SqlCommand cmd = new SqlCommand();
     string tableNameEscaped = bld.QuoteIdentifier(partType.name);
     cmd.CommandType = System.Data.CommandType.Text;
     #if DEBUG
     cmd.CommandText = string.Format("SELECT TOP 4 * FROM {0} ORDER BY [Part Number] ASC", tableNameEscaped);
     #else
     cmd.CommandText = string.Format("SELECT * FROM {0} ORDER BY [Part Number] ASC", tableNameEscaped);
     #endif
     Execute(cmd, delegate(DataTable result) {
         result.Columns["Part Number"].ColumnName = "Part_num";
         //result.Columns.Remove("Part Type");
         PartCollection parts = new PartCollection(result);
         if (partsHandler != null) {
             partsHandler(parts);
         }
     }, errorHandler);
 }

Example #4

 public abstract void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler);

Example #5

File: mysqlpartsdb.cs Project: jnwatts/cs320_project2_group11

 public override void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler)
 {
     string sql = "SELECT * FROM Parts AS P NATURAL LEFT JOIN " + partType.name + "_attributes AS A WHERE P.Part_type_id = " + partType.typeId;
     Execute(sql, delegate(DataTable result) {
         PartCollection parts = new PartCollection(result);
         if (partsHandler != null) {
             partsHandler(parts);
         }
     }, errorHandler);
 }

Example #6

File: partsdb.cs Project: jnwatts/cs320_project2_group11

 public abstract void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler);