static public List <Core.Models.Category.CategoryItem> GetAllCategoryItemsSorted() { using (var db = new DataModel.Entities()) { List <Core.Models.Category.CategoryItem> list = new List <Core.Models.Category.CategoryItem>(); var query = (from i in db.Categories where i.Deleted == null orderby i.Name ascending select new Core.Models.Category.CategoryItem() { Id = i.Id, Name = i.Name, Body = i.Body, ParentId = i.ParentId, Row = i.Row, UserId = i.UserId, Language = i.Language, Url = i.Url, Type = i.Type, Status = i.Status, Created = i.Created, Updated = i.Updated }); foreach (var item in query) { list.Add(item); } return(list); } }
static public Core.Models.Content.ContentItem Get(Guid id) { using (var db = new DataModel.Entities()) { var result = (from i in db.Contents where i.Id == id && i.Deleted == null select new Core.Models.Content.ContentItem { Id = i.Id, Title = i.Title, Description = i.Description, Body = i.Body, Url = i.Url, ContentDate = i.ContentDate, CategoryId = i.CategoryId, UserId = i.UserId, Type = i.Type, Status = i.Status, Created = i.Created, Updated = i.Updated, Deleted = i.Deleted }).SingleOrDefault(); return(result); } }
static public List <Core.Models.Content.ContentItem> GetAllContents() { List <Core.Models.Content.ContentItem> list = new List <Models.Content.ContentItem>(); using (var db = new DataModel.Entities()) { var result = (from i in db.Contents where i.Deleted == null select new Core.Models.Content.ContentItem { Id = i.Id, Title = i.Title, Description = i.Description, Body = i.Body, Url = i.Url, ContentDate = i.ContentDate, CategoryId = i.CategoryId, UserId = i.UserId, Type = i.Type, Status = i.Status, Created = i.Created, Updated = i.Updated, Deleted = i.Deleted }); foreach (var item in result) { list.Add(item); } } return(list); }
static public Core.Models.User.UserItem Save(Core.Models.User.UserItem user) { using (var db = new DataModel.Entities()) { var result = (from i in db.Users where i.Id == user.Id && i.Deleted == null select i).SingleOrDefault(); if (result == null) { var mailCheck = (from i in db.Users where i.Mail == user.Mail select i).SingleOrDefault(); if (mailCheck != null) { throw new Exception(Core.Strings.DiffMail); } var nameCheck = (from i in db.Users where i.Name == user.Name select i).SingleOrDefault(); if (nameCheck != null) { throw new Exception(Core.Strings.DiffUserName); } return(Create(user, db)); } else { var hashPass = Hash(user.Password); if (hashPass != result.Password) { throw new Exception(Core.Strings.WrongPassword); } return(Update(user, db, result)); } } }
static public List <Core.Models.Category.CategoryItem> All() { using (var db = new DataModel.Entities()) { var list = (from i in db.Categories where i.Deleted == null orderby i.Row select new Core.Models.Category.CategoryItem() { Id = i.Id, Name = i.Name, Body = i.Body, ParentId = i.ParentId, Row = i.Row, Url = i.Url, UserId = i.UserId, Language = i.Language, Type = i.Type, Status = i.Status, Created = i.Created, Updated = i.Updated }).ToList(); return(list); } }
public static Core.Models.Page.PageItem parseRoute(string path, List <Core.Models.Category.CategoryItem> categories) { Core.Models.Page.PageItem page = null; try { using (var db = new DataModel.Entities()) { var paths = path.Split('/'); if (paths.Length == 2) { var lastElement = paths[paths.Length - 2]; var category = GetCategory(lastElement, db); if (category != null) { page = new Models.Page.PageItem() { Category = category, PageType = Enums.Page.PageType.Category }; } } else { var lastElement = paths[paths.Length - 3]; var category = GetCategory(lastElement, db); if (category != null) { page = new Models.Page.PageItem() { Category = category, Contents = GetContentList(db), PageType = Enums.Page.PageType.Category }; } else { var content = GetContent(lastElement, db); if (content != null) { page = new Models.Page.PageItem() { Content = content, Category = GetCategory(paths[paths.Length - 3], db) }; } } } } } catch (Exception) { } return(page); }
static public List <Core.Models.Category.CategoryItem> GetAllCategories() { using (var db = new DataModel.Entities()) { var all = All(); var parents = all.Where(x => x.ParentId == null).ToList(); foreach (var parent in parents) { parent.DisplayName = parent.Name; parent.Categories = GetAllSubCategories(parent, all, parent.CategoryRow); } return(parents); } }
static public List <Core.Models.Category.CategoryItem> GetAllCategoriesByLanguage(Enums.Page.Language language) { using (var db = new DataModel.Entities()) { var all = All(); var parents = all.Where(x => x.ParentId == null && Core.Enums.Helper.Get(x.Language).Name == Core.Enums.Helper.Get(language).Name).ToList(); foreach (var parent in parents) { parent.DisplayName = parent.Name; parent.Categories = GetAllSubCategories(parent, all, parent.CategoryRow); } return(parents); } }
public static void GetDate_Equipment_SET_Detail(out Equipment_SET_detail[] Equipment_SET_details, int?SET_ID) { Web_T_REC.DataModel.Entities efen = new DataModel.Entities(); if (SET_ID != null) { Equipment_SET_details = (from a in efen.Equipment_SET_detail where a.SET_ID == SET_ID select a).ToArray(); } else { Equipment_SET_details = efen.Equipment_SET_detail.ToArray(); } }
public static void GetDate_Equipment_SET(out Packages[] Packagess, int?Pack_Id) { Web_T_REC.DataModel.Entities efen = new DataModel.Entities(); if (Pack_Id != null) { Packagess = (from a in efen.Packages where a.Pack_Id == Pack_Id select a).ToArray(); } else { Packagess = efen.Packages.ToArray(); } }
static public Core.Models.User.UserItem Get(Guid id) { using (var db = new DataModel.Entities()) { var result = (from i in db.Users where i.Id == id && i.Deleted == null select new Core.Models.User.UserItem() { Id = i.Id, FirstName = i.FirstName, LastName = i.LastName, Name = i.Name, Mail = i.Mail, Role = i.Role }).SingleOrDefault(); return(result); } }
static public Core.Models.Content.ContentItem Save(Core.Models.Content.ContentItem content) { using (var db = new DataModel.Entities()) { var result = (from i in db.Contents where i.Id == content.Id && i.Deleted == null select i).SingleOrDefault(); if (result == null) { var url = Core.Helpers.BaseHelper.ConvertToUrl(content.Title); content.Url = url; var row = 0; while ((from i in db.Contents where i.Url == content.Url select i).SingleOrDefault() != null) { row++; content.Url = $"{url}-{row}"; } return(Create(content, db)); } return(Update(content, db, result)); } }
public Record Add(Record entity) { var cmdText = "insert into Record (Id,Title,Project,Description,Tag,Status,DealWith,CreateDate,LastEditDate)" + " values (@Id,@Title,@Project,@Description,@Tag,@Status,@DealWith,@CreateDate,@LastEditDate)"; var parameters = new[]{ new SQLiteParameter("@Id",entity.Id.ToString()), new SQLiteParameter("@Title",entity.Title), new SQLiteParameter("@Project",entity.Project), new SQLiteParameter("@Description",entity.Description), new SQLiteParameter("@Tag",entity.Tag), new SQLiteParameter("@Status",entity.Status), new SQLiteParameter("@DealWith",entity.DealWith), new SQLiteParameter("@CreateDate",entity.CreateDate), new SQLiteParameter("@LastEditDate",entity.LastEditDate) }; if (DbContext.ExecuteNoQuery(cmdText, parameters) != 1) throw new Exception("新增记录失败"); return entity; }
static public Core.Models.User.UserItem Login(Core.Models.User.UserLoginItem user) { using (var db = new DataModel.Entities()) { var hashedPass = Hash(user.Password); var result = (from i in db.Users where (i.Name == user.UserNameMail || i.Mail == user.UserNameMail) && i.Password == hashedPass && i.Deleted == null select new Core.Models.User.UserItem() { Id = i.Id, FirstName = i.FirstName, LastName = i.LastName, Name = i.Name, Mail = i.Mail, Role = i.Role }).SingleOrDefault(); return(result); } }
private static Core.Models.Category.CategoryItem GetCategory(string url, DataModel.Entities db) { var categories = (from i in db.Categories where i.Deleted == null && i.Url == url select new Models.Category.CategoryItem() { Id = i.Id, Name = i.Name, Body = i.Body, ParentId = i.ParentId, Url = i.Url, Row = i.Row, UserId = i.UserId, Type = i.Type, Status = i.Status, Created = i.Created, Updated = i.Updated }).SingleOrDefault(); return(categories); }
public Record Update(Record entity) { var cmdText = "update Record set " + " title = @Title,project = @Project,description = @Description,tag = @Tag,status = @Status,dealwith = @DealWith,CreateDate = @CreateDate,LastEditDate = @LastEditDate" + " where id = @Id"; var parameters = new[]{ new SQLiteParameter("@Id",entity.Id.ToString()), new SQLiteParameter("@Title",entity.Title), new SQLiteParameter("@Project",entity.Project), new SQLiteParameter("@Description",entity.Description), new SQLiteParameter("@Tag",entity.Tag), new SQLiteParameter("@Status",entity.Status), new SQLiteParameter("@DealWith",entity.DealWith), new SQLiteParameter("@CreateDate",entity.CreateDate), new SQLiteParameter("@LastEditDate",entity.LastEditDate) }; if (DbContext.ExecuteNoQuery(cmdText, parameters) != 1) throw new Exception("修改记录失败"); return entity; }
private static Core.Models.Content.ContentItem GetContent(string url, DataModel.Entities db) { var content = (from i in db.Contents where i.Deleted == null && i.Url == url select new Models.Content.ContentItem() { Id = i.Id, Title = i.Title, Description = i.Description, Body = i.Body, Url = i.Url, ContentDate = i.ContentDate, CategoryId = i.CategoryId, UserId = i.UserId, Type = i.Type, Status = i.Status, Created = i.Created, Updated = i.Updated, }).SingleOrDefault(); return(content); }
private static List <Core.Models.Content.ContentItem> GetContentList(DataModel.Entities db) { var contents = (from i in db.Contents where i.Deleted == null select new Models.Content.ContentItem() { Id = i.Id, Title = i.Title, Description = i.Description, Body = i.Body, Url = i.Url, ContentDate = i.ContentDate, CategoryId = i.CategoryId, UserId = i.UserId, Type = i.Type, Status = i.Status, Created = i.Created, Updated = i.Updated, }).ToList(); return(contents); }
static private Core.Models.User.UserItem Create(Core.Models.User.UserItem user, DataModel.Entities db) { var pass = Hash(user.PasswordAgain); var newUser = new DataModel.User() { Id = user.Id, FirstName = user.FirstName, LastName = user.LastName, Password = pass, Name = user.Name, Mail = user.Mail, Role = user.Role, Type = user.Type, Status = user.Status, Created = DateTime.Now }; db.Users.Add(newUser); db.SaveChanges(); return(user); }
static private Core.Models.User.UserItem Update(Core.Models.User.UserItem user, DataModel.Entities db, DataModel.User dbUser) { /// TODO dbUser.FirstName = !string.IsNullOrEmpty(user.FirstName) && user.FirstName != dbUser.FirstName ? user.FirstName : dbUser.FirstName; dbUser.LastName = !string.IsNullOrEmpty(user.LastName) && user.LastName != dbUser.LastName ? user.LastName : dbUser.LastName; db.SaveChanges(); return(user); }
static private Core.Models.Content.ContentItem Create(Core.Models.Content.ContentItem content, DataModel.Entities db) { var newContent = new DataModel.Content() { Id = content.Id, Title = content.Title, Description = content.Description, Url = content.Url, Body = content.Body, ContentDate = content.ContentDate, CategoryId = content.CategoryId, UserId = content.UserId, Type = content.Type, Status = content.Status, Created = DateTime.Now }; db.Contents.Add(newContent); db.SaveChanges(); return(content); }
static private Core.Models.Content.ContentItem Update(Core.Models.Content.ContentItem content, DataModel.Entities db, DataModel.Content dbContent) { dbContent.Title = !string.IsNullOrEmpty(content.Title) && content.Title != dbContent.Title ? content.Title : dbContent.Title; dbContent.Body = !string.IsNullOrEmpty(content.Body) && content.Body != dbContent.Body ? content.Body : dbContent.Body; dbContent.CategoryId = content.CategoryId != null && content.CategoryId != dbContent.CategoryId ? content.CategoryId : dbContent.CategoryId; dbContent.UserId = content.UserId != null && content.UserId != dbContent.UserId ? content.UserId : dbContent.UserId; dbContent.Type = content.Type != dbContent.Type ? content.Type : dbContent.Type; dbContent.Status = content.Status != dbContent.Status ? content.Status : dbContent.Status; db.SaveChanges(); return(content); }
public bool Delete(Guid id) { var cmdText = "delete from record where id = @id"; var parameters = new[] { new SQLiteParameter("@id", id.ToString()) }; return DbContext.ExecuteNoQuery(cmdText, parameters) == 1; }
static private Core.Models.Category.CategoryItem Create(Core.Models.Category.CategoryItem category, DataModel.Entities db) { var newCategory = new DataModel.Category() { Id = category.Id, Name = category.Name, Url = category.Url, Body = category.Body, ParentId = category.ParentId, Row = category.Row, UserId = category.UserId, Language = category.Language, Type = category.Type, Status = category.Status, Created = DateTime.Now }; db.Categories.Add(newCategory); db.SaveChanges(); return(category); }
static private Core.Models.Category.CategoryItem Update(Core.Models.Category.CategoryItem category, DataModel.Entities db, DataModel.Category dbCategory) { dbCategory.Name = !string.IsNullOrEmpty(category.Name) && category.Name != dbCategory.Name ? category.Name : dbCategory.Name; dbCategory.Body = !string.IsNullOrEmpty(category.Body) && category.Body != dbCategory.Body ? category.Body : dbCategory.Body; dbCategory.ParentId = category.ParentId != null && category.ParentId != dbCategory.ParentId ? category.ParentId : dbCategory.ParentId; dbCategory.Type = category.Type != dbCategory.Type ? category.Type : dbCategory.Type; dbCategory.Status = category.Status != dbCategory.Status ? category.Status : dbCategory.Status; dbCategory.Language = category.Language != dbCategory.Language ? category.Language : dbCategory.Language; db.SaveChanges(); return(category); }