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()); } }