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);
}
