public ActionResult Create([Bind(Include = "RoleId,Description")] Role role)
{
if (ModelState.IsValid)
{
db.Roles.Add(role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(role));
}
public ActionResult Create([Bind(Include = "ProjectID,NomProjet,DateDebut,DateFin,EquipeID,CreateurDeProjetID")] Projet projet)
{
if (ModelState.IsValid)
{
db.Projets.Add(projet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(projet));
}
public ActionResult Create([Bind(Include = "SprintID,SprintName,Date_debut,Date_fin,ProjetID")] Sprint sprint)
{
if (ModelState.IsValid)
{
db.Sprints.Add(sprint);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sprint));
}
public ActionResult Create([Bind(Include = "ProjectId,ProjectName")] Project project)
{
if (ModelState.IsValid)
{
db.Projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project));
}
public ActionResult Create([Bind(Include = "idEquipe,nomEquipe")] Equipe equipe)
{
if (ModelState.IsValid)
{
db.Equipes.Add(equipe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(equipe));
}
public ActionResult Create([Bind(Include = "DeveloppeurID,Nom,Prenom,Password,Email")] Developpeur developpeur)
{
if (ModelState.IsValid)
{
db.Developpeurs.Add(developpeur);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(developpeur));
}
public ActionResult Create([Bind(Include = "SprintId,SprintName,SprintGoal,ProjectId,FromDate,ToDate,DailyScrum,SprintDemo,IsCurrent")] Sprint sprint)
{
if (ModelState.IsValid)
{
db.Sprints.Add(sprint);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProjectId = new SelectList(db.Projects.OrderBy(p => p.ProjectName), "ProjectId", "ProjectName", sprint.ProjectId);
return(View(sprint));
}
public ActionResult Create([Bind(Include = "BacklogItemId,Description,Estimate,SprintId")] BacklogItem backlogitem)
{
if (ModelState.IsValid)
{
db.BacklogItems.Add(backlogitem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SprintId = new SelectList(db.Sprints.OrderBy(s => s.SprintName), "SprintId", "SprintName", backlogitem.SprintId);
return(View(backlogitem));
}
public ActionResult Create([Bind(Include = "developpeurToEqipeId,IdDeveloppeur,IdEquipe")] DeveloppeurToEquipe developpeurToEquipe)
{
if (ModelState.IsValid)
{
db.DeveloppeurToEquipes.Add(developpeurToEquipe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdEquipe = new SelectList(db.Equipes, "idEquipe", "nomEquipe", developpeurToEquipe.IdEquipe);
return(View(developpeurToEquipe));
}
public ActionResult Create([Bind(Include = "TeamMemberId,FullName")] TeamMember teammember)
{
if (ModelState.IsValid)
{
db.TeamMembers.Add(teammember);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(teammember));
}
public ActionResult Create([Bind(Include = "TacheID,nomTache,statusTache,coutTache,DeveloppeurId,SprintID")] Tache tache)
{
if (ModelState.IsValid)
{
db.Taches.Add(tache);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DeveloppeurId = new SelectList(db.Developpeurs, "DeveloppeurID", "Nom", tache.DeveloppeurId);
ViewBag.SprintID = new SelectList(db.Sprints, "SprintID", "SprintName", tache.SprintID);
return(View(tache));
}
public bool Add(Stories inStories)
{
using (var context = new ScrumContext())
{
try
{
if (inStories.ElementType == GeneralVariable.ElementType.NewStory.GetHashCode())
{
foreach (var item in context.Stories)
{
if (item.Position == inStories.Position)
{
context.Stories.Remove(item);
}
}
}
context.Stories.Add(inStories);
if (context.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
//logFile.CatchError("YS7TRyVYHUmRS10GOQYEw", ex);
return(false);
}
}
}
public ActionResult Create([Bind(Include = "SprintTeamMemberId,SprintId,TeamMemberId,RoleId,IsManOfSprint")] SprintTeamMember sprintteammember)
{
if (ModelState.IsValid)
{
db.SprintTeamMembers.Add(sprintteammember);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RoleId = new SelectList(db.Roles.OrderBy(r => r.Description), "RoleId", "Description", sprintteammember.RoleId);
ViewBag.SprintId = new SelectList(db.Sprints.OrderBy(s => s.SprintName), "SprintId", "SprintName", sprintteammember.SprintId);
ViewBag.TeamMemberId = new SelectList(db.TeamMembers.OrderBy(t => t.FullName), "TeamMemberId", "FullName", sprintteammember.TeamMemberId);
return(View(sprintteammember));
}
public bool Update(Stories inStories)
{
using (var context = new ScrumContext())
{
try
{
context.Entry(inStories).State = EntityState.Modified;
if (context.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
//logFile.CatchError("asdf9o234nj92834n09234", ex);
return(false);
}
}
}
public bool Delete(Stories inStories)
{
using (var context = new ScrumContext())
{
try
{
context.Entry(inStories).State = EntityState.Deleted;
if (context.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
//logFile.CatchError("adsfkjo2h394823n498273u4j", ex);
return(false);
}
}
}
public static void Main(string[] args)
{
using (var db = new ScrumContext())
{
db.Add(new Group {
GroupId = 9
});
Console.WriteLine("Creating group");
try
{
db.Add(new User
{
GroupId = 1, Password = "******", Username = "******", GroupRole = GroupRole.ScrumMaster
});
db.SaveChanges();
Console.Write("Creating user");
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
public bool CreateAccount(string username, string password)
{
Console.WriteLine(username + " " + password);
try
{
db.Add(new User
{
Username = username,
Password = password,
});
db.SaveChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}