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