public AddCoachDetailResponse AddCoachDetail(AddCoachDetailRequest request) { var result = base.CreateResponse <AddCoachDetailResponse>("新建教练信息"); try { using (var con = new DbConnectionProvider(dbName).GetOpenConnection()) { var parms = new DynamicParameters(); parms.Add("UserID", request.Coach.UserID, DbType.Int32); parms.Add("Name", request.Coach.Name, DbType.String); parms.Add("Level", request.Coach.Level, DbType.SByte); parms.Add("IsFree", request.Coach.IsFree, DbType.Boolean); parms.Add("PersonalSign", request.Coach.PersonalSign, DbType.String); parms.Add("BriefIntroduction", request.Coach.BriefIntroduction, DbType.String); parms.Add("HonorDesc", request.Coach.HonorDesc, DbType.String); parms.Add("Certificates", request.Coach.Certificates, DbType.String); parms.Add("CourseDesc", request.Coach.CourseDesc, DbType.String); parms.Add("GymDesc", request.Coach.GymDesc, DbType.String); parms.Add("AreaDesc", request.Coach.AreaDesc, DbType.String); parms.Add("IsHomeRecommended", request.Coach.IsHomeRecommended, DbType.Boolean); parms.Add("Photos", request.Coach.Photos != null && request.Coach.Photos.Count > 0 ? JsonConvert.SerializeObject(request.Coach.Photos) : string.Empty, DbType.String); result.CoachID = con.ExecuteScalar <int>("sp_AddCoachDetail", parms, CommandType.StoredProcedure); foreach (var c in request.Coach.Courses) { parms = new DynamicParameters(); parms.Add("CourseTypeID", c.CourseTypeID, DbType.Int32); parms.Add("CoachID", c.ChargeType, DbType.Int32); result.CoachID = con.ExecuteScalar <int>("sp_AddCourseCoach", parms, CommandType.StoredProcedure); } } } catch (Exception ex) { base.HandleResponseException(ref result, ex); } return(result); }
public AddCoachDetailResponse AddCoachDetail(AddCoachDetailRequest request) { return(BasicDataManager.GetInstance().AddCoachDetail(request)); }