public void BindItems() { DataTable _dtfunctionTable; try { string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } _dtfunctionTable = objBLL.GetSettingforFunctions(); if (_dtfunctionTable.Rows.Count > 0) { for (int i = 0; i < _dtfunctionTable.Rows.Count; i++) { if (_dtfunctionTable.Rows[i]["Settings_Key"].ToString() == "View Functions To Jobs") { trVisible1.Visible = true; lblDescriptionJob.Text = _dtfunctionTable.Rows[i]["Descriptions"].ToString().Replace("_", " "); if (_dtfunctionTable.Rows[i]["Settings_Value"].ToString().Trim() == "1") { chkbSettingValue.Checked = true; } else { chkbSettingValue.Checked = false; } } else if (_dtfunctionTable.Rows[i]["Settings_Key"].ToString() == "JOB_DUE_IN_7_DAYS") { trVisible2.Visible = true; lblDescription7Day.Text = _dtfunctionTable.Rows[i]["Settings_Key"].ToString().Replace("_", " "); txtSettingValue7Day.Text = _dtfunctionTable.Rows[i]["Settings_Value"].ToString(); } else if (_dtfunctionTable.Rows[i]["Settings_Key"].ToString() == "JOB_DUE_THIS_MONTH") { trVisible3.Visible = true; lblDescriptionMonth.Text = _dtfunctionTable.Rows[i]["Settings_Key"].ToString().Replace("_", " "); txtSettingValueMonth.Text = _dtfunctionTable.Rows[i]["Settings_Value"].ToString(); } } } if (_dtfunctionTable.Rows.Count == 0) { divAddSetting.Visible = false; } } catch (Exception ex) { throw ex; } }
private void CheckSettingforFunctions() { DataTable _settingTable; DataRow[] foundRows; try { _settingTable = objBLL.GetSettingforFunctions(); if (_settingTable.Rows.Count > 0) { foundRows = _settingTable.Select("Settings_Key = 'View Functions To Jobs'"); if (foundRows.Length > 0) { if (_settingTable.Rows[0]["Settings_Value"].ToString() == "0") //Convert datatype bit to varchar //if ((bool)foundRows[0]["Settings_Value"] == false) { tblFunction.Visible = false; } else { tblFunction.Visible = true; } } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); throw ex; } }