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); } }