public InfoMaterialAdd Post([FromBody] InfoMaterialAdd material) { try { var conn = _configuration.GetConnectionString("DefaultConnection"); MaterialDataManager mat = new MaterialDataManager(); mat.SaveMaterialData(material, conn); return(material); } catch (Exception) { throw; } }
public long SaveMaterialData(InfoMaterialAdd material, string conn) { using (IDbConnection con = new SqlConnectionFactory(conn).Create()) { material.ID = con.ExecInsert("[dbo].[InfoMaterialAdd]", new { material.ClassID, material.SubjectNameID, material.UserID, material.SectionNameID, material.ThemeNameID }); con.ExecInsert("[dbo].[InterdisciplinaryRelationship]", new { InfoMaterialID = material.ID, material.InterdisciplinaryRelationshipObj.ClassID, material.InterdisciplinaryRelationshipObj.SubjectNameID, material.InterdisciplinaryRelationshipObj.UserID, material.InterdisciplinaryRelationshipObj.SectionNameID, material.InterdisciplinaryRelationshipObj.ThemeNameID }); con.ExecInsert("[dbo].[BaseTheme]", new { InfoMaterialID = material.ID, material.BaseThemeObj.ClassID, material.BaseThemeObj.UserID, material.BaseThemeObj.SectionNameID, material.BaseThemeObj.ThemeNameID }); material.MaterialDataObj.ID = con.ExecInsert("[dbo].[MaterialData]", new { InfoMaterialID = material.ID, material.MaterialDataObj.MaterialNameRU, material.MaterialDataObj.MaterialNameKZ, material.MaterialDataObj.MaterialNameEN, }); foreach (var item in material.MaterialDataObj.MaterialDataGlossaryList) { con.ExecInsert("[dbo].[MaterialDataGlossary]", new { MaterialDataID = material.MaterialDataObj.ID, item.GlossaryID }); } //foreach (var item in material.MaterialDataObj.MaterialDataImageList) //{ // con.ExecInsert("[dbo].[MaterialDataImage]", new // { // MaterialDataID = material.MaterialDataObj.ID // }); //} //foreach (var item in material.MaterialDataObj.MaterialDataVideoList) //{ // con.ExecInsert("[dbo].[MaterialDataVideo]", new // { // MaterialDataID = material.MaterialDataObj.ID // }); //} foreach (var item in material.MaterialDigEduResourcesList) { con.ExecInsert("[dbo].[MaterialDigEduResources]", new { InfoMaterialID = material.ID, item.NameRU, item.NameKZ, item.NameEN, item.Link }); } foreach (var item in material.MaterialInteractiveList) { con.ExecInsert("[dbo].[MaterialInteractive]", new { InfoMaterialID = material.ID, item.NameRU, item.NameKZ, item.NameEN, item.Link }); } material.MaterialAdditionalInformationObj.ID = con.ExecInsert("[dbo].[MaterialAdditionalInformation]", new { InfoMaterialID = material.ID, material.MaterialAdditionalInformationObj.MaterialNameRU, material.MaterialAdditionalInformationObj.MaterialNameKZ, material.MaterialAdditionalInformationObj.MaterialNameEN, material.MaterialAdditionalInformationObj.Link }); //foreach (var item in material.MaterialAdditionalInformationObj.MaterialAddInfoImageList) //{ // con.ExecInsert("[dbo].[MaterialAddInfoImage]", new // { // MaterialAddInfoID = material.MaterialAdditionalInformationObj.ID // }); //} //foreach (var item in material.MaterialAdditionalInformationObj.MaterialAddInfoVideoList) //{ // con.ExecInsert("[dbo].[MaterialAddInfoVideo]", new // { // MaterialAddInfoID = material.MaterialAdditionalInformationObj.ID // }); //} return(material.ID); } }