private async void ScanQrCodeTopUpAsync()//scan top up
{
try
{
var scanner = DependencyService.Get <IQrScanningService>();
var result = await scanner.ScanAsync();
TopUpModel jsonqrcode = JsonConvert.DeserializeObject <TopUpModel>(result);
if (result != null)
{
//return result;
Preferences.Set("Reference", jsonqrcode.Ref);
Preferences.Set("AdminName", jsonqrcode.Name);
Preferences.Set("TopUpAmount", jsonqrcode.MoneyAmount.ToString());
Preferences.Set("ExpiryDate", jsonqrcode.ExpiryDate);
Preferences.Set("AdminBookBank", jsonqrcode.BookBank);
Preferences.Set("AdminId", jsonqrcode.AdminId);
await Application.Current.MainPage.Navigation.PushPopupAsync(new TopUpPopup());
}
else
{
// return null;
}
}
catch (Exception ex)
{
throw;
}
}
public bool TopUpUser(TopUpModel topup)
{
SqlCommand cmd = new SqlCommand
("SELECT Balance FROM Users WHERE UserID = @userid", conn);
cmd.Parameters.AddWithValue("@userid", topup.UserID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet result = new DataSet();
conn.Open();
da.Fill(result, "AccountDetails");
conn.Close();
double userBalance = 0.00;
foreach (DataRow row in result.Tables["AccountDetails"].Rows)
{
userBalance = Convert.ToDouble(row["Balance"]);
}
userBalance = userBalance + topup.topUpAmount;
SqlCommand cmd1 = new SqlCommand
("UPDATE Users SET Balance = @remaining WHERE UserID = @userid", conn);
cmd1.Parameters.AddWithValue("@remaining", userBalance);
cmd1.Parameters.AddWithValue("@userid", topup.UserID);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close();
return(true);
}
public List <TopUpModel> List(TopUpModel model)
{
List <TopUpModel> _list = new List <TopUpModel>();
bool?sStatus = null;
if (model.sStatusId == 1)
{
sStatus = true;
}
else if (model.sStatusId == 0)
{
sStatus = false;
}
else
{
sStatus = null;
}
var obj = ent.MRC_RptRechargeSales(model.ServiceProviderId, model.sFromdate, model.sTodate, model.sMobileNo, model.sAmount, sStatus, model.AgentId, model.sType);
foreach (var item in obj)
{
TopUpModel _model = new TopUpModel
{
CustomerName = "",
MobileNo = item.CustomerMobileNo,
RechargeAmount = item.Amount == null ? 0 : item.Amount.Value,
ReferenceNo = item.ReferenceNo,
SalesDate = item.SalesDate,
SalesTranId = item.SalesTranId == null ? 0 : item.SalesTranId.Value
};
_list.Add(_model);
}
return(_list);
}
public ActionResult Index()
{
TopUpModel _model = new TopUpModel();
_model.ddlServiceProviderList = ser.ddlServiceProviderList();
_model.ddlTypeList = ser.ddlTypeList();
_model.ddlStatusList = ser.ddlStatusList();
return(View(_model));
}
public IActionResult TopUp([FromBody] TopUpModel model)
{
string error = "";
if (string.IsNullOrEmpty(model.Receive))
{
error = " Email Receive is null";
return(BadRequest(new { message = error }));
}
if (!((validateMethods.CheckRegEx_UserName(model.Receive)) && (model.Receive.Length > validateMethods.LengthEmail) && (model.Receive.Length < 50)))
{
error = " Email Receive is Invalid!";
return(BadRequest(new { message = error }));
}
if (string.IsNullOrEmpty(model.SenderId))
{
error = " Email sender is null";
return(BadRequest(new { message = error }));
}
if (!((validateMethods.CheckRegEx_UserName((model.SenderId)) && ((model.SenderId.Length > validateMethods.LengthEmail) && (model.SenderId.Length < 50)))))
{
error = " Email sender is Invalid!";
return(BadRequest(new { message = error }));
}
//Call Api Check email and Password
if (error == "")
{
try
{
var user = _userService.TopUp(model.SenderId, model.RefNo, model.SenderId);
if (user == false)
{
return(BadRequest(new { message = "Not Found" }));
}
return(Ok(user));
}
catch (Exception ex)
{
error = ex.Message;
}
return(BadRequest(new { message = error }));
}
else
{
return(BadRequest(new { message = error }));
}
}
public ActionResult TopUp(TopUpModel model)
{
if (ModelState.IsValid && model.Amount > 0)
{
var userId = User.Identity.GetUserId();
if (_userRepository.TopUp(userId, model.Amount))
{
_logger.Info("user" + User.Identity.Name + " reilled the account for " + model.Amount);
ViewBag.TopUpResult = "Your account has been credited";
}
}
else
{
ViewBag.TopUpResult = "Your account has not been credited";
}
return(RedirectToAction("Account"));
}
public ActionResult Index(ExportModel Expmodel, TopUpModel model, FormCollection frm)
{
model.ddlServiceProviderList = ser.ddlServiceProviderList();
model.ddlTypeList = ser.ddlTypeList();
model.ddlStatusList = ser.ddlStatusList();
model.ListTopUp = ser.List(model);
crtBKT.GetExportTypeClicked(Expmodel, frm);
if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null))
{
try
{
if (Expmodel.ExportTypeExcel != null)
{
Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel;
}
else if (Expmodel.ExportTypeWord != null)
{
Expmodel.ExportTypeWord = Expmodel.ExportTypeWord;
}
else if (Expmodel.ExportTypePdf != null)
{
Expmodel.ExportTypePdf = Expmodel.ExportTypePdf;
}
var exportData = model.ListTopUp.Select(m => new
{
Tran_Id = m.SalesTranId,
Date = TimeFormat.DateFormat(m.SalesDate.ToString()),
Mobile_No = m.MobileNo,
Amount = m.RechargeAmount,
});
App_Class.AppCollection.Export(Expmodel, exportData, "Mobile TopUp ");
}
catch
{
}
}
return(View(model));
}
public object TopUpUser([FromBody] TopUpModel topup)
{
bool status = ApiContext.TopUpUser(topup);
return(Ok());
}
