public bool PopulateCountries()
{
try
{
var client = new RestClient("https://restcountries.eu/rest/v2/");
var request = new RestRequest("all", Method.GET);
// string date = ConvertToTimestamp(datetime).ToString();
// request.AddParameter("fields", "name;alpha3code");
// request.AddHeader("contentType", "application/x-www-form-urlencoded");
IRestResponse response = client.Execute(request);
JsonDeserializer deserial = new JsonDeserializer();
var obj = deserial.Deserialize <List <BNKMVC.Models.ViewModel.CountryViewModel> >(response);
using (var db = new Entities.mbankEntities())
{
foreach (var i in obj)
{
db.Countries.Add(new Country()
{
Alph3Code = i.alpha3Code,
Name = i.name,
});
}
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
string returnMessage = ex.Message;
return(false);
}
}
public bool Find(string userid)
{
try
{
using (var db = new Entities.mbankEntities())
{
var find = db.AspNetUsers.Find(userid);
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public string getAccountNumber(string userid)
{
try
{
using (var db = new Entities.mbankEntities())
{
var accout = db.tblAccounts.Where(a => a.AspNetUser.Id == userid).Select(a => a.acctNo).SingleOrDefault();
return(accout);
}
}
catch (Exception)
{
return(null);
}
}
public double GetBalance(string accountNo)
{
try
{
using (var db = new Entities.mbankEntities())
{
var find = db.tblAccounts.Where(a => a.acctNo == accountNo).SingleOrDefault();
if (find != null)
{
return(Convert.ToDouble(find.ActiveAmount));
}
return(0.00);
}
}
catch (Exception)
{
return(0.00);
}
}
public bool FindAccount(string accountNo)
{
try
{
using (var db = new Entities.mbankEntities())
{
var find = db.tblAccounts.Where(a => a.acctNo == accountNo).SingleOrDefault();
if (find != null)
{
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public ActionResult Contact(Models.FeedBackDto m)
{
if (ModelState.IsValid)
{
var db = new Entities.mbankEntities();
db.tblfeedbacks.Add(new Entities.tblfeedback
{
Clientname = m.Clientname,
email = m.email,
Message = m.Message,
datesent = DateTime.UtcNow.ToString(),
});
db.SaveChanges();
TempData["view"] = 1;
TempData["Message"] = "We have received your message and we will get back to you";
return(View(m));
}
return(View(m));
}
public bool AddAccount(string userid)
{
try
{
using (var db = new Entities.mbankEntities())
{
db.tblAccounts.Add(new tblAccount
{
userId = userid,
acctNo = Generator.RndAccountNo(),
ActiveAmount = Convert.ToDecimal(0.00),
});
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool UpdateAccountBalance(string accountNo, decimal amount)
{
try
{
using (var db = new Entities.mbankEntities())
{
var find = db.tblAccounts.Where(a => a.acctNo == accountNo).SingleOrDefault();
if (find != null)
{
find.ActiveAmount = amount;
db.Entry(find).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
