protected void Page_Load(object sender, EventArgs e)
{
Vd.isValidLogin();
if (!IsPostBack)
{
hideMessageBox();
clearAll(this.Form.Controls);
}
}
protected void Page_Load(object sender, EventArgs e)
{
bRes = false;
Vd.isValidLogin();
if (!IsPostBack)
{
try
{
ReportDocument rprt = new ReportDocument();
ConnectionInfo connInfo = new ConnectionInfo();
connInfo.ServerName = "edo";
connInfo.DatabaseName = "png";
connInfo.UserID = "sa";
connInfo.Password = "******";
TableLogOnInfo tableLogOnInfo = new TableLogOnInfo();
tableLogOnInfo.ConnectionInfo = connInfo;
rprt.Load(Server.MapPath("~\\RptTemp\\rptPLNA4-4.rpt"));
foreach (CrystalDecisions.CrystalReports.Engine.Table table in rprt.Database.Tables)
{
table.ApplyLogOnInfo(tableLogOnInfo);
table.LogOnInfo.ConnectionInfo.ServerName = connInfo.ServerName;
table.LogOnInfo.ConnectionInfo.DatabaseName = connInfo.DatabaseName;
table.LogOnInfo.ConnectionInfo.UserID = connInfo.UserID;
table.LogOnInfo.ConnectionInfo.Password = connInfo.Password;
// Apply the schema name to the table's location
table.Location = "dbo." + table.Location;
}
SqlConnection con = new SqlConnection(Db.GetConnectionString());
SqlCommand cmd = new SqlCommand("select * from [dbo].[vwUTLECDMRD] Where Month = 4 And Year = 2016", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds, "Newtbl_data");
rprt.SetDataSource(ds);
rprt.VerifyDatabase();
Label1.Text = ds.Tables[0].Rows[0]["Name"].ToString();
CrystalReportViewer1.ReportSource = rprt;
}
catch (Exception me)
{
bRes = false;
}
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
Vd.isValidLogin();
bRes = false;
if (!IsPostBack)
{
hideMessageBox();
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
Vd.isValidLogin();
if (!IsPostBack)
{
ddlMonthPeriod.Items.FindByValue(DateTime.Now.Month.ToString()).Selected = true;
txtYearPeriod.Text = DateTime.Now.Year.ToString();
hideMessageBox();
isEdit = false;
loadData();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Vd.isValidLogin();
if (!IsPostBack)
{
string v = Request.QueryString["LogOut"];
if (v != null)
{
Session["userid"] = null;
HttpContext.Current.Response.Redirect("./Default.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
bRes = false;
Vd.isValidLogin();
if (!IsPostBack)
{
Session["Edit"] = false;
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
Vd.isValidLogin();
if (!IsPostBack)
{
//ddlMonthPeriod.Items.FindByValue(DateTime.Now.Month.ToString()).Selected = true;
hideMessageBox();
clearAll(this.Form.Controls);
txtYearPeriod.Text = DateTime.Now.Year.ToString();
ddlMonthPeriod.Items.FindByValue(DateTime.Now.Month.ToString()).Selected = true;
getKWhRate();
BindGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
bRes = false;
Vd.isValidLogin();
if (!IsPostBack)
{
hideMessageBox();
ddlMonthPeriod.Items.FindByValue(DateTime.Now.Month.ToString()).Selected = true;
txtYearPeriod.Text = DateTime.Now.Year.ToString();
BindGridSort(ddlSort.SelectedValue.ToString());
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["EditCFS"] = null;
Session["DetailCFS"] = null;
Vd.isValidLogin();
if (!IsPostBack)
{
bAwal = true;
bNoData = false;
hideMessageBox();
//CreateDynamicGrid();
BindGrid();
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
Vd.isValidLogin();
if (!IsPostBack)
{
//string FilePath = Server.MapPath("~\\RptTemp\\1.pdf");
//WebClient User = new WebClient();
//Byte[] FileBuffer = User.DownloadData(FilePath);
//if (FileBuffer != null)
//{
// Response.ContentType = "application/pdf";
// Response.AddHeader("content-length", FileBuffer.Length.ToString());
// Response.BinaryWrite(FileBuffer);
//}
string filePath = Server.MapPath("~\\RptTemp\\") + Request.QueryString["FN"];
this.Response.ContentType = "application/pdf";
this.Response.AppendHeader("Content-Disposition;", "attachment;filename=" + Request.QueryString["FN"]);
this.Response.WriteFile(filePath);
this.Response.End();
}
}
