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