public static CourseProgramOutputModel ToCourseProgramOutputModel(CourseProgram program) { return(new CourseProgramOutputModel { Id = program.Id, CourseId = program.CourseId, IsActual = program.IsActual }); }
public async Task <int> CourseProgramAddOrUpdate(CourseProgram newProgram) { string procName = SpName.CourseProgramInsert; try { if (procName == SpName.CourseProgramInsert) { var result = await connection.QueryAsync <decimal>( procName, new { newProgram.CourseId, newProgram.IsActual, newProgram.Title }, dbTransaction, commandType : CommandType.StoredProcedure ); return(decimal.ToInt32(result.FirstOrDefault())); } else { var result = await connection.QueryAsync <decimal>( procName, new { id = newProgram.Id, isActual = newProgram.IsActual, title = newProgram.Title }, dbTransaction, commandType : CommandType.StoredProcedure ); return(decimal.ToInt32(result.FirstOrDefault())); } } catch (SqlException ex) { Console.WriteLine(ex.Message); throw ex; } }
private async Task Setup() { listNews = new List <News>(NewsMock.listNews.Select(x => (News)x.Clone())); user1 = (User)UserMock.listUsers[0].Clone(); user2 = (User)UserMock.listUsers[1].Clone(); group = (Group)GroupMock.groupMocks[0].Clone(); course = (Course)CourseMock.listCourse[0].Clone(); courseProgram = (CourseProgram)CourseProgramMock.listCourseProgram[0].Clone(); city = (City)DictionaryMocks.cityMock[0].Clone(); var createdCityId = await dictionaryStorage.CityAddOrUpdate(city); user1.CityId = (int)createdCityId; user2.CityId = (int)createdCityId; listNews[0].AuthorId = await userStorage.UserAddOrUpdate(user1); listNews[0].RecipientID = await userStorage.UserAddOrUpdate(user2); listNews[1].AuthorId = await userStorage.UserAddOrUpdate(user2); courseProgram.CourseId = await courseStorage.CourseAddOrUpdate(course); group.CourseProgramId = await courseStorage.CourseProgramAddOrUpdate(courseProgram); listNews[1].GroupID = await groupStorage.GroupAddOrUpdate(group); for (int i = 0; i < listNews.Count; i++) { News inputmodel = new News() { AuthorId = listNews[i].AuthorId, Content = listNews[i].Content, GroupID = listNews[i].GroupID, Id = listNews[i].Id, PublicationDate = listNews[i].PublicationDate, RecipientID = listNews[i].RecipientID, Title = listNews[i].Title }; int id = await newsStorage.NewsAddOrUpdate(inputmodel); listNews[i].Id = id; listNews[i].PublicationDate = (await newsStorage.NewsGetById(id)).PublicationDate; } }
public int EidtCourseProgram(string cpId, CourseProgram cp) { //return 123; CourseProgram myCp = new CourseProgram(); SqlWhereList swl = new SqlWhereList(); swl.Add("SoftVersion", cp.SoftVersion); swl.Add("CourseType", cp.CourseType); myCp = cpBll.GetAll(swl).FirstOrDefault(); int orderNum = 99; if (myCp != null) { orderNum = myCp.OrderNum ?? 99; } int res; if (cpId == "add") { cp.CreatedTime = DateTime.Now; cp.Editor = UserCookies.AdminName; cp.Status = 1; cp.OrderNum = orderNum; cp.ProgramUrl = cp.ProgramUrl == null ? "" : cp.ProgramUrl; res = cpBll.Add(cp); } else { cp.CreatedTime = DateTime.Now; cp.Editor = UserCookies.AdminName; cp.Status = 1; cp.OrderNum = orderNum; cp.ProgramUrl = cp.ProgramUrl == null ? "" : cp.ProgramUrl; res = cpBll.Update(cp); } CreateJsonPage(cp.SoftVersion); return(res); }
/// <summary> /// 删除单条数据 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Delete(CourseProgram obj) { return(dal.Delete(obj)); }
/// <summary> /// 更新单条数据 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Update(CourseProgram obj) { return(dal.Update(obj)); }
/// <summary> /// 添加单条数据 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Add(CourseProgram obj) { return(dal.Add(obj)); }
public void AddToCoursePrograms(CourseProgram courseProgram) { base.AddObject("CoursePrograms", courseProgram); }
public static CourseProgram CreateCourseProgram(int ID, byte[] rowVersion, int courseCategory_Course, int courseCategory_Category) { CourseProgram courseProgram = new CourseProgram(); courseProgram.Id = ID; courseProgram.RowVersion = rowVersion; courseProgram.CourseCategory_Course = courseCategory_Course; courseProgram.CourseCategory_Category = courseCategory_Category; return courseProgram; }