public IHttpActionResult PostProjectDeveloper(ProjectDeveloper projectDeveloper)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ProjectDevelopers.Add(projectDeveloper);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (ProjectDeveloperExists(projectDeveloper.ProjectId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = projectDeveloper.ProjectId }, projectDeveloper));
}
public IHttpActionResult PutProjectDeveloper(int id, ProjectDeveloper projectDeveloper)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != projectDeveloper.ProjectId)
{
return(BadRequest());
}
db.Entry(projectDeveloper).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProjectDeveloperExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void InsertProject(ProjectDto ProjectDto, string ProjetManagerId)
{
var project = new Project()
{
Title = ProjectDto.Title,
Description = ProjectDto.Description,
ProjectManagerId = ProjetManagerId,
TeamLeaderId = ProjectDto.TeamLeaderId
};
project.StatusProject = (ProjectStatus)ProjectDto.StatusProjectDto;
db.Projects.Add(project);
db.SaveChanges();
foreach (var item in ProjectDto.DeveloperIds)
{
var projectDeveloper = new ProjectDeveloper()
{
ProjectId = project.Id,
DeveloperId = item
};
db.ProjectDevelopers.Add(projectDeveloper);
}
db.SaveChanges();
}
public ProjectDeveloper Add(ProjectDeveloper item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
_context.ProjectDevelopers.Add(item);
_context.SaveChangesAsync();
return(item);
}
public async Task <IActionResult> ConfirmDeleteProjectDeveloper(int?ProjectId, int?DeveloperId)
{
if ((ProjectId != null) && (DeveloperId != null))
{
ProjectDeveloper projectDeveloper = projectDeveloperRepository.Get(ProjectId, DeveloperId);
if (projectDeveloper != null)
{
return(View(projectDeveloper));
}
}
return(NotFound());
}
static void Main(string[] args)
{
ProjectDeveloper p = new ProjectDeveloper();
DeveloperHubDbContext db = new DeveloperHubDbContext();
p.DeveloperId = 1;
db.ProjectDevelopers.Add(p);
db.SaveChanges();
Console.WriteLine("Complete");
Console.ReadKey();
}
private void button3_Click(object sender, EventArgs e)
{
string name = txtFullName.Text;
string username = txtUsername.Text;
string password = txtPassword.Text;
if (name == "" || username == "" || password == "")
{
MessageBox.Show("Please fill up the form properly");
}
else
{
if (radioButton1.Checked)
{
ProjectDeveloper p = new ProjectDeveloper {
ProgrammerId = 0, FullName = name, Username = username, Password = password
};
try
{
new ProgrammerDAO().Insert(p);
MessageBox.Show("Account created");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Console.WriteLine(ex.Message);
}
}
else
{
Tester p = new Tester {
TesterId = 0, FullName = name, Username = username, Password = password
};
try
{
new TesterDAO().Insert(p);
MessageBox.Show("Account created");
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
MessageBox.Show("Username already exists");
}
MessageBox.Show(ex.Message);
Console.WriteLine(ex.Message);
}
}
}
}
public IHttpActionResult DeleteProjectDeveloper(int id)
{
ProjectDeveloper projectDeveloper = db.ProjectDevelopers.Find(id);
if (projectDeveloper == null)
{
return(NotFound());
}
db.ProjectDevelopers.Remove(projectDeveloper);
db.SaveChanges();
return(Ok(projectDeveloper));
}
public async Task <IActionResult> DetailsProjectDeveloper(int?ProjectId, int?DeveloperId)
{
if ((ProjectId != null) && (DeveloperId != null))
{
ProjectDeveloper projectDeveloper = projectDeveloperRepository.Get(ProjectId, DeveloperId);
projectDeveloper.Project = projectRepository.Get(ProjectId);
projectDeveloper.Developer = developerRepository.Get(DeveloperId);
if (projectDeveloper != null)
{
return(View(projectDeveloper));
}
}
return(NotFound());
}
public async Task <bool> InviteDeveloperToProject(int developerId, int projectId)
{
using (CompanyDbContext context = CompanyDbContext.Create())
{
var entity = new ProjectDeveloper
{
DeveloperId = developerId,
ProjectId = projectId
};
context.ProjectDeveloper.Add(entity);
await context.SaveChangesAsync();
return(true);
}
}
public bool Delete(int?ProjectId, int?DeveloperId)
{
ProjectDeveloper projectDeveloper = _context.ProjectDevelopers.FirstOrDefault((p => (p.ProjectId == ProjectId) && (p.DeveloperId == DeveloperId)));
// projectDeveloper.Project = await db.Projects.FirstOrDefaultAsync(p => p.ProjectId == ProjectId);
// projectDeveloper.Developer = await db.Developers.FirstOrDefaultAsync(p => p.DeveloperId == DeveloperId);
if (projectDeveloper != null)
{
_context.ProjectDevelopers.Remove(projectDeveloper);
_context.SaveChangesAsync();
return(true);
}
return(false);
}
public bool Update(ProjectDeveloper item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
int index = _context.ProjectDevelopers.FirstOrDefault(x => x.ProjectId == item.ProjectId).ProjectId;
if (index == -1)
{
return(false);
}
_context.Projects.Remove(_context.Projects.FirstOrDefault(x => x.ProjectId == item.ProjectId));
// _context.Projects.Add();
_context.SaveChangesAsync();
return(true);
}
private void GetAllProgrammer()
{
ProgrammerDAO programmerDAO = new ProgrammerDAO();
//Programmer p = programmerDAO.GetById(programmerId);
List <String> programmers = new List <String>();
ProjectProgrammerDAO projectProgrammerDAO = new ProjectProgrammerDAO();
List <ProjectProgrammer> list = projectProgrammerDAO.GetAllProjectsByProjectId(projectId);
//projectProgrammerDAO.GetAll();
foreach (var l in list)
{
ProjectDeveloper p = programmerDAO.GetById(Convert.ToInt32(l.ProgrammerId));
programmers.Add(p.ProgrammerId + "," + p.FullName);
}
foreach (var a in programmers)
{
listBox1.Items.Add(a);
}
}
public void UpdateProject(ProjectDto ProjectDto)
{
var Project = GetProject(ProjectDto.Id);
Project.Title = ProjectDto.Title;
Project.Description = ProjectDto.Description;
Project.TeamLeaderId = ProjectDto.TeamLeaderId;
db.Projects.Update(Project);
db.SaveChanges();
var OldProjectDevelopers = GetOldProjectDevelopers(ProjectDto.Id);
db.ProjectDevelopers.RemoveRange(OldProjectDevelopers);
foreach (var DeveloperId in ProjectDto.DeveloperIds)
{
var NewProjectDeveloper = new ProjectDeveloper()
{
ProjectId = ProjectDto.Id,
DeveloperId = DeveloperId
};
db.ProjectDevelopers.Add(NewProjectDeveloper);
}
db.SaveChanges();
}
/// <summary>
/// returns a name of bug fixer
/// </summary>
/// <returns></returns>
public List <Fixer> GetBugFixers()
{
conn.Open();
List <Fixer> list = new List <Fixer>();
Fixer fixer = null;
ProjectDeveloper programmer = null;
try
{
SqlCommand sql = new SqlCommand(null, conn);
sql.CommandText = "SELECT f.bug_id, f.fixed_date, p.full_name FROM tbl_programmer p JOIN tbl_fixer f ON p.programmer_id = f.fixed_by;";
sql.Prepare();
using (SqlDataReader reader = sql.ExecuteReader())
{
while (reader.Read())
{
fixer = new Fixer();
programmer = new ProjectDeveloper();
fixer.BugId = Convert.ToInt32(reader["bug_id"]);
fixer.FixedDate = Convert.ToDateTime(reader["fixed_date"]);
programmer.FullName = reader["full_name"].ToString();
fixer.programmer = programmer;
list.Add(fixer);
}
}
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(list);
}
public void AddDeveloperToProject(ProjectDeveloper entity)
{
_unitOfWork.ProjectDeveloperRepository.Add(entity);
//_unitOfWork.Complete();
}
public async Task <IActionResult> CreateProjectDeveloper(ProjectDeveloper projectDeveloper)
{
projectDeveloperRepository.Add(projectDeveloper);
return(RedirectToAction("ProjectDeveloperList"));
}
