protected void chb_chnage(object sender, EventArgs e)
{
CheckBox chb = (CheckBox)sender;
string js = "";
string cols = "";
if (chb.Checked)
{
List <USP_getallcolumnsResult> obj = Reportgenrator.Getallcolumns(chb.ToolTip);
for (int i = 0; i < obj.Count; i++)
{
cols += obj[i].COLUMN_NAME + "~" + obj[i].DATA_TYPE + "~" + obj[i].CHARACTER_MAXIMUM_LENGTH.ToString() + "^";
}
if (cols.Length > 0)
{
cols = cols.Substring(0, cols.Length - 1);
}
js = "createtable('" + chb.ToolTip + "','" + cols + "');";
ddlmtables.Items.Add(new ListItem(chb.ToolTip));
}
else
{
js = "removetable('" + chb.ToolTip + "');";
ddlmtables.Items.Remove(ddlmtables.Items.FindByText(chb.ToolTip));
}
ScriptManager.RegisterStartupScript(Page, GetType(), "js", js, true);
}
protected void ddlrpt_change(object sender, EventArgs e)
{
if (ddlrpt.SelectedValue != "22")
{
chklicensetypes.Visible = false;
btngenerate.Visible = false;
lblcounty.Visible = false;
ddl_county.Visible = false;
DataSet ds = Reportgenrator.Getrpt("select * from tbl_rpt_details where rptid=" + ddlrpt.SelectedValue);
if (ds.Tables[0].Rows.Count > 0)
{
hfdquery.Value = ds.Tables[0].Rows[0]["query"].ToString();
hfdfltrs.Value = ds.Tables[0].Rows[0]["fltrs"].ToString();
hfdcols.Value = ds.Tables[0].Rows[0]["ordby"].ToString();
}
ScriptManager.RegisterStartupScript(Page, GetType(), "js", "afterbind()", true);
}
else
{
lblcounty.Visible = true;
ddl_county.Visible = true;
chklicensetypes.Visible = true;
btngenerate.Visible = true;
ScriptManager.RegisterStartupScript(Page, GetType(), "js", "HideDivandResultPanel()", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlrpt.DataSource = Reportgenrator.Getrpt("select rptname,rptid from tbl_rpt_details where rpttype like 'R' order by rptname");
ddlrpt.DataTextField = "rptname";
ddlrpt.DataValueField = "rptid";
ddlrpt.DataBind();
if (ddlrpt.SelectedIndex != -1)
{
ddlrpt_change(null, null);
}
chklicensetypes.DataSource = Reportgenrator.GetLicensetype();
chklicensetypes.DataTextField = "License_Type";
chklicensetypes.DataValueField = "LicenseType_ID";
chklicensetypes.DataBind();
ddl_county.DataSource = Person_Details.Licensing_Details.Get_Lkp_tablesdata(10);
ddl_county.DataValueField = "Lkp_data_ID";
ddl_county.DataTextField = "Values";
ddl_county.DataBind();
ddl_county.Items.Insert(0, new ListItem("All", "-1"));
var items = from ListItem li in ddl_county.Items
where li.Text.Contains("All")
select li;
foreach (ListItem li in items)
{
li.Selected = true;
}
}
}
protected void ddlviews_changed(object sender, EventArgs e)
{
ddlselectcolmns.DataSource = Reportgenrator.Getallcolumns(ddlviews.SelectedItem.Text);
ddlselectcolmns.DataTextField = "COLUMN_NAME";
ddlselectcolmns.DataValueField = "COLUMN_NAME";
ddlselectcolmns.DataBind();
ddlcols_change(null, null);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// dtlst.DataSource = Reportgenrator.Getalltables().OrderBy(c => c.TABLE_NAME);
// dtlst.DataBind();
dtlst1.DataSource = Reportgenrator.Getallviews();
dtlst1.DataBind();
}
}
protected void btndel_click(object sender, EventArgs e)
{
Reportgenrator.Delete_print(Convert.ToInt32(hfdselprnt.Value));
if (File.Exists(Server.MapPath("../Prints") + "//" + hfdselprnt.Value + ".aspx"))
{
File.Delete(Server.MapPath("../Prints") + "//" + hfdselprnt.Value + ".aspx");
}
btnclr_click(null, null);
ScriptManager.RegisterStartupScript(Page, GetType(), "js", "afterdel()", true);
}
protected void btnedit_click(object sender, EventArgs e)
{
tbl_print obj = Reportgenrator.Get_printdetails(hfdselprnt.Value);
string ftxt = File.ReadAllText(Server.MapPath("../Prints") + "//" + hfdselprnt.Value + ".aspx");
int sind = ftxt.IndexOf("<div class=Section1>") + 20;
int lind = ftxt.LastIndexOf("</div>");
txtsummarycomplaint.Text = ftxt.Substring(sind, lind - sind).Replace("<%=", ":%=").Replace("%>", "%:");
txtfilename.Text = obj.fname;
ScriptManager.RegisterStartupScript(Page, GetType(), "js", "afteredit()", true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlviews.DataSource = Reportgenrator.Getallviews_frm();
ddlviews.DataTextField = "view_name";
ddlviews.DataValueField = "view_name";
ddlviews.DataBind();
ddlviews_changed(null, null);
//Page.GetPostBackEventReference(btndel);
}
}
protected void btn_save_click(object sender, EventArgs e)
{
string filepath = Reportgenrator.Insert_print(Convert.ToInt32(hfdselprnt.Value), ddlflds.SelectedValue, ddlviews.SelectedItem.Text, txtfilename.Text, ddlselectcolmns.Items[0].Text);
if (File.Exists(Server.MapPath("../Prints") + "//" + filepath + ".aspx"))
{
File.Delete(Server.MapPath("../Prints") + "//" + filepath + ".aspx");
}
StringBuilder stb = new StringBuilder();
stb.Append(File.ReadAllText(Server.MapPath("../Prints") + "//top.txt").ToString());
stb.Append("@page Section1 ");
stb.Append("{size:" + txtpagewidth.Text + " " + txtpageheight.Text + "; ");
stb.Append("margin:" + txtmrgtop.Text + " " + txtmrgrght.Text + " " + txtmrgbotom.Text + " " + txtmrgleft.Text + ";} ");
stb.Append("div.Section1 ");
stb.Append("{page:Section1;} ");
stb.Append("Table ");
stb.Append("{ ");
stb.Append("font-family:Arial; ");
stb.Append("font-size:11pt; ");
stb.Append("} ");
stb.Append("--> ");
stb.Append("</style> ");
stb.Append("</head> ");
stb.Append("<body lang=EN-US> ");
stb.Append("<div class=Section1> ");
string str = txtsummarycomplaint.Text;
str = str.Replace(":%", "<%");
str = str.Replace("%:", "%>");
str = str.Replace(""", Convert.ToString('"'));
stb.Append(str);
stb.Append("</div></body></html>");
StreamWriter sw = File.CreateText(Server.MapPath("../Prints") + "//" + filepath + ".aspx");
sw.Write(stb);
sw.Close();
btnclr_click(null, null);
string js = "";
js = "clr();";
ScriptManager.RegisterStartupScript(Page, GetType(), "js1", js, true);
}
public DataSet binddrp(string oths)
{
string[] cls = oths.Split(',');
if (cls.Length == 3)
{
string query = "select " + cls[1] + " as disp," + cls[2] + " as val from " + cls[0] + " order by disp";
DataSet ds = Reportgenrator.Getrpt(query);
DataRow dr = ds.Tables[0].NewRow();
dr[0] = "All";
dr[1] = "0";
ds.Tables[0].Rows.InsertAt(dr, 0);
ds.AcceptChanges();
return(ds);
}
return(null);
}
protected void btnrpt_save(object sender, EventArgs e)
{
hfdrptid.Value = Reportgenrator.Save_rpt(hfdrptid.Value, txtrpt.Text, hfdquery.Value, hfdfltrs.Value, hfdcols.Value);
// ScriptManager.RegisterStartupScript(Page, GetType(), "js", "aftersave()", true);
Page.RegisterStartupScript("js", "<script>aftersave();</script>");
}
protected void btndel_click(object sender, EventArgs e)
{
Reportgenrator.Delete_rpt(Convert.ToInt32(hfdsel.Value));
ScriptManager.RegisterStartupScript(Page, GetType(), "js", "afterdel()", true);
}