/// <summary> /// The create project. /// </summary> /// <param name="project"> /// The project. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public int CreateProject(NewProject project) { // returns null if ok, 1 if fails, 2 if the project with similar name already exists try { project.ParsedStartDate = DateTime.Parse(project.StartDate); project.ParsedEstFinishDate = DateTime.Parse(project.EstFinishDate); var createcontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); int? id = createcontext.Projects.Count() + 1; IQueryable<Project> projects = from p in createcontext.Projects where p.Allias.Equals(project.Title) select p; if (projects.Count() != 0) { createcontext.Dispose(); return 2; } int newid = createcontext.Projects.Count() + 1; var record = new Project { Allias = project.Title, Comments = project.Comments, EstFinishDate = project.ParsedEstFinishDate, Id = newid, ProjectAdminId = project.Admin, StartDate = project.ParsedStartDate }; createcontext.Projects.InsertOnSubmit(record); createcontext.Projects.Context.SubmitChanges(); createcontext.Dispose(); return 0; } catch (Exception e) { return 1; } }
partial void UpdateProject(Project instance);
partial void DeleteProject(Project instance);
partial void InsertProject(Project instance);