コード例 #1
0
ファイル: AppTaskService.cs プロジェクト: ECCC-CSSP/CSSPDBDLL
 public AppTask GetAppTaskWithTVItemIDTVItemID2AndCommandDB(int TVItemID, int TVItemID2, AppTaskCommandEnum AppTaskCommand)
 {
     return((from c in db.AppTasks
             where c.TVItemID == TVItemID &&
             c.TVItemID2 == TVItemID2 &&
             c.AppTaskCommand == (int)AppTaskCommand
             select c).FirstOrDefault <AppTask>());
 }
コード例 #2
0
ファイル: AppTaskService.cs プロジェクト: ECCC-CSSP/CSSPDBDLL
        public AppTaskModel GetAppTaskModelWithTVItemIDTVItemID2AndCommandDB(int TVItemID, int TVItemID2, AppTaskCommandEnum Command)
        {
            AppTaskModel appTaskModel = (from c in db.AppTasks
                                         let tvItemIDTVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID select cl.TVText).FirstOrDefault <string>()
                                                              let tvItemIDTVText2 = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID2 select cl.TVText).FirstOrDefault <string>()
                                                                                    let errorText = (from cl in db.AppTaskLanguages where cl.Language == (int)LanguageRequest && cl.AppTaskID == c.AppTaskID select cl.ErrorText).FirstOrDefault <string>()
                                                                                                    let statusText = (from cl in db.AppTaskLanguages where cl.Language == (int)LanguageRequest && cl.AppTaskID == c.AppTaskID select cl.StatusText).FirstOrDefault <string>()
                                                                                                                     where c.TVItemID == TVItemID &&
                                                                                                                     c.TVItemID2 == TVItemID2 &&
                                                                                                                     c.AppTaskCommand == (int)Command
                                                                                                                     select new AppTaskModel
            {
                Error = "",
                AppTaskID = c.AppTaskID,
                DBCommand = (DBCommandEnum)c.DBCommand,
                TVItemID = c.TVItemID,
                TVItemIDTVText = tvItemIDTVText,
                TVItemID2 = c.TVItemID2,
                TVItemID2TVText = tvItemIDTVText2,
                AppTaskCommand = (AppTaskCommandEnum)c.AppTaskCommand,
                ErrorText = errorText,
                StatusText = statusText,
                AppTaskStatus = (AppTaskStatusEnum)c.AppTaskStatus,
                PercentCompleted = c.PercentCompleted,
                Parameters = c.Parameters,
                Language = (LanguageEnum)c.Language,
                EndDateTime_UTC = c.EndDateTime_UTC,
                StartDateTime_UTC = c.StartDateTime_UTC,
                EstimatedLength_second = c.EstimatedLength_second,
                RemainingTime_second = c.RemainingTime_second,
                LastUpdateDate_UTC = c.LastUpdateDate_UTC,
                LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
            }).FirstOrDefault <AppTaskModel>();

            if (appTaskModel == null)
            {
                return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.AppTask, ServiceRes.TVItemID + "," + ServiceRes.TVItemID2 + "," + ServiceRes.AppTaskCommand, TVItemID + "," + TVItemID2 + "," + Command.ToString())));
            }

            return(appTaskModel);
        }
コード例 #3
0
        public void AppTaskExtraB_Every_Property_Has_Get_Set_Test()
        {
            string val1 = "Some text";

            appTaskExtraB.AppTaskReportTest = val1;
            Assert.AreEqual(val1, appTaskExtraB.AppTaskReportTest);
            string val2 = "Some text";

            appTaskExtraB.TVItemText = val2;
            Assert.AreEqual(val2, appTaskExtraB.TVItemText);
            string val3 = "Some text";

            appTaskExtraB.TVItem2Text = val3;
            Assert.AreEqual(val3, appTaskExtraB.TVItem2Text);
            string val4 = "Some text";

            appTaskExtraB.LastUpdateContactText = val4;
            Assert.AreEqual(val4, appTaskExtraB.LastUpdateContactText);
            string val5 = "Some text";

            appTaskExtraB.AppTaskCommandText = val5;
            Assert.AreEqual(val5, appTaskExtraB.AppTaskCommandText);
            string val6 = "Some text";

            appTaskExtraB.AppTaskStatusText = val6;
            Assert.AreEqual(val6, appTaskExtraB.AppTaskStatusText);
            string val7 = "Some text";

            appTaskExtraB.LanguageText = val7;
            Assert.AreEqual(val7, appTaskExtraB.LanguageText);
            int val8 = 45;

            appTaskExtraB.AppTaskID = val8;
            Assert.AreEqual(val8, appTaskExtraB.AppTaskID);
            int val9 = 45;

            appTaskExtraB.TVItemID = val9;
            Assert.AreEqual(val9, appTaskExtraB.TVItemID);
            int val10 = 45;

            appTaskExtraB.TVItemID2 = val10;
            Assert.AreEqual(val10, appTaskExtraB.TVItemID2);
            AppTaskCommandEnum val11 = (AppTaskCommandEnum)3;

            appTaskExtraB.AppTaskCommand = val11;
            Assert.AreEqual(val11, appTaskExtraB.AppTaskCommand);
            AppTaskStatusEnum val12 = (AppTaskStatusEnum)3;

            appTaskExtraB.AppTaskStatus = val12;
            Assert.AreEqual(val12, appTaskExtraB.AppTaskStatus);
            int val13 = 45;

            appTaskExtraB.PercentCompleted = val13;
            Assert.AreEqual(val13, appTaskExtraB.PercentCompleted);
            string val14 = "Some text";

            appTaskExtraB.Parameters = val14;
            Assert.AreEqual(val14, appTaskExtraB.Parameters);
            LanguageEnum val15 = (LanguageEnum)3;

            appTaskExtraB.Language = val15;
            Assert.AreEqual(val15, appTaskExtraB.Language);
            DateTime val16 = new DateTime(2010, 3, 4);

            appTaskExtraB.StartDateTime_UTC = val16;
            Assert.AreEqual(val16, appTaskExtraB.StartDateTime_UTC);
            DateTime val17 = new DateTime(2010, 3, 4);

            appTaskExtraB.EndDateTime_UTC = val17;
            Assert.AreEqual(val17, appTaskExtraB.EndDateTime_UTC);
            int val18 = 45;

            appTaskExtraB.EstimatedLength_second = val18;
            Assert.AreEqual(val18, appTaskExtraB.EstimatedLength_second);
            int val19 = 45;

            appTaskExtraB.RemainingTime_second = val19;
            Assert.AreEqual(val19, appTaskExtraB.RemainingTime_second);
            DateTime val20 = new DateTime(2010, 3, 4);

            appTaskExtraB.LastUpdateDate_UTC = val20;
            Assert.AreEqual(val20, appTaskExtraB.LastUpdateDate_UTC);
            int val21 = 45;

            appTaskExtraB.LastUpdateContactTVItemID = val21;
            Assert.AreEqual(val21, appTaskExtraB.LastUpdateContactTVItemID);
            bool val22 = true;

            appTaskExtraB.HasErrors = val22;
            Assert.AreEqual(val22, appTaskExtraB.HasErrors);
            IEnumerable <ValidationResult> val69 = new List <ValidationResult>()
            {
                new ValidationResult("First CSSPError Message")
            }.AsEnumerable();

            appTaskExtraB.ValidationResults = val69;
            Assert.AreEqual(val69, appTaskExtraB.ValidationResults);
        }
