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