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