/// <summary>
/// 教練搜尋
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public List <CoachData> GetCoachList(CoachSearchView input)
{
var result = new List <CoachData>();
string returnStr = ShareService.Instance.SendApi("Search/CoachDataList", JsonConvert.SerializeObject(input));
result = JsonConvert.DeserializeObject <List <CoachData> >(returnStr);
return(result);
}
/// <summary>
/// 首頁查詢
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public List <CoachView> ViewCoachData(CoachSearchView input)
{
var list = new List <CoachView>();
con.Open();
var para = new DynamicParameters();
try
{
string wherestr = @"select distinct(MemberId) from ViewCoachData where 1=1";
string str = @"select * from ViewCoachData where 1=1 ";
if (input.TrainingProgramId != 0)
{
para.Add("@TrainingProgramId", input.TrainingProgramId, DbType.Int32, ParameterDirection.Input, size: 100);
wherestr += " and TrainingProgramId=@TrainingProgramId ";
}
if (input.CourseId != 0)
{
para.Add("@CourseId", input.CourseId, DbType.Int32, ParameterDirection.Input, size: 100);
wherestr += " and CourseId=@CourseId ";
}
if (!string.IsNullOrEmpty(input.Area))
{
para.Add("@Area", input.Area, DbType.String, ParameterDirection.Input, size: 100);
wherestr += " and Area=@Area ";
}
str += $"and MemberId in({wherestr})";
list = con.Query <CoachView>(str, para, commandTimeout: 300, commandType: CommandType.Text).ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(list);
}
public List <CoachData> CoachDataList(CoachSearchView input)
{
var result = new List <CoachData>();
try
{
//取整包資料
var list = repository.ViewCoachData(input);
var coachs = list.Select(c => c.MemberId).Distinct();
CoachData data = new CoachData();
foreach (var coach in coachs)
{
data = list.Where(c => c.MemberId == coach).Select(c => new CoachData()
{
MemberId = c.MemberId,
ImageName = c.ImageName,
Name = c.Name,
NickName = c.NickName,
Intoduction = c.Intoduction,
Email = c.Email
}).FirstOrDefault();
data.TrainingProgram = list.Where(c => c.MemberId == coach)
.Select(c => c.TrainingProgram).Distinct().ToList();
data.Course = list.Where(c => c.MemberId == coach)
.Select(c => c.Course).Distinct().ToList();
data.Area = list.Where(c => c.MemberId == coach)
.Select(c => c.Area).Distinct().ToList();
result.Add(data);
}
}
catch (Exception ex)
{
LogService.LogTxt("CoachDataList例外錯誤" + ex.ToString());
return(null);
}
return(result);
}
public List <CoachData> CoachDataList(CoachSearchView model)
{
return(facade.CoachDataList(model));
}
