public int Add(LogAddModel mLog) { var location = _context.Locations.FirstOrDefault(a => a.LocationId == mLog.LocationId); if (location == null) { throw new ExpectException("Could not find Location data which LocationId equal to " + mLog.LocationId); } var logDescription = _context.LogDescriptions.FirstOrDefault(a => a.LogDescriptionId == mLog.LogDescriptionId); if (logDescription == null) { throw new ExpectException("Could not find LogDescription data which LogDescriptionId equal to " + mLog.LogDescriptionId); } var user = _loginUser.GetLoginUserInfo(); var model = new Log { Comment = mLog.Comment, LocationId = mLog.LocationId, LogDescriptionId = mLog.LogDescriptionId, Creator = user.UserName, CreateDate = DateTime.Now }; _context.Logs.Add(model); _context.SaveChanges(); return(model.LogId); }
public int Add(ProjectAddModel project) { var customer = _context.Customers.FirstOrDefault(c => c.CustomerId == project.CustomerId); if (customer == null) { throw new ExpectException("Could not find Customer data which CustomerId equal to " + project.CustomerId); } //ProjectNo must be unique var checkData = _context.Projects.Where(p => p.ProjectNo == project.ProjectNo).ToList(); if (checkData.Count > 0) { throw new ExpectException("The data which ProjectNo equal to '" + project.ProjectNo + "' already exist in system"); } //Get UserInfo var user = _loginUser.GetLoginUserInfo(); var model = new Project { CustomerId = project.CustomerId, ProjectName = project.ProjectName, ProjectNo = project.ProjectNo, Creator = user.UserName, CreateDate = DateTime.Now }; _context.Projects.Add(model); _context.SaveChanges(); return(model.ProjectId); }
public int Add(CustomerAddModel customer) { //CustomerNo must be unique var checkData = _context.Customers.Where(c => c.CustomerNo == customer.CustomerNo).ToList().Count; if (checkData > 0) { throw new ExpectException("The data which CustomerNo equal to '" + customer.CustomerNo + "' already exist in system"); } //Get UserInfo var user = _loginUser.GetLoginUserInfo(); var model = new Customer { CustomerName = customer.CustomerName, CustomerNo = customer.CustomerNo, Creator = user.UserName, CreateDate = DateTime.Now }; _context.Customers.Add(model); _context.SaveChanges(); return(model.CustomerId); }
public int Add(SceneAddModel scene) { var project = _context.Projects.FirstOrDefault(c => c.ProjectId == scene.ProjectId); if (project == null) { throw new ExpectException("Could not find Project data which ProjectId equal to " + scene.ProjectId); } //SceneName must be unique var checkData = _context.Scenes.Where(s => s.SceneName == scene.SceneName).ToList(); if (checkData.Count > 0) { throw new ExpectException("The data which SceneName equal to '" + scene.SceneName + "' already exist in system"); } //Get UserInfo var user = _loginUser.GetLoginUserInfo(); var model = new Scene { ProjectId = scene.ProjectId, SceneName = scene.SceneName, Enable = scene.Enable, Creator = user.UserName, CreateDate = DateTime.Now }; _context.Scenes.Add(model); _context.SaveChanges(); return(model.SceneId); }
public int Add(SceneSegmentAddModel mSceneSegment) { var scene = _context.Scenes.FirstOrDefault(c => c.SceneId == mSceneSegment.SceneId); if (scene == null) { throw new ExpectException("Could not find Scene data which SceneId equal to " + mSceneSegment.SceneId); } //SequenceNo must be unique var checkData = _context.SceneSegments.Where(s => s.SequenceNo == mSceneSegment.SequenceNo).ToList(); if (checkData.Count > 0) { throw new ExpectException("The data which SequenceNo equal to '" + mSceneSegment.SequenceNo + "' already exist in system"); } //Get UserInfo var user = _loginUser.GetLoginUserInfo(); var model = new SceneSegment { SceneId = mSceneSegment.SceneId, SequenceNo = mSceneSegment.SequenceNo, StartTime = mSceneSegment.StartTime, Volumn = mSceneSegment.Volumn, Creator = user.UserName, CreateDate = DateTime.Now }; _context.SceneSegments.Add(model); _context.SaveChanges(); return(model.SceneSegmentId); }
public int Add(GroupAddModel group) { var project = _context.Projects.FirstOrDefault(p => p.ProjectId == group.ProjectId); if (project == null) { throw new ExpectException("Could not find Project data which ProjectId equal to " + group.ProjectId); } //If SceneId not null,check whether corresponding Scenes data existed if (group.SceneId != null) { var scene = _context.Scenes.FirstOrDefault(p => p.SceneId == group.SceneId); if (scene == null) { throw new ExpectException("Could not find Scenes data which SceneId equal to " + group.SceneId); } } //GroupName must be unique var checkData = _context.Groups.Where(g => g.GroupName == group.GroupName).ToList(); if (checkData.Count > 0) { throw new ExpectException("The data which GroupName equal to '" + group.GroupName + "' already exist in system."); } //Get UserInfo var user = _loginUser.GetLoginUserInfo(); var model = new Group { GroupName = group.GroupName, ProjectId = group.ProjectId, SceneId = group.SceneId, Creator = user.UserName, CreateDate = DateTime.Now }; _context.Groups.Add(model); _context.SaveChanges(); return(model.GroupId); }
public int Add(HolidayAddModel mHoliday) { var project = _context.Projects.FirstOrDefault(c => c.ProjectId == mHoliday.ProjectId); if (project == null) { throw new ExpectException("Could not find Project data which ProjectId equal to " + mHoliday.ProjectId); } //Get UserInfo var user = _loginUser.GetLoginUserInfo(); var model = new Holiday { ProjectId = mHoliday.ProjectId, Day = mHoliday.Day, Creator = user.UserName, CreateDate = DateTime.Now }; _context.Holidays.Add(model); _context.SaveChanges(); return(model.HolidayId); }
public int Add(LocationAddModel mLocation) { var customer = _context.Projects.FirstOrDefault(l => l.ProjectId == mLocation.ProjectId); if (customer == null) { throw new ExpectException("Could not find Project data which ProjectId equal to " + mLocation.ProjectId); } var device = _context.Devices.FirstOrDefault(l => l.DeviceId == mLocation.DeviceId); if (device == null) { throw new ExpectException("Could not find Device data which DeviceId equal to " + mLocation.DeviceId); } //InstallationNumber must be unique var checkData = _context.Locations.Where(dl => dl.InstallationNumber == mLocation.InstallationNumber).ToList(); if (checkData.Count > 0) { throw new ExpectException("The data which InstallationNumber equal to '" + mLocation.InstallationNumber + "' already exist in system"); } //DeviceSerialNo must be unique checkData = _context.Locations.Where(dl => dl.DeviceSerialNo == mLocation.DeviceSerialNo).ToList(); if (checkData.Count > 0) { throw new ExpectException("The data which DeviceSerialNo equal to '" + mLocation.DeviceSerialNo + "' already exist in system"); } //Check Orientation if (!Enum.IsDefined(typeof(Orientation), mLocation.Orientation)) { throw new ExpectException("Invalid Orientation.You can get correct Orientation values from API"); } //Check DeviceType if (!Enum.IsDefined(typeof(DeviceType), mLocation.DeviceType)) { throw new ExpectException("Invalid DeviceType.You can get correct DeviceType values from API"); } //Check CommMode if (!Enum.IsDefined(typeof(CommMode), mLocation.CommMode)) { throw new ExpectException("Invalid CommMode.You can get correct CommMode values from API"); } //Get UserInfo var user = _loginUser.GetLoginUserInfo(); var model = new Location { Building = mLocation.Building, CommAddress = mLocation.CommAddress, CommMode = mLocation.CommMode, CurrentPosition = mLocation.CurrentPosition, Description = mLocation.Description, DeviceSerialNo = mLocation.DeviceSerialNo, DeviceId = mLocation.DeviceId, DeviceType = mLocation.DeviceType, FavorPositionFirst = mLocation.FavorPositionFirst, FavorPositionrSecond = mLocation.FavorPositionrSecond, FavorPositionThird = mLocation.FavorPositionThird, Floor = mLocation.Floor, InstallationNumber = mLocation.InstallationNumber, Orientation = mLocation.Orientation, ProjectId = mLocation.ProjectId, RoomNo = mLocation.RoomNo, Creator = user.UserName, CreateDate = DateTime.Now }; _context.Locations.Add(model); _context.SaveChangesAsync(); return(model.LocationId); }