public EntityProject GetProjectById(int IdProject) { List <EntityAparment> _apartments = new List <EntityAparment>(); ApartmentRepository _apartmentRepository = new ApartmentRepository(); var returnEntity = new EntityProject(); try { _apartments = _apartmentRepository.GetAparmentsByProject(IdProject); using (var db = GetSqlConnection()) { var p = new DynamicParameters(); p.Add(name: "@IDPROYECTO", value: IdProject, dbType: DbType.Int32, direction: ParameterDirection.Input); const string sql = @"usp_ObtenerProyectos_By_Id"; returnEntity = db.Query <EntityProject>(sql, p, commandType: CommandType.StoredProcedure).FirstOrDefault(); } if (returnEntity != null) { returnEntity.apartments = _apartments; } } catch (Exception ex) { throw new Exception(ex.Message); } return(returnEntity); }
public void AddProject(EntityProject project) { using (MyContext db = new MyContext()) { db.Projects.Add(project); db.SaveChanges(); } }
public HttpResponseMessage POST([FromBody] EntityProject project) { try { obj.AddProject(project); var message = Request.CreateResponse(HttpStatusCode.Created, project); message.Headers.Location = new Uri(Request.RequestUri + project.projectId.ToString()); return(message); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public void AddProject() { EntityProject entProject = new EntityProject(); EntityUser entUser = new EntityUser(); entProject.projectId = 1; entProject.projectName = "Cards and Payment"; entProject.startDate = DateTime.Now; entProject.endDate = DateTime.Now; entProject.priority = 1; entProject.isCompleted = false; entProject.numberofTasks = 2; entProject.completedTasks = 1; entProject.manager = entUser; BLProjectManager.AddProject(entProject); NUnit.Framework.Assert.AreEqual(entProject.projectId, 1); NUnit.Framework.Assert.IsNotNull(entUser); }
public void UpdateTask() { EntityTask entTask = new EntityTask(); EntityUser entUser = new EntityUser(); EntityProject entProject = new EntityProject(); EntityParentTask entParentTask = new EntityParentTask(); entTask.taskId = 1; entTask.task = "Updated Task"; entTask.startDate = DateTime.Now; entTask.endDate = DateTime.Now; entTask.priority = 1; entTask.isCompleted = false; entTask.user = entUser; entTask.project = entProject; entTask.parentTask = entParentTask; BLProjectManager.UpdateTask(entTask, 1); NUnit.Framework.Assert.IsNotEmpty("1"); NUnit.Framework.Assert.IsNotNull("1"); }
public BaseResponse GetProject(int id) { var returnEntity = new BaseResponse(); var entityProject = new EntityProject(); try { using (var db = GetSqlConnection()) { const string sql = @"usp_ObtenerProyecto"; var p = new DynamicParameters(); p.Add(name: "@IDPROYECTO", value: id, dbType: DbType.Int32, direction: ParameterDirection.Input); entityProject = db.Query <EntityProject>(sql, param: p, commandType: CommandType.StoredProcedure).FirstOrDefault(); if (entityProject != null) { returnEntity.isSuccess = true; returnEntity.errorCode = "0000"; returnEntity.errorMessage = string.Empty; returnEntity.data = entityProject; } else { returnEntity.isSuccess = false; returnEntity.errorCode = "0000"; returnEntity.errorMessage = string.Empty; returnEntity.data = null; } } } catch (Exception ex) { returnEntity.isSuccess = false; returnEntity.errorCode = "0001"; returnEntity.errorMessage = ex.Message; returnEntity.data = null; } return(returnEntity); }