private void DeleteCurrentRow()
        {
            DataGridViewRow row  = DiaryGV.CurrentRow;
            DiaryLine       line = (DiaryLine)row.DataBoundItem;

            diary.DiaryLines.Remove(line);
            ProvisionData();
        }
示例#2
0
 public LineForm(Diary diary, DiaryLine line = null)
 {
     InitializeComponent();
     theDiary     = diary;
     alteredLine  = new DiaryLine();
     originalLine = line;
     BasicSetup(diary.Questions);
     ApplyData(originalLine);
     SetToolTips();
 }
        private void UploadToSQL(DiaryLine line, List <Tuple <string, string> > variableNames)
        {
            string logic = line.Logic;

            foreach (Tuple <string, string> t in variableNames)
            {
                logic = logic.ToLower();
                if (logic.Contains(t.Item1.ToLower()))
                {
                    logic = logic.Replace(t.Item1.ToLower(), t.Item2);
                }
            }
            List <SqlParameter> paramList = new List <SqlParameter>();

            paramList.Add(new SqlParameter("DiaryType", diary.Name));

            if (line.TypeOfLine == LineType.Check)
            {
                paramList.Add(new SqlParameter("pdate", "NULL"));
                paramList.Add(new SqlParameter("sdate", "NULL"));
                paramList.Add(new SqlParameter("ddate", "NULL"));
                paramList.Add(new SqlParameter("cclass", "04"));
            }
            else
            {
                paramList.Add(new SqlParameter("pdate", line.PromptDate.ToFileString()));
                paramList.Add(new SqlParameter("sdate", line.StatDate.ToFileString()));
                paramList.Add(new SqlParameter("ddate", line.DueDate.ToFileString()));
                paramList.Add(new SqlParameter("cclass", line.LineClass));
            }
            paramList.Add(new SqlParameter("desc1", Tools.ConvertString(line.Description)));
            paramList.Add(new SqlParameter("reg13", Tools.ConvertString(line.RegLink)));

            paramList.Add(new SqlParameter("logic", logic));
            paramList.Add(new SqlParameter("applink", line.DocumentLink));
            paramList.Add(new SqlParameter("sectionlink", line.SectionLink));
            paramList.Add(new SqlParameter("rulelink", line.RuleLink));
            paramList.Add(new SqlParameter("guidancelink", line.WebLink));
            paramList.Add(new SqlParameter("role", line.Role));
            paramList.Add(new SqlParameter("category", line.Category.SortOrder + "-" + line.Category.Title));
            paramList.Add(new SqlParameter("offset", line.Offset));
            paramList.Add(new SqlParameter("templatelineno", line.Offset));
            paramList.Add(new SqlParameter("nexttemplate", line.NextTemplateName));
            paramList.Add(new SqlParameter("recurmonth", line.RecurringMonthsToAdd));

            Tools.RunCommand("Insert into ips_diarytemplate([diarytype],[cclass],[pdate],[sdate],[ddate],[desc1],[reg13],[logic],[applink],[sectionlink],[rulelink],[guidancelink],[role],[category],[offset],[nexttemplate],[recurmonth],templatelineno) " +
                             "VALUES(@DiaryType, @cclass, @pdate, @sdate, @ddate, @desc1, @reg13, @logic, @applink, @sectionlink, @rulelink, @guidancelink, @role, @category, @offset, @nexttemplate, @recurmonth, @templatelineno)", paramList);
        }
示例#4
0
        public Diary(string[] diaryLines)
        {
            Header     = new List <string>();
            Questions  = new List <Question>();
            DiaryDates = new List <DiaryDate>();
            DiaryLines = new List <DiaryLine>();
            bool inHeader = true;

            foreach (string line in diaryLines)
            {
                if (inHeader)
                {
                    Header.Add(line);
                    //Find the template name
                    if (line.ToUpper().Contains("DYTYPE :="))
                    {
                        //get everything from the = to the closing ;
                        Name = line.Substring(line.IndexOf("=") + 1);
                        Debug.Print(Name);
                        Name = Name.Replace(';', ' ');
                        Debug.Print(Name);
                        Name = Tools.ConvertString(Name, false);
                        Debug.Print(Name);
                    }
                    if (line.Contains("Begin Diary Lines"))
                    {
                        inHeader = false;
                    }
                    continue;
                }
                else
                {
                    if (line.ToUpper().Contains("CHECKLINE") || line.ToUpper().Contains("DIARYLINE"))
                    {
                        DiaryLine newLine = new DiaryLine(line);
                        DiaryLines.Add(newLine);
                    }
                    continue;
                }
            }
            DiaryCategories = DiaryLines.AsEnumerable()
                              .Select(s => new DiaryLineCategory {
                Title = s.Category.Title, SortOrder = s.Category.SortOrder
            })
                              .Distinct().ToList();
            Questions = Question.CaptureQuestions(Header);
        }
        private void EditCurrentRow()
        {
            DataGridViewRow row = DiaryGV.CurrentRow;

            if (row.IsNewRow)
            {
                AddRow();
            }
            else
            {
                DiaryLine line     = (DiaryLine)row.DataBoundItem;
                LineForm  editForm = new LineForm(diary, line);
                if (editForm.ShowDialog() == DialogResult.OK)
                {
                    diary.DiaryLines.Remove(line);
                    diary.DiaryLines.Add(editForm.alteredLine);
                }
            }
            ProvisionData();
        }
示例#6
0
        public void ApplyData(DiaryLine originalLine)
        {
            LogicCB.Text  = originalLine.Logic;
            ClassDDL.Text = originalLine.LineClass;

            if (originalLine.TypeOfLine == LineType.Diary)
            {
                pMonthSpin.Value      = originalLine.PromptDate.MonthsToAdd;
                pdaysSpin.Value       = originalLine.PromptDate.DaysToAdd;
                pdateddl.SelectedItem = originalLine.PromptDate.BaseDate;
                sMonthSpin.Value      = originalLine.StatDate.MonthsToAdd;
                sdaysSpin.Value       = originalLine.StatDate.DaysToAdd;
                sdateddl.SelectedItem = originalLine.StatDate.BaseDate;
                dMonthSpin.Value      = originalLine.DueDate.MonthsToAdd;
                ddaysSpin.Value       = originalLine.DueDate.DaysToAdd;
                ddateddl.SelectedItem = originalLine.DueDate.BaseDate;
                rMonthSpin.Value      = originalLine.RecurringMonthsToAdd;
            }

            DescTB.Text      = originalLine.Description;
            DocLinkTb.Text   = originalLine.DocumentLink;
            SectionTB.Text   = originalLine.SectionLink;
            RuleTB.Text      = originalLine.RuleLink;
            GuidanceTB.Text  = originalLine.WebLink;
            CategoryDDL.Text = originalLine.Category.Title;
            RoleDDL.Text     = originalLine.Role.ToString();

            NextTemplateTB.Text = originalLine.NextTemplateName;

            //set to the ORderddl
            List <int> orderOptions = new List <int>();

            orderOptions.Add(originalLine.Offset);
            orderOptions.AddRange(CalculateOrderOptions(originalLine.Category.Title));
            OrderDDL.DataSource   = orderOptions;
            OrderDDL.SelectedItem = originalLine.Offset;
        }