public long SaveRegistrationPerson(Person per, string conn)
{
using (IDbConnection con = new SqlConnectionFactory(conn).Create())
{
per.ID = con.ExecInsert("[dbo].[Person]", new
{
per.LastName,
per.FirstName,
per.SecondName,
per.IIN,
per.Email
});
per.UsersObj.ID = con.ExecInsert("[dbo].[Users]", new
{
per.UsersObj.Password,
PersonID = per.ID,
per.UsersObj.UserTypeID
});
if (per.UsersObj.IsSchoolboy)
{
con.ExecInsert("[dbo].[SchoolboyUsers]", new
{
UserID = per.UsersObj.ID,
per.UsersObj.SchoolboyUsersObj.SchoolID,
per.UsersObj.SchoolboyUsersObj.ClassID,
per.UsersObj.SchoolboyUsersObj.LanguageLearningID
});
}
return(per.ID);
}
}
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);
}
}
