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