private void PopulatePageCntrls(int argsBGID) { Int32 iCount = 0; GetSOPDataResponse ret = null; log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { AdminBLL objAdminBLL = new AdminBLL(); GetSOPData objGetBillingTableRequest = new GetSOPData(); objGetBillingTableRequest.SOP_ID = argsBGID.ToString(); objGetBillingTableRequest.WhereClause = " where SOP_ID =" + argsBGID.ToString(); ret = objAdminBLL.GetSOPData(objGetBillingTableRequest); hdnBTID.Value = ret.SOPNo[iCount].SOP_ID.ToString(); hdnBTID.Value = ret.SOPNo[iCount].SOP_Title.ToString(); hdnBTID.Value = ret.SOPNo[iCount].SOP_Subject.ToString(); hdnBTID.Value = ret.SOPNo[iCount].ImagePathName.ToString(); hdnBTID.Value = ret.SOPNo[iCount].Location.ToString(); txtUpdateSOPNo.Text = ret.SOPNo[iCount].SOP_ID.ToString(); txtUpdateSOPTitle.Text = ret.SOPNo[iCount].SOP_Title.ToString(); txtUpdateSOPSubject.Text = ret.SOPNo[iCount].SOP_Subject.ToString(); //ddllocation.Items.Insert(0,ret.SOPNo[iCount].Location.ToString()); Session.Add("ImagePath", ret.SOPNo[iCount].ImagePathName.ToString()); } catch (Exception ex) { logger.Info(ex.Message); } }
private void BindGridWithFilter() { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { getLocationIDByName(ddllocation.Text.Trim()); AdminBLL ws = new AdminBLL(); GetSOPData objReq = new GetSOPData(); if (ddllocation.Text.ToString() == "") { } else { objReq.WhereClause = " Where Location = '" + searchid.Text + "' "; } GetSOPDataResponse ret = ws.GetSOPData(objReq); int pageSize = ContextKeys.GRID_PAGE_SIZE; gvSOPTable.PageSize = pageSize; gvSOPTable.DataSource = ret.SOPNo; gvSOPTable.DataBind(); // ShowHide(); } catch (Exception ex) { logger.Info(ex.Message); } }
private void BindGridWithFilter() { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { AdminBLL ws = new AdminBLL(); GetSOPData objReq = new GetSOPData(); string WhereClause = ReturnWhere(); if (!string.IsNullOrEmpty(txtSOPID.Text)) { objReq.SOP_ID = txtSOPID.Text; } if (!string.IsNullOrEmpty(txtSOPSubjectSearch.Text)) { objReq.SOP_Subject = txtSOPSubjectSearch.Text; } if (!string.IsNullOrEmpty(txtSOPtitle.Text)) { objReq.SOP_Title = txtSOPtitle.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; } } GetSOPDataResponse ret = ws.GetSOPData(objReq); int pageSize = ContextKeys.GRID_PAGE_SIZE; gvSOPTable.PageSize = pageSize; gvSOPTable.DataSource = ret.SOPNo; gvSOPTable.DataBind(); ShowHide(); } catch (Exception ex) { logger.Info(ex.Message); } }
public GetSOPDataResponse GetAllSOPData(GetSOPData objGetSOPDataRequest) { try { AdminDAL objAdminDAL = new AdminDAL(); GetSOPDataResponse ret = new GetSOPDataResponse(); List <SOP> lst = objAdminDAL.GetAllSOPData(objGetSOPDataRequest); ret.SOPNo = lst; return(ret); } catch (Exception ex) { throw ex; } }
private void PopulatePageCntrls(int argsBGID) { Int32 iCount = 0; GetSOPDataResponse ret = null; log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { AdminBLL objAdminBLL = new AdminBLL(); GetSOPData objGetBillingTableRequest = new GetSOPData(); objGetBillingTableRequest.SOP_ID = argsBGID.ToString(); objGetBillingTableRequest.WhereClause = " where SOP_ID =" + argsBGID.ToString(); ret = objAdminBLL.GetSOPData(objGetBillingTableRequest); hdnBTID.Value = ret.SOPNo[iCount].SOP_ID.ToString(); hdnBTID.Value = ret.SOPNo[iCount].SOP_Title.ToString(); hdnBTID.Value = ret.SOPNo[iCount].SOP_Subject.ToString(); //hdnBTID.Value = ret.SOPNo[iCount].ImagePathName.ToString(); hdnBTID.Value = ret.SOPNo[iCount].Location.ToString(); cn = db.getconnection(); cn.Open(); SqlCommand _cmd = new SqlCommand("select Location_name from location where Location_id=@id", cn); _cmd.Parameters.AddWithValue("@id", hdnBTID.Value); SqlDataReader dr = _cmd.ExecuteReader(); if (dr.Read()) { ddllocation.Items.Insert(0, dr.GetString(0)); //========================// dr.Close(); dr.Dispose(); //========================// cn.Close(); } txtUpdateSOPNo.Text = ret.SOPNo[iCount].SOP_ID.ToString(); txtUpdateSOPTitle.Text = ret.SOPNo[iCount].SOP_Title.ToString(); txtUpdateSOPSubject.Text = ret.SOPNo[iCount].SOP_Subject.ToString(); Session.Add("ImagePath", ret.SOPNo[iCount].ImagePathName.ToString()); } catch (Exception ex) { logger.Info(ex.Message); } }
private void BindGrid() { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { AdminBLL ws = new AdminBLL(); GetSOPData _req = new GetSOPData(); GetSOPDataResponse _resp = ws.GetSOPData(_req); gvSOPTable.DataSource = _resp.SOPNo; gvSOPTable.DataBind(); ShowHide(); } catch (Exception ex) { logger.Info(ex.Message); } }
private void BindGridWithFilter() { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { AdminBLL ws = new AdminBLL(); GetSOPData objReq = new GetSOPData(); // string WhereClause = ReturnWhere(); GetSOPDataResponse ret = ws.GetSOPData(objReq); gvSOPTable.DataSource = ret.SOPNo; gvSOPTable.DataBind(); ShowHide(); } catch (Exception ex) { logger.Info(ex.Message); } }