protected void Button1_Click(object sender, EventArgs e) { int userId = Convert.ToInt32(Session["UserLogin"]); int ProjectId = Convert.ToInt32(DropDownList1.SelectedValue); using (PMTDBContext context = new PMTDBContext()) { Task task = new Task(); task.TaskDescription = TextBox1.Text.ToString(); task.DueDate = Convert.ToDateTime(DropDownList3.SelectedValue); task.Priority = DropDownList4.SelectedItem.Text.ToString(); task.TaskAssignedTo = DropDownList2.SelectedItem.Text.ToString(); task.ProjectID = Convert.ToInt32(DropDownList1.SelectedValue); User user = context.Users.FirstOrDefault(a => a.UserID == userId); task.TaskAssignedBy = user.UserName.ToString(); context.Tasks.Add(task); context.SaveChanges(); Project project = context.Projects.SingleOrDefault(a => a.ProjectID == ProjectId); project.NumOfTask += 1; context.SaveChanges(); } Response.Redirect("~/ProjectDetails.aspx?ProjectID=" + DropDownList1.SelectedValue.ToString()); }
protected void Button1_Click(object sender, EventArgs e) { if (!String.IsNullOrWhiteSpace(TextBoxName.Text) && !String.IsNullOrWhiteSpace(TextBoxEmail.Text) && !String.IsNullOrWhiteSpace(TextBoxPassword.Text) && RadioButtonList1.SelectedItem != null && ListBox1.SelectedValue != null) { using (PMTDBContext context = new PMTDBContext()) { User user = new User(); user.UserName = TextBoxName.Text.ToString(); user.Email = TextBoxEmail.Text.ToString(); user.Password = TextBoxPassword.Text.ToString(); user.Status = RadioButtonList1.SelectedItem.ToString(); user.DesignationID = Convert.ToInt32(ListBox1.SelectedValue); context.Users.Add(user); context.SaveChanges(); } Response.Redirect("/AddUser.aspx"); } else { Label6.Text = "Fill All Info"; //Response.Write("Fill All Info"); } this.loadUser(); }
protected void Button1_Click(object sender, EventArgs e) { if (Convert.ToInt32(DropDownList1.SelectedValue) > 0 && Convert.ToInt32(DropDownList2.SelectedValue) > 0) { int ProjectId = Convert.ToInt32(DropDownList1.SelectedValue); using (PMTDBContext context = new PMTDBContext()) { UsersUnderProject usersUnderProject = new UsersUnderProject(); usersUnderProject.ProjectID = Convert.ToInt32(DropDownList1.SelectedValue); usersUnderProject.UserID = Convert.ToInt32(DropDownList2.SelectedValue); context.UsersUnderProjects.Add(usersUnderProject); context.SaveChanges(); Project project = context.Projects.SingleOrDefault(a => a.ProjectID == ProjectId); project.NumOfMember += 1; context.SaveChanges(); } Response.Redirect("/AssignResourcePerson.aspx"); } else { Response.Write("Please Select Project and User"); } this.loadDropdowns(); this.loadData(); }
protected void Button1_Click(object sender, EventArgs e) { using (PMTDBContext context = new PMTDBContext()) { if (context.Users.Where(a => a.Email == TextBox1.Text.ToString()).Where(a => a.Password == TextBox2.Text.ToString()).Count() == 1) { User user = context.Users.FirstOrDefault(a => a.Email == TextBox1.Text.ToString() && a.Password == TextBox2.Text.ToString()); if (user.DesignationID == 1) { Session["UserLogin"] = user.UserID; Session["Designation"] = user.DesignationID; Session["UserName"] = user.UserName + " " + user.Designation.DesignationName; Response.Redirect("/AddUser.aspx", false); } else if (user.DesignationID == 2) { Session["UserLogin"] = user.UserID; Session["Designation"] = user.DesignationID; Session["UserName"] = user.UserName + " " + user.Designation.DesignationName; Response.Redirect("/ViewMyProjects.aspx", false); } else if (user.DesignationID != 1) { Session["UserLogin"] = user.UserID; Session["Designation"] = user.DesignationID; Session["UserName"] = user.UserName + " " + user.Designation.DesignationName; Response.Redirect("/ViewMyProjects.aspx", false); } } else { Response.Write("Wrong Email or Password"); } } }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { var Id = Convert.ToInt32(DropDownList1.SelectedValue); DropDownList2.Items.Clear(); DropDownList3.Items.Clear(); using (PMTDBContext context = new PMTDBContext()) { List <UsersUnderProject> usersUnderProject = context.UsersUnderProjects.Where(a => a.ProjectID == Id).ToList(); List <User> user = new List <User>(); foreach (var item in usersUnderProject) { User addUser = context.Users.FirstOrDefault(a => a.UserID == item.UserID); user.Add(addUser); } this.loadUserDropdown(user.ToList()); } using (PMTDBContext context = new PMTDBContext()) { Project project = context.Projects.FirstOrDefault(a => a.ProjectID == Id); int days = Convert.ToInt32((Convert.ToDateTime(project.EndDate) - Convert.ToDateTime(project.StartDate)).TotalDays); DateTime date = Convert.ToDateTime(project.StartDate); for (int i = 0; i < days; i++) { var newItem = new ListItem(); date = date.AddDays(1); newItem.Text = date.ToShortDateString(); newItem.Value = date.ToShortDateString(); DropDownList3.Items.Add(newItem); } } }
protected void Button1_Click(object sender, EventArgs e) { using (PMTDBContext context = new PMTDBContext()) { GridView1.DataSource = context.Projects.Where(a => a.EndDate > DateTime.Now).Select(a => new { a.ProjectName, a.CodeName, a.StartDate, a.EndDate, a.Status }).ToList(); GridView1.DataBind(); } }
private void loadUser(int id) { using (PMTDBContext context = new PMTDBContext()) { User user = context.Users.FirstOrDefault(a => a.UserID == id); TextBoxEmail.Text = user.Email.ToString(); TextBoxName.Text = user.UserName.ToString(); } }
private void loadDesignations() { using (PMTDBContext context = new PMTDBContext()) { IEnumerable <Designation> designation = context.Designations.ToList(); foreach (var item in designation) { var newItem = new ListItem(); newItem.Value = item.DesignationID.ToString(); newItem.Text = item.DesignationName.ToString(); ListBox1.Items.Add(newItem); } } }
protected void Button1_Click1(object sender, EventArgs e) { using (PMTDBContext context = new PMTDBContext()) { Comment comment = new Comment(); comment.Comment1 = TextBox1.Text.ToString(); comment.CommentDate = DateTime.Now; comment.TaskID = Convert.ToInt32(DropDownList2.SelectedValue); comment.UserID = Convert.ToInt32(Session["UserLogin"]); context.Comments.Add(comment); context.SaveChanges(); } Response.Redirect("~/ViewComment.aspx?TaskID=" + DropDownList2.SelectedValue.ToString()); }
private void loadProjectDropdowns() { using (PMTDBContext context = new PMTDBContext()) { IEnumerable <Project> project = context.Projects.ToList(); foreach (var item in project) { var newItem = new ListItem(); newItem.Value = item.ProjectID.ToString(); newItem.Text = item.ProjectName.ToString(); DropDownList1.Items.Add(newItem); } } }
protected void TextBoxEmail_TextChanged(object sender, EventArgs e) { ListBox1.Items.Clear(); using (PMTDBContext context = new PMTDBContext()) { if (context.Users.Where(a => a.Email == TextBoxEmail.Text).Count() > 0) { Label6.Text = "Email already Exists"; } else { TextBoxPassword.Text = TextBoxEmail.Text.ToString() + 123; this.loadDesignations(); } } }
protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e) { var Id = Convert.ToInt32(DropDownList1.SelectedValue); DropDownList2.Items.Clear(); using (PMTDBContext context = new PMTDBContext()) { List <Task> task = context.Tasks.Where(a => a.ProjectID == Id).ToList(); foreach (var item in task) { var newItem = new ListItem(); newItem.Value = item.TaskID.ToString(); newItem.Text = item.TaskDescription.ToString(); DropDownList2.Items.Add(newItem); } } }
protected void Page_Load(object sender, EventArgs e) { int userId = Convert.ToInt32(Session["UserLogin"]); using (PMTDBContext context = new PMTDBContext()) { IEnumerable <UsersUnderProject> usersUnderProject = context.UsersUnderProjects.Where(a => a.UserID == userId).ToList(); List <Project> project = new List <Project>(); foreach (var item in usersUnderProject) { Project projectData = context.Projects.FirstOrDefault(a => a.ProjectID == item.ProjectID); project.Add(projectData); } GridView1.DataSource = project.Select(a => new { a.ProjectName, a.Description, a.StartDate, a.EndDate, a.Status, a.NumOfMember, a.NumOfTask, a.ProjectID }).ToList(); GridView1.DataBind(); } }
private void loadData() { using (PMTDBContext context = new PMTDBContext()) { IEnumerable <UsersUnderProject> usersUnderProject = context.UsersUnderProjects.ToList(); List <Join_User_Project_UserUnderProject> joinData = new List <Join_User_Project_UserUnderProject>(); foreach (var item in usersUnderProject) { Join_User_Project_UserUnderProject addData = new Join_User_Project_UserUnderProject() { //AssignedID = item.AssignedID, ProjectName = item.Project.ProjectName, UserName = item.User.UserName, DesignationName = item.User.Designation.DesignationName }; joinData.Add(addData); } GridView1.DataSource = joinData.ToList(); GridView1.DataBind(); } }
protected void Button2_Click(object sender, EventArgs e) { using (PMTDBContext context = new PMTDBContext()) { IEnumerable <UsersUnderProject> usersUnderProject = context.UsersUnderProjects.ToList(); List <Join_User_Project_UserUnderProject> joinData = new List <Join_User_Project_UserUnderProject>(); foreach (var item in usersUnderProject) { Join_User_Project_UserUnderProject addData = new Join_User_Project_UserUnderProject() { //AssignedID = item.AssignedID, ProjectName = item.Project.ProjectName, UserName = item.User.UserName, DesignationName = item.User.Designation.DesignationName }; joinData.Add(addData); } GridView1.DataSource = joinData.OrderBy(a => a.ProjectName).ToList(); GridView1.DataBind(); } }
protected void Button1_Click1(object sender, EventArgs e) { var value = Convert.ToInt32(Request.QueryString["UserID"]); if (value > 0 || Request.QueryString["UserID"] != null) { if (RadioButtonList1.SelectedItem != null && ListBox1.SelectedValue != null) { if (!String.IsNullOrWhiteSpace(TextBoxName.Text.ToString()) && !String.IsNullOrWhiteSpace(TextBoxEmail.Text.ToString())) { using (PMTDBContext context = new PMTDBContext()) { User user = context.Users.FirstOrDefault(a => a.UserID == value); if (user != null) { user.UserName = TextBoxName.Text.ToString(); user.Email = TextBoxEmail.Text.ToString(); user.Password = TextBoxEmail.Text.ToString() + "123"; user.Status = RadioButtonList1.SelectedItem.ToString(); user.DesignationID = Convert.ToInt32(ListBox1.SelectedValue); context.SaveChanges(); Response.Redirect("/AddUser.aspx"); } } } else { Label6.Text = "No field can be empty"; } } else { Label6.Text = "Select Status and Designation"; } } else { Response.Write("URL error"); } }
protected void Button1_Click(object sender, EventArgs e) { HttpPostedFile postedFile = FileUpload1.PostedFile; string fileName = Path.GetFileName(postedFile.FileName); int fileSize = postedFile.ContentLength; string filepath = Server.MapPath("~/uploads"); if (FileUpload1.HasFile) { if (fileSize < 4000000) { FileUpload1.SaveAs(filepath + "\\" + DateTime.Now.ToFileTime() + " " + FileUpload1.FileName); using (PMTDBContext context = new PMTDBContext()) { Project project = new Project(); project.ProjectName = ProjectName.Text.ToString(); project.CodeName = CodeName.Text.ToString(); project.Description = Description.Text.ToString(); project.StartDate = Convert.ToDateTime(StartDate.Text); project.EndDate = Convert.ToDateTime(EndDate.Text); project.Status = RadioButtonList1.SelectedValue.ToString(); project.FileName = DateTime.Now.ToFileTime() + " " + FileUpload1.FileName.ToString(); project.NumOfMember = 0; project.NumOfTask = 0; context.Projects.Add(project); context.SaveChanges(); } Response.Redirect("~/AddProject.aspx"); } else { Label9.Text = "File size is too large"; } } else { Label9.Text = "No file selected"; } }
private void loadUser() { using (PMTDBContext context = new PMTDBContext()) { IEnumerable <User> user = context.Users.ToList(); List <Join_Users_Designations> joinData = new List <Join_Users_Designations>(); foreach (var item in user) { Join_Users_Designations addData = new Join_Users_Designations() { UserID = item.UserID, UserName = item.UserName, Email = item.Email, Status = item.Status, DesignationName = item.Designation.DesignationName }; joinData.Add(addData); } GridView1.DataSource = joinData.ToList(); GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { var value = Convert.ToInt32(Request.QueryString["ProjectID"]); if (value > 0 || Request.QueryString["ProjectID"] != null) { using (PMTDBContext context = new PMTDBContext()) { Project project = context.Projects.FirstOrDefault(a => a.ProjectID == value); ProjectName.Text = project.ProjectName; CodeName.Text = project.CodeName; Description.Text = project.Description; Status.Text = project.Status; StartDate.Text = project.StartDate.ToString(); EndDate.Text = project.EndDate.ToString(); Duration.Text = Convert.ToString((Convert.ToDateTime(project.EndDate) - Convert.ToDateTime(project.StartDate)).TotalDays); ListBox1.Items.Add(project.FileName); List <UsersUnderProject> usersUnderProject = context.UsersUnderProjects.Where(a => a.ProjectID == value).ToList(); List <User> user = new List <User>(); foreach (var item in usersUnderProject) { User addUser = context.Users.FirstOrDefault(a => a.UserID == item.UserID); user.Add(addUser); } GridView1.DataSource = user.Select(a => new { a.UserName, a.Designation.DesignationName }).ToList(); GridView1.DataBind(); GridView2.DataSource = context.Tasks.Where(a => a.ProjectID == value).Select(a => new { a.TaskDescription, a.TaskAssignedTo, a.Priority, a.TaskAssignedBy, a.DueDate, a.TaskID }).ToList(); GridView2.DataBind(); Label10.Text = "Task List (Total:" + context.Tasks.Where(a => a.ProjectID == value).Count() + ")"; //context.Tasks.Where(a => a.ProjectID == value).Count(); } } else { Response.Write("URL Error"); } }
private void loadDropdowns() { using (PMTDBContext context = new PMTDBContext()) { IEnumerable <Project> project = context.Projects.ToList(); foreach (var item in project) { var newItem = new ListItem(); newItem.Value = item.ProjectID.ToString(); newItem.Text = item.ProjectName.ToString(); DropDownList1.Items.Add(newItem); } IEnumerable <User> user = context.Users.Where(a => a.DesignationID != 1).ToList(); foreach (var item in user) { var newItem = new ListItem(); newItem.Value = item.UserID.ToString(); newItem.Text = item.UserName.ToString() + " " + item.Designation.DesignationName.ToString(); DropDownList2.Items.Add(newItem); } } }
protected void Page_Load(object sender, EventArgs e) { var value = Convert.ToInt32(Request.QueryString["TaskID"]); if (value > 0 || Request.QueryString["TaskID"] != null) { using (PMTDBContext context = new PMTDBContext()) { Task task = context.Tasks.FirstOrDefault(a => a.TaskID == value); Task.Text = task.TaskDescription.ToString(); ProjectName.Text = task.Project.ProjectName.ToString(); } using (PMTDBContext context = new PMTDBContext()) { GridView1.DataSource = context.Comments.Where(a => a.TaskID == value).Select(a => new { a.Comment1, a.CommentDate }).ToList(); GridView1.DataBind(); Label3.Text = "Comments (Total: " + context.Comments.Where(a => a.TaskID == value).Count() + ")"; } } else { Response.Write("URL ERROR"); } }