public void EditLink(Link link)
 {
     using (SqlConnection connection = new SqlConnection(Settings.GetConnectionString()))
     {
         DynamicParameters param = AddLinkParameters(link);
         param.Add("@LinkID", link.LinkID);
         connection.Execute("LinksEdit", param, commandType: CommandType.StoredProcedure);
     }
 }
 public DynamicParameters AddLinkParameters(Link link)
 {
     DynamicParameters parameters = new DynamicParameters();
     parameters.Add("@URL", link.URL);
     parameters.Add("@LinkText", link.LinkText);
     parameters.Add("@SiteID", link.SiteID);
     parameters.Add("@Date", link.Date);
     parameters.Add("@BootcampID", link.BootcampID);
     return parameters;
 }
 public Link AddLink(Link link)
 {
     using (SqlConnection connection = new SqlConnection(Settings.GetConnectionString()))
     {
         DynamicParameters param = AddLinkParameters(link);
         param.Add("@LinkID", dbType: DbType.Int32, direction: ParameterDirection.Output);
         connection.Execute("LinksAdd", param, commandType: CommandType.StoredProcedure);
         link.LinkID = param.Get<int>("@LinkID");
     }
     return link;
 }
Beispiel #4
0
 public HttpResponseMessage Post(Link link)
 {
     if (base.ModelState.IsValid)
     {
         _linkRepo.AddLink(link);
         return new HttpResponseMessage(HttpStatusCode.OK);
     }
     return base.Request.CreateErrorResponse(HttpStatusCode.BadRequest, base.ModelState);
 }
Beispiel #5
0
 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;
 }