/// <summary>
/// The modify user.
/// </summary>
/// <param name="user">
/// The user.
/// </param>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
public bool ModifyUser(NewUser user)
{
try
{
var modifycontext =
new ScrumNotesDbClassDataContext(
ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString());
User userrecord = (from u in modifycontext.Users where u.Id.Equals(user.id) select u).Single();
userrecord.Allias = user.Name;
userrecord.ADUserName = user.ADname;
userrecord.Comments = user.Comments;
userrecord.Email = user.Email;
userrecord.ScrumAdmin = user.IsSCRUMadmin ?? false;
modifycontext.SubmitChanges();
modifycontext.Dispose();
return true;
}
catch (Exception e)
{
return false;
}
}
/// <summary>
/// The delete user.
/// </summary>
/// <param name="userId">
/// The user id.
/// </param>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
public bool DeleteUser(int userId)
{
try
{
var deletecontext =
new ScrumNotesDbClassDataContext(
ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString());
User user = (from u in deletecontext.Users where u.Id.Equals(userId) select u).FirstOrDefault();
deletecontext.Users.DeleteOnSubmit(user);
deletecontext.SubmitChanges();
deletecontext.Dispose();
return true;
}
catch (Exception e)
{
return false;
}
}
/// <summary>
/// The modify project.
/// </summary>
/// <param name="project">
/// The project.
/// </param>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
public bool ModifyProject(NewProject project)
{
try
{
int id = project.id;
var updatecontext =
new ScrumNotesDbClassDataContext(
ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString());
Project projectrecord = (from p in updatecontext.Projects where p.Id.Equals(id) select p).Single();
project.ParsedStartDate = DateTime.Parse(project.StartDate);
project.ParsedEstFinishDate = DateTime.Parse(project.EstFinishDate);
projectrecord.Allias = project.Title;
projectrecord.Comments = project.Comments;
projectrecord.EstFinishDate = project.ParsedEstFinishDate;
projectrecord.ProjectAdminId = project.Admin;
projectrecord.StartDate = project.ParsedStartDate;
updatecontext.SubmitChanges();
updatecontext.Dispose();
return true;
}
catch (Exception e)
{
return false;
}
}
/// <summary>
/// The delete project.
/// </summary>
/// <param name="projectId">
/// The project id.
/// </param>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
public bool DeleteProject(int projectId)
{
try
{
var deletecontext =
new ScrumNotesDbClassDataContext(
ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString());
Project project =
(from p in deletecontext.Projects where p.Id.Equals(projectId) select p).FirstOrDefault();
deletecontext.Projects.DeleteOnSubmit(project);
deletecontext.SubmitChanges();
deletecontext.Dispose();
return true;
}
catch (Exception e)
{
return false;
}
}
