public ParsedData Copy() { ParsedData tmp = new ParsedData(); tmp.parsertype = this.parsertype; tmp.orig = this.orig; tmp.firmname = this.firmname; tmp.art = this.art; tmp.desc = this.desc; tmp.statistic = this.statistic; tmp.price = this.price; return(tmp); }
public void InsertParsedData(int OrderId, ParsedData d) { string sql = string.Format("insert Into ParsedData " + "(OrderId, ParseDate, ParserType, Original, Firmname, Artikul, Description,Statistic,Price," + "SearchedArtikul,Url) values " + "(@OrderId,@ParseDate,@ParserType,@Original,@Firmname,@Artikul,@Description,@Statistic,@Price," + "@SearchedArtikul,@Url)"); using (SqlCommand cmd = new SqlCommand(sql, this.sqlCn)) { SqlParameter p = new SqlParameter(); p.ParameterName = "@OrderId"; p.Value = OrderId; p.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@SearchedArtikul"; p.Value = d.searchedArtikul; p.SqlDbType = SqlDbType.NChar; p.Size = 20; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@Url"; p.Value = d.url; p.SqlDbType = SqlDbType.NChar; p.Size = 300; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@ParseDate"; p.Value = DateTime.Now.Date; p.SqlDbType = SqlDbType.Date; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@ParserType"; p.Value = d.parsertype; p.SqlDbType = SqlDbType.NChar; p.Size = 20; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@Original"; p.Value = d.orig; p.SqlDbType = SqlDbType.NChar; p.Size = 20; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@Firmname"; p.Value = d.firmname; p.SqlDbType = SqlDbType.NChar; p.Size = 20; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@Artikul"; p.Value = d.art; p.SqlDbType = SqlDbType.NChar; p.Size = 20; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@Description"; p.Value = d.desc; p.SqlDbType = SqlDbType.NChar; p.Size = 300; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@Statistic"; p.Value = d.statistic; p.SqlDbType = SqlDbType.NChar; p.Size = 10; cmd.Parameters.Add(p); p = new SqlParameter(); p.ParameterName = "@Price"; p.Value = d.price; p.SqlDbType = SqlDbType.Decimal; p.Precision = 8; p.Scale = 2; cmd.Parameters.Add(p); cmd.ExecuteNonQuery(); } }