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 = }