public ActionResult Index(Nullable <int> id)
{
if (id.HasValue)
{
List <InputDTO> inputMessages = new List <InputDTO>();
InformationTypeDTO informationType = InformationTypeDAC.GetInformationType(id.Value, ContextManager.Current.SelectedAreaID.Value);
if (informationType.Title == "Unknown") // id.Value == 203)
{
inputMessages = InputDAC.GetFilteredInputMessages(id.Value, ContextManager.Current.SelectedAreaID.Value, Membership.GetUser().Email);
}
else
{
inputMessages = InputDAC.GetInputMessages(id.Value, ContextManager.Current.SelectedAreaID.Value, 0);
}
return(View("Index", new InputIndexModel()
{
InputMessages = inputMessages, InformationType = InformationTypeDAC.GetInformationType(id.Value, ContextManager.Current.SelectedAreaID.Value)
}));
}
else
{
return(View("Index", new InputIndexModel()
{
InputMessages = InputDAC.GetInputMessages(ContextManager.Current.SelectedAreaID.Value, 50)
}));
}
}
public ActionResult ReanalyzeAllItems(Nullable <int> informationTypeID)
{
List <InputDTO> inputMessages = null;
if (informationTypeID.HasValue)
{
InformationTypeDTO informationType = InformationTypeDAC.GetInformationType(informationTypeID.Value, ContextManager.Current.SelectedAreaID.Value);
if (informationType.Title == "Unknown")
{
inputMessages = InputDAC.GetFilteredInputMessages(informationTypeID.Value, ContextManager.Current.SelectedAreaID.Value, Membership.GetUser().Email);
}
else
{
inputMessages = InputDAC.GetInputMessages(informationTypeID.Value, ContextManager.Current.SelectedAreaID.Value, 0);
}
}
else
{
inputMessages = InputDAC.GetInputMessages(ContextManager.Current.SelectedAreaID.Value, 100000);
}
if (inputMessages != null)
{
foreach (InputDTO inputMessage in inputMessages)
{
Analyzer.RerunAnalysis(inputMessage.ID.Value, ContextManager.Current.SelectedAreaID.Value);
}
}
return(Index(informationTypeID));
}
public static Int32 StoreInformationType(InformationTypeDTO informationType, Int32 areaID)
{
using (SqlConnection cnn = WordDAC.NewConnection)
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[information_type_pkg.store]";
SqlParameter idParam = cmd.Parameters.Add("id", SqlDbType.Int);
idParam.Value = (informationType.ID.HasValue) ? (object)informationType.ID.Value : DBNull.Value;
idParam.Direction = ParameterDirection.InputOutput;
SqlParameter parentIDParam = cmd.Parameters.Add("@parent_id", SqlDbType.Int);
parentIDParam.Value = (informationType.ParentID.HasValue) ? (object)informationType.ParentID.Value : DBNull.Value;
parentIDParam.Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("@title", informationType.Title);
cmd.Parameters.AddWithValue("@possible_limit", informationType.PossibleLimit);
cmd.Parameters.AddWithValue("@certain_limit", informationType.CertainLimit);
cmd.Parameters.AddWithValue("@area_id", areaID);
cnn.Open();
cmd.ExecuteNonQuery();
informationType.ID = Convert.ToInt32(idParam.Value);
return(informationType.ID.Value);
}
}
public ActionResult SaveNew(InformationTypeDTO informationType)
{
if (ModelState.IsValid)
{
informationType.PossibleLimit = informationType.CertainLimit;
Int32 id = InformationTypeDAC.StoreInformationType(informationType, ContextManager.Current.SelectedAreaID.Value);
return(Details(id));
}
else
{
return(New(informationType.ParentID));
}
}
public ActionResult SaveDetails(InformationTypeDTO informationType, IList <RelevantWordDTO> RelevantWordList)
{
if (ModelState.IsValid)
{
informationType.PossibleLimit = informationType.CertainLimit;
InformationTypeDAC.StoreInformationType(informationType, ContextManager.Current.SelectedAreaID.Value);
foreach (RelevantWordDTO relevantWord in RelevantWordList)
{
if (!String.IsNullOrEmpty(relevantWord.Word))
{
WordDAC.StoreRelevantWord(relevantWord);
}
}
return(Details(informationType.ID.Value));
}
else
{
return(Details(informationType.ID.Value));
}
}
