public bool AddAA(baseAA obj)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
ENTITIES.AcademicActivity aa = db.AcademicActivities.Add(new ENTITIES.AcademicActivity
{
activity_type_id = obj.activity_type_id,
activity_date_start = DateTime.ParseExact(obj.from, "dd/MM/yyyy", CultureInfo.InvariantCulture),
activity_date_end = DateTime.ParseExact(obj.to, "dd/MM/yyyy", CultureInfo.InvariantCulture)
});
db.SaveChanges();
db.AcademicActivityLanguages.Add(new ENTITIES.AcademicActivityLanguage
{
language_id = 1,
activity_id = aa.activity_id,
location = obj.location
});
ENTITIES.Article ar = db.Articles.Add(new ENTITIES.Article
{
account_id = 1,
article_status_id = 1,
need_approved = false
});
db.SaveChanges();
db.ActivityInfoes.Add(new ENTITIES.ActivityInfo
{
activity_id = aa.activity_id,
article_id = ar.article_id,
main_article = true
});
db.ArticleVersions.Add(new ENTITIES.ArticleVersion
{
article_id = ar.article_id,
publish_time = DateTime.Now,
version_title = obj.activity_name,
language_id = 1,
article_content = ""
});
db.SaveChanges();
transaction.Commit();
return(true);
}
catch (Exception e)
{
transaction.Rollback();
return(false);
}
}
}
public baseAA GetbaseAA(int id)
{
try
{
string sql = @"SELECT av.version_title as 'activity_name', [aa].activity_type_id, [al].[location], cast(aa.activity_date_start as nvarchar) as 'from', cast(aa.activity_date_end as nvarchar) as 'to'
FROM SMIA_AcademicActivity.AcademicActivity aa inner join SMIA_AcademicActivity.AcademicActivityLanguage al
on aa.activity_id = al.activity_id inner join SMIA_AcademicActivity.ActivityInfo ai
on ai.activity_id = aa.activity_id and ai.main_article = 1 inner join IA_Article.Article ar
on ar.article_id = ai.article_id inner join IA_Article.ArticleVersion av
on av.article_id = ai.article_id and al.language_id = av.language_id
WHERE al.language_id = 1 and aa.activity_id = @id";
baseAA obj = db.Database.SqlQuery <baseAA>(sql,
new SqlParameter("id", id)).FirstOrDefault();
obj.from = changeFormatDate(obj.from);
obj.to = changeFormatDate(obj.to);
return(obj);
}
catch (Exception e)
{
return(new baseAA());
}
}
