private void bind_emp()
{
string str = "";
if (ddlEmpType.SelectedIndex > 0)
{
str = " select NAME+' ('+CODE+')' NAME, CODE from V_paybill where DESG_TYPE='" + ddlEmpType.SelectedValue.ToString().Trim() + "' and GPF_TYPE='" + ddlGpsMps.SelectedItem.Text + "' order by NAME";
}
else
{
str = " select NAME+' ('+CODE+')' NAME, CODE from V_paybill order by NAME";
}
DataTable dt = cc.EQ(str);
if (dt.Rows.Count > 0)
{
ddl_emp.DataTextField = "NAME";
ddl_emp.DataValueField = "CODE";
ddl_emp.DataSource = dt;
ddl_emp.DataBind();
ddl_emp.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
ddl_emp.Items.Clear();
}
}
public void SearchDesignation()
{
string strSearch = "";
string MName = txtSearchDesignationName.Text.Trim();
strSearch = @"SELECT Name,
(CASE WHEN MDesignation.SHName='HO' THEN 'Head Officer' WHEN MDesignation.SHName='RO' THEN 'Divisional Officer'
WHEN MDesignation.SHName='DO' THEN 'District Officer' ELSE 'Auditor' END )SHName1,
SHName,
ID,HName,
isnull(TreeLevel,0) as TreeLevel,
isnull(MDesignation.ParentID,null)ParentID,
(select Name from MDesignation mm where mm.ID=MDesignation.ParentID )PName
from MDesignation where Name like '" + MName + "%'";
DataTable dt1 = cc.EQ(strSearch);
if (dt1.Rows.Count > 0)
{
grd.DataSource = dt1;
grd.DataBind();
}
else
{
grd.DataSource = null;
grd.DataBind();
}
}
public DataTable Get_Trn_No()
{
DataTable dtTRN_NO = new DataTable();
return(dtTRN_NO = cc.EQ("SELECT ISNULL(MAX([TRN_NO]),0) AS TRN_NO FROM [Trans].[MEMBERS]"));
}
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();
}
}
}
}
