/// <summary> /// To GET ALL CONCERN /// </summary> /// <returns></returns> public ConcernList GETALLCONCERN() { // used in Master page OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GETALLCONCERN"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ConcernBO objConcern = null; ConcernList Concern = new ConcernList(); while (dr.Read()) { objConcern = new ConcernBO(); objConcern.ConcernID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONCERNID"))); objConcern.ConcernName = dr.GetString(dr.GetOrdinal("CONCERN")); objConcern.Isdeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); Concern.Add(objConcern); } dr.Close(); return(Concern); }
/// <summary> /// to get the concern details /// </summary> /// <param name="lastItemSelected"></param> private void GetConcer(bool lastItemSelected) { ConcernBLL objConcer = new ConcernBLL(); ConcernList ConcernList = new ConcernList(); ConcernList = objConcer.GetConcern(); PAPConcernsDropDownList.Items.Clear(); PAPConcernsDropDownList.DataSource = ConcernList; PAPConcernsDropDownList.DataTextField = "ConcernName"; PAPConcernsDropDownList.DataValueField = "ConcernID"; PAPConcernsDropDownList.DataBind(); PAPConcernsDropDownList.Items.Insert(0, new ListItem("-- Select --", "0")); PAPConcernsDropDownList.SelectedIndex = 0; if (PAPConcernsDropDownList.Items.FindByText("Other") != null) { ListItem LastListItem = new ListItem(PAPConcernsDropDownList.Items.FindByText("Other").Text, PAPConcernsDropDownList.Items.FindByText("Other").Value); PAPConcernsDropDownList.Items.Remove(PAPConcernsDropDownList.Items.FindByText("Other")); PAPConcernsDropDownList.Items.Add(LastListItem); if (lastItemSelected) { PAPConcernsDropDownList.Items[PAPConcernsDropDownList.Items.Count - 1].Selected = true; } else { PAPConcernsDropDownList.SelectedIndex = 0; } } }
/// <summary> /// Retrieve all direct references from concerns. /// </summary> /// <param name="concerns">A ConcernList object.</param> /// <returns>A list of EntityInfo.</returns> public static List <EntityInfo> GetConcernListDirectReferences(this ConcernList concerns) { var directReferences = new List <EntityInfo>(); if (!concerns.IsValid()) { return(directReferences); } var entityComparer = new EntityInfoComparer(); foreach (var concern in concerns) { if (concern.IsValid()) { directReferences = directReferences .Union( concern.GetConcernDirectReferences(), entityComparer) .ToList(); } } return(directReferences); }
/// <summary> /// get the data based on ID /// </summary> /// <param name="ConcernID"></param> /// <returns></returns> public ConcernBO GetConcernById(int ConcernID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSELECTCONCERN"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ConcernID_", ConcernID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ConcernBO ConcernObj = null; ConcernList Users = new ConcernList(); ConcernObj = new ConcernBO(); while (dr.Read()) { if (ColumnExists(dr, "CONCERN") && !dr.IsDBNull(dr.GetOrdinal("CONCERN"))) { ConcernObj.ConcernName = dr.GetString(dr.GetOrdinal("CONCERN")); } if (ColumnExists(dr, "CONCERNID") && !dr.IsDBNull(dr.GetOrdinal("CONCERNID"))) { ConcernObj.ConcernID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONCERNID"))); } } dr.Close(); return(ConcernObj); }
/// <summary> /// Retrieve layouts from concerns. /// </summary> /// <param name="concerns">A ConcernList object.</param> /// <returns>A LayoutList.</returns> public static LayoutList GetLayouts(this ConcernList concerns) { var layouts = new LayoutList(); if (!concerns.IsValid()) { return(layouts); } var layoutComparer = new LayoutInfoComparer(); foreach (var concern in concerns) { if (concern.IsValid() && concern.Layouts.IsValid()) { layouts = layouts .Union( concern.Layouts.ToLayoutList(concern), layoutComparer) .ToLayoutList(); } } return(layouts); }
public static bool IsValid(this ConcernList concerns) { if (!concerns.IsValid <ConcernInfo>()) { return(false); } return(true); }
/// <summary> /// Check if there is at least one menu in the application. /// </summary> /// <param name="concerns">A list of concerns.</param> public bool isMenu(ConcernList concerns) { if (concerns.AsEnumerable() != null) { foreach (ConcernInfo concern in concerns.AsEnumerable()) { if (getMenu(concern).AsEnumerable().Count() > 0) { return(true); } } } return(false); }
/// <summary> /// Check if there is at least one menu in the list of concerns. /// </summary> /// <param name="concerns">A ConcernList object.</param> /// <returns>A boolean.</returns> public static bool HasMenu(this ConcernList concerns) { if (!concerns.IsValid()) { return(false); } foreach (var concern in concerns) { if (concern.IsValid() && concern .GetMenu() .Count() > 0) { return(true); } } return(false); }
public LanguageViewTemplate(ConcernList concerns, LanguageList languages) { _languages = languages; _isMenu = isMenu(concerns); }
public ConcernList get_concern_details(string report_no, string concern_no) { var concerns = new ConcernList(); return(concerns.GetConcernDetails(report_no, concern_no)); }
public List <ConcernList> get_my_concerns(string report_no) { var concerns = new ConcernList(); return(concerns.GetMyConcerns(report_no)); }
public List <ConcernListData> get_concerns(string report_no) { var concerns = new ConcernList(); return(concerns.GetConcernList(report_no)); }