public void bindDetailToEdit(int id)
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "SELECT * FROM User_Details where User_ID=@Id";
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@Id", id);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
ddl_User_Type.Text = dr["User_Type"].ToString();
ddl_Status.Text = dr["User_Status"].ToString();
txt_User_Code.Text = dr["User_Code"].ToString();
txt_User_pass.Attributes.Add("value", IGTMAIN.Decryptdata(dr["User_pass"].ToString()));
txt_User_Name.Text = dr["User_Name"].ToString();
txt_User_Email.Text = dr["User_Email"].ToString();
txt_User_Phno.Text = dr["User_Phno"].ToString();
}
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
if (lbl_Message.Text == "Edit Data")
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "UPDATE User_Details SET User_Type=@User_Type, User_Status = @User_Status, User_pass = @User_pass ,User_Name=@User_Name, User_Email=@User_Email,User_Phno=@User_Phno WHERE User_ID=@Id";
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@User_Type", ddl_User_Type.Text);
cmd.Parameters.AddWithValue("@User_Status", ddl_Status.Text);
cmd.Parameters.AddWithValue("@User_Code", txt_User_Code.Text);
cmd.Parameters.AddWithValue("@User_pass", IGTMAIN.Encryptdata(txt_User_pass.Text));
cmd.Parameters.AddWithValue("@User_Name", txt_User_Name.Text);
cmd.Parameters.AddWithValue("@User_Email", txt_User_Email.Text);
cmd.Parameters.AddWithValue("@User_Phno", txt_User_Phno.Text);
cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(hfSelectedRecord.Value));
con.Open();
cmd.ExecuteNonQuery();
}
clearInputControls();
bindDetailsToListView();
hfSelectedRecord.Value = string.Empty;
lbl_Message.Text = "Record is Updated Successfully.";
}
else
{
DataRow[] dr = IGTMAIN.dtlp.Select("User_Code = '" + txt_User_Code.Text + "'");
if (dr.Length == 0)
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "INSERT INTO User_Details (User_Type, User_Status, User_Code,User_Name,User_pass,User_Email,User_Phno) VALUES (@User_Type, @User_Status, @User_Code,@User_Name,@User_pass,@User_Email,@User_Phno)";
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@User_Type", ddl_User_Type.Text);
cmd.Parameters.AddWithValue("@User_Status", ddl_Status.Text);
cmd.Parameters.AddWithValue("@User_Code", txt_User_Email.Text);
cmd.Parameters.AddWithValue("@User_pass", IGTMAIN.Encryptdata(txt_User_pass.Text));
cmd.Parameters.AddWithValue("@User_Name", txt_User_Name.Text);
cmd.Parameters.AddWithValue("@User_Email", txt_User_Email.Text);
cmd.Parameters.AddWithValue("@User_Phno", txt_User_Phno.Text);
con.Open();
cmd.ExecuteNonQuery();
}
clearInputControls();
bindDetailsToListView();
lbl_Message.Text = "New Record is Added Successfully.";
}
else
{
string script = "alert(\"User Already Exist.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
btn_Submit.Text = "Submit";
}
protected void bindDetailsToListView()
{
IGTMAIN.cmdtext = IGTMAIN.cmdtextAll;
IGTMAIN.GetDataLP();
lstViewDetails.DataSource = IGTMAIN.dtlp;
lstViewDetails.DataBind();
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
IGTMAIN.cmdtextAll = "Select * from User_Details ";
string script = "Welcome!!!";
if (txt_User_ID.Text.Length != 0 && txt_Password.Text.Length != 0)
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "SELECT * FROM User_Details where User_Code=@Id";
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@Id", txt_User_ID.Text.ToUpper());
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == false)
{
script = "alert(\" Wrong User Name Entered.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
else if (dr.HasRows == true)
{
dr.Read();
string _password = dr["User_pass"].ToString();
_password = IGTMAIN.Decryptdata(_password);
if (txt_Password.Text.ToUpper() == _password)
{
Session.RemoveAll();
Session["User_ID"] = dr["User_Name"].ToString();
Session["Login_Time"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Session["LActive_Time"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Session["Status"] = "ACTIVE";
Response.Redirect("AdminDefault.aspx");
}
else
{
script = "alert(\" Wrong Password entered.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
}
}
else
{
script = "alert(\" All Fields are Manadatory. Please fill and Submit again.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
if (txt_CPass.Text.Length > 0 && txt_NCPass.Text.Length > 0 && txt_NewPass.Text.Length > 0)
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "SELECT * FROM User_Details where User_Code='" + Session["User_ID"] + "'";
SqlCommand cmd = new SqlCommand(cmdText, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == false)
{
script = "alert(\" Wrong User Name Entered.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
else if (dr.HasRows == true)
{
dr.Read();
string _password = dr["User_pass"].ToString();
_password = IGTMAIN.Decryptdata(_password);
if (txt_CPass.Text == _password)
{
if (txt_NCPass.Text == txt_NewPass.Text)
{
updatepassword();
}
else
{
script = "alert(\"New Password and Confirm Password not Matching.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
else
{
script = "alert(\" Wrong Current Password entered.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
else
{
script = "alert(\" All Fields are Manadatory. Please fill and Submit again.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
}
}
protected void updatepassword()
{
using (SqlConnection con = new SqlConnection(IGTMAIN.CS))
{
string cmdText = "UPDATE User_Details SET User_pass =@User_pass where User_Name=@User_Name";
SqlCommand cmd = new SqlCommand(cmdText, con);
cmd.Parameters.AddWithValue("@User_Name", Session["User_ID"]);
cmd.Parameters.AddWithValue("@User_pass", IGTMAIN.Encryptdata(txt_NewPass.Text));
con.Open();
cmd.ExecuteNonQuery();
script = "alert(\" Password Succesfully Updated.\");";
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true);
}
}
protected void btn_csv_Click(object sender, ImageClickEventArgs e)
{
IGTMAIN.cmdtext = IGTMAIN.cmdtextlp;
IGTMAIN.GetDataLP();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + IGTMAIN.filename + ".csv");
Response.Charset = "";
Response.ContentType = "application/text";
StringBuilder sb = new StringBuilder();
sb.Append(IGTMAIN.Title1);
sb.Append("\r\n");
sb.Append(IGTMAIN.Title2);
sb.Append("\r\n");
sb.Append(IGTMAIN.Title3);
sb.Append("\r\n");
for (int k = 0; k < IGTMAIN.dtlp.Columns.Count; k++)
{
//add separator
sb.Append(IGTMAIN.dtlp.Columns[k].ColumnName + ',');
}
//append new line
sb.Append("\r\n");
for (int i = 0; i < IGTMAIN.dtlp.Rows.Count; i++)
{
for (int k = 0; k < IGTMAIN.dtlp.Columns.Count; k++)
{
//add separator
sb.Append(IGTMAIN.dtlp.Rows[i][k].ToString().Replace(",", ";") + ',');
}
//append new line
sb.Append("\r\n");
}
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}
protected void btn_word_Click(object sender, ImageClickEventArgs e)
{
IGTMAIN.cmdtext = IGTMAIN.cmdtextlp;
IGTMAIN.GetDataLP();
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=" + IGTMAIN.filename + ".doc");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.word";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
System.Web.UI.WebControls.GridView dg = new System.Web.UI.WebControls.GridView();
dg.Caption = IGTMAIN.Title;
dg.DataSource = IGTMAIN.dtlp;
dg.DataBind();
dg.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
protected void btn_excel_Click(object sender, ImageClickEventArgs e)
{
IGTMAIN.cmdtext = IGTMAIN.cmdtextlp;
IGTMAIN.GetDataLP();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=" + IGTMAIN.filename + ".xls");
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();
System.Web.UI.WebControls.GridView dg = new System.Web.UI.WebControls.GridView();
dg.Caption = IGTMAIN.Title;
dg.DataSource = IGTMAIN.dtlp;
dg.DataBind();
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
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 Page_Load(object sender, EventArgs e)
{
string bt = IGTMAIN.IsMobileBrowser();
string abv;
}
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 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);
}
}
