public long Add(UsersInProjects userInProject)
{
try
{
using (SqlConnection connection = new SqlConnection(__connectionString))
{
connection.Open();
var parameters = new DynamicParameters();
parameters.Add("UserId", userInProject.UserId, DbType.Int64);
parameters.Add("ProjectId", userInProject.ProjectId, DbType.Int64);
parameters.Add("CreatedBy", userInProject.CreatedBy, DbType.Int64);
parameters.Add("CreatedDate", userInProject.CreatedDate, DbType.DateTime);
var userInProjectInserted = connection.Query(
sql: "UsersInProjects_Add",
param: parameters,
commandType: CommandType.StoredProcedure);
return((userInProjectInserted.FirstOrDefault()).UserInProjectId);
}
}
catch (Exception)
{
throw;
}
}
public long Add(UsersInProjects entity)
{
try
{
return(__repository.Add(entity));
}
catch (Exception)
{
throw;
}
}
public EntityValidationResult IsValid(UsersInProjects userInProject)
{
try
{
var validation = new EntityValidationResult();
validation.Status = true;
validation.ValidationMessages = new List <string>();
if (!IsUserAndProjectUnique(userInProject.UserId, userInProject.ProjectId))
{
validation.Status = false;
validation.ValidationMessages.Add("User already associate to project");
}
var user = __userApp.GetById(userInProject.UserId);
if (user == null)
{
validation.Status = false;
validation.ValidationMessages.Add("User Not Found");
}
var project = __projectApp.GetById(userInProject.ProjectId);
if (project == null)
{
validation.Status = false;
validation.ValidationMessages.Add("Project Not Found");
}
return(validation);
}
catch (Exception)
{
throw;
}
}
