public void AddBalance(WalletUserInfoModel walletUserModel)
{
ModelState.Remove("FullName");
ModelState.Remove("Email");
ModelState.Remove("MobileNo");
if (ModelState.IsValid)
{
WalletUserInfo walletUser = new WalletUserInfo();
walletUser.AgentId = Session["AddAgentId"].ToString();
//walletUser.FullName = Session["AddFullName"].ToString();
Session.Remove("AddAgentId");
walletUser.BalanceToAdd = walletUserModel.BalanceToAdd;
walletUser.Remarks = walletUserModel.Remarks;
walletUser.ActionUser = Session["UserName"].ToString();
walletUser.ActionIP = ApplicationUtilities.GetIP();
//HttpContext httpCtx = HttpContext.Current;
//walletUser.ActionBrowser = httpCtx.Request.Headers["User-Agent"];
CommonDbResponse dbresp = _CustomerManagement.InsertBalance(walletUser);
if (dbresp.ErrorCode == 0)
{
this.ShowPopup(0, "Succesfully Added amount: " + walletUser.BalanceToAdd);
return;
}
dbresp.SetMessageInTempData(this, "Index");
}
else
{
this.ShowPopup(1, "Amount Not Added");
}
}
public JsonResult ResetPassword(string userid, string agentid)
{
var data = new CommonDbResponse();
bool valid = true;
string userId = userid.DecryptParameter();
string AgentId = agentid.DecryptParameter();
if (String.IsNullOrEmpty(userId))
{
data = new CommonDbResponse {
Code = ResponseCode.Failed, Message = "Failed to Reset Password"
};
valid = false;
}
WalletUserInfo walletUser = new WalletUserInfo();
walletUser.AgentId = AgentId;
walletUser.UserId = userId;
if (valid)
{
data = _CustomerManagement.ResetPassword(walletUser);
//if (data.ErrorCode == 0)
//{
// data.Message = "Successfully Changed User";
//}
}
data.SetMessageInTempData(this);
return(Json(data));
}
public List <WalletUserInfo> WalletUserList(string agentType = "", string agentId = "", string ParentId = "")
{
var WalletUserInfos = new List <WalletUserInfo>();
string sql = "sproc_wallet_user @flag='s'";
sql += (string.IsNullOrEmpty(agentType) ? "" : ", @agent_type =" + DAO.FilterString(agentType));
sql += (string.IsNullOrEmpty(agentId) ? "" : ", @agent_id =" + DAO.FilterString(agentId));
sql += (string.IsNullOrEmpty(ParentId) ? "" : ", @parent_id =" + DAO.FilterString(ParentId));
//string sql = "select * from tbl_manage_services where txn_type_id= " + DAO.FilterString(type);
var dbres = DAO.ExecuteDataTable(sql);
if (dbres != null)
{
foreach (DataRow dr in dbres.Rows)
{
WalletUserInfo walletUser = new WalletUserInfo();
walletUser.MobileNo = dr["user_mobile_no"].ToString();
walletUser.Email = dr["user_email"].ToString();
walletUser.FullName = dr["full_name"].ToString();
walletUser.AgentId = dr["agent_id"].ToString();
walletUser.UserId = dr["user_id"].ToString();
walletUser.ParentId = dr["parent_id"].ToString();
walletUser.KycStatus = dr["kyc_status"].ToString();
walletUser.AgentStatus = dr["userStatus"].ToString();
walletUser.Balance = dr["balance"].ToString();
walletUser.CreatedLocalDate = dr["Registered_Date"].ToString();
WalletUserInfos.Add(walletUser);
}
}
return(WalletUserInfos);
}
public ActionResult RequestCard(CardModel cardModels)
{
int ReqAmount = 0;
float AvaBalnce = 0;
cardModels.Balance = Session["Balance"].ToString();
//CardModel cardModel = new CardModel();
var cardType = _card.GetCardType();
foreach (var item in cardType.Where(kvp => kvp.Value.ToUpper() == "VIRTUAL CARD").ToList())
{
cardType.Remove(item.Key);
}
cardModels.CardTypeList = ApplicationUtilities.SetDDLValue(cardType as Dictionary <string, string>, "", "--Card Type--");
if (int.TryParse(cardModels.Amount, out ReqAmount))
{
if (ReqAmount < 100) //|| ReqAmount>1000
{
ModelState.AddModelError("Amount", "Amount should be at least RS. 100");
return(View(cardModels));
}
}
else
{
ModelState.AddModelError("Amount", "Invalid Requested amount.");
return(View(cardModels));
}
if (float.TryParse(cardModels.Balance, out AvaBalnce))
{
if (ReqAmount > AvaBalnce)
{
ModelState.AddModelError("Amount", "Requested amount greater then balance");
return(View(cardModels));
}
}
cardModels.UserId = Session["UserId"].ToString();
cardModels.AgentId = Session["AgentId"].ToString();
cardModels.UserName = Session["UserName"].ToString();
//cardModels.UserName = Session["FullName"].ToString();
WalletUserInfo walletUser = _walletUserBusiness.UserInfo(cardModels.UserId);
cardModels.Email = walletUser.Email;
cardModels.MobileNo = walletUser.MobileNo;
cardModels.ActionUser = cardModels.UserName;
cardModels.CreatedIp = ApplicationUtilities.GetIP();
CardCommon cardCommon = cardModels.MapObject <CardCommon>();
//CommonDbResponse dbResponse = _card.CardApproval(cardCommon);
CommonDbResponse dbResponse = _card.RequestCard(cardCommon);
if (dbResponse.Code == 0)
{
//dbResponse.SetMessageInTempData(this, "Index");
return(RedirectToAction("Index"));
}
dbResponse.SetMessageInTempData(this, "Index");
return(View(cardModels));
}
public CommonDbResponse ResetPassword(WalletUserInfo walletUser)
{
string sql = "sproc_wallet_user @flag = 'rpassword'";
//sql += ", @agent_id=" + DAO.FilterString(walletUser.AgentId);
sql += ", @user_id=" + DAO.FilterString(walletUser.UserId);
sql += ", @action_user="******", @created_ip=" + DAO.FilterString(walletUser.ActionIP);
return(DAO.ParseCommonDbResponse(sql));
}
public CommonDbResponse InsertBalance(WalletUserInfo walletUser)
{
string sql = "sproc_balance_transfer @flag = 'awu'";
sql += ", @agent_id=" + DAO.FilterString(walletUser.AgentId);
sql += ", @amount=" + DAO.FilterString(walletUser.BalanceToAdd);
sql += ", @action_user="******", @remarks=" + DAO.FilterString(walletUser.Remarks);
sql += ", @created_ip=" + DAO.FilterString(walletUser.ActionIP);
return(DAO.ParseCommonDbResponse(sql));
}
public CommonDbResponse AddUser(WalletUserInfo walletUser)
{
string sql = "sproc_wallet_user @flag = 'i'";
sql += ", @usermobileNumber=" + DAO.FilterString(walletUser.MobileNo);
sql += ", @useremail=" + DAO.FilterString(walletUser.Email);
sql += ", @fullname=" + DAO.FilterString(walletUser.FullName);
sql += ", @parent_id=" + DAO.FilterString(walletUser.ParentId);
sql += ", @action_user="******", @action_IP=" + DAO.FilterString(walletUser.ActionIP);
//if (!string.IsNullOrEmpty(DAO.FilterString(walletUser.ParentId)))
// sql += ", @parent_id=" + DAO.FilterString(walletUser.ParentId);
sql += ", @action_browser=" + DAO.FilterString(walletUser.ActionBrowser);
return(DAO.ParseCommonDbResponse(sql));
}
public WalletUserInfo UserInfo(string UserId = "")
{
WalletUserInfo walletUser = new WalletUserInfo();
string sql = "sproc_user_detail @flag = 'searchuser',@search= " + DAO.FilterString(UserId);
var dr = DAO.ExecuteDataRow(sql);
if (dr != null)
{
walletUser.UserId = dr["user_id"].ToString();
walletUser.Email = dr["user_email"].ToString();
walletUser.FullName = dr["full_name"].ToString();
walletUser.MobileNo = dr["user_mobile_no"].ToString();
walletUser.UserName = dr["user_name"].ToString();
walletUser.AgentId = dr["agent_id"].ToString();
walletUser.UserId = dr["user_id"].ToString();
walletUser.Balance = dr["available_balance"].ToString();
walletUser.CreatedLocalDate = dr["created_local_date"].ToString();
walletUser.PPImage = dr["identification_photo_logo"].ToString();
}
return(walletUser);
}
public ActionResult AddCustomer(WalletUserInfoModel walletUserModel)
{
ModelState.Remove("BalanceToAdd");
ModelState.Remove("Remarks");
if (string.IsNullOrEmpty(walletUserModel.FullName))
{
ModelState.AddModelError("FullName", "Full Name is Required");
}
if (string.IsNullOrEmpty(walletUserModel.Email))
{
ModelState.AddModelError("Email", "Email is Required");
}
if (string.IsNullOrEmpty(walletUserModel.MobileNo))
{
ModelState.AddModelError("MobileNo", "Mobile Number is Required");
}
if (ModelState.IsValid)
{
WalletUserInfo walletUser = new WalletUserInfo();
walletUser.ParentId = walletUserModel.ParentId.DecryptParameter();
walletUser.MobileNo = walletUserModel.MobileNo;
walletUser.Email = walletUserModel.Email;
walletUser.FullName = walletUserModel.FullName;
walletUser.ActionUser = Session["UserName"].ToString();
walletUser.ActionIP = ApplicationUtilities.GetIP();
HttpContext httpCtx = System.Web.HttpContext.Current;
walletUser.ActionBrowser = httpCtx.Request.Headers["User-Agent"];
CommonDbResponse dbresp = _CustomerManagement.AddUser(walletUser);
if (dbresp.ErrorCode == 0)
{
dbresp.SetMessageInTempData(this);
//this.ShowPopup(0, "Succesfully Added amount: " + walletUser.BalanceToAdd);
return(RedirectToAction("Index", new { ParentId = walletUserModel.ParentId }));
}
dbresp.SetMessageInTempData(this);
}
return(View(walletUserModel));
}
public ActionResult Profile()
{
#region FileLocation
string FileLocation;
string usertype = Session["UserType"].ToString();
if (usertype.ToLower() == "distributor")
{
FileLocation = "/Content/userupload/Distributor/kyc/";
}
else if (usertype.ToLower() == "sub-distributor")
{
FileLocation = "/Content/userupload/SubDistributor/kyc/";
}
else if (usertype.ToLower() == "walletuser")
{
FileLocation = "/Content/userupload/Walletuser/kyc/";
}
else if (usertype.ToLower() == "merchant")
{
FileLocation = "/Content/userupload/Merchant/kyc/";
}
else if (usertype.ToLower() == "agent")
{
FileLocation = "/Content/userupload/Agent/kyc/";
}
else if (usertype.ToLower() == "sub-agent")
{
FileLocation = "/Content/userupload/SubAgent/kyc/";
}
else
{
FileLocation = "/Content/userupload/";
}
#endregion
string UserId = Session["UserName"].ToString();
WalletUserInfo walletUser = _walletUserBusiness.UserInfo(UserId);
return(View(walletUser));
}
public JsonResult UserStatusChange(string agentid, string userid, string status)
{
var data = new CommonDbResponse();
bool valid = true;
string userId = userid.DecryptParameter();
string agentId = agentid.DecryptParameter();
if (String.IsNullOrEmpty(userId) || String.IsNullOrEmpty(agentId))
{
data = new CommonDbResponse {
Code = ResponseCode.Failed, Message = "Invalid User."
};
valid = false;
}
if (valid)
{
WalletUserInfo walletUser = new WalletUserInfo();
walletUser.UserId = userId;
if (status.ToLower() == "y")
{
walletUser.AgentStatus = "n";
}
if (status.ToLower() == "n")
{
walletUser.AgentStatus = "y";
}
walletUser.AgentId = agentId;
data = _CustomerManagement.UserStatusChange(walletUser.UserId, walletUser.AgentId, walletUser.AgentStatus);
//if (data.ErrorCode == 0)
//{
// data.Message = "Successfully Changed User";
//}
}
data.SetMessageInTempData(this);
return(Json(data));
}
public ActionResult CardApprovalDetail(CardModel cardModel, string btnApprove)
{
if (btnApprove.ToUpper() == "REJECT")
{
cardModel.RequestStatus = "Rejected";
}
if (btnApprove.ToUpper() == "APPROVE")
{
cardModel.RequestStatus = "Approved";
}
//Get user info from userName
WalletUserInfo walletUser = _walletUserBusiness.UserInfo(cardModel.UserName);
cardModel.UserId = walletUser.UserId;
cardModel.AgentId = walletUser.AgentId;
cardModel.ActionUser = Session["UserId"].ToString();
cardModel.CreatedIp = ApplicationUtilities.GetIP();
cardModel.CardType = _card.GetCardType().FirstOrDefault(x => x.Value == cardModel.CardType).Key;
CardCommon cardCommon = cardModel.MapObject <CardCommon>();
CommonDbResponse dbResponse = _card.CardApproval(cardCommon);
dbResponse.SetMessageInTempData(this);
return(RedirectToAction("CardApprovalList"));
}
public CommonDbResponse InsertBalance(WalletUserInfo walletUser)
{
return(_repo.InsertBalance(walletUser));
}
public CommonDbResponse AddUser(WalletUserInfo walletUser)
{
return(_repo.AddUser(walletUser));
}
public CommonDbResponse ResetPassword(WalletUserInfo walletUser)
{
return(_repo.ResetPassword(walletUser));
}
