public COM.DBHelper.SQLReturnValue DMT_CheckSufficentBalance(DMT_SufFicentClass obj)
{
string[,] param = { { "UserId", obj.UserId.ToString() },
{ "Amount", obj.Amount.ToString() } };
COM.DBHelper.SQLReturnValue Mval = sqlhelper.ExecuteProcWithMessage("DMT_CHECK_SUFFICENTBAL", param, true);
return(Mval);
}
public COM.DBHelper.SQLReturnValue DMT_Delete_BeneficiaryStatus(DMT_DeleBeneClass obj)
{
string[,] param = { { "UserId", obj.userid.ToString() },
{ "BeneficiryCode", obj.BeneficiryCode.ToString() },
{ "CustomerMobile", obj.CustomerMobile.ToString() } };
COM.DBHelper.SQLReturnValue Mval = sqlhelper.ExecuteProcWithMessage("DMT_DELETE_BENEFI_STATUS", param, true);
return(Mval);
}
public COM.DBHelper.SQLReturnValue DMT_UpdateBeneficiaryCode(DMT_UpdateBeneClass obj)
{
string[,] param = { { "UserId", obj.UserId.ToString() },
{ "BeneficiryCode", obj.BeneficiryCode.ToString() },
{ "BeneficiryAccNo", obj.BeneficiryAccNo.ToString() },
{ "BeneficiryMobile", obj.BeneficiryMobile.ToString() } };
COM.DBHelper.SQLReturnValue Mval = sqlhelper.ExecuteProcWithMessage("DMT_UPDATE_BENEFICIARY", param, true);
return(Mval);
}
public COM.DBHelper.SQLReturnValue DMT_Remittance(DMT_Remitt obj)
{
string[,] param = { { "USERID", obj.UserId.ToString() },
{ "BENEFICIARYCODE", obj.BeneficiryCode.ToString() },
{ "BENEFICIARYMOBILE", obj.BeneficiryMobile.ToString() },
{ "CUSTOMERMOBILE", obj.CustomerMobile.ToString() },
{ "IFSCCODE", obj.IFSC.ToString() },
{ "ACOOUNTNO", obj.AccountNo.ToString() },
{ "ROUTINGTYPE", obj.RountingType.ToString() },
{ "BENEFICIARYNAME", obj.BeneficiaryName.ToString() },
{ "REMARKS", obj.Remakrs.ToString() },
{ "AMOUNT", obj.Amount.ToString() },
{ "TRANSACTIONMODE", obj.Mode.ToString() },
{ "RemitterId", obj.RemitterId.ToString() },
{ "IpAddress", COM.GeneralClass.IpAddress() },
{ "RequestNo", obj.RequestNo.ToString() },
{ "Response", obj.Response.ToString() } };
COM.DBHelper.SQLReturnValue Mval = sqlhelper.ExecuteProcWithMessage("DMT_REMITTANCE", param, true);
return(Mval);
}
public JsonResult SaveEntry(MDL.FundTransfer model)
{
GlobalVarible.Clear();
try
{
strvalidationResult = ValidationEntry(model);
if (strvalidationResult.Count() == 0)
{
if (checkpassword(model.up_password))
{
model.up_upperid = Guid.Parse(User.Identity.GetUserId());
string[,] param = { { "PARENTID", model.up_upperid.ToString() }, { "USERID", model.up_userid.ToString() }, { "BALTOADD", model.up_fundbalance }, { "TRANSMODE", model.up_mode }, { "REMARKS", model.up_remakrs }, };
COM.DBHelper.SQLReturnValue M = sqlhelper.ExecuteProcWithMessageKMT("ADD_FUND_TO_ACCOUNT", param, true);
if (M.ValueFromSQL == 1)
{
GlobalVarible.AddMessage(M.MessageFromSQL);
}
else
{
throw new Exception(string.Join("<br />", M.MessageFromSQL));
}
}
else
{
throw new Exception(string.Join("<br />", "Invalid Password !"));
}
}
else
{
throw new Exception(string.Join("<br />", strvalidationResult));
}
}
catch (Exception ex)
{
GlobalVarible.AddError(ex.Message);
}
MySession.Current.MessageResult.MessageHtml = GlobalVarible.GetMessageHTML();
return(Json(MySession.Current.MessageResult, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveEntry(MDL.WalletRequest model)
{
GlobalVarible.Clear();
try
{
strvalidationResult = ValidationEntry(model);
if (strvalidationResult.Count() == 0)
{
model.userid = Guid.Parse(User.Identity.GetUserId());
if (String.IsNullOrEmpty(model.wr_remakrs))
{
model.wr_remakrs = string.Empty;
}
string[,] param = { { "USERID", model.userid.ToString() }, { "AMOUNT", model.wr_amount }, { "TRANSMODE", model.wr_mode.ToString() },
{ "ACCOUNTNO", model.wr_accountno }, { "BANKNAME", model.wr_bankname }, { "REFID", model.wr_refrenceid },{ "REMARKS", model.wr_remakrs },
{ "USERLEVEL", ((int)User.GetUserlevel()).ToString() } };
COM.DBHelper.SQLReturnValue M = sqlhelper.ExecuteProcWithMessageKMT("WALLET_REQUEST", param, true);
if (M.ValueFromSQL == 1)
{
GlobalVarible.AddMessage(M.MessageFromSQL);
}
else
{
throw new Exception(string.Join("<br />", M.MessageFromSQL));
}
}
else
{
throw new Exception(string.Join("<br />", strvalidationResult));
}
}
catch (Exception ex)
{
GlobalVarible.AddError(ex.Message);
}
MySession.Current.MessageResult.MessageHtml = GlobalVarible.GetMessageHTML();
return(Json(MySession.Current.MessageResult, JsonRequestBehavior.AllowGet));
}
public JsonResult Approved(MDL.ApprovedRequest model)
{
GlobalVarible.Clear();
try
{
strvalidationResult = ValidationEntry2(model);
if (strvalidationResult.Count() == 0)
{
if (checkpassword(model.LoginPwd))
{
Guid wrid = new Guid(model.wr_id.Replace("/", ""));
Guid userid = Guid.Parse(User.Identity.GetUserId());
string[,] param = { { "WR_ID", wrid.ToString() }, { "UPPERID", userid.ToString() } };
COM.DBHelper.SQLReturnValue M = sqlhelper.ExecuteProcWithMessageKMT("WALLET_APPROVED", param, true);
if (M.ValueFromSQL == 1)
{
GlobalVarible.AddMessage(M.MessageFromSQL);
}
else
{
throw new Exception(string.Join("<br />", M.MessageFromSQL));
}
}
else
{
throw new Exception(string.Join("<br />", "Invalid Password !"));
}
}
else
{
throw new Exception(string.Join("<br />", strvalidationResult));
}
}
catch (Exception ex)
{
GlobalVarible.AddError(ex.Message);
}
MySession.Current.MessageResult.MessageHtml = GlobalVarible.GetMessageHTML();
return(Json(MySession.Current.MessageResult, JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage doWalletRequest(MDL.WalletRequest model)
{
GlobalVarible.Clear();
List <string> strvalidationResult = new List <string>();
try
{
COM.DBHelper sqlhelper = new COM.DBHelper();
strvalidationResult = ValidateWalletRequest(model);
if (strvalidationResult.Count() == 0)
{
model.userid = Guid.Parse(User.Identity.GetUserId());
string[,] param = { { "USERID", model.userid.ToString() }, { "AMOUNT", model.wr_amount }, { "TRANSMODE", model.wr_mode.ToString() },
{ "ACCOUNTNO", model.wr_accountno }, { "BANKNAME", model.wr_bankname }, { "REFID", model.wr_refrenceid },{ "REMARKS", model.wr_remakrs },
{ "USERLEVEL", ((int)User.GetUserlevel()).ToString() } };
COM.DBHelper.SQLReturnValue M = sqlhelper.ExecuteProcWithMessageKMT("WALLET_REQUEST", param, true);
if (M.ValueFromSQL == 1)
{
GlobalVarible.AddMessage(M.MessageFromSQL);
}
else
{
throw new Exception(string.Join("<br />", M.MessageFromSQL));
}
}
else
{
throw new Exception(string.Join("<br />", strvalidationResult));
}
return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult }));
}
catch (Exception ex)
{
GlobalVarible.AddError(ex.Message);
ERRORREPORTING.Report(ex, _REQUESTURL, _LOGINUSERID, _ERRORKEY, new JavaScriptSerializer().Serialize(model));
return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult }));
}
}
public HttpResponseMessage doTransfer(doFundTransferModel data)
{
COM.DBHelper sqlhelper = new COM.DBHelper();
GlobalVarible.Clear();
List <string> strvalidationResult = new List <string>();
try
{
string token = _LOGINUSERID.ToString();
string reqdata = ENCDESC.Decrypt(data.data, token, data.userid);
MDL.FundTransfer model = new FundTransfer();
model = new JavaScriptSerializer().Deserialize <MDL.FundTransfer>(reqdata);
strvalidationResult = ValidateFundTransfer(model);
if (strvalidationResult.Count() == 0)
{
if (checkpassword(model.up_password))
{
model.up_upperid = Guid.Parse(User.Identity.GetUserId());
string[,] param =
{
{ "PARENTID", model.up_upperid.ToString() },
{ "USERID", model.up_userid.ToString() },
{ "BALTOADD", model.up_fundbalance },
{ "TRANSMODE", model.up_mode },
{ "REMARKS", model.up_remakrs },
};
COM.DBHelper.SQLReturnValue M = sqlhelper.ExecuteProcWithMessageKMT("ADD_FUND_TO_ACCOUNT", param, true);
if (M.ValueFromSQL == 1)
{
// get detail user device token
using (BAL.UserDeviceToken objUDT = new BAL.UserDeviceToken())
{
ENT.UserDeviceToken usertoken = objUDT.GetUserDeviceToken(model.up_userid);
if (usertoken != null)
{
string message = "Your account is credited with with " + model.up_fundbalance.ToString();
FCMNOTIFICATION.SendPushNotification(usertoken.udt_devicetoken, message, model.up_userid, 1);
}
}
GlobalVarible.AddMessage(M.MessageFromSQL);
}
else
{
throw new Exception(string.Join("<br />", M.MessageFromSQL));
}
}
else
{
throw new Exception(string.Join("<br />", "Invalid Password !"));
}
}
else
{
throw new Exception(string.Join("<br />", strvalidationResult));
}
return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult }));
}
catch (Exception ex)
{
GlobalVarible.AddError(ex.Message);
ERRORREPORTING.Report(ex, _REQUESTURL, _LOGINUSERID, _ERRORKEY, string.Empty);
return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult }));
}
}
public HttpResponseMessage approveRequest(approveRequest data)
{
COM.DBHelper sqlhelper = new COM.DBHelper();
GlobalVarible.Clear();
List <string> strvalidationResult = new List <string>();
try
{
string token = _LOGINUSERID.ToString();
string reqdata = ENCDESC.Decrypt(data.data, token, data.userid);
MDL.ApproveRequest model = new ApproveRequest();
model = new JavaScriptSerializer().Deserialize <MDL.ApproveRequest>(reqdata);
strvalidationResult = ValidateApproveRequest(model);
if (strvalidationResult.Count() == 0)
{
if (checkpassword(model.loginpassword))
{
Guid wrid = new Guid(model.wr_id);
Guid userid = Guid.Parse(User.Identity.GetUserId());
string[,] param = { { "WR_ID", wrid.ToString() }, { "UPPERID", userid.ToString() } };
COM.DBHelper.SQLReturnValue M = sqlhelper.ExecuteProcWithMessageKMT("WALLET_APPROVED", param, true);
if (M.ValueFromSQL == 1)
{
// get detail user device token
using (BAL.WalletRequest objUDT = new BAL.WalletRequest())
{
ENT.WalletRequest request = objUDT.GetRequestById(Guid.Parse(model.wr_id));
if (request != null)
{
string message = "Your account is credited with with " + request.wr_amount.ToString();
FCMNOTIFICATION.SendPushNotification(request.udt_devicetoken, message, request.wr_userid, 1);
}
}
GlobalVarible.AddMessage(M.MessageFromSQL);
}
else
{
throw new Exception(string.Join("<br />", M.MessageFromSQL));
}
}
else
{
throw new Exception(string.Join("<br />", "Invalid Password !"));
}
}
else
{
throw new Exception(string.Join("<br />", strvalidationResult));
}
return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult }));
}
catch (Exception ex)
{
GlobalVarible.AddError(ex.Message);
ERRORREPORTING.Report(ex, _REQUESTURL, _LOGINUSERID, _ERRORKEY, string.Empty);
return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { GlobalVarible.FormResult }));
}
}
