public IActionResult RegisterDojo(Dojos NewDojo)
{
if (ModelState.IsValid)
{
Dojos RegisteredDojo = _context.Dojos.SingleOrDefault(i => i.DojoId == NewDojo.DojoId);
if (RegisteredDojo != null)
{
// ViewBag.Message = "This email exists. Please use a different email.";
ModelState.AddModelError("DojoName", "This ninja exists. Please choose a different name.");
return(View("Dojos"));
}
_context.Dojos.Add(NewDojo);
_context.SaveChanges();
NewDojo = _context.Dojos.SingleOrDefault(i => i.DojoId == NewDojo.DojoId);
ViewBag.Dojos = _context.Dojos.Include(d => d.Ninjas).ToList();
ViewBag.Ninjas = _context.Ninjas.Include(n => n.Dojos).ToList();
HttpContext.Session.SetInt32("CurrentDojo", NewDojo.DojoId);
int?CurrentDojoId = HttpContext.Session.GetInt32("CurrentDojo");
ViewBag.CurrentDojo = NewDojo;
// return RedirectToAction("Account", "Transactions", new{AccountId});
return(RedirectToAction("Dojos", "Dojos"));
//Handle success
}
ViewBag.Dojos = _context.Dojos.Include(d => d.Ninjas).ToList();
ViewBag.Ninjas = _context.Ninjas.Include(n => n.Dojos).ToList();
return(View("Dojos"));
}
public Dojos Update(Dojos dojo)
{
Dojos result = null;
string sql = " UPDATE tblDojos "
+ " SET "
+ " intIDPersonen = @IDPersonen, "
+ " strDojoName = @DojoName, "
+ " strBeschreibung = @Beschreibung, "
+ " strDojoUrl = @DojoUrl, "
+ " intDDLinkStatus = @DDLinkStatus, "
+ " intDDStilrichtung = @DDStilrichtung, "
+ " strPLZ = @PLZ, "
+ " strOrt = @Ort, "
+ " intDDBundesland = @DDBundesland, "
+ " intDDLand = @DDLand, "
+ " blnFreigegeben = @Freigegeben, "
+ " memInternerKommentar = @InternerKommentar, "
+ " dtmLastChanged = @LastChanged, "
+ " intIDLastChanged = @IDLastChanged "
+ " WHERE (IDDojos = @ID)";
var parameters = GetUpdateParameters(dojo);
int affectedRows = Execute <Termine>(sql, parameters);
if (affectedRows > 0)
{
result = Get(dojo.IDDojos);
}
return(result);
}
public void Get_ParameterID590_ReturnsOneDojos()
{
int id = 590;
Dojos actual = _target.Get(id);
Assert.IsNotNull(actual);
}
public void Get_ParameterID590_IsBudoClubKarlsruhe()
{
int id = 590;
string expected = "Budo-Club Karlsruhe e.V.";
Dojos actual = _target.Get(id);
Assert.AreEqual(expected, actual.strDojoName);
}
public IActionResult Recruit(int NewDojoId, int NewNinjaId)
{
Ninjas NewNinja = _context.Ninjas.SingleOrDefault(n => n.NinjaId == NewNinjaId);
Dojos NewDojo = _context.Dojos.SingleOrDefault(d => d.DojoId == NewDojoId);
NewNinja.Dojos.DojoName = NewDojo.DojoName;
_context.SaveChanges();
return(RedirectToAction("Show", new { DojoId = NewDojoId }));
}
public IActionResult DojoPage(int NewDojoId)
{
Dojos NewDojo = _context.Dojos.Where(n => n.DojoId == NewDojoId).Include(n => n.Ninjas).SingleOrDefault();
ViewBag.Dojos = NewDojo;
ViewBag.DojoMembers = _context.Ninjas.Include(n => n.Dojos).Where(n => n.Dojos.DojoId == NewDojoId).ToList();
ViewBag.RogueNinjas = _context.Ninjas.Include(n => n.Dojos).Where(n => n.Dojos.DojoId == 0).ToList();
return(View("Show"));
}
public void Insert_NewDojo_DojoWasInserted()
{
string expected = "Test DojoName";
Dojos actual = _target.Insert(_TestDojo);
Assert.AreEqual(expected, actual.strDojoName);
_target.Delete(_TestDojo.IDDojos);
}
public void Update_InsertAndUpdate_WasUpdatedInDatabase()
{
var expected = "Test DojoName Update";
var dojo = _target.Insert(_TestDojo);
dojo.strDojoName = "Test DojoName Update";
dojo.strOrt = "Test Ort Update";
Dojos updated = _target.Update(dojo);
var actual = _target.Get(updated.IDDojos);
Assert.AreEqual(expected, actual.strDojoName);
}
public Dojos Insert(Dojos dojo)
{
if (dojo == null)
{
throw new ArgumentNullException(nameof(dojo));
}
if (dojo.IDDojos != 0)
{
throw new ArgumentException(nameof(dojo.IDDojos));
}
Dojos result = null;
var saveDate = DateTime.Now.ToOADate();
string sql = " Insert INTO tblDojos "
+ " (intIDPersonen, strDojoName, strBeschreibung, strDojoUrl, intDDLinkStatus, intDDStilrichtung, strPLZ, strOrt, intDDBundesland, intDDLand, blnFreigegeben, memInternerKommentar, dtmLastChanged, intIDLastChanged, dtmErstAm, intIDErstVon) "
+ " VALUES (@IDPersonen, @DojoName, @Beschreibung, @DojoUrl, @DDLinkStatus, @DDStilrichtung, @PLZ, @Ort, @DDBundesland, @DDLand, @Freigegeben, @InternerKommentar, @LastChanged, @IDLastChanged, @ErstAm, @IDErstVon ) ";
var parameter = new
{
IDPersonen = dojo.intIDPersonen,
DojoName = dojo.strDojoName,
Beschreibung = dojo.strBeschreibung,
DojoUrl = dojo.strDojoUrl,
DDLinkStatus = dojo.intDDLinkStatus,
DDStilrichtung = dojo.intDDStilrichtung,
PLZ = dojo.strPLZ,
Ort = dojo.strOrt,
DDBundesland = dojo.intDDBundesland,
DDLand = dojo.intDDLand,
Freigegeben = dojo.blnFreigegeben,
InternerKommentar = dojo.memInternerKommentar,
LastChanged = saveDate,
IDLastChanged = dojo.intIDLastChanged,
ErstAm = saveDate,
IDErstVon = dojo.intIDErstVon
};
var rowsaffected = Execute <Dojos>(sql, parameter);
if (rowsaffected > 0)
{
var select = " SELECT TOP 1 * "
+ " FROM tblDojos "
+ " WHERE dtmErstAm = @Saved AND dtmLastChanged = @Saved "
+ " ORDER BY IDDojos DESC";
var parameter2 = new { Saved = saveDate };
result = Query <Dojos>(select, parameter2).FirstOrDefault();
}
return(result);
}
public void SetUp()
{
_target = new DojosRepository();
_TestDojo = new Dojos
{
intIDPersonen = 1,
strDojoName = "Test DojoName",
intDDLinkStatus = 50,
intDDStilrichtung = 0, //93,
intDDBundesland = 0,
intDDLand = 0,
intIDLastChanged = 1,
intIDErstVon = 1
};
}
private DynamicParameters GetUpdateParameters(Dojos dojo)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("IDPersonen", dojo.intIDPersonen);
parameters.Add("DojoName", dojo.strDojoName);
parameters.Add("Beschreibung", dojo.strBeschreibung);
parameters.Add("DojoUrl", dojo.strDojoUrl);
parameters.Add("DDLinkStatus", dojo.intDDLinkStatus);
parameters.Add("DDStilrichtung", dojo.intDDStilrichtung);
parameters.Add("PLZ", dojo.strPLZ);
parameters.Add("Ort", dojo.strOrt);
parameters.Add("DDBundesland", dojo.intDDBundesland);
parameters.Add("DDLand", dojo.intDDLand);
parameters.Add("Freigegeben", dojo.blnFreigegeben);
parameters.Add("InternerKommentar", dojo.memInternerKommentar);
parameters.Add("LastChanged", DateTime.Now.ToOADate());
parameters.Add("IDLastChanged", dojo.intIDLastChanged);
parameters.Add("ID", dojo.IDDojos);
return(parameters);
}
public void Ctor_NewInstance_ImplementsIEntity()
{
var target = new Dojos();
Assert.IsNotNull(target as IEntity);
}
