public void DeleteNews(News news)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var newsEntity = from item in context.News
where item.NewsID == news.NewsID
select item;
News entity = newsEntity.SingleOrDefault();
if (entity != null)
{
context.DeleteObject(entity);
context.SaveChanges();
}
}
}
public string DeleteFile(File file)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var files = from item in context.Files
where item.FileID == file.FileID
select item;
File entity = files.FirstOrDefault();
if ((entity != null))
{
context.DeleteObject(entity);
context.SaveChanges();
}
return entity.FileName;
}
}
public bool ValidatePermission(int userID)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var data = (from user in context.Users
where user.UserID == userID
&& user.IsEnabled == true
select user).ToList();
if (data.Count != 0)
{
return true;
}
else
{
return false;
}
}
}
public void UpdateUser(User user)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var users = from item in context.Users
where item.UserID == user.UserID
select item;
User entity = users.SingleOrDefault();
if (entity != null)
{
entity.Name = user.Name;
entity.Password = Cryptography.EncryptData(user.Password, saltKeyword);
entity.Login = user.Login;
entity.IsEnabled = user.IsEnabled;
context.SaveChanges();
}
}
}
public void UpdateNews(News news)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var newsList = from item in context.News
where item.NewsID == news.NewsID
select item;
News entity = newsList.SingleOrDefault();
if (entity != null)
{
entity.Title = news.Title;
entity.Text = news.Text;
entity.IsEnabled = news.IsEnabled;
context.SaveChanges();
}
}
}
public void UpdateFile(File file)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var files = from item in context.Files
where item.FileID == file.FileID
select item;
File entity = files.FirstOrDefault();
if ((entity != null))
{
entity.SubTypeID = file.SubTypeID;
entity.IsEnabled = file.IsEnabled;
context.SaveChanges();
}
}
}
public User SelectUserToLogin(string login, string pwd)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
User user = (from item in context.Users
where item.Login == login
&& item.IsEnabled == true
select item).FirstOrDefault();
if (user != null)
{
string spwd2 = Cryptography.EncryptData(pwd, saltKeyword);
string pwd2 = Cryptography.DecryptData(user.Password, saltKeyword);
if (pwd == pwd2)
return user;
else
return null;
}
else
return null;
}
}
public List<User> SelectUser(int? userID, string name, bool? isEnabled)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var result = from item in context.Users
where (item.UserID == userID || userID == null)
&& (item.Name == name || name == null)
&& (item.IsEnabled == isEnabled || isEnabled == null)
orderby item.Name
select item;
foreach (var item in result)
{
//TODO: is necessary?
item.Password = Cryptography.DecryptData(item.Password, saltKeyword);
}
return result.ToList();
}
}
public void InsertFile(File file)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
context.AddToFiles(file);
context.SaveChanges();
}
}
public List<Parameter> SelectParameter(int? parameterID, string name)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var result = from p in context.Parameters
where (p.ParameterID == parameterID || parameterID == null)
&& (p.Name == name || name == null)
orderby p.Name
select p;
return result.ToList();
}
}
public News SelectNewsFrontEnd()
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var result = from item in context.News
where item.IsEnabled == true
orderby item.CreateDate descending
select item;
return result.FirstOrDefault();
}
}
public List<News> SelectNews(int? newsID, string title, bool? isEnabled)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var result = from item in context.News
where (item.NewsID == newsID || newsID == null)
&& (item.Title == title || title == null)
&& (item.IsEnabled == isEnabled || isEnabled == null)
orderby item.CreateDate descending
select item;
return result.ToList();
}
}
public List<File> SelectFileFiltered(int? userID, int? typeID, int? subTypeID, String name, System.DateTime? initialDate, System.DateTime? finalDate)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var result = from p in context.Files
where (p.User.UserID == userID || userID == null)
&& (p.SubType.Type.TypeID == typeID || typeID == null)
&& (p.SubType.SubTypeID == subTypeID || subTypeID == null)
&& (p.Created >= initialDate || initialDate == null)
&& (p.Created <= finalDate || finalDate == null)
&& (p.FileName.Contains(name) || name == null)
&& (p.IsEnabled == true)
orderby p.Created descending
select p;
foreach (var item in result)
{
item.UserReference.Load();
item.SubTypeReference.Load();
item.SubType.TypeReference.Load();
}
return result.ToList();
}
}
public List<File> SelectFile(int? fileID, int? userID, int? typeID, int? subTypeID, string name, bool? isEnabled)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var result = from p in context.Files
where (p.FileID == fileID || fileID == null)
&& (p.User.UserID == userID || userID == null)
&& (p.SubType.SubTypeID == subTypeID || subTypeID == null)
&& (p.SubType.Type.TypeID == typeID || typeID == null)
&& (p.FileName == name || name == null)
&& (p.IsEnabled == isEnabled || isEnabled == null)
orderby p.Created descending
select p;
foreach (var item in result)
{
item.UserReference.Load();
item.SubTypeReference.Load();
item.SubType.TypeReference.Load();
}
return result.ToList();
}
}
public void InsertUser(User user)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
user.Password = Cryptography.EncryptData(user.Password, saltKeyword);
context.AddToUsers(user);
context.SaveChanges();
}
}
public void InsertNews(News news)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
news.CreateDate = DateTime.Now;
context.AddToNews(news);
context.SaveChanges();
}
}
public List<Entities.Type> SelectType(int? typeID, string name, bool? isEnabled)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var result = from p in context.Types
where (p.TypeID == typeID || typeID == null)
&& (p.Name == name || name == null)
&& (p.IsEnabled == isEnabled || isEnabled == null)
orderby p.Name
select p;
foreach (var item in result)
{
item.SubTypes.Load();
}
return result.ToList();
}
}
public void DeleteUser(User user)
{
using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext)))
{
var users = from item in context.Users
where item.UserID == user.UserID
select item;
User entity = users.SingleOrDefault();
if (entity != null)
{
context.DeleteObject(entity);
context.SaveChanges();
}
}
}
