public MemberCodesnippetsViewModel GetMemberCodeSnippets(Guid memberID)
{
MemberCodesnippetsViewModel memberCodesnippetsViewModel = new MemberCodesnippetsViewModel();
Member member = clubmembershipDataContext.Members.FirstOrDefault(x => x.IDMember == memberID);
if (member != null)
{
memberCodesnippetsViewModel.Name = member.Name;
memberCodesnippetsViewModel.Position = member.Name;
memberCodesnippetsViewModel.Title = member.Title;
IQueryable <CodeSnippet> memberCodeSnippets = clubmembershipDataContext.CodeSnippets.Where(x => x.IDMember == memberID);
foreach (CodeSnippet dbCodeSnippet in memberCodeSnippets)
{
CodeSnippetModel codeSnippetModel = new CodeSnippetModel();
codeSnippetModel.Title = dbCodeSnippet.Title;
codeSnippetModel.ContentCode = dbCodeSnippet.ContentCode;
codeSnippetModel.Revision = dbCodeSnippet.Revision;
memberCodesnippetsViewModel.codeSnippets.Add(codeSnippetModel);
}
}
return(memberCodesnippetsViewModel);
}
public void InsertCodeSnippet(CodeSnippetModel codeSnippetModel)
{
codeSnippetModel.IDCodeSnippet = Guid.NewGuid();
clubmembershipDataContext.CodeSnippets.InsertOnSubmit(MapModelToDbObject(codeSnippetModel));
clubmembershipDataContext.SubmitChanges();
}
public void CreateCodeSnippet(string snippetID, InteractiveGameObjectModel model)
{
Type modelType = ReflectionManager.Instance.GetAssetType(snippetID, "code_snippet_", "CodeSnippetModel") ?? typeof(CodeSnippetModel);
Type viewType = ReflectionManager.Instance.GetAssetType(snippetID, "code_snippet_", "CodeSnippetView") ?? typeof(CodeSnippetView);
Type controllerType = ReflectionManager.Instance.GetAssetType(snippetID, "code_snippet_", "CodeSnippetController") ?? typeof(CodeSnippetController);
CodeSnippetModel codeModel = (Activator.CreateInstance(modelType) as CodeSnippetModel);
codeModel.assetID = snippetID;
codeModel.targetGameObject = model;
CodeSnippetController codeController = Activator.CreateInstance(controllerType) as CodeSnippetController;
codeController.model = codeModel;
GameResourceManager.Instance.LoadConfigData(codeModel);
CodeSnippetView codeView = Activator.CreateInstance(viewType) as CodeSnippetView;
codeView.model = codeModel;
codeView.controller = codeController;
codeView.inputFields = CodeBlockManager.Instance.PopEditablePart(codeModel.tag, codeModel.dataCount);
Debug.Log("Pop count is " + codeModel.dataCount);
codeController.InitCodeSnippet();
codeView.InitCodeSnippet();
snippetViews.Add(codeView);
}
public CodeSnippetModel GetCodeSnippetID(Guid id)
{
CodeSnippetModel codeSnippetModel = new CodeSnippetModel();
CodeSnippet codeSnippet = clubmembershipDataContext.CodeSnippets.FirstOrDefault(x => x.IDCodeSnippet == id);
return(MapDbObjectToModel(codeSnippet));
}
public void UpdateCodeSnippet(CodeSnippetModel codeSnippetModel)
{
Models.DBObjects.CodeSnippet existingcodeSnippet = dbContext.CodeSnippets.FirstOrDefault(x => x.IDCodeSnippet == codeSnippetModel.IDCodeSnippet);
if (existingcodeSnippet != null)
{
existingcodeSnippet.UpdateObject(codeSnippetModel);
dbContext.SubmitChanges();
}
}
public void UpdateCodeSnippet(CodeSnippetModel codeSnippetModel)
{
Models.DBObjects.CodeSnippet existingCodeSnippet = clubmembershipDataContext.CodeSnippets.FirstOrDefault
(x => x.IDCodeSnippet == codeSnippetModel.IDCodeSnippet);
if (existingCodeSnippet != null)
{
existingCodeSnippet.IDCodeSnippet = codeSnippetModel.IDCodeSnippet;
existingCodeSnippet.ContentCode = codeSnippetModel.ContentCode;
existingCodeSnippet.IDMember = codeSnippetModel.IDMember;
existingCodeSnippet.Title = codeSnippetModel.Title;
existingCodeSnippet.Revision = codeSnippetModel.Revision;
existingCodeSnippet.DateTimeAdded = codeSnippetModel.DateTimeAdded;
existingCodeSnippet.IDSnippetPreviousVersion = codeSnippetModel.IDSnippetPreviousVersion;
existingCodeSnippet.IsPublished = codeSnippetModel.IsPublished;
clubmembershipDataContext.SubmitChanges();
}
}
private CodeSnippet MapModelToDbObject(CodeSnippetModel codeSnippetModel)
{
CodeSnippet dbCodeSnippetModel = new CodeSnippet();
if (codeSnippetModel != null)
{
dbCodeSnippetModel.IDCodeSnippet = codeSnippetModel.IDCodeSnippet;
dbCodeSnippetModel.ContentCode = codeSnippetModel.ContentCode;
dbCodeSnippetModel.IDMember = codeSnippetModel.IDMember;
dbCodeSnippetModel.Title = codeSnippetModel.Title;
dbCodeSnippetModel.Revision = codeSnippetModel.Revision;
dbCodeSnippetModel.DateTimeAdded = codeSnippetModel.DateTimeAdded;
dbCodeSnippetModel.IDSnippetPreviousVersion = codeSnippetModel.IDSnippetPreviousVersion;
dbCodeSnippetModel.IsPublished = codeSnippetModel.IsPublished;
return(dbCodeSnippetModel);
}
return(null);
}
private CodeSnippetModel MapDbObjectToModel(CodeSnippet codeSnippet)
{
CodeSnippetModel codeSnippetModel = new CodeSnippetModel();
if (codeSnippet != null)
{
codeSnippetModel.IDCodeSnippet = codeSnippet.IDCodeSnippet;
codeSnippetModel.DateTimeAdded = codeSnippet.DateTimeAdded;
codeSnippetModel.IDSnippetPreviousVersion = codeSnippet.IDSnippetPreviousVersion;
codeSnippetModel.Revision = codeSnippet.Revision;
codeSnippetModel.Title = codeSnippet.Title;
codeSnippetModel.ContentCode = codeSnippet.ContentCode;
codeSnippetModel.IDMember = codeSnippet.IDMember;
codeSnippetModel.IsPublished = codeSnippet.IsPublished;
return(codeSnippetModel);
}
return(null);
}
public void InsertCodeSnippet(CodeSnippetModel codeSnippet)
{
codeSnippet.IDCodeSnippet = Guid.NewGuid();
dbContext.CodeSnippets.InsertOnSubmit(codeSnippet.MapObject <Models.DBObjects.CodeSnippet>());
dbContext.SubmitChanges();
}
