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