コード例 #4
0
ファイル: AppTaskService.cs プロジェクト: ECCC-CSSP/CSSPDBDLL
        public int GetAppTaskModelCountWithAppTaskStatusAndAppTaskCommandDB(AppTaskStatusEnum appTaskStatus, AppTaskCommandEnum appTaskCommand)
        {
            int AppTaskModelCount = (from c in db.AppTasks
                                     where c.AppTaskStatus == (int)appTaskStatus &&
                                     c.AppTaskCommand == (int)appTaskCommand
                                     select c).Count();

            return(AppTaskModelCount);
        }
コード例 #5
0
        public void AppTask_Every_Property_Has_Get_Set_Test()
        {
            int val1 = 45;

            appTask.AppTaskID = val1;
            Assert.AreEqual(val1, appTask.AppTaskID);
            int val2 = 45;

            appTask.TVItemID = val2;
            Assert.AreEqual(val2, appTask.TVItemID);
            int val3 = 45;

            appTask.TVItemID2 = val3;
            Assert.AreEqual(val3, appTask.TVItemID2);
            AppTaskCommandEnum val4 = (AppTaskCommandEnum)3;

            appTask.AppTaskCommand = val4;
            Assert.AreEqual(val4, appTask.AppTaskCommand);
            AppTaskStatusEnum val5 = (AppTaskStatusEnum)3;

            appTask.AppTaskStatus = val5;
            Assert.AreEqual(val5, appTask.AppTaskStatus);
            int val6 = 45;

            appTask.PercentCompleted = val6;
            Assert.AreEqual(val6, appTask.PercentCompleted);
            string val7 = "Some text";

            appTask.Parameters = val7;
            Assert.AreEqual(val7, appTask.Parameters);
            LanguageEnum val8 = (LanguageEnum)3;

            appTask.Language = val8;
            Assert.AreEqual(val8, appTask.Language);
            DateTime val9 = new DateTime(2010, 3, 4);

            appTask.StartDateTime_UTC = val9;
            Assert.AreEqual(val9, appTask.StartDateTime_UTC);
            DateTime val10 = new DateTime(2010, 3, 4);

            appTask.EndDateTime_UTC = val10;
            Assert.AreEqual(val10, appTask.EndDateTime_UTC);
            int val11 = 45;

            appTask.EstimatedLength_second = val11;
            Assert.AreEqual(val11, appTask.EstimatedLength_second);
            int val12 = 45;

            appTask.RemainingTime_second = val12;
            Assert.AreEqual(val12, appTask.RemainingTime_second);
            DateTime val13 = new DateTime(2010, 3, 4);

            appTask.LastUpdateDate_UTC = val13;
            Assert.AreEqual(val13, appTask.LastUpdateDate_UTC);
            int val14 = 45;

            appTask.LastUpdateContactTVItemID = val14;
            Assert.AreEqual(val14, appTask.LastUpdateContactTVItemID);
            bool val15 = true;

            appTask.HasErrors = val15;
            Assert.AreEqual(val15, appTask.HasErrors);
            IEnumerable <ValidationResult> val48 = new List <ValidationResult>()
            {
                new ValidationResult("First CSSPError Message")
            }.AsEnumerable();

            appTask.ValidationResults = val48;
            Assert.AreEqual(val48, appTask.ValidationResults);
        }