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