protected void btnSubmit_Click(object sender, EventArgs e) { // lblTest.Text = ImageUploader.FileName; DateTime dt; if (DatePicker1.Date.HasValue) { dt = (DateTime)DatePicker1.Date; } else { dt = DateTime.Now; } if (txtTime.Text == "") { txtTime.Text = DateTime.Now.ToString("hh:mm"); } //StringBuilder sb = new StringBuilder(HttpUtility.HtmlEncode(txtNewsBody.Text)); //sb.Replace("<b>", "<b>"); //sb.Replace("</b>", "</b>"); //sb.Replace("<i>", "<i>"); //sb.Replace("</i>", "</i>"); News nw = new News(txtTime.Text, dt, txtDescTitle.Text, txtTitle1.Text, txtTitle2.Text, txtNewsSummery.Text, txtNewsBody.Text, image_src.Value, txtNewsResource.Text, true, symbols.Value); // lblTest.Text = nw.news_body; if (edit_mode == false) database.InsertNews(nw, symbols.Value.ToString(), "i", news_id); else database.InsertNews(nw, symbols.Value.ToString(), "e", news_id); }
public static News LoadNewsForEdit(int news_id) { DataTable dt = LoadNews(news_id); News nw = new News(dt.Rows[0]["time"].ToString(), (DateTime)dt.Rows[0]["datetime"], dt.Rows[0]["TitleDesc"].ToString(), dt.Rows[0]["Titl1"].ToString(), dt.Rows[0]["Title2"].ToString(), dt.Rows[0]["Summery"].ToString(), dt.Rows[0]["Body"].ToString(), dt.Rows[0]["ImageUrl"].ToString(), dt.Rows[0]["Link"].ToString(), (bool)dt.Rows[0]["Publication"], dt.Rows[0]["symbols"].ToString()); return nw; }
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(); }