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