protected void btn_Submit_Click(object sender, EventArgs e) { string[] delimiters = new string[] { "---" }; string[] txtdiv = ddl_News_Type.Text.ToString().Split(delimiters, StringSplitOptions.RemoveEmptyEntries); txt_News_Code.Text = txtdiv[1].ToString() + "--" + txt_Title.Text.Replace(' ', '-'); if (!string.IsNullOrEmpty(txt_Title.Text) || !string.IsNullOrEmpty(txt_ETitle.Text) || !string.IsNullOrEmpty(txt_News_Code.Text) || !string.IsNullOrEmpty(txt_Story_Details.Text) || !string.IsNullOrEmpty(txt_link_name.Text)) { IGTMAIN.cmdtext = IGTMAIN.cmdtextAll; IGTMAIN.GetDataLP(); DataRow[] dr = IGTMAIN.dtlp.Select("News_Code = '" + txt_News_Code.Text + "'"); if (dr.Length == 0) { using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { string cmdText = "INSERT INTO News_Details (News_Type_Code,News_Code,Is_Breaking,Title,ETitle,Intro,MetaKey,MetaDesc,Story_Details,link_name,Posted_By" + ",Written_By,Covered_By,Photo_By,Status,Remarks,State,City,Created_Date,Created_IP,Created_MAC,Created_By)" + "VALUES" + "(@News_Type_Code,@News_Code,@Is_Breaking,@Title,@ETitle,@Intro,@MetaKey, @MetaDesc, @Story_Details,@link_name,@Posted_By" + ",@Written_By,@Covered_By,@Photo_By,@Status,@Remarks,@State,@City,@Created_Date,@Created_IP,@Created_MAC,@Created_By)"; SqlCommand cmd = new SqlCommand(cmdText, con); cmd.Parameters.AddWithValue("@News_Type_Code", ddl_News_Type.Text.ToUpper()); cmd.Parameters.AddWithValue("@News_Code", txt_News_Code.Text.ToUpper()); cmd.Parameters.AddWithValue("@Is_Breaking", ddl_Breaking.Text.ToUpper()); cmd.Parameters.AddWithValue("@Title", txt_Title.Text.ToUpper()); cmd.Parameters.AddWithValue("@ETitle", txt_ETitle.Text.ToUpper()); cmd.Parameters.AddWithValue("@Intro", txt_Intro.Text.ToUpper()); cmd.Parameters.AddWithValue("@MetaKey", txt_Keyword.Text); cmd.Parameters.AddWithValue("@MetaDesc", txt_Desc.Text); cmd.Parameters.AddWithValue("@Story_Details", txt_Story_Details.Text.ToString()); cmd.Parameters.AddWithValue("@link_name", txt_link_name.Text); cmd.Parameters.AddWithValue("@Posted_By", HttpContext.Current.Session["User_ID"].ToString()); cmd.Parameters.AddWithValue("@Written_By", txt_Written_By.Text.ToUpper()); cmd.Parameters.AddWithValue("@Covered_By", txt_Covered_By.Text); cmd.Parameters.AddWithValue("@Photo_By", txt_Photo_By.Text.ToUpper()); cmd.Parameters.AddWithValue("@Status", ddl_Status.Text.ToUpper()); cmd.Parameters.AddWithValue("@Remarks", txt_Remarks.Text); cmd.Parameters.AddWithValue("@State", ddl_State.Text); cmd.Parameters.AddWithValue("@City", ddl_City.Text); cmd.Parameters.AddWithValue("@Created_Date", DateTime.Now.ToString("yyyyMMddHHmmss")); cmd.Parameters.AddWithValue("@Created_IP", IGTMAIN.GetIpAddress().ToString()); cmd.Parameters.AddWithValue("@Created_MAC", IGTMAIN.GetMacAddress().ToString()); cmd.Parameters.AddWithValue("@Created_By", HttpContext.Current.Session["User_ID"].ToString()); con.Open(); cmd.ExecuteNonQuery(); } string script = "alert(\"New Record is Added Successfully.\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); lbl_Message.Text = "New Record is Added Successfully."; txt_link_name.Enabled = true; // ImageUpload(); } else { string script = "alert(\"News Already Exist.\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } } else { string script = "alert(\"Enter All Fields.\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }
protected void Page_Load(object sender, EventArgs e) { string _innerhtmlB = string.Empty; using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { string cmdText = "INSERT INTO Visit_Details (Device_Type ,Page_Name ,Visit_Date,Visit_IP,Visit_MAC ,Remarks) VALUES (@Device_Type ,@Page_Name ,@Visit_Date ,@Visit_IP ,@Visit_MAC ,@Remarks)"; SqlCommand cmd = new SqlCommand(cmdText, con); cmd.Parameters.AddWithValue("@Device_Type", IGTMAIN.IsMobileBrowser().ToString()); cmd.Parameters.AddWithValue("@Page_Name", Page.AppRelativeVirtualPath.ToString()); cmd.Parameters.AddWithValue("@Visit_Date", DateTime.Now.ToString("yyyyMMddHHmmss")); cmd.Parameters.AddWithValue("@Visit_IP", IGTMAIN.GetIpAddress().ToString()); cmd.Parameters.AddWithValue("@Visit_MAC", IGTMAIN.GetMacAddress().ToString()); cmd.Parameters.AddWithValue("@Remarks", "OK"); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { // _innerhtmlB = " <marquee direction=\"left\" scrollamount=\"4\" onmouseover=\"this.stop();\" onmouseout=\"this.start();\" \" >"; int i = 0; string cmdText = "SELECT TOP 9 * FROM News_Details where Status='ACTIVE' and Is_Breaking ='YES' order by PDate DESC,Priority, Modified_Date desc"; SqlCommand cmd = new SqlCommand(cmdText, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { string title = dr["Title"].ToString().Replace("<br/>", ""); breakingnews[i] = " <a href=\"../" + dr["link_name"].ToString() + ".aspx\" title =\"" + title + "\" target=\"_blank\" style=\"color:white;padding-left: 10px; line-height:140%;font-size:16px; font-weight: bold;font-family: \"Mangal\"; \">" + dr["Title"].ToString() + " </a>"; i++; } } con.Close(); } div_breaking.InnerHtml = breakingnews[0]; breakingnewsno = 0; using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { // <marquee direction="up" scrollamount="4" onmouseover="this.stop();" onmouseout="this.start();" style="width: 200px; height: 190px; margin-top: 0px; " > <br /> <br /> <a href="WORLD_WIDE_WORKSHOP_ON_APOSTOLIC_PLANNING.aspx" style="text-align: left; color: white; text-transform: uppercase;" title="WORLD WIDE WORKSHOP (WWW) ON APOSTOLIC PLANNING" target="_blank">WORLD WIDE WORKSHOP (WWW) ON APOSTOLIC PLANNING</a> <br /> <br /> <a href="My_Personal_Journey_of_Self_discovery_and_Transformation.aspx" style="text-align: left; color: white; text-transform: uppercase;" title="My Personal Journey of Self-discovery and Transformation" target="_blank">My Personal Journey of Self-discovery and Transformation</a> _innerhtmlB = " <p style=\"color:white; line-height:120%;font-size:24px; font-weight: bold;font-family: Mangal; text-align:center;\"> LIVE NEWS</p><hr style=\"height: 0; margin-top: 0px; margin-bottom: 0px; border: 0; border-top: 3px solid #ffffff;\"/> <marquee direction=\"up\" scrollamount=\"3\" onmouseover=\"this.stop();\" onmouseout=\"this.start();\" style=\" height: 300px; margin-top: 0px; \" > "; int i = 0; string cmdText = "SELECT TOP 50 * FROM News_Details where Status='ACTIVE' and Is_Breaking ='YES' order by PDate DESC,Priority, Modified_Date desc"; SqlCommand cmd = new SqlCommand(cmdText, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { string title = dr["Title"].ToString().Replace("<br/>", ""); _innerhtmlB = _innerhtmlB + " <a href=\"../" + dr["link_name"].ToString() + ".aspx\" title =\"" + title + "\" target=\"_blank\" style=\"color:white;font-size:14px; font-weight: bold;font-family: \"Mangal\"; \">" + dr["Title"].ToString() + " </a> <hr style=\"height: 0; margin-top: 5px; margin-bottom: 5px; border: 0; border-top: 1px solid #333333;\"/>"; i++; } } con.Close(); } _innerhtmlB = _innerhtmlB + "</marquee>"; LiveNews.InnerHtml = _innerhtmlB; ////getting trending news using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { string cmdText = "select distinct page_name, count(page_name) as CountPage from [Visit_Details] where page_name like '%-%' group by page_name order by CountPage desc"; SqlCommand cmd = new SqlCommand(cmdText, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); int tnno = 0; while (dr.Read()) { _artrendingnews[tnno] = dr["page_name"].ToString(); tnno++; if (tnno == 10) { break; } } con.Close(); } _innerhtmlB = " <p style=\"color:white; line-height:120%;font-size:24px; font-weight: bold;font-family: Mangal; text-align:center;\"> Trending News</p><hr style=\"height: 0; margin-top: 0px; margin-bottom: 0px; border: 0; border-top: 3px solid #ffffff;\"/> <marquee direction=\"up\" scrollamount=\"3\" onmouseover=\"this.stop();\" onmouseout=\"this.start();\" style=\" height: 300px; margin-top: 0px; \" > "; string s = ""; for (int i = 0; i < _artrendingnews.Length; i++) { s = s + _artrendingnews[i]; //// if (j == null) break; string lj = _artrendingnews[i].ToString(); string[] topic_name = lj.Split('/'); string _topic_name = topic_name[topic_name.Length - 1]; _topic_name = _topic_name.Substring(0, _topic_name.Length - 5); using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { string cmdText = "SELECT * FROM News_Details where Status='ACTIVE' and link_name like '%" + _topic_name + "'";; SqlCommand cmd = new SqlCommand(cmdText, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string title = dr["Title"].ToString().Replace("<br/>", ""); string linkM = "~/" + dr["link_name"].ToString() + ".aspx"; //search the destination ID if (lj == linkM) { _innerhtmlB = _innerhtmlB + " <a href=\"../" + dr["link_name"].ToString() + ".aspx\" title =\"" + title + "\" target=\"_blank\" style=\"color:white;font-size:14px; font-weight: bold;font-family: \"Mangal\"; \">" + dr["Title"].ToString() + " </a> <hr style=\"height: 0; margin-top: 5px; margin-bottom: 5px; border: 0; border-top: 1px solid #333333;\"/>"; // i++; } } con.Close(); } } _innerhtmlB = _innerhtmlB + "</marquee>"; TrendingNews.InnerHtml = _innerhtmlB; using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { _innerhtmlB = ""; string cmdText = " SELECT top 1 Video_News_URL FROM Video_News order by Video_News_ID desc";; SqlCommand cmd = new SqlCommand(cmdText, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string vurl = dr["Video_News_URL"].ToString(); string[] _avurl = vurl.Split('/'); vurl = _avurl[_avurl.Length - 1]; _innerhtmlB = "<div class=\"video-responsive\" style=\"border: 5px solid black;background-color:black; color:black; \"> <iframe src=\"https://www.youtube.com/embed/" + vurl + "\" frameborder=\"0\" ></iframe> </div>"; } con.Close(); } ipyttv.InnerHtml = _innerhtmlB; }
protected void ImageUpload() { if (!string.IsNullOrEmpty(txt_Title.Text) || !string.IsNullOrEmpty(txt_ETitle.Text) || !string.IsNullOrEmpty(txt_News_Code.Text) || !string.IsNullOrEmpty(txt_Story_Details.Text) || !string.IsNullOrEmpty(txt_link_name.Text)) { lblImageMes.Text = ""; if (fileuploadTitle.HasFile == false) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", "<script>alert('No File Uploaded.')</script>", false); lblImageMes.Text = "No Title Images are available to Upload. "; } else { int imageno = 1; string ImageCode = ""; string ImgDirectoryName = ""; foreach (var file in fileuploadTitle.PostedFiles) { ImageCode = txt_link_name.Text.ToUpper() + imageno.ToString(); string[] imagename = ImageCode.Split('/'); string filename = Path.GetFileName(file.FileName); string[] fileex = filename.Split('.'); ImageCode = (DateTime.Now.ToString("yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture)); ImageCode = ImageCode + "/" + imagename[1] + "." + fileex[fileex.Length - 1]; //Code Saving only File file.SaveAs(Server.MapPath("/newsImages/" + ImageCode)); // string selcectstatementimages = "select Image_Code from News_Images_Details where Image_Code='" + ImageCode + "'"; //SqlDataAdapter daImage = new SqlDataAdapter(selcectstatementimages, IGTMAIN.CS); //DataTable dtImage = new DataTable(); //daImage.Fill(dtImage); using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { string cmdtext = "delete from News_Images_Details where Image_Code='" + ImageCode + "'"; SqlCommand cmd = new SqlCommand(cmdtext, con); con.Open(); cmd.ExecuteNonQuery(); } using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { SqlCommand cmd = new SqlCommand("INSERT INTO News_Images_Details(Image_Code,News_Code,Image_Name,Image_Title,Status,link_name,Remarks,Created_Date,Created_IP,Created_MAC,Created_By) VALUES(@Image_Code,@News_Code,@Image_Code,@Image_Title,@Status,@link_name,@Remarks,@Created_Date,@Created_IP,@Created_MAC,@Created_By)", con); cmd.Parameters.AddWithValue("@Image_Code", ImageCode); cmd.Parameters.AddWithValue("@News_Code", txt_News_Code.Text); cmd.Parameters.AddWithValue("@Image_Title", ""); cmd.Parameters.AddWithValue("@Status", "ACTIVE"); cmd.Parameters.AddWithValue("@link_name", txt_link_name.Text); cmd.Parameters.AddWithValue("@Remarks", ""); cmd.Parameters.AddWithValue("@Created_Date", DateTime.Now.ToString("yyyyMMddHHmmss")); cmd.Parameters.AddWithValue("@Created_IP", IGTMAIN.GetIpAddress().ToString()); cmd.Parameters.AddWithValue("@Created_MAC", IGTMAIN.GetMacAddress().ToString()); cmd.Parameters.AddWithValue("@Created_By", HttpContext.Current.Session["User_ID"].ToString()); con.Open(); cmd.ExecuteNonQuery(); } imageno++; } if (fileuploadimages.HasFile == false) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", "<script>alert('No File Uploaded.')</script>", false); lblImageMes.Text = "No Images are available to Upload. "; } else { imageno = 2; ImageCode = ""; foreach (var file in fileuploadimages.PostedFiles) { ImageCode = txt_link_name.Text.ToUpper() + imageno.ToString(); string[] imagename = ImageCode.Split('/'); string filename = Path.GetFileName(file.FileName); string[] fileex = filename.Split('.'); ImageCode = (DateTime.Now.ToString("yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture)); ImageCode = ImageCode + "/" + imagename[1] + "." + fileex[fileex.Length - 1]; //Code for changing Image Size Widht Height Quality ect /* file.SaveAs(Server.MapPath("/images/" + filename)); * string urlImage = Server.MapPath("/images/" + filename); * Bitmap image1 = new Bitmap(@urlImage, true); * urlImage = Server.MapPath("/images/" + ImageCode); * ImagesChangeandSave(image1, 500, 400, 5, urlImage); */ //Code Saving only File file.SaveAs(Server.MapPath("/newsImages/" + ImageCode)); using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { string cmdtext = "delete from News_Images_Details where Image_Code='" + ImageCode + "'"; SqlCommand cmd = new SqlCommand(cmdtext, con); con.Open(); cmd.ExecuteNonQuery(); } using (SqlConnection con = new SqlConnection(IGTMAIN.CS)) { //INSERT INTO #table1 (Id, guidd, TimeAdded, ExtraData) SELECT Id, guidd, TimeAdded, ExtraData FROM #table2 WHERE NOT EXISTS (Select Id, guidd From #table1 WHERE #table1.id = #table2.id) SqlCommand cmd = new SqlCommand("INSERT INTO News_Images_Details(Image_Code,News_Code,Image_Name,Image_Title,Status,link_name,Remarks,Created_Date,Created_IP,Created_MAC,Created_By) VALUES(@Image_Code,@News_Code,@Image_Code,@Image_Title,@Status,@link_name,@Remarks,@Created_Date,@Created_IP,@Created_MAC,@Created_By)", con); cmd.Parameters.AddWithValue("@Image_Code", ImageCode); cmd.Parameters.AddWithValue("@News_Code", txt_News_Code.Text); cmd.Parameters.AddWithValue("@Image_Title", ""); cmd.Parameters.AddWithValue("@Status", "ACTIVE"); cmd.Parameters.AddWithValue("@link_name", txt_link_name.Text); cmd.Parameters.AddWithValue("@Remarks", ""); cmd.Parameters.AddWithValue("@Created_Date", DateTime.Now.ToString("yyyyMMddHHmmss")); cmd.Parameters.AddWithValue("@Created_IP", IGTMAIN.GetIpAddress().ToString()); cmd.Parameters.AddWithValue("@Created_MAC", IGTMAIN.GetMacAddress().ToString()); cmd.Parameters.AddWithValue("@Created_By", HttpContext.Current.Session["User_ID"].ToString()); con.Open(); cmd.ExecuteNonQuery(); } imageno++; } } } lblImageMes.Text = "Images are uploaded Successfully."; btn_Upload.Enabled = false; fileuploadimages.Enabled = false; fileuploadTitle.Enabled = false; txt_News_Code.Enabled = false; txt_link_name.Enabled = false; } else { string script = "alert(\"Enter All Fields.\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } }