private void BindGridWithFilter()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL ws = new AdminBLL();
GetPassData objReq = new GetPassData();
string WhereClause = ReturnWhere();
if (!string.IsNullOrEmpty(txtPassNUmber.Text))
{
objReq.Pass_No = txtPassNUmber.Text;
}
if (!string.IsNullOrEmpty(ddlstatus.Text))
{
objReq.Status = ddlstatus.Text;
}
if (!string.IsNullOrEmpty(ddlAddPassType.Text))
{
objReq.pass_Type = ddlAddPassType.Text;
}
if (!string.IsNullOrEmpty(WhereClause))
{
objReq.WhereClause = WhereClause;
}
if (!string.IsNullOrEmpty(txtdatefrom.Text))
{
if (string.IsNullOrEmpty(txtdateto.Text))
{
objReq.Date_From = txtdatefrom.Text;
}
}
if (!string.IsNullOrEmpty(txtdateto.Text))
{
if (!string.IsNullOrEmpty(txtdatefrom.Text))
{
objReq.Date_From = txtdatefrom.Text;
objReq.Date_From = txtdateto.Text;
}
}
GetPassDataResponse ret = ws.GetPassData(objReq);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvPassTable.PageSize = pageSize;
gvPassTable.DataSource = ret.Pass;
gvPassTable.DataBind();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
public GetPassDataResponse GetPassData2(GetPassData objGetPassDataRequest)
{
try
{
AdminDAL objAdminDAL = new AdminDAL();
GetPassDataResponse ret = new GetPassDataResponse();
List <Pass> lst = objAdminDAL.GetPassData2(objGetPassDataRequest);
ret.Pass = lst;
return(ret);
}
catch (Exception ex)
{
throw ex;
}
}
private void BindGrid()
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
AdminBLL ws = new AdminBLL();
GetPassData _req = new GetPassData();
GetPassDataResponse _resp = ws.GetPassData(_req);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvKeySearch.PageSize = pageSize;
gvKeySearch.DataSource = _resp.Pass;
gvKeySearch.DataBind();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
private void PopulatePageCntrls(String argsBGID)
{
Int32 iCount = 0;
GetPassDataResponse ret = null;
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
//DBConnectionHandler1 db = new DBConnectionHandler1();
//SqlConnection cn = db.getconnection();
//cn.Open();
//SqlCommand cmd = new SqlCommand("select Pass_No,pass_Type,Pass_Desciption from Pass_Master where Pass_id=@passid", cn);
//cmd.Parameters.AddWithValue("@passid", argsBGID);
//SqlDataReader dr = cmd.ExecuteReader();
//if (dr.Read())
//{
// txtUpdatePassNo.Text = dr.GetString(0);
// ddlAddPassType.Text = dr.GetString(1);
// txtUpdatePassDescription.Text = dr.GetString(2);
// cn.Close();
//}
//hdnBTID.Value = txtUpdatePassNo.Text;
AdminBLL objAdminBLL = new AdminBLL();
GetPassData objGetBillingTableRequest = new GetPassData();
objGetBillingTableRequest.Pass_No = argsBGID.ToString();
objGetBillingTableRequest.WhereClause = " where Pass_id= '" + argsBGID + "' ";
ret = objAdminBLL.GetPassData2(objGetBillingTableRequest);
//hdnBTID.Value = ret.Pass[iCount].Pass_No.ToString();
txtpass_id.Text = ret.Pass[iCount].Pass_id.ToString();
txtUpdatePassNo.Text = ret.Pass[iCount].Pass_No.ToString();
ddlAddPassType.Text = ret.Pass[iCount].pass_Type.ToString();
txtUpdatePassDescription.Text = ret.Pass[iCount].Pass_Desciption.ToString();
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
protected void gvNewKey_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
log4net.ILog logger = log4net.LogManager.GetLogger("File");
try
{
if (e.NewPageIndex >= 0)
{
gvKeySearch.PageIndex = e.NewPageIndex;
AdminBLL ws = new AdminBLL();
GetPassData _req = new GetPassData();
GetPassDataResponse _resp = ws.GetPassData(_req);
int pageSize = ContextKeys.GRID_PAGE_SIZE;
gvKeySearch.PageSize = pageSize;
gvKeySearch.DataSource = _resp.Pass;
gvKeySearch.DataBind();
}
}
catch (Exception ex)
{
logger.Info(ex.Message);
}
}
