public ActionResult Create(Team t)
{
t.CreatedDate = DateTime.Now;
db.Teams.Add(t);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void DeleteStudentAndCredentials(int studentId)
{
Student s = new Student {
StudentId = studentId
};
try
{
s = DeleteUserWebsiteFTPDatabase(studentId);
db.SaveChanges();
}
catch (Exception)
{
RollbackOnError(BatchState.State, s.Credentials.FTPUserName);
throw;
}
}
private void btnDeleteTeam(object sender, EventArgs e)
{
try
{
Team t = db.Teams.Find(((Team)lbExistingTeams.SelectedItem).TeamId);
string warningText = "Er du sikker på, at du vil slette holdet: " + t.Name + " og alle studerende tilknyttet?\nDenne operation sletter også deres Websites, FTP Directory og Database, samt login til alle disse";
DialogResult result = MessageBox.Show(warningText, "Advarsel!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
//Find oprettede brugere på det angivne hold, der skal laves en ToList, da DeleteUserWebsiteFTPDatabase ellers ændrer i collectionen, der køres foreach over(må man ikke )
var students = t.Students.ToList();
//Sletter Windows bruger, IIS Website, IIS FTP (VirtualDirectory), Database, samt databaseserver login, for hver funden bruger.
foreach (var item in students)
{
_userInteraction.DeleteUserWebsiteFTPDatabase(item.StudentId);
}
//sletter herefter holdet i databasen, og gemmer ændringerne til databasen.
db.Teams.Remove(t);
db.SaveChanges();
//opdaterer GUI, så det fjernede hold ikke længere er der.
cbTeam.Items.Remove(t);
cbTeamMany.Items.Remove(t);
lbExistingTeams.Items.Remove(t);
comboCredentialsTeam.Items.Remove(t);
BatchState.State = UserProcessState.INITIAL;
MessageBox.Show("Team, Students and credentials removed, aswell as FTP Virtual directory, Website and Windows User Credentials");
}
}
catch (Exception ex)
{
MessageBox.Show("Der er sket en fejl:\n" + ex.Message, "Fejl", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Edit(Student student)
{
Student s = db.Students.Find(student.TeamId);
if (TryUpdateModel <Student>(student))
{
try
{
db.Entry(student).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError("", "Error updating model " + ex.Message);
}
}
return(RedirectToAction("Index"));
}
public void InsertUserWithCredentialsOnTeam(Student student, Credentials cred, int teamId)
{
try
{
using (StudentsModel ctx = new StudentsModel())
{
student.Credentials = cred;
student.TeamId = teamId;
ctx.Students.Add(student);
ctx.SaveChanges();
BatchState.State = UserProcessState.SQL_INSERT_USER_DATA_OK;
}
}
catch (Exception)
{
BatchState.State = UserProcessState.SQL_INSERT_USER_DATA_ERROR;
throw;
}
}
