public static List<Model.DepartmentModel> BindDepartmentName() { using (DataAccess.TeamDBEntities context = new DataAccess.TeamDBEntities()) { var listOfItem = context.Departments.Select(d => new DepartmentModel { Name = d.Name, Code = d.Code }).ToList(); return listOfItem; } }
public static void Add(Model.ProjectModal project) { using (DataAccess.TeamDBEntities context = new DataAccess.TeamDBEntities()) { Mapper.CreateMap<Model.ProjectModal, Project>(); Project projectAdd = Mapper.Map<Project>(project); context.Projects.Add(projectAdd); context.SaveChanges(); } }
public static void Delete(int id) { using (DataAccess.TeamDBEntities context = new DataAccess.TeamDBEntities()) { var project = (from p in context.Projects where p.ID == id select p).FirstOrDefault(); context.Projects.Attach(project); context.Projects.Remove(project); context.SaveChanges(); } }
public static List<Model.ProjectModal> ListOfProject() { using (DataAccess.TeamDBEntities context = new DataAccess.TeamDBEntities()) { var listItem = (from p in context.Projects select p).ToList(); Mapper.CreateMap<Project, Model.ProjectModal>(); List<Model.ProjectModal> item = Mapper.Map<List<ProjectModal>>(listItem); return item; } }
public static void Update(Model.ProjectModal project) { using (DataAccess.TeamDBEntities context = new DataAccess.TeamDBEntities()) { Project item = (from p in context.Projects where p.ID == project.ID select p).FirstOrDefault(); Mapper.CreateMap<Model.ProjectModal, Project>(); Mapper.Map(project, item); context.SaveChanges(); } }
public static Model.ProjectModal Edit(int id) { using (DataAccess.TeamDBEntities context = new DataAccess.TeamDBEntities()) { var detail = (from d in context.Projects where d.ID == id select d).ToList(); Mapper.CreateMap<Project, Model.ProjectModal>(); ProjectModal projectDetail = Mapper.Map<Project, ProjectModal>(detail.FirstOrDefault()); return projectDetail; } }
public static List<Model.ProjectModal> Search(string name, string location) { List<Model.ProjectModal> queryData = ListOfProject(); using (DataAccess.TeamDBEntities context = new DataAccess.TeamDBEntities()) { if (!string.IsNullOrEmpty(name)) { queryData = queryData.Where(p => p.Name.Contains(name)).ToList(); } if (!string.IsNullOrEmpty(location)) { queryData = queryData.Where(l => l.Location.Contains(location)).ToList(); } } return queryData; }