/// <summary>
/// 进行报名
/// </summary>
/// <returns></returns>
public bool AddActivtiyUser(LuckyCharmUserModel model)
{
bool isSuccess = false;
try
{
using (var client = new LuckyCharmClient())
{
var request = new AddLuckyCharmUserRequest()
{
ActivityId = model.ActivityId,
AreaId = model.AreaId,
AreaName = model.AreaName,
Phone = model.Phone,
UserId = model.UserId,
UserName = model.UserName,
};
isSuccess = client.AddLuckyCharmUser(request).Result;
}
}
catch (Exception e)
{
Logger.Error($"AddActivtiyUser -> {JsonConvert.SerializeObject(model)}", e);
throw;
}
return(isSuccess);
}
public static async Task <int> AddActivityUser(AddLuckyCharmUserRequest model)
{
string sql = @"insert Activity.dbo.T_LuckyCharmUser (ActivityId,UserId,UserName,Phone,AreaId,AreaName)
VALUES(@ActivityId,@UserId,@UserName,@Phone,@AreaId,@AreaName)";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@ActivityId", model.ActivityId);
cmd.Parameters.AddWithValue("@UserId", model.UserId);
cmd.Parameters.AddWithValue("@UserName", model.UserName);
cmd.Parameters.AddWithValue("@Phone", model.Phone);
cmd.Parameters.AddWithValue("@AreaId", model.AreaId);
cmd.Parameters.AddWithValue("@AreaName", model.AreaName);
return(await DbHelper.ExecuteNonQueryAsync(false, cmd));
}
}
/// <summary>
/// 新增报名用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static async Task <OperationResult <bool> > AddActivityUserAsync(AddLuckyCharmUserRequest model)
{
if (string.IsNullOrWhiteSpace(model.AreaName) || string.IsNullOrWhiteSpace(model.UserName) || model.Phone.Length != 11)
{
return(OperationResult.FromError <bool>("1", "参数错误"));
}
var isUserExist = await DalLuckyCharm.IsExistUserByPhone(model.Phone);
var isActivityExist = await DalLuckyCharm.IsExistActivityByPKID(model.ActivityId);
if (isUserExist > 0)
{
return(OperationResult.FromError <bool>("2", "用户已报名"));
}
if (isActivityExist <= 0)
{
return(OperationResult.FromError <bool>("1", "活动不存在"));
}
return(OperationResult.FromResult(await DalLuckyCharm.AddActivityUser(model) > 0));
}
public async Task <OperationResult <bool> > AddLuckyCharmUserAsync(AddLuckyCharmUserRequest request)
{
return(await LuckyCharmManager.AddActivityUserAsync(request));
}