public ActionResult Comment(int id, FormCollection collection) { try { // Admin.Models.Project.Project user = new Admin.Models.Project.Project(); Admin.Models.Project.Project proj = new Admin.Models.Project.Project(); Admin.Models.Project.Project com = new Admin.Models.Project.Project(); var CommentList = new List<Admin.Models.Project.Project>(); proj=model.GetUsernameByMemberID(Int32.Parse(Session["SelectedMemberID"].ToString())); var name =proj.UserName; // model.GetAllComments(id); //user=model.GetUsernameByMemberID(proj.MemberID); // var name=user.UserName; var selectedDiscussionID = Int32.Parse(Session["SelectedDiscussionID"].ToString()); model.CreateComments(selectedDiscussionID, collection.Get("Comments"),name); ViewData["DiscussionID"] = id; Session["SelectedDiscussionID"] = id; com = model.GetCommentIDByDiscussionID(id); Session["SelectedCommentID"] = com.CommentedBy; return View("CommentList"); } catch { return View(); } }
public ActionResult Create(FormCollection collection) { try { Admin.Models.Project.Project proj = new Admin.Models.Project.Project(); var projectList = new List<Admin.Models.Project.Project>(); var mems = collection.Get("members"); // var file = collection.Get(""); model.CreateProject(collection.Get("ProjectTitle"), collection.Get("ProjectDescription"), collection.Get("FirstName"), collection.Get("LastName"), Convert.ToString(mems)); return RedirectToAction("Index"); } catch { return View(); } }
public Project Comments(int did) { Project data = new Project(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select DiscussionID,CommentedBy,Comment from tbl_Comment where DiscussionID=@ID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@ID", did); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { data.DiscussionID = Int32.Parse(sqlConn.Reader["DiscussionID"].ToString()); data.Comments = sqlConn.Reader["Comment"].ToString(); data.CommentedBy = sqlConn.Reader["CommentedBy"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return data; }
//////////////////////// comments here ////////////// //public ActionResult Comment(int id) //{ // ProjectLab.Areas.Admin.Models.Project.Project data = new ProjectLab.Areas.Admin.Models.Project.Project(); // var commList = new List<Admin.Models.Project.Peroject>(); // var disList = new List<Admin.Models.Project.Project>(); // ViewData["DiscussionID"] = Session["SelectedDiscussionID"]; // Session["SelectedDiscussionID"] = id; // return View("CreateComments"); //} public ActionResult ListComment(int id) { Admin.Models.Project.Project data = new Admin.Models.Project.Project(); ViewData["DiscussionID"] = Session["SelectedDiscussionID"]; return View("CommentList"); }
public ActionResult Discussion(int id, FormCollection collection) { try { Admin.Models.Project.Project proj = new Admin.Models.Project.Project(); Admin.Models.Project.Project discuss = new Admin.Models.Project.Project(); var discussList = new List<Admin.Models.Project.Project>(); // var id = collection.Get("ProjectID"); ViewData["ProjectID"] = id; proj = model.GetUsernameByMemberID(Int32.Parse(Session["SelectedMemberID"].ToString())); var mid = proj.UserName; var selectedProjectID = Int32.Parse(Session["SelectedProjectID"].ToString()); model.CreateDiscussion(selectedProjectID, collection.Get("DiscussionTitle"), collection.Get("DiscussionDescription"),mid); discuss = model.GetDiscussionIdByProjectId(id); Session["SelectedDiscussionID"] = discuss.DiscussionID; return View("Listed"); } catch { return View(); } }
/// <summary> /// //////////////////////////////get only comments start here..... /// </summary> /// <param name="did"></param> /// <returns></returns> public List<Project> GetOnlyComments(int did) { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Project comm = new Project(); var commlist = new List<Project>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select DiscussionID,Comment from tbl_Comment where DiscussionID=@id"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@id", did); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { commlist.Add(new Admin.Models.Project.Project { ProjectID = Int32.Parse(sqlConn.Reader["DiscussionID"].ToString()), ProjectTitle = sqlConn.Reader["Comment"].ToString(), CreatedAt=DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()), }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return commlist; }
public Project GetMembersByProjectID(int pid) { Project data = new Project(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select Members from tbl_Projects where ProjectID=@ID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@ID", pid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { // data.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()); data.ProjectMembers = sqlConn.Reader["Members"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return data; }
public Project GetData(int projectID) { Project proj = new Project(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select * from tbl_Projects where ProjectID=@projectID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@projectID", projectID); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { proj.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()); proj.ProjectTitle = sqlConn.Reader["ProjectTitle"].ToString(); proj.ProjectDescription = sqlConn.Reader["ProjectDescription"].ToString(); proj.ProjectMembers = sqlConn.Reader["Members"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return proj; }
public Project GetDiscussionTitleByDiscussionID(int ID) { { Project proj = new Project(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select DiscussionTitle from tbl_discussion where DiscussionID=@disID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@disID", ID); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { // proj.DiscussionID = Int32.Parse(sqlConn.Reader["DiscussionID"].ToString()); proj.DiscussionTitle = sqlConn.Reader["DiscussionTitle"].ToString(); // proj.CreatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return proj; } }
/////////////////////////////////start for the discussion list//////////////// public List<Project> GetAllDiscussion(int pid) { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Project Discuss = new Project(); var discussList = new List<Project>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select * from tbl_discussion where ProjectID=@pid"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@pid", pid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { discussList.Add(new Admin.Models.Project.Project { ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()), // DiscussionID = Int32.Parse(sqlConn.Reader["DiscussionID"].ToString()), DiscussionTitle = sqlConn.Reader["DiscussionTitle"].ToString(), DiscussionDescription = sqlConn.Reader["DiscussionDescription"].ToString(), CreatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()), CreatedBy=sqlConn.Reader["CreatedBy"].ToString(), }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return discussList; }
public List<Project> GetAllProjects() { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Project proj = new Project(); var projectList = new List<Project>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select p.ProjectID,p.ProjectTitle,p.ProjectDescription,p.Members from tbl_Projects as p"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { projectList.Add(new Admin.Models.Project.Project { ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()), ProjectTitle = sqlConn.Reader["ProjectTitle"].ToString(), ProjectDescription = sqlConn.Reader["ProjectDescription"].ToString(), ProjectMembers = sqlConn.Reader["Members"].ToString(), }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return projectList; }
//////////////////////////////////////////for discussion //////////////////////////// public Project Discussion(int pid) { Project data = new Project(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select DiscussionID,DiscussionTitle,DiscussionDescription from tbl_discussion where ProjectID=@ID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@ID", pid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { data.DiscussionID = Int32.Parse(sqlConn.Reader["DiscussionID"].ToString()); data.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()); data.DiscussionTitle = sqlConn.Reader["DiscussionTitle"].ToString(); data.DiscussionDescription = sqlConn.Reader["DiscussionDescription"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return data; }
public Project GetUsernameByMemberID(int memID) { Project proj = new Project(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select MemberID,UserName from tbl_member where MemberID=@ID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@ID",memID); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { proj.MemberID = Int32.Parse(sqlConn.Reader["MemberID"].ToString()); proj.UserName = sqlConn.Reader["UserName"].ToString(); // proj.ProjectDescription = sqlConn.Reader["ProjectDescription"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return proj; }
public List<Project> getProjectmembersfromProjects() { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Project pro = new Project(); var onlymemberlist = new List<Project>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = " select * from tbl_Projects"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { onlymemberlist.Add(new Admin.Models.Project.Project { MemberID = Int32.Parse(sqlConn.Reader["MemberID"].ToString()), ProjectMembers=sqlConn.Reader["Members"].ToString(), FirstName = sqlConn.Reader["FirstName"].ToString(), LastName = sqlConn.Reader["LastName"].ToString() }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return onlymemberlist; }
public Project GetProjectByToDoID(int todoid) { Project data = new Project(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select ProjectID from tbl_ToDo where ToDoID=@ID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@ID", todoid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { data.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()); // data.Comments = sqlConn.Reader["Comment"].ToString(); // data.CommentedBy = Int32.Parse(sqlConn.Reader["CommentedBy"].ToString()); // data.DiscussionDescription = sqlConn.Reader["DiscussionDescription"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return data; }
public List<Project> GetOnlyProjectTitle(int id) { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Project title = new Project(); var titleList = new List<Project>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select ProjectID,ProjectTitle,ProjectDescription,Members from tbl_Projects where ProjectID=@pid"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@pid", id); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { titleList.Add(new Admin.Models.Project.Project { ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()), ProjectTitle = sqlConn.Reader["ProjectTitle"].ToString(), ProjectDescription = sqlConn.Reader["ProjectDescription"].ToString(), ProjectMembers = sqlConn.Reader["Members"].ToString(), }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return titleList; }