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