public static ArchModelView GetSketChup(int id)
{
ApplicationDbContext db = new ApplicationDbContext();
ArchModel edit = db.ArchModels.FirstOrDefault(x => x.Id == id && x.Type == ModelType.SKETCHUP);
return(ModelConverter.ArchModelToView(edit));
}
public static void AddBookOrder(BookOrderView a)
{
ApplicationDbContext db = new ApplicationDbContext();
db.BookOrders.Add(ModelConverter.ViewToBookOrder(a));
db.SaveChanges();
}
public static void AddDataSystem(SystemDataView data)
{
ApplicationDbContext db = new ApplicationDbContext();
SystemData a = ModelConverter.ViewToSystemDataModel(data);
db.SystemDatas.Add(a);
db.SaveChanges();
}
public static int AddSketChup(ArchModelView a)
{
ApplicationDbContext db = new ApplicationDbContext();
ArchModel add = ModelConverter.ViewToArchModel(a);
db.ArchModels.Add(add);
db.SaveChanges();
return(add.Id);
}
internal static BookViewModel GetBook(int id)
{
Book b = DBHelper.GetBook(id);
if (b == null)
{
return(null);
}
return(ModelConverter.BookToView(b));
}
public static List <AuthorViewModel> GetAllAuthorsView()
{
List <AuthorViewModel> authorModels = new List <AuthorViewModel>();
List <Author> authors = DBHelper.GetAllAuthors();
foreach (var author in authors)
{
authorModels.Add(ModelConverter.AuthorToView(author));
}
return(authorModels);
}
public static List <PublisherViewModel> GetAllPublishersView()
{
List <Publisher> publishers = DBHelper.GetAllPublishers();
List <PublisherViewModel> result = new List <PublisherViewModel>();
foreach (var pub in publishers)
{
result.Add(ModelConverter.PublisherToView(pub));
}
return(result);
}
public static Tuple <List <BookViewModel>, int> GetAllBooksView(int[] topicIds = null, int authorId = -1, int publisherId = -1, int page = 1, string search = "*")
{
var books = DBHelper.GetAllBooks(topicIds, authorId, publisherId, page, search);
List <BookViewModel> result = new List <BookViewModel>();
foreach (var book in books.Item1)
{
result.Add(ModelConverter.BookToView(book));
}
return(new Tuple <List <BookViewModel>, int>(result, books.Item2));
}
public static List <BlogCategoryView> GetBlogCategoryTree()
{
var context = new ApplicationDbContext();
List <BlogCategoryView> topics = new List <BlogCategoryView>();
Stack <BlogCategory> topicQ = new Stack <BlogCategory>();
var firstLevels = context.BlogCategories.Where(x => x.Level == 0).ToList();
foreach (BlogCategory top in firstLevels)
{
topicQ.Push(top);
}
while (topicQ.Count > 0)
{
var current = topicQ.Pop();
topics.Add(ModelConverter.BlogCategoryToView(current));
foreach (var child in current.Childs)
{
topicQ.Push(child);
}
}
return(topics);
}
public static List <TopicViewModel> GetTopicTree()
{
var context = new ApplicationDbContext();
List <TopicViewModel> topics = new List <TopicViewModel>();
Stack <Topic> topicQ = new Stack <Topic>();
var firstLevels = context.Topics.Where(x => x.Level == 0).ToList();
foreach (Topic top in firstLevels)
{
topicQ.Push(top);
}
while (topicQ.Count > 0)
{
var current = topicQ.Pop();
topics.Add(ModelConverter.TopicToView(current));
foreach (var child in current.Childs)
{
topicQ.Push(child);
}
}
return(topics);
}
public static int AddAuthor(AuthorViewModel author)
{
Author addAuthor = ModelConverter.ViewToAuthor(author);
return(AddAuthor(addAuthor));
}
internal static TranslateContentView GetPendingTranslates(int id)
{
PendingTranslate translate = DBHelper.GetPendingTranslate(id);
return(ModelConverter.TranslateToView(translate));
}
internal static List <TranslateContentView> GetAllPendingTranslates()
{
List <PendingTranslate> result = DBHelper.GetAllPendingTranslate();
return(result.Select(x => ModelConverter.TranslateToView(x)).ToList());
}
public static List <TopicViewModel> GetAllTopicView()
{
List <Topic> topics = DBHelper.GetAllTopics();
return(topics.Select(x => ModelConverter.TopicToView(x)).ToList());
}
public static ContentViewModel GetContentView(int id, string code)
{
Content c = DBHelper.GetContent(id, code);
return(ModelConverter.ContentToView(c));
}
public static List <RoleView> GetAllRoles()
{
var roles = DBHelper.GetAllRoles();
return(roles.Select(x => ModelConverter.RoleToView(x)).ToList());
}
public static List <ArchModelView> GetAll3DMax()
{
var list3DMax = DBHelper.GetAll3DMax();
return(list3DMax.Select(x => ModelConverter.ArchModelToView(x)).ToList());
}
internal static DocumentView GetDocument(int id)
{
Document doc = DBHelper.GetDocument(id);
return(ModelConverter.DocumentToView(doc));
}
public static UserView GetUser(string v)
{
ApplicationUser user = DBHelper.GetUser(v);
return(ModelConverter.UserToView(user));
}
internal static Tuple <List <DocumentView>, int> GetAllDocuments(int[] topicIds, int page, string search)
{
var docs = DBHelper.GetAllDocuments(topicIds, page, search);
return(new Tuple <List <DocumentView>, int>(docs.Item1.Select(x => ModelConverter.DocumentToView(x)).ToList(), docs.Item2));
}
public static List <BookOrderView> GetBookOrderIdUser(string user)
{
List <BookOrder> book = DBHelper.GetBookOrderIdUser(user);
return(book.Select(x => ModelConverter.BookOrderToView(x)).ToList());
}
public static SystemDataView GetSystemDataView(int id)
{
SystemData a = DBHelper.GetSystemData(id);
return(ModelConverter.SystemDataToView(a));
}
public static List <SystemDataView> GetAllSystemDataView()
{
List <SystemData> a = DBHelper.GetAllSystemData();
return(a.Select(x => ModelConverter.SystemDataToView(x)).ToList());
}
public static ArchModelView getArchModelView(int id)
{
ArchModelView a = ModelConverter.ArchModelToView(DBHelper.getArchModel(id));
return(a);
}
public static int AddPublisher(PublisherViewModel model)
{
return(AddPublisher(ModelConverter.ViewToPublisher(model)));
}
public static ContentViewModel GetPrevContent(ContentViewModel c)
{
Content prev = DBHelper.GetPrevContent(c.BookId, c.Code);
return(ModelConverter.ContentToView(prev));
}
public static List <AccessTokenView> GetAllAccessTokens()
{
List <AccessToken> tokens = DBHelper.GetAllAccessTokens();
return(tokens.Select(x => ModelConverter.TokenToView(x)).ToList());
}
public static ContentViewModel GetNextContent(ContentViewModel c)
{
Content next = DBHelper.GetNextContent(c.BookId, c.Code);
return(ModelConverter.ContentToView(next));
}
public static List <ArchModelView> GetAllArchModelView()
{
List <ArchModel> a = DBHelper.GetAllArchModel();
return(a.Select(x => ModelConverter.ArchModelToView(x)).ToList());
}
public static List <ArchModelView> GetAllSketChup()
{
var listSketChup = DBHelper.GetAllSketChup();
return(listSketChup.Select(x => ModelConverter.ArchModelToView(x)).ToList());
}
