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