Example #1
0
        public dynamic post()
        {
            WSC2019_SS3Entities db = new WSC2019_SS3Entities();

            return(db.Tasks.Select(x => new {
                ID = x.ID,
                Name = x.Name
            }));
        }
        public dynamic post()
        {
            WSC2019_SS3Entities db = new WSC2019_SS3Entities();

            return(db.PMScheduleModels.Select(x => new
            {
                ID = x.ID,
                Name = x.Name,
                ScheduleTypeID = x.PMScheduleTypeID,
                ScheduleTypeName = x.PMScheduleType.Name
            }));
        }
Example #3
0
        public dynamic post()
        {
            WSC2019_SS3Entities db = new WSC2019_SS3Entities();

            return(db.Assets.Select(x => new {
                ID = x.ID,
                AssetSN = x.AssetSN,
                AssetName = x.AssetName,
                Description = x.Description,
                WarrantyDate = x.WarrantyDate
            }));
        }
        public dynamic post()
        {
            WSC2019_SS3Entities db = new WSC2019_SS3Entities();

            return(db.PMTasks.Select(x => new {
                ID = x.ID,
                AssetID = x.AssetID,
                AssetName = x.Asset.AssetName,
                AssetSN = x.Asset.AssetSN,
                TaskID = x.TaskID,
                TaskName = x.Task.Name,
                PMScheduleTypeID = x.PMScheduleTypeID,
                PMScheduleTypeName = x.PMScheduleType.Name,
                ScheduleDate = x.ScheduleDate,
                ScheduleKilometer = x.ScheduleKilometer,
                TaskDone = x.TaskDone
            }));
        }