private void SetDocAccess(int ContactID) { Dist23MVC.Models.clsDataGetter dg = new Models.clsDataGetter(ConfigurationManager.ConnectionStrings["Dist23Data"].ConnectionString); Session["isDistrict"] = false; SqlDataReader dr = dg.GetDataReader("SELECT * FROM ContactPosition WHERE ContactID=" + ContactID.ToString()); while (dr.Read()) { int gID = (int)dr["GroupID"]; Groups group = db.Groups.FirstOrDefault(x => x.pKey == gID); if (group.isDistrict == true) { Session["isDistrict"] = true; } else { Session["userGroup"] = dr["GroupID"]; } } dg.KillReader(dr); dg = null; }
private void SetDocAccess(int ContactID) { Dist23MVC.Models.clsDataGetter dg = new Models.clsDataGetter(ConfigurationManager.ConnectionStrings["Dist23Data"].ConnectionString); Session["isDistrict"] = false; SqlDataReader dr = dg.GetDataReader("SELECT * FROM ContactPosition WHERE ContactID=" + ContactID.ToString()); while (dr.Read()) { int gID = (int)dr["GroupID"]; Groups group = db.Groups.FirstOrDefault(x => x.pKey == gID); if (group.isDistrict == true) Session["isDistrict"] = true; else Session["userGroup"] = dr["GroupID"]; } dg.KillReader(dr); dg = null; }