protected void btn_entry_send_Click(object sender, EventArgs e) { object user = Session["username"]; if (user != null) { // String a = div_write_entry.InnerText; // String date12 = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"); DateTime date = DateTime.UtcNow; String content = div_write_entry.Text.ToString().ToLower(); int writerid = getWriterID(user.ToString()); int titleid = getTitleID(lbl_default_title_name.Text); String url = Helper.SEOUrl(getTitle(titleid)); if (titleid != -1 && content != null) { var connect = new SqlConnection(con); var cmd = connect.CreateCommand(); cmd.CommandText = "insert into ENTRY (Date, Contents, WriterID, WriterName, TitleID, TitleName, Visible, FavCount, LikeCount, DislCount) values (@date, @content, @writerid, @writername, @titleid, @titlename, 'True', 0, 0, 0)"; cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@content", content); cmd.Parameters.AddWithValue("@writerid", writerid); cmd.Parameters.AddWithValue("@writername", user.ToString()); cmd.Parameters.AddWithValue("@titleid", titleid); cmd.Parameters.AddWithValue("@titlename", lbl_default_title_name.Text); connect.Open(); try { var reader = cmd.ExecuteNonQuery(); TitleLayer.setTitleUpdate(titleid); div_write_entry.Text = ""; Response.Redirect(url); } catch (Exception ex) { lbl_entrysend_status.Text = ex.Message.ToString(); } connect.Close(); } else { lbl_entrysend_status.Text = "entry boş ya da bu başlığa entry girişi durduruldu."; } } else { Response.Redirect("/User/Login.aspx"); } }
//burası lissolkanat //protected void listSolKanat_SelectedIndexChanged(object sender, EventArgs e) //{ // loadEntries(listSolKanat.SelectedItem.ToString()); // lbl_default_title_name.Text = listSolKanat.SelectedItem.ToString(); //} protected void btn_entry_send_Click(object sender, EventArgs e) { object user = Session["username"]; if (user != null) { DateTime date = DateTime.Now; String content = txt_write_entry.Text; int writerid = getWriterID(user.ToString()); int titleid = getTitleID(lbl_default_title_name.Text); if (titleid != -1) { var connect = new SqlConnection(con); var cmd = connect.CreateCommand(); cmd.CommandText = "insert into ENTRY (Date, Contents, WriterID, WriterName, TitleID, TitleName, Visible, FavCount, LikeCount, DislCount) values (@date, @content, @writerid, @writername, @titleid, @titlename, 'True', 0, 0, 0)"; cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@content", content); cmd.Parameters.AddWithValue("@writerid", writerid); cmd.Parameters.AddWithValue("@writername", user.ToString()); cmd.Parameters.AddWithValue("@titleid", titleid); cmd.Parameters.AddWithValue("@titlename", lbl_default_title_name.Text); connect.Open(); try { var reader = cmd.ExecuteNonQuery(); TitleLayer.setTitleUpdate(titleid); txt_write_entry.Text = ""; loadEntries(lbl_default_title_name.Text); } catch (Exception ex) { } connect.Close(); } else { lbl_entrysend_status.Text = "bu başlığa entry girişi durduruldu."; } } else { Response.Redirect("/User/Login.aspx"); } }