/// <summary>
/// 删除白名单
/// </summary>
/// <param name="wl">白名单实体</param>
/// <returns>业务操作结果</returns>
public OperationResult Delete(WhiteList wl)
{
int rcount = WhiteListRepository.Delete(wl);
if (rcount > 0)
{
return(new OperationResult(OperationResultType.Success, "删除白名单成功。", wl));
}
else
{
return(new OperationResult(OperationResultType.Warning, "删除白名单失败。"));
}
}
/// <summary>
/// 添加白名单
/// </summary>
/// <param name="prizebetting">奖品信息</param>
/// <returns>业务操作结果</returns>
public OperationResult Add(int memberid, Guid poid)
{
try
{
List <SqlParameter> paramList = new List <SqlParameter>();
//用户ID
SqlParameter paramMemberId = new SqlParameter("@MemberId", SqlDbType.Int);
paramMemberId.Value = memberid;
paramList.Add(paramMemberId);
//PrizeOrder Id
SqlParameter paramPI = new SqlParameter("@PrizeOrderId", SqlDbType.VarChar, 100);
paramPI.Value = poid.ToString();
paramList.Add(paramPI);
SqlParameter paramerrorcode = new SqlParameter("@ErrorCode", SqlDbType.VarChar, 10);
paramerrorcode.Direction = ParameterDirection.Output;
paramList.Add(paramerrorcode);
SqlCommand command = new SqlCommand();
DataSet ds = WhiteListRepository.ExecProcdureReturnDataSet("sp_addToWhiteList", out command, paramList.ToArray());
string errorCode = command.Parameters["@ErrorCode"].Value.ToString();
if (string.IsNullOrEmpty(errorCode))
{
return(new OperationResult(OperationResultType.Success, "添加白名单成功。", null));
}
else
{
switch (errorCode)
{
case "Error_01":
return(new OperationResult(OperationResultType.Warning, "白名单数目不能超过中奖人数。", null));
case "Error_02":
return(new OperationResult(OperationResultType.Warning, "该用户已在白名单中，不能重复添加。", null));
default:
return(new OperationResult(OperationResultType.Warning, "出错了。", null));
}
}
}
catch (System.Exception ex)
{
return(new OperationResult(OperationResultType.Error, ex.Message));
}
}
public ActionResult SaveWhiteListNumber(WhiteListViewModel vm)
{
ControllerReturnStatus status = ControllerReturnStatus.Success;
string additionalErrInfo = string.Empty;
var ad = GetAdInfo();
string fullName = ad [0];
string loginIdentity = ad [1];
string department = ad [2];
try {
var repo = new WhiteListRepository();
repo.AddWhiteListPhoneNumber(vm.PhoneNumber, loginIdentity, fullName, department, vm.Notes, vm.DncOverride);
} catch (Exception ex) {
status = ControllerReturnStatus.Fail;
if (ex.InnerException != null)
{
if (ex.InnerException.ToString().Contains("duplicate"))
{
additionalErrInfo = " was NOT added to white list because it already is in the white list - by user ";
}
}
}
// Tell the modal what happened when we tried to save.
string formattedPhone = Helpers.FormatPhoneNumber(vm.PhoneNumber);
string message = "Phone number: " + formattedPhone;
if (additionalErrInfo == string.Empty)
{
additionalErrInfo = " was NOT added to white list by user ";
}
message += (status == 0 ? " was successfully added to white list by user " + fullName + " DNC-Override set to:" + vm.DncOverride : additionalErrInfo + fullName + " DNC-Override set to:" + vm.DncOverride);
string title = (status == 0 ? "Success on adding phone number " + formattedPhone : "Error on adding phone number " + formattedPhone);
var result = new { Status = status, Title = title, Message = message };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task <IHttpActionResult> Register(RegisterBindingModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//// *****************
//// http://stackoverflow.com/a/23273257
//// http://forums.asp.net/t/1982430.aspx?ASP+NET+Identity+2+0+How+to+add+a+User+to+a+Role+
//var roleManager = new RoleManager<IdentityRole>(new RoleStore<IdentityRole>());
//string roleName = "Admin";
////Create Role Admin if it does not exist
//if (!roleManager.RoleExists(roleName))
//{
// var roleresult = roleManager.Create(new IdentityRole(roleName));
//}
//roleManager.Create(new IdentityRole(roleName));
//UserManager.AddToRole(user.Id, "This Is A Test");
//// *****************
// *****************
var status = "ApprovedByDefault";
var _whiteListRepository = new WhiteListRepository(); // TODO: re-factor this
var tmp = _whiteListRepository.Get("itcongress2015", model.Email);
if (tmp == 0) //not found
{
status = "WaitingForApproval";
}
var repo = new UserRepository();
long id2 = repo.getMaxId() + 1;
// *****************
var user = new ApplicationUser()
{
UserName = model.Email, Email = model.Email, Hometown = model.Hometown, PhoneNumber = model.PhoneNumber, Owner = model.Owner,
FirstName = model.FirstName, LastName = model.LastName, Title = model.Title, Company = model.Company, Status = status, Id2 = id2
};
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
if (!result.Succeeded)
{
return(GetErrorResult(result));
}
return(Ok());
}
public string validate(SessionModel session)
{
BlackListRepository bl = new BlackListRepository();
WhiteListRepository wl = new WhiteListRepository();
if (!Checkers.IsPhoneNumber(session.sender))
{
return("Invalid phone number");
}
if (!Checkers.IsPhoneNumber(session.receiver))
{
return("Invalid phone number");
}
if (Checkers.checkingInputs(session.sender))
{
return(Properties.Settings.Default.MESSAGE_INVALID_INPUT.Replace("%PARAM%", "MSISDN"));
}
if (Checkers.checkingInputs(session.receiver))
{
return(Properties.Settings.Default.MESSAGE_INVALID_INPUT.Replace("%PARAM%", "receiver"));
}
if (Checkers.checkingInputs(session.amount))
{
return(Properties.Settings.Default.MESSAGE_INVALID_INPUT.Replace("%PARAM%", "amount"));
}
if (Checkers.checkingInputs(session.pin))
{
return(Properties.Settings.Default.MESSAGE_INVALID_INPUT.Replace("%PARAM%", "pin"));
}
// Only validate blaclist
if (bl.CheckExists(session.sender))
{
return(Properties.Settings.Default.BLACK_LIST_MESSAGE);
}
if (!wl.CheckExists(session.sender, 1))
{
return(Properties.Settings.Default.TC_SA_LIST_MESSAGE);
}
if (!wl.CheckExists(session.receiver, 2))
{
return(Properties.Settings.Default.DL_TL_LIST_MESSAGE.Replace("%RECEIVER%", session.receiver));
}
if (Convert.ToDecimal(session.amount) < Convert.ToDecimal(Properties.Settings.Default.PARAM_MINIMUM_AMOUNT))
{
return(Properties.Settings.Default.MESSAGE_MINIMUM_ALLOWED_AMOUNT.Replace("%AMOUNT%", Properties.Settings.Default.PARAM_MINIMUM_AMOUNT));
}
return("ok");
}
/// <summary>
/// 取待添加至白名单的用户
/// </summary>
/// <param name="pageSize">每页输出的记录数</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="whereString">条件字符串</param>
/// <param name="orderbyString">排序字符串</param>
/// <param name="totalCount">返回总记录</param>
/// <param name="totalPageCount">返回总页数</param>
/// <param name="revealstate">奖单ID</param>
/// <returns></returns>
public OperationResult GetUsers(int pageSize, int pageIndex, string whereString, string orderbyString, out int totalCount, out int totalPageCount, Guid poid)
{
totalCount = 0;
totalPageCount = 0;
try
{
List <SqlParameter> paramList = new List <SqlParameter>();
//每页输出的记录数
SqlParameter paramPS = new SqlParameter("@PageSize", SqlDbType.Int);
paramPS.Value = pageSize;
paramList.Add(paramPS);
//当前页数
SqlParameter paramPI = new SqlParameter("@PageIndex", SqlDbType.Int);
paramPI.Value = pageIndex;
paramList.Add(paramPI);
//where条件字符串
SqlParameter paramWhere = new SqlParameter("@Where", SqlDbType.VarChar, 2000);
paramWhere.Value = whereString;
paramList.Add(paramWhere);
//排序字符串
SqlParameter paramOrder = new SqlParameter("@Order", SqlDbType.VarChar, 1000);
paramOrder.Value = orderbyString;
paramList.Add(paramOrder);
//奖单ID
SqlParameter paramPOId = new SqlParameter("@PrizeOrderId", SqlDbType.VarChar, 100);
paramPOId.Value = poid.ToString();
paramList.Add(paramPOId);
SqlParameter paramtc = new SqlParameter("@TotalCount", SqlDbType.Int);
paramtc.Direction = ParameterDirection.Output;
paramList.Add(paramtc);
SqlParameter paramtpc = new SqlParameter("@TotalPageCount", SqlDbType.Int);
paramtpc.Direction = ParameterDirection.Output;
paramList.Add(paramtpc);
SqlParameter paramerrorcode = new SqlParameter("@ErrorCode", SqlDbType.VarChar, 10);
paramerrorcode.Direction = ParameterDirection.Output;
paramList.Add(paramerrorcode);
SqlCommand command = new SqlCommand();
DataSet ds = WhiteListRepository.ExecProcdureReturnDataSet("sp_getUsersForWhiteList", out command, paramList.ToArray());
string errorCode = command.Parameters["@ErrorCode"].Value.ToString();
if (string.IsNullOrEmpty(errorCode))
{
totalCount = Convert.ToInt32(command.Parameters["@TotalCount"].Value);
totalPageCount = Convert.ToInt32(command.Parameters["@TotalPageCount"].Value);
return(new OperationResult(OperationResultType.Success, "模糊查询用户操作顺利。", ds));
}
else
{
switch (errorCode)
{
case "Error_01":
return(new OperationResult(OperationResultType.Warning, "白名单数目不能超过中奖人数。", null));
default:
return(new OperationResult(OperationResultType.Warning, "出错了。", null));
}
}
}
catch (System.Exception ex)
{
return(new OperationResult(OperationResultType.Error, ex.Message));
}
}