private IList <Project> PopulateDropdownList()
{
IList <Project> _dbProjects = null;
List <DB.Type> types = new List <DB.Type>();
using (var db = new MLEEntities())
{
_dbProjects = db.Project.ToList();
types = db.Type.Where(x => x.Active == true).ToList();
}
projectList.DataSource = _dbProjects;
projectList.DataTextField = "Name";
projectList.DataValueField = "Id";
projectList.DataBind();
projectList.SelectedIndex = 0;
ddlProjects.DataSource = _dbProjects;
ddlProjects.DataTextField = "Name";
ddlProjects.DataValueField = "Id";
ddlProjects.DataBind();
ddlProjects.SelectedValue = PId.ToString();
ddlType.DataSource = types;
ddlType.DataTextField = "Name";
ddlType.DataValueField = "Id";
ddlType.DataBind();
return(_dbProjects);
}
private void GetUserById(int userId)
{
using (var db = new MLEEntities())
{
User _dbUser = db.User.Where(u => u.Id == userId).FirstOrDefault();
UserRole userRole = null;
Role role = null;
if (_dbUser != null)
{
GetProjectsOnUser(db, _dbUser);
userRole = db.UserRole.Where(u => u.UserId == userId).FirstOrDefault();
if (userRole != null)
role = db.Role.Where(r => r.Id == userRole.RoleId).FirstOrDefault();
txtName.Text = _dbUser.FirstName;
txtSurname.Text = _dbUser.LastName;
txtEmail.Text = _dbUser.E_mail;
txtUsername.Text = _dbUser.Username;
//txtPassword.Text = _dbUser.Password;
txtDescription.Text = _dbUser.Description;
cbIsActive.Checked = _dbUser.IsActive.Value;
if (!IsPostBack)
roleList.SelectedValue = role != null ? role.Id.ToString() : "1";
}
}
}
private void GetExampleById(int id)
{
using (var db = new MLEEntities())
{
var _dbExample = db.Example.Where(e => e.Id == id).FirstOrDefault();
if (_dbExample != null)
{
txtContent.Text = _dbExample.Content != null ? _dbExample.Content : "";
lbText.Text = _dbExample.Content != null ? _dbExample.Content : "";
txtDescription.Text = _dbExample.Description != null ? _dbExample.Description : "";
//txtDateCreated.Text = _dbExample.DateCreated != null ? _dbExample.DateCreated.Value.ToString("dd.MM.yyyy") : "";
if (!IsPostBack)
{
projectList.SelectedValue = _dbExample.ProjectId != null?_dbExample.ProjectId.Value.ToString() : "0";
categoryList.SelectedValue = _dbExample.CategoryId != null?_dbExample.CategoryId.Value.ToString() : "0";
statusList.SelectedValue = _dbExample.StatusId != null?_dbExample.StatusId.Value.ToString() : "0";
ddlType.SelectedValue = _dbExample.TypeId != null?_dbExample.TypeId.Value.ToString() : "0";
}
//txtTimeSpent.Text = _dbExample.TimeSpent != null ? _dbExample.TimeSpent.ToString() : "";
//txtProjectTitle.Text = db.Project.Where(p => p.Id == _dbExample.ProjectId).FirstOrDefault().Name;
//txtStatusType.Text = db.Status.Where(p => p.Id == _dbExample.StatusId).FirstOrDefault().Name;
//txtCategoryTitle.Text = db.Category.Where(p => p.Id == _dbExample.CategoryId).FirstOrDefault().Name;
}
}
}
private IList<Project> PopulateProjectList()
{
IList<Project> _dbProjects = null;
using (var db = new MLEEntities())
_dbProjects = db.Project.Where(x => x.IsActive == true).ToList();
return _dbProjects;
}
private void CreateNewSubcategory(MLEEntities db, FileHelper.Subcategory subcategory, int?categoryID, int counter)
{
var s = new Subcategory();
var name = "";
var color = "";
if (subcategory != null && counter != 0)
{
name = subcategory.Name;
color = subcategory.Color;
var rnd = new Random();
if (color == null)
{
if (counter > FileHelper.Default_colors.Count - 1)
{
color = HexConverter(Color.FromArgb(rnd.Next(256), rnd.Next(256), rnd.Next(256)));
}
else
{
color = FileHelper.Default_colors[counter];
}
}
}
s.Name = name;
s.Color = color;
s.CategoryId = categoryID;
s.Description = "Automatic upload (ZIP)";
s.isActive = true;
db.Subcategory.Add(s);
db.SaveChanges();
}
public static bool?CheckUser()
{
using (var db = new MLEEntities())
{
var u = db.User.Where(x => x.Username == HttpContext.Current.User.Identity.Name.ToString()).FirstOrDefault();
if (u != null)
{
Examples.Username = u.FirstName;
Examples.UserID = u.Id;
var rID = u.UserRole.Where(x => x.UserId == u.Id).Select(x => x.RoleId).FirstOrDefault();
//ADMIN
if (rID == 1)
{
return(true);
}
//CLIENT
else if (rID == 2)
{
return(false);
}
}
else
{
return(null);
}
}
return(null);
}
private List <Project> GetAllProjects(bool update_pager)
{
using (var db = new MLEEntities())
{
var projects = db.Project.Include(x => x.Example).ToList();
var count = projects.Count;
var default_by_page = 20;
current_page = 1;
if (check_page)
{
if (Request.QueryString["page"] != null)
{
int.TryParse(Request.QueryString["page"].ToString(), out current_page);
}
}
Pages = (int)Math.Ceiling((double)count / (double)default_by_page);
current_page = current_page > Pages ? Pages : current_page;
Skip = (current_page - 1) * default_by_page;
if (update_pager)
{
Pager.CreatePager(Pages, current_page, phPager, "Projects");
}
projects = projects.Skip(Skip).Take(default_by_page).ToList();
return(projects);
}
}
private void GetProjectById(int id)
{
using (var db = new MLEEntities())
{
Project _dbProject = db.Project.Where(p => p.Id == id).FirstOrDefault();
PopulateDropDowns(db);
if (_dbProject != null)
{
GetTypesOnProject(db, _dbProject);
GetUsersOnProject(db, _dbProject);
txtName.Text = _dbProject.Name != null ? _dbProject.Name : "";
txtDescription.Text = _dbProject.Description != null ? _dbProject.Description : "";
txtSpentTime.Text = _dbProject.TimeSpent != null?_dbProject.TimeSpent.ToString() : "";
txtDateCreated.Text = _dbProject.DateCreated != null?_dbProject.DateCreated.Value.ToString("dd.MM.yyyy") : "";
txtStartDate.Text = _dbProject.Start_Date != null?_dbProject.Start_Date.Value.ToString("dd.MM.yyyy") : "";
txtEndDate.Text = _dbProject.End_Date != null?_dbProject.End_Date.Value.ToString("dd.MM.yyyy") : "";
ddlStatus.SelectedValue = _dbProject.StatusId != null?_dbProject.StatusId.Value.ToString() : "1";
}
}
}
private void Save()
{
using (var db = new MLEEntities())
{
DateTime.TryParse(txtStartDate.Text, out DateTime start_date);
DateTime.TryParse(txtEndDate.Text, out DateTime end_date);
Project _project = new Project()
{
Name = txtName.Text,
Description = txtDescription.Text,
DateCreated = DateTime.Now,
TimeSpent = TimeSpan.Zero,
Start_Date = start_date,
End_Date = end_date.Year == 0001 ? DateTime.Now : end_date,
StatusId = int.Parse(ddlStatus.SelectedValue)
};
db.Project.Attach(_project);
db.Project.Add(_project);
db.SaveChanges();
}
}
private void GetSubcategoryById(int id)
{
using (var db = new MLEEntities())
{
var _dbSubcategory = db.Subcategory.Where(c => c.Id == id).FirstOrDefault();
if (_dbSubcategory != null)
{
if (_dbSubcategory.Name != "")
{
txtSubcategoryName.Text = _dbSubcategory.Name;
txtDescription.Text = _dbSubcategory.Description;
cbIsActive.Checked = _dbSubcategory.isActive.Value;
txtColor.Text = _dbSubcategory.Color;
btnColor.BackColor = ColorTranslator.FromHtml(_dbSubcategory.Color);
}
else
{
txtSubcategoryName.Text = "TEXT";
txtSubcategoryName.Enabled = false;
txtDescription.Text = _dbSubcategory.Description;
cbIsActive.Checked = _dbSubcategory.isActive.Value;
btnColor.BackColor = Color.Transparent;
btnColor.Enabled = false;
txtColor.Enabled = false;
}
}
}
}
private void Save()
{
using (var db = new MLEEntities())
{
var _user = new User()
{
FirstName = txtName.Text,
LastName = txtSurname.Text,
E_mail = txtEmail.Text,
Username = txtUsername.Text,
Password = LoginHelper.SHA256(txtPassword.Text),
Description = txtDescription.Text,
IsActive = cbIsActive.Checked,
DateCreated = DateTime.Now
};
db.User.Attach(_user);
db.User.Add(_user);
db.SaveChanges();
var users = db.User.OrderByDescending(u => u.Id).Take(1).ToList();
var _userRole = new UserRole()
{
UserId = users[0].Id,
RoleId = int.Parse(roleList.SelectedValue)
};
db.UserRole.Attach(_userRole);
db.UserRole.Add(_userRole);
db.SaveChanges();
}
}
private void Delete()
{
categoryId = int.Parse(Request.QueryString["id"]);
using (var db = new MLEEntities())
{
Category _dbCategory = db.Category.Where(u => u.Id == categoryId).FirstOrDefault();
List <Subcategory> subcategories = db.Subcategory.Where(c => c.CategoryId == categoryId).ToList();
if (subcategories.Count != 0)
{
db.Subcategory.RemoveRange(subcategories);
db.SaveChanges();
}
if (!db.Example.Any(e => e.CategoryId == categoryId))
{
db.Category.Attach(_dbCategory);
db.Category.Remove(_dbCategory);
}
db.SaveChanges();
}
}
/// <summary>
/// Checks if User is allowed to use application.
/// </summary>
/// <param name="user">Username</param>
/// <param name="pass">Password</param>
/// <returns></returns>
public static bool LoginChecker(string user, string pass)
{
User User = null;
using (var db = new MLEEntities())
User = db.User.Where(x => x.Username == user).FirstOrDefault();
if (User == null)
{
return(false);
}
if (User.IsActive == false)
{
return(false);
}
if (User.Username == user)
{
string passCheck = SHA256(pass);
if (User.Password == passCheck)
{
return(true);
}
}
return(false);
}
private List <Category> GetAllCategories(bool update_pager)
{
using (var db = new MLEEntities())
{
var categories = db.Category.ToList();
var count = categories.Count;
var default_by_page = 20;
current_page = 1;
if (check_page)
{
if (Request.QueryString["page"] != null)
{
int.TryParse(Request.QueryString["page"].ToString(), out current_page);
}
}
Pages = (int)Math.Ceiling((double)count / (double)default_by_page);
current_page = current_page > Pages ? Pages : current_page;
Skip = (current_page - 1) * default_by_page;
if (update_pager)
{
Pager.CreatePager(Pages, current_page, phPager, "Categories");
}
categories = categories.Skip(Skip).Take(default_by_page).ToList();
return(categories);
}
}
private void HandleUser()
{
using (var db = new MLEEntities())
{
var u = new User()
{
Username = txtUsername.Text,
Password = LoginHelper.SHA256(txtPassword.Text),
FirstName = txtFirstName.Text,
LastName = txtLastName.Text,
E_mail = txtMail.Text,
DateCreated = DateTime.Now,
IsActive = true
};
db.User.Add(u);
db.SaveChanges();
// It's always Client
// Administator can change it in Admin
var ur = new UserRole()
{
UserId = u.Id,
RoleId = 2
};
db.UserRole.Add(ur);
db.SaveChanges();
}
var subject = "MLE registracija";
var body = "<h3>Da bi se prijavili u sustav, administrator mora pregledati Vašu prijavu!</h3>";
LoginHelper.SendMail(txtMail.Text, subject, body);
}
private void Update()
{
using (var db = new MLEEntities())
{
var _dbUser = db.User.Where(u => u.Id == userId).FirstOrDefault();
if (_dbUser != null)
{
db.User.Attach(_dbUser);
_dbUser.FirstName = txtName.Text;
_dbUser.LastName = txtSurname.Text;
_dbUser.E_mail = txtEmail.Text;
_dbUser.Username = txtUsername.Text;
if (txtPassword.Text != "")
_dbUser.Password = LoginHelper.SHA256(txtPassword.Text);
_dbUser.Description = txtDescription.Text;
_dbUser.IsActive = cbIsActive.Checked;
db.SaveChanges();
}
var _userRole = db.UserRole.Where(u => u.UserId == _dbUser.Id).FirstOrDefault();
if (_userRole != null)
{
db.UserRole.Attach(_userRole);
_userRole.RoleId = int.Parse(roleList.SelectedValue);
_userRole.UserId = _dbUser.Id;
db.SaveChanges();
}
}
}
private void ProcessPreMarkedWords(string content, MLEEntities db, int exampleID, int sentenceID, int entityID, List <ExampleCategory> exampleCategory, int?categoryForWords)
{
var doc = new HtmlAgilityPack.HtmlDocument();
doc.LoadHtml(content);
var nodes = doc.DocumentNode.SelectNodes("//span");
if (nodes == null)
{
return;
}
foreach (var node in nodes)
{
var span_class = node.GetClasses().FirstOrDefault();
if (span_class != null)
{
var text = node.InnerText;
var ec = exampleCategory.Select(x => x.Category.Subcategory).ToList();
var cfw = db.Category.Where(x => x.Id == categoryForWords.Value).Select(x => x.Subcategory).ToList();
var subcategory = db.Subcategory.FirstOrDefault(x => x.Name == span_class);
if (subcategory != null)
{
var m = new Marked();
}
}
}
}
private void GetRelatedExamples(int cId)
{
using (var db = new MLEEntities())
{
RelatedExamples = db.Example.Include(x => x.Project).Where(x => x.CategoryId == cId).Select(x => x.Project).Distinct().OrderBy(x => x.DateCreated).ToList();
var ec = db.ExampleCategory.Where(x => x.CategoryId == cId).Select(x => x.Example.Project).OrderBy(x => x.DateCreated).Distinct();
RelatedExamples.AddRange(ec);
}
}
private void ImportData()
{
var d = new DirectoryInfo(Server.MapPath("/DataImport"));
var files = d.GetFiles("*.txt");
foreach (var file in files)
{
var path = Server.MapPath("/DataImport/" + file.Name);
if (File.Exists(path))
{
var reader = File.OpenText(path);
var text = reader.ReadToEnd();
if (text != null)
{
using (var db = new MLEEntities())
{
var fileIsAlreadyInDB = db.Example.Where(x => x.FileName == file.Name || x.Content == text).FirstOrDefault() != null ? true : false;
if (!fileIsAlreadyInDB)
{
var ls = text.Split('.').ToList();
var new_text = "";
for (int i = 1; i <= ls.Count - 1; i++)
{
new_text += "<span ID='" + i + "'>" + ls[i] + ".</span>";
}
var example = new Example
{
FileName = file.Name,
Content = new_text,
Description = "Uploaded data to Database",
DateCreated = DateTime.Now,
StatusId = 3 // U tijeku
};
db.Example.Add(example);
db.SaveChanges();
UploadSuccessful++;
}
else
{
UploadExists++;
}
}
}
else
{
UploadError++;
}
}
else
{
UploadError++;
}
}
}
private void Delete()
{
subcategoryId = int.Parse(Request.QueryString["id"]);
using (var db = new MLEEntities())
{
var sc = db.Subcategory.Where(u => u.Id == subcategoryId).FirstOrDefault();
db.Subcategory.Remove(sc);
db.SaveChanges();
}
}
protected List <Subcategory> GetSubcategories(int?catID)
{
if (catID == null)
{
return(new List <Subcategory>());
}
using (var db = new MLEEntities())
return(db.Subcategory.Where(x => x.CategoryId == catID).ToList());
}
private void ProcessCategory(MLEEntities db, FileHelper.Category forWords, ref int?TypeID, ref int?CategoryID)
{
if (forWords != null)
{
var category_name = forWords.CategoryName;
var type = forWords.Type;
// FIND type
var t = db.Type.FirstOrDefault(x => x.HTML_name == type);
if (t != null)
{
TypeID = t.Id;
}
// CHECK and GET / CREATE Category
var categoryExists = false;
var categories = db.Category.Include(x => x.Subcategory).Where(x => x.Name == category_name).ToList();
foreach (var category in categories)
{
if (category != null)
{
var sub_categories = category.Subcategory.Select(x => x.Name).OrderBy(x => x);
var sub_names = forWords.Subcategories.Select(x => x.Name).OrderBy(x => x);
if (sub_categories.SequenceEqual(sub_names) || (type == "text" && sub_names.Count() == 0))
{
categoryExists = true;
CategoryID = category.Id;
break;
}
}
}
if (CategoryID == null || CategoryID == 0)
{
CreateNewCategory(db, category_name, ref CategoryID);
}
if (!categoryExists)
{
if (forWords.Subcategories.Count > 0)
{
// SAVE subcategories only if category is created
for (int i = 0; i < forWords.Subcategories.Count; i++)
{
CreateNewSubcategory(db, forWords.Subcategories[i], CategoryID, i + 1);
}
}
else
{
CreateNewSubcategory(db, null, CategoryID, 0);
}
}
}
}
protected void btnSendMail_Click(object sender, EventArgs e)
{
using (var db = new MLEEntities())
{
var u = db.User.FirstOrDefault(x => x.E_mail == txtForgotMail.Text);
if (u != null)
{
var f = db.ForgotPassword.FirstOrDefault(x => x.UserId == u.Id);
if (f != null)
{
f.IsValid = false;
db.SaveChanges();
}
var fp = new DB.ForgotPassword()
{
UserId = u.Id,
InsertedEmail = u.E_mail,
DateTime = DateTime.Now,
WrongEmail = false,
GeneratedKey = LoginHelper.SHA256(u.Id + u.E_mail + DateTime.Now.Ticks),
ValidUntil = DateTime.Now.AddDays(1),
IsValid = true,
IsUsed = false
};
db.ForgotPassword.Attach(fp);
db.ForgotPassword.Add(fp);
db.SaveChanges();
var subject = "MLE zaboravljena lozinka";
var body = "Da biste promijenili lozinku, potrebno je kliknuti na sljedeću poveznicu: <a href='http://mle.s15.novenaweb.info/Client/ChangePassword.aspx?key=" + fp.GeneratedKey + "'>http://mle.s15.novenaweb.info/Client/ChangePassword.aspx?key=" + fp.GeneratedKey + "</a>.<br>Poveznica neće biti valjana nakon 24 sata.";
LoginHelper.SendMail(u.E_mail, subject, body);
}
else
{
var fp = new DB.ForgotPassword()
{
InsertedEmail = txtForgotMail.Text,
DateTime = DateTime.Now,
Description = "Inserted mail is not existing in database. Key not generated!",
WrongEmail = true,
IsValid = false,
IsUsed = false
};
db.ForgotPassword.Attach(fp);
db.ForgotPassword.Add(fp);
db.SaveChanges();
}
}
MailSent = true;
txtForgotMail.Text = String.Empty;
}
private void PopulateDropdownList()
{
using (var db = new MLEEntities())
{
ddlCategories.DataSource = db.Category.ToList();
ddlCategories.DataTextField = "Name";
ddlCategories.DataValueField = "Id";
ddlCategories.DataBind();
ddlCategories.SelectedValue = CId.ToString();
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
using (var db = new MLEEntities())
{
if (LoginHelper.LoginChecker(txtUsername.Text, txtPassword.Text))
{
FormsAuthentication.SetAuthCookie(txtUsername.Text, false);
Response.Redirect("/Admin/Modules/Users.aspx");
}
}
}
private void CreateNewCategory(MLEEntities db, string category_name, ref int?CategoryID)
{
var c = new DB.Category();
c.isActive = true;
c.Name = category_name;
c.Description = "Automatic upload (ZIP)";
db.Category.Add(c);
db.SaveChanges();
CategoryID = c.Id;
}
private void GetTypeByID(int id)
{
using (var db = new MLEEntities())
{
var t = db.Type.Where(x => x.Id == id).FirstOrDefault();
if (t != null)
{
txtName.Text = t.Name;
cbActive.Checked = t.Active ?? false;
}
}
}
private void GetCategoryById(int id)
{
using (var db = new MLEEntities())
{
Category _dbCategory = db.Category.Where(c => c.Id == id).FirstOrDefault();
if (_dbCategory != null)
{
txtCategoryName.Text = _dbCategory.Name;
txtDescription.Text = _dbCategory.Description;
cbIsActive.Checked = _dbCategory.isActive.Value;
}
}
}
public static void Finish(string ExampleId)
{
var Int_ExampleId = Convert.ToInt32(ExampleId);
using (var db = new MLEEntities())
{
var e = db.Example.FirstOrDefault(x => x.Id == Int_ExampleId);
if (e != null)
{
e.StatusId = 2;
db.SaveChanges();
}
}
}
public static void SaveEntity(string ExampleId, string Content)
{
var Int_ExampleId = Convert.ToInt32(ExampleId);
using (var db = new MLEEntities())
{
var e = db.Example.FirstOrDefault(x => x.Id == Int_ExampleId);
if (e != null)
{
e.Content = Content;
db.SaveChanges();
}
}
}
