public void EditBootcamp(Bootcamp bootcamp)
{
using (SqlConnection connection = new SqlConnection(Settings.GetConnectionString()))
{
DynamicParameters param = AddBootcampParameters(bootcamp);
param.Add("@BootcampID", bootcamp.BootcampID);
connection.Execute("BootcampsEdit", param, commandType: CommandType.StoredProcedure);
}
}
public Bootcamp AddBootcamp(Bootcamp bootcamp)
{
using (SqlConnection connection = new SqlConnection(Settings.GetConnectionString()))
{
DynamicParameters param = AddBootcampParameters(bootcamp);
param.Add("@BootcampID", dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("BootcampsAdd", param, commandType: CommandType.StoredProcedure);
bootcamp.BootcampID = param.Get<int>("@BootcampID");
}
return bootcamp;
}
public DynamicParameters AddBootcampParameters(Bootcamp bootcamp)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Name", bootcamp.Name);
parameters.Add("@PrimaryTechnologyID", bootcamp.PrimaryTechnologyID);
parameters.Add("@LocationID", bootcamp.LocationID);
parameters.Add("@Price", bootcamp.Price);
parameters.Add("@LengthInWeeks", bootcamp.LengthInWeeks);
parameters.Add("@Website", bootcamp.Website);
parameters.Add("@LogoLink", bootcamp.LogoLink);
return parameters;
}
public HttpResponseMessage Put(Bootcamp bootcamp)
{
if (base.ModelState.IsValid)
{
_bootcampRepo.EditBootcamp(bootcamp);
return new HttpResponseMessage(HttpStatusCode.OK);
}
return base.Request.CreateErrorResponse(HttpStatusCode.BadRequest, base.ModelState);
}
public MockRepository()
{
Site site = new Site
{
SiteName = "Test",
SiteLogoURL = "TestUrl"
};
mockSite = site;
BootcampLocation location = new BootcampLocation
{
BootcampID = 2,
LocationID = 1
};
MockBootcampLocation = location;
Location location2 = new Location
{
LocationID = 1,
City = "Houston",
Country = "USA"
};
mockLocation = location2;
Technology technology = new Technology
{
Name = "Javascript"
};
mockTechnology = technology;
BootcampTechnology technology2 = new BootcampTechnology
{
BootcampID = 1,
TechnologyID = 1
};
mockBootcampTechnology = technology2;
ContactForm form = new ContactForm
{
ContactFormID = 1,
Email = "*****@*****.**",
Message = "hello there",
Name = "Charles"
};
MockContactForm = form;
Bootcamp bootcamp = new Bootcamp
{
BootcampID = 1,
PrimaryTechnologyID = 1,
Name = "App Academy",
LocationID = 2,
Price = 0x2ee0,
LengthInWeeks = 10,
Website = "http://www.appacademy.com",
LogoLink = "http://sample.com"
};
mockBootcamp = bootcamp;
BootcampSession session = new BootcampSession
{
BootcampSessionID = 3,
BootcampID = 1,
LocationID = 1,
TechnologyID = 1,
StartDate = new DateTime(0x7de, 8, 1),
EndDate = new DateTime(0x7de, 10, 0x16)
};
mockBootcampSession = session;
Link link = new Link
{
LinkID = 1,
URL = "http://www.wsj.com",
LinkText = "Bootcamps in the WSJ",
SiteID = 1,
Date = new DateTime(0x7de, 2, 0x16),
BootcampID = 1
};
mockLink = link;
Review review = new Review
{
ReviewID = 1,
ReviewText = "It was good",
IsVerified = false,
BootcampID = 2,
UserID = 1
};
mockReview = review;
User user = new User
{
UserID = 1,
Email = "*****@*****.**",
Password = "******"
};
mockUser = user;
}