public int InsertModule(ModuleAddRequest model)
{
int ModulesId = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Modules_Insert_v2"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ModuleName", model.ModuleName);
//paramCollection.AddWithValue("@Length", model.Length);
//paramCollection.AddWithValue("@Labs", model.Labs);
//paramCollection.AddWithValue("@RequiredReading", model.RequiredReading);
//paramCollection.AddWithValue("@Homework", model.Homework);
//paramCollection.AddWithValue("@Description", model.Description);
paramCollection.AddWithValue("@SectionId", model.SectionId);
SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
},
returnParameters : delegate(SqlParameterCollection param)
{
int.TryParse(param["@Id"].Value.ToString(), out ModulesId);
});
return(ModulesId);
}
public HttpResponseMessage EchoClassModule(ModuleAddRequest model)
{
if (ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.OK, model));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public HttpResponseMessage PostClassModule(ModuleAddRequest model)
{
if (ModelState.IsValid)
{
int id = _moduleService.InsertModule(model);
ItemResponse <int> response = new ItemResponse <int>();
response.Item = id;
return(Request.CreateResponse(response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public int CreateSectionModule(SectionModule model)
{
int Id = 0;
int moduleId = model.ModuleId;
//Module oldModule = new Module();
if (model.ModuleId > 0)
{
Module oldModule = _moduleService.GetClassModules(moduleId);
string name = oldModule.ModuleName;
int sectionId = model.SectionId;
ModuleAddRequest module = new ModuleAddRequest();
module.ModuleName = name;
module.SectionId = sectionId;
int newId = _moduleService.InsertModule(module);
List <ModuleWikiPages> oldWikiPages = _moduleService.GetModuleWikis(moduleId);
Id = newId;
if (oldWikiPages != null)
{
foreach (ModuleWikiPages wikiPage in oldWikiPages)
{
int wikiPageId = wikiPage.WikiPageId;
string userId = UserService.GetCurrentUserId();
WikiPage copyWikiPage = _wikiService.GetWiki(wikiPageId);
WikiAddRequest newWikiPage = new WikiAddRequest();
newWikiPage.Title = copyWikiPage.Title;
newWikiPage.URL = copyWikiPage.URL;
//newWikiPage.Language = copyWikiPage.Language;
//newWikiPage.PublishDate = copyWikiPage.PublishDate;
int newPageId = _wikiService.Add(newWikiPage, userId);
_moduleService.AddWikiPage(Id, newPageId);
}
}
}
return(Id);
}
