protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserID"] == null) { Response.Redirect("~\\Login.aspx"); } else { string str = "~" + Request.FilePath; DataTable dtYear = new DataTable(); dtYear = cc.EQ("select dbo.FIN_YEAR('" + Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd") + "')"); if (Session["FinYear"].ToString().Trim() == dtYear.Rows[0][0].ToString().Trim()) { btnSave.Enabled = true; btnReset.Enabled = true; } else { btnSave.Enabled = false; btnReset.Enabled = false; } string Userid = Session["UserID"].ToString(); if (!cc.FormAuthorize(Userid, str)) { Response.Redirect("~\\MessagePage.aspx"); } } BindgrdApplForMendatoryDocs(); cc.FillDDL2(ref ddlVendor, "---Select---", "V_Name", "V_Code", "Master.VENDOR"); if (Session["TypeCode"] != null) { ddlVendor.SelectedValue = Session["TypeCode"].ToString(); ddlVendor.Enabled = false; string strDistributor = "SELECT V_CODE, Distb_CODE, Distb_NAME, Status FROM Master.Distributor WHERE V_Code='" + ddlVendor.SelectedValue.Trim() + "' And Status='A'"; DataTable dtDistributor = SQL_DBCS.ExecuteDataTable(strDistributor); ddlDistributor.DataSource = dtDistributor; ddlDistributor.DataTextField = "Distb_NAME"; ddlDistributor.DataValueField = "Distb_CODE"; ddlDistributor.DataBind(); ddlDistributor.Items.Insert(0, "---Select---"); ddlDistributor.SelectedIndex = 0; //cc.FillDDLFrom2(ref ddlDistributor, "---Select---", "Distb_NAME", "Distb_CODE", "Master.Distributor", "V_Code", ddlVendor.SelectedValue.Trim()); txtApplNo.Focus(); } BindgrdgrdUploadedMendatoryDocs(); if (Request.QueryString["ApplNo"] != null) { //txtApplNo.Text = Request.QueryString["ApplNo"].ToString(); string SQL = "", App_no; App_no = Request.QueryString["ApplNo"].ToString(); SQL = @"SELECT App_No,Name,V_NAME,B_NAME,D_NAME FROM Trans.APPLICATIONS INNER JOIN Master.VILLMST ON Trans.APPLICATIONS.V_CODE=Master.VILLMST.V_CODE INNER JOIN Master.DSTMST ON Trans.APPLICATIONS.D_Code=Master.DSTMST.D_CODE INNER JOIN Master.BLOCKMST ON Master.DSTMST.D_CODE = Master.BLOCKMST.D_CODE WHERE APP_NO='" + App_no + "'"; DataTable dt = new DataTable(); dt = cc.EQ(SQL); if (dt.Rows.Count > 0) { lblAppNo.Text = dt.Rows[0]["App_No"].ToString(); lblFarmerName.Text = dt.Rows[0]["Name"].ToString(); lblAddress.Text = "Village:" + dt.Rows[0]["V_NAME"].ToString() + ", Block:" + dt.Rows[0]["B_NAME"].ToString() + ", District:" + dt.Rows[0]["D_NAME"].ToString(); } } } }