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();
}
}
}
}
