public ActionResult ProjDiscLoad(int projId)
{
JsonDataGridResult jsonDataGridResult = new JsonDataGridResult();
try
{
List<Proj_Discussion> list = ProjDiscussionService.GetList(projId);
List<User> listUser = UserService.GetList();
if (list != null && list.Count() > 0)
{
foreach (Proj_Discussion model in list)
{
User user = listUser.Find(item => item.user_Id == model.Proj_Disc_User_Id);
if (user != null)
model.UserName = user.user_Name;
jsonDataGridResult.rows.Add(model);
}
}
}
catch (Exception ex)
{
jsonDataGridResult.result = false;
jsonDataGridResult.message = ex.Message;
}
return Json(jsonDataGridResult, JsonRequestBehavior.AllowGet);
}
public ActionResult TeamList(int? page, int? rows, string status, string sort, string order, string queryWord)
{
#region Get paging condition
Paging paging = new Paging();
paging.SetPageSize(rows.HasValue ? rows.Value : Paging.DEFAULT_PAGE_SIZE); //pageRows;
paging.SetCurrentPage(page.HasValue ? page.Value : 1); //pageNumber;
#endregion
JsonDataGridResult jsonDataGridResult = new JsonDataGridResult();
List<Team> list = null;
try
{
SqlHelper.Initialization();
list = DAL.TeamService.GetList(paging, sort, order, status, queryWord);
if (list != null && list.Count() > 0)
{
foreach (Team idea in list)
{
jsonDataGridResult.rows.Add(idea);
}
jsonDataGridResult.total = paging.GetRecordCount();
}
}
catch (Exception ex)
{
jsonDataGridResult.result = false;
jsonDataGridResult.message = ex.Message;
}
return Json(jsonDataGridResult, JsonRequestBehavior.AllowGet);
}
public ContentResult UserChangePassWordSave(User userModel)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
string userName = User.Identity.Name.Split(',')[1];
int userId = Convert.ToInt32(User.Identity.Name.Split(',')[0]);
User user = UserService.GetModel(userId);
if (SqlHelper.Fun_Secret(userModel.user_Password_Model) == user.user_Password)
{
user.user_Password = SqlHelper.Fun_Secret(userModel.user_Password);
user.user_Update_Time = DateTime.Now;
UserService.Update(user);
jsonResult.result = true;
jsonResult.message = "";
}
else
{
jsonResult.result = false;
jsonResult.message = "The Old Password is not match!";
}
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ActionResult NewsDelete(int? news_Id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
if (news_Id.HasValue)
{
News model = NewsService.GetModel(news_Id.Value);
NewsService.Delete(model);
jsonResult.result = true;
jsonResult.message = "";
}
else
{
jsonResult.result = false;
jsonResult.message = "Id is null！";
}
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
return Json(jsonResult, JsonRequestBehavior.AllowGet);
}
public ActionResult UserApprove(string idList)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
if (!string.IsNullOrEmpty(idList))
{
List<User> list = UserService.GetList(idList);
if (list != null && list.Count() > 0)
{
foreach (User user in list)
{
user.user_Statue = true;
}
UserService.UpdateList(list);
jsonResult.result = true;
jsonResult.message = "";
}
}
else
{
jsonResult.message = "IdList is null！";
}
}
catch (Exception ex)
{
jsonResult.message = ex.Message;
}
return Json(jsonResult, JsonRequestBehavior.AllowGet);
}
public ContentResult IdeaCommSave(Idea_Comment model, int ideaId)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
//using()
//{
Idea_Comment ideaComm = new Idea_Comment();
ideaComm.Idea_Comm_Idea_Id = ideaId;
ideaComm.Idea_Comm_Content = model.Idea_Comm_Content;
ideaComm.Idea_Comm_Time = DateTime.Now;
IdeaCommService.Save(ideaComm);
Idea idea = IdeaService.GetModel(ideaId);
idea.Idea_Status = 2;
IdeaService.Update(idea);
jsonResult.result = true;
jsonResult.message = "";
//}
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ActionResult IdeaCommLoad(int ideaId)
{
JsonDataGridResult jsonDataGridResult = new JsonDataGridResult();
try
{
List<Idea_Comment> list = IdeaCommService.GetList(ideaId);
if (list != null && list.Count() > 0)
{
foreach (Idea_Comment model in list)
{
jsonDataGridResult.rows.Add(model);
}
}
}
catch (Exception ex)
{
jsonDataGridResult.result = false;
jsonDataGridResult.message = ex.Message;
}
return Json(jsonDataGridResult, JsonRequestBehavior.AllowGet);
}
public ContentResult ProjDiscSave(Proj_Discussion model, int projId)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
Proj_Discussion projDisc = new Proj_Discussion();
projDisc.Proj_Disc_Proj_Id = projId;
projDisc.Proj_Disc_Content = model.Proj_Disc_Content;
projDisc.Proj_Disc_Time = DateTime.Now;
projDisc.Proj_Disc_User_Id =Convert.ToInt32(User.Identity.Name.Split(',')[0]);
ProjDiscussionService.Save(projDisc);
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ActionResult GetNewsList()
{
JsonDataGridResult jsonDataGridResult = new JsonDataGridResult();
List<News> list = null;
try
{
SqlHelper.Initialization();
list = DAL.NewsService.GetList("select top(5) * from PSS_News order by news_Id desc");//desc
if (list != null && list.Count() > 0)
{
foreach (News model in list)
{
jsonDataGridResult.rows.Add(model);
}
}
}
catch (Exception ex)
{
throw ex;
}
return Json(jsonDataGridResult, JsonRequestBehavior.AllowGet);
}
public ActionResult TeamDelete(int? id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
if (id.HasValue)
{
Team model = TeamService.GetModel(id.Value);
TeamService.Delete(model);
jsonResult.result = true;
jsonResult.message = "";
}
else
{
jsonResult.message = "Id is null！";
}
}
catch (Exception ex)
{
jsonResult.message = ex.Message;
}
return Json(jsonResult, JsonRequestBehavior.AllowGet);
}
public ContentResult TeamSave(Team model, int? id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
Team team = null;
if (id.HasValue)
{
team = TeamService.GetModel(id.Value);
}
else
{
team = new Team();
}
team.Team_User_Id = model.Team_User_Id;
team.Team_Proj_Id = model.Team_Proj_Id;
team.Team_Title = model.Team_Title;
team.Team_Status = 0;
team.Team_Update_Time = DateTime.Now;
if (id.HasValue)
{
TeamService.Update(team);
}
else
{
TeamService.Save(team);
}
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult UserSave(User userModel, int?id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
User user = null;
if (id.HasValue)
{
user = UserService.GetModel(id.Value);
}
else if(UserService.IsExistName(userModel.user_Name,userModel.user_Trimester_Id))
{
jsonResult.result = false;
jsonResult.message = "There is already exist the name, please change a userName!";
return Content(JsonConvert.SerializeObject(jsonResult));
}
else
{
user = new User();
user.user_Register_Time = DateTime.Now;
user.user_Log_Time = DateTime.Now;
}
user.user_Name = userModel.user_Name;
user.user_Password =SqlHelper.Fun_Secret(userModel.user_Password);
user.user_Email = userModel.user_Email;
user.user_Telephone = userModel.user_Telephone;
//user.user_Is_Teacher = userModel.user_Is_Teacher;
user.user_Skill = userModel.user_Skill;
user.user_Introduction = userModel.user_Introduction;
user.user_Update_Time = DateTime.Now;
user.user_Trimester_Id = userModel.user_Trimester_Id;
user.user_Statue = true;
if (id.HasValue)
{
UserService.Update(user);
}
else
{
UserService.Save(user);
}
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult UserPersonalProfileSave(User userModel)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
string userName = User.Identity.Name.Split(',')[1];
int userId = Convert.ToInt32(User.Identity.Name.Split(',')[0]);
User user = UserService.GetModel(userId);
user.user_Email = userModel.user_Email;
user.user_Telephone = userModel.user_Telephone;
user.user_Skill = userModel.user_Skill;
user.user_Introduction = base.Server.UrlDecode(userModel.user_Introduction);
user.user_Update_Time = DateTime.Now;
user.user_Trimester_Id = userModel.user_Trimester_Id;
user.User_Email_Visiable = userModel.User_Email_Visiable;
user.User_Telephone_Visiable = userModel.User_Telephone_Visiable;
user.user_Update_Time = DateTime.Now;
UserService.Update(user);
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult IdeaSave(Idea model, int? id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
Idea idea = null;
if (id.HasValue)
{
idea = IdeaService.GetModel(id.Value);
}
else
{
idea = new Idea();
idea.Idea_Presenter = User.Identity.Name.Split(',')[1];
}
idea.Idea_Title = model.Idea_Title;
idea.Idea_Staff_Contact = model.Idea_Staff_Contact;
idea.Idea_Client_Contact = model.Idea_Client_Contact;
idea.Idea_Client_Company = model.Idea_Client_Company;
idea.Idea_Valid_Dates = model.Idea_Valid_Dates;
idea.Idea_Students_Num = model.Idea_Students_Num;
idea.Idea_Continuation = model.Idea_Continuation;
idea.Idea_Description = model.Idea_Description;
idea.Idea_Skills_Required = model.Idea_Skills_Required;
idea.Idea_Context = model.Idea_Context;
idea.Idea_Goals = model.Idea_Goals;
idea.Idea_Features = model.Idea_Features;
idea.Idea_Challenges = model.Idea_Challenges;
idea.Idea_Opportunities = model.Idea_Opportunities;
idea.Idea_Trimester_Id = model.Idea_Trimester_Id;
idea.Idea_Update_Time = DateTime.Now;
idea.Idea_Advisor_Contact = model.Idea_Advisor_Contact;
idea.Idea_Status = model.Idea_Status;
if (id.HasValue)
{
IdeaService.Update(idea);
}
else
{
IdeaService.Save(idea);
}
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult ProjectImport(int trimesterId,string idList)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
List<Project> listOld = ProjectService.GetList(idList);
List<Project> listNew = new List<Project>();
foreach (Project model in listOld)
{
model.Proj_Trimester_Id = trimesterId;
listNew.Add(model);
}
if (listNew != null && listNew.Count() > 0)
{
ProjectService.SaveList(listNew);
jsonResult.result = true;
jsonResult.message = "";
}
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult TrimesterSave(Trimester model, int? id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
Trimester trimester = null;
if (id.HasValue)
{
trimester = TrimesterService.GetModel(id.Value);
}
else
{
trimester = new Trimester();
}
trimester.tri_Name = model.tri_Name;
trimester.tri_IsOpen = model.tri_IsOpen;
trimester.tri_StartDate = model.tri_StartDate;
trimester.tri_EndDate = model.tri_EndDate;
if (id.HasValue)
{
TrimesterService.Update(trimester);
}
else
{
TrimesterService.Save(trimester);
}
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult NewsSave(News model, int? id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
News news = null;
if (id.HasValue)
{
news = NewsService.GetModel(id.Value);
}
else
{
news = new News();
}
news.news_Title = model.news_Title;
news.news_Content = base.Server.UrlDecode(model.news_Content);
news.news_Update_Time = DateTime.Now;
if (id.HasValue)
{
NewsService.Update(news);
}
else
{
NewsService.Save(news);
}
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult IdeaDiscSave(Idea_Discussion model, int ideaId)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
Idea_Discussion ideaDisc = new Idea_Discussion();
ideaDisc.Idea_Disc_Idea_Id = ideaId;
ideaDisc.Idea_Disc_Content = model.Idea_Disc_Content;
ideaDisc.Idea_Disc_Time = DateTime.Now;
ideaDisc.Idea_Disc_User_Id = Convert.ToInt32(User.Identity.Name.Split(',')[0]);
IdeaDiscussionService.Save(ideaDisc);
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult ProjectSave(Project model, int? id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
Project project = null;
if (id.HasValue)
{
project = ProjectService.GetModel(id.Value);
}
else
{
project = new Project();
project.Proj_Presenter = User.Identity.Name.Split(',')[1];
}
project.Proj_Title = model.Proj_Title;
project.Proj_Staff_Contact = model.Proj_Staff_Contact;
project.Proj_Client_Contact = model.Proj_Client_Contact;
project.Proj_Client_Company = model.Proj_Client_Company;
project.Proj_Valid_Dates = model.Proj_Valid_Dates;
project.Proj_Students_Num = model.Proj_Students_Num;
project.Proj_Continuation = model.Proj_Continuation;
project.Proj_Description = model.Proj_Description;
project.Proj_Skills_Required = model.Proj_Skills_Required;
project.Proj_Context = model.Proj_Context;
project.Proj_Goals = model.Proj_Goals;
project.Proj_Features = model.Proj_Features;
project.Proj_Challenges = model.Proj_Challenges;
project.Proj_Opportunities = model.Proj_Opportunities;
project.Proj_Trimester_Id = model.Proj_Trimester_Id;
project.Proj_Update_Time = DateTime.Now;
if (id.HasValue)
{
ProjectService.Update(project);
}
else
{
ProjectService.Save(project);
}
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}