protected void bindDetailsToListView()
{
IGTMAIN.cmdtext = IGTMAIN.cmdtextAll;
IGTMAIN.GetDataLP();
lstViewDetails.DataSource = IGTMAIN.dtlp;
lstViewDetails.DataBind();
}
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 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);
}
}
