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