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();
}
}
