public void bindclg()
{
try
{
string columnfield = string.Empty;
group_code = Session["group_code"].ToString();
if (group_code.Contains(';'))
{
string[] group_semi = group_code.Split(';');
group_code = group_semi[0].ToString();
}
if ((group_code.ToString().Trim() != "") && (Session["single_user"].ToString() != "1" && Session["single_user"].ToString() != "true" && Session["single_user"].ToString() != "TRUE" && Session["single_user"].ToString() != "True"))
{
columnfield = " and group_code='" + group_code + "'";
}
else
{
columnfield = " and user_code='" + Session["usercode"] + "'";
}
dicParameter.Clear();
dicParameter.Add("column_field", columnfield.ToString());
//dtHeader.Dispose();
//dtHeader.Clear();
dtHeader = storAcc.selectDataTable("bind_college", dicParameter);
ddlCollege.Items.Clear();
if (dtHeader.Rows.Count > 0)
{
ddlCollege.DataSource = dtHeader;
ddlCollege.DataTextField = "collname";
ddlCollege.DataValueField = "college_code";
ddlCollege.DataBind();
}
}
catch
{
}
}
public void Bindcollege()
{
try
{
ddlCollege.Items.Clear();
dtCommon.Clear();
ddlCollege.Enabled = false;
DataSet dsprint = new DataSet();
dsprint.Clear();
string qryUserCodeOrGroupCode = string.Empty;
string group_user = ((Session["group_code"] != null) ? Convert.ToString(Session["group_code"]) : string.Empty);
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = Convert.ToString(group_semi[0]);
}
if ((Convert.ToString(group_user).Trim() != "") && Session["group_code"] != null && Session["single_user"] != null && Convert.ToString(Session["single_user"]).Trim() != "1" && Convert.ToString(Session["single_user"]).Trim().ToLower() != "true")
{
qryUserCodeOrGroupCode = " and group_code='" + group_user + "'";
}
else if (Session["usercode"] != null && !string.IsNullOrEmpty(Convert.ToString(Session["usercode"]).Trim()))
{
qryUserCodeOrGroupCode = " and user_code='" + Convert.ToString(Session["usercode"]).Trim() + "'";
}
if (!string.IsNullOrEmpty(qryUserCodeOrGroupCode))
{
dicQueryParameter.Clear();
dicQueryParameter.Add("column_field", Convert.ToString(qryUserCodeOrGroupCode));
dtCommon = storeAcc.selectDataTable("bind_college", dicQueryParameter);
}
if (dtCommon.Rows.Count > 0)
{
ddlCollege.DataSource = dtCommon;
ddlCollege.DataTextField = "collname";
ddlCollege.DataValueField = "college_code";
ddlCollege.DataBind();
ddlCollege.SelectedIndex = 0;
ddlCollege.Enabled = true;
}
}
catch (Exception ex)
{
d2.sendErrorMail(ex, userCollegeCode, "TransferReports");
}
}
public void bindclg()
{
try
{
ddlclg.Items.Clear();
dtCommon.Clear();
DataSet dsprint = new DataSet();
dsprint.Clear();
string qryUserCodeOrGroupCode = string.Empty;
string group_user = ((Session["group_code"] != null) ? Convert.ToString(Session["group_code"]) : string.Empty);
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = Convert.ToString(group_semi[0]);
}
if ((Convert.ToString(group_user).Trim() != "") && Session["group_code"] != null && Session["single_user"] != null && Convert.ToString(Session["single_user"]).Trim() != "1" && Convert.ToString(Session["single_user"]).Trim().ToLower() != "true")
{
qryUserCodeOrGroupCode = " and group_code='" + group_user + "'";
}
else if (Session["usercode"] != null && !string.IsNullOrEmpty(Convert.ToString(Session["usercode"]).Trim()))
{
qryUserCodeOrGroupCode = " and user_code='" + Convert.ToString(Session["usercode"]).Trim() + "'";
}
if (!string.IsNullOrEmpty(qryUserCodeOrGroupCode))
{
dicQueryParameter.Clear();
dicQueryParameter.Add("column_field", Convert.ToString(qryUserCodeOrGroupCode));
dtCommon = storeAcc.selectDataTable("bind_college", dicQueryParameter);
}
if (dtCommon.Rows.Count > 0)
{
ddlclg.DataSource = dtCommon;
ddlclg.DataTextField = "collname";
ddlclg.DataValueField = "college_code";
ddlclg.DataBind();
ddlclg.SelectedIndex = 0;
ddlclg.Enabled = true;
}
//ddlclg.Items.Clear();
//string columnfield = string.Empty;
//string group_user = Session["collegecode"] != null ? Convert.ToString(Session["collegecode"]) : "";
//if (group_user.Contains(";"))
//{
// string[] groupsemi = group_user.Split(';');
// group_user = Convert.ToString(groupsemi[0]);
//}
//if ((Convert.ToString(group_user).Trim() != "") && Session["single_user"] != null && (Convert.ToString(Session["single_user"]) != "1" && Convert.ToString(Session["single_user"]) != "true" && Convert.ToString(Session["single_user"]) != "TRUE" && Convert.ToString(Session["single_user"]) != "True"))
//{
// columnfield = " and group_code='" + group_user + "'";
//}
//else if (Session["usercode"] != null)
//{
// columnfield = " and user_code='" + Convert.ToString(Session["usercode"]).Trim() + "'";
//}
//ht.Clear();
//ht.Add("column_field", Convert.ToString(columnfield));
//ds = da.select_method("bind_college", ht, "sp");
//ddlclg.Items.Clear();
//if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
//{
// ddlclg.DataSource = ds;
// ddlclg.DataValueField = "college_code";
// ddlclg.DataTextField = "collname";
// ddlclg.DataBind();
// ddlclg.SelectedIndex = 0;
//}
}
catch
{
}
}
