public static void InsertNews(News nw, string symbols, string mode, int news_id)
{
SqlConnection cnn = new SqlConnection(connection_string);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insertNewsSite";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tmpDateTime", nw.getPublishDatetime());
cmd.Parameters.AddWithValue("@tpmDatOfEvent", DateTime.Now);
cmd.Parameters.AddWithValue("@tmpTitleDesc", nw.getDescTitle());
cmd.Parameters.AddWithValue("@tmpTitl1", nw.getTitle1());
cmd.Parameters.AddWithValue("@tmpTitle2", nw.getTitle2());
cmd.Parameters.AddWithValue("@tmpSummery", nw.getNewsSummery());
cmd.Parameters.AddWithValue("@tmpBody", nw.getNewsBody());
cmd.Parameters.AddWithValue("@tmpLink", nw.getNewsResource());
cmd.Parameters.AddWithValue("@tmpImageUrl", nw.getImageFileName());
cmd.Parameters.AddWithValue("@tmpPublication", nw.getPublication());
cmd.Parameters.AddWithValue("@tmpIdEdited", false);
cmd.Parameters.AddWithValue("@tmpSymbolString", symbols);
cmd.Parameters.AddWithValue("@time", nw.getTime());
cmd.Parameters.AddWithValue("@mode", mode);
cmd.Parameters.AddWithValue("@news_id", news_id);
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
}
private void loadNews(News nw)
{
txtTime.Text = nw.getTime();
DatePicker1.Date = nw.getPublishDatetime();
txtTitle1.Text = nw.getTitle1();
txtTitle2.Text = nw.getTitle2();
txtDescTitle.Text = nw.getDescTitle();
txtNewsBody.Text = nw.getNewsBody();
txtNewsResource.Text = nw.getNewsResource();
txtNewsSummery.Text = nw.getNewsSummery();
chkPublish.Checked = nw.getPublication();
image_src.Value = nw.getImageFileName();
// symbols.Value = nw.getSymbolString();
ParseSymbolString(nw.getSymbolString());
//symbolNames.Value =
}
private void loadNews(News nw)
{
txtTime.Text = nw.getTime();
DatePicker1.Date = nw.getPublishDatetime();
txtTitle1.Text = nw.getTitle1();
txtTitle2.Text = nw.getTitle2();
txtDescTitle.Text = nw.getDescTitle();
txtNewsBody.Text = nw.getNewsBody();
txtNewsResource.Text = nw.getNewsResource();
txtNewsSummery.Text = nw.getNewsSummery();
chkPublish.Checked = nw.getPublication();
image_src.Value = nw.getImageFileName();
// symbols.Value = nw.getSymbolString();
ParseSymbolString(nw.getSymbolString());
//symbolNames.Value =
}
public static void InsertNews(News nw, string symbols, string mode, int news_id)
{
SqlConnection cnn = new SqlConnection(connection_string);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insertNewsSite";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tmpDateTime", nw.getPublishDatetime());
cmd.Parameters.AddWithValue("@tpmDatOfEvent", DateTime.Now);
cmd.Parameters.AddWithValue("@tmpTitleDesc", nw.getDescTitle());
cmd.Parameters.AddWithValue("@tmpTitl1", nw.getTitle1());
cmd.Parameters.AddWithValue("@tmpTitle2", nw.getTitle2());
cmd.Parameters.AddWithValue("@tmpSummery", nw.getNewsSummery());
cmd.Parameters.AddWithValue("@tmpBody", nw.getNewsBody());
cmd.Parameters.AddWithValue("@tmpLink", nw.getNewsResource());
cmd.Parameters.AddWithValue("@tmpImageUrl", nw.getImageFileName());
cmd.Parameters.AddWithValue("@tmpPublication", nw.getPublication());
cmd.Parameters.AddWithValue("@tmpIdEdited", false);
cmd.Parameters.AddWithValue("@tmpSymbolString", symbols);
cmd.Parameters.AddWithValue("@time", nw.getTime());
cmd.Parameters.AddWithValue("@mode", mode);
cmd.Parameters.AddWithValue("@news_id", news_id);
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
}
