public int createProject(ProjectMetadata objProject) { try { Project objProjectEnt = new Project(); int result = 0; using (GDEntities db = new GDEntities()) { objProjectEnt = ConvertM(objProject); using (var context = db.Database.BeginTransaction()) { db.Project.Add(objProjectEnt); db.SaveChanges(); context.Commit(); result = objProjectEnt.IdProject; } } return 1; } catch (Exception) { throw; } }
public List<Project> getListProject(int page, int pageSize, string sort, string sortdir, ProjectMetadata ObjectProject) { using (GDEntities db = new GDEntities()) { var listProject = (from p in db.Project where (p.IdProject > 0 ? p.IdProject == ObjectProject.IdProject :p.IdProject> 0) && (p.NameProject == null ? p.NameProject == ObjectProject.NameProject: p.NameProject == null) select p).ToList(); int totalRows = listProject.Count(); if (totalRows > 0) { listProject = listProject.OrderBy(sort + " " + sortdir).Skip(page).Take(pageSize).ToList(); } return listProject; } }