// // GET: /Employee/Create public ActionResult Create() { ICreditUnion_DAL _cu = new CreditUnion_DAL(); ViewBag.CU = new SelectList(_cu.GetAll(), "id", "CUName"); ViewBag.usertype = Session["UserRole"]; ViewBag.CUId = Session["cuid"]; ViewBag.preapprovalid = _dashboard.getPreAprrovalID(); if ((int)Session["UserRole"] > 0) { CreditUnion Cre = new CreditUnion(); Cre = _cu.Find((int)ViewBag.CUId); ViewBag.CUName = Cre.CUName; ViewBag.address = Cre.Address; ViewBag.phone = Cre.Phone; ViewBag.Fax = Cre.Fax; } else { ViewBag.CUName = ""; ViewBag.address = ""; ViewBag.phone = ""; ViewBag.Fax = ""; } return(View()); }
public async Task <ActionResult <CreditUnion> > PostCreditUnion(CreditUnion item) { _context.CreditUnions.Add(item); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetCreditUnion), new { id = item.Id }, item)); }
public CreditUnion Add(CreditUnion creditunion) { var sqlQuery = "INSERT INTO CreditUnion (CUName, Address, Phone, Fax, Email, Active) VALUES(@CUName, @Address, @Phone, @Fax, @Email, 1); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var CreditUnionId = this._db.Query <int>(sqlQuery, creditunion).Single(); creditunion.id = CreditUnionId; return(creditunion); }
public void CreditUnion_GetList_ShouldReturnExpectedCountList() { //Arrange CreditUnion union = new CreditUnion(); var expected = union.GetList().Count; var actual = 0; Assert.AreEqual(expected, actual); }
public ActionResult Edit([Bind(Include = "id,CUName,Address,Phone,Fax,Email")] CreditUnion creditunion, int id) { if (ModelState.IsValid) { _dashboard.Update(creditunion); return(RedirectToAction("Index")); } return(View(creditunion)); }
public async Task <IActionResult> PutCreditUnion(long id, CreditUnion item) { if (id != item.Id) { return(BadRequest()); } _context.Entry(item).State = EntityState.Modified; await _context.SaveChangesAsync(); return(NoContent()); }
public static CoreCreditUnion MapUnion(CreditUnion union) { return(new CoreCreditUnion { UnionId = union.UnionId, CreditUnionName = union.CreditUnionName, Street = union.Street, State = union.State, City = union.City, Zip = union.Zip }); }
public CreditUnion Update(CreditUnion creditunion) { var sqlQuery = "UPDATE CreditUnion " + "SET CUName = @CUName, " + " Address = @Address, " + " Phone = @Phone, " + " Fax = @Fax, " + " Email = @Email " + "WHERE id = @id"; this._db.Execute(sqlQuery, creditunion); return(creditunion); }
// // GET: /Employee/Delete/5 public ActionResult Delete(int id) { Customer _cust = new Customer(); _cust = _dashboard.Find(id); ICreditUnion_DAL _cu = new CreditUnion_DAL(); CreditUnion Cre = new CreditUnion(); Cre = _cu.Find(_cust.CUId); ViewBag.CUName = Cre.CUName; ViewBag.address = Cre.Address; ViewBag.phone = Cre.Phone; ViewBag.Fax = Cre.Fax; return(View(_cust)); }
public void Account_Transfer_MoneyShouldBeTransferred() { Consumer consumer1 = new Consumer(); Consumer consumer2 = new Consumer() { Owner = "Tim", Balance = 1.5m, }; CreditUnion union = new CreditUnion(); union.AddAccount(consumer2); consumer1.Transfer("Tim", 2); var expected = 3.5m; var actual = consumer2.Balance; Assert.AreEqual(expected, actual); }
//public ActionResult CustomerSearch(string searchSSNum, string searchLastName) //{ // string cuid; // try // { // if ((int)Session["cuid"] > 0) // { // cuid = (string)Session["cuid"]; // } // else // { // cuid = ""; // } // } // catch (Exception e) // { // cuid = ""; // } // List<Customer> lstCustomer = _dashboard.GetAll(cuid); // var customers = from s in lstCustomer // select s; // if (!String.IsNullOrEmpty(searchSSNum) & !String.IsNullOrEmpty(searchLastName)) // { // customers = // customers.Where(s => s.CCSocialNum.EndsWith(searchSSNum) & s.LastName.Equals(searchLastName)); // if (customers.Count() <= 0) // { // ModelState.AddModelError("", "No customer found!"); // return RedirectToAction("Index", "Home"); // } // } // else // { // ModelState.AddModelError("", "Social Security number and last name both required information!"); // return RedirectToAction("Index", "Home"); // } // Customer cus = customers.First(); // //ILoanInfo_DAL loaninfo = new LoanInfo_DAL(); // //List<LoanInfo> lstLoan = loaninfo.GetAll(); // //var loans = from l in lstLoan // // select l; // //loans = loans.Where(l => l.CustomerId.Equals(cus.id)); // //LoanInfo ln = loans.First(); // //if (loans.Any()) // //{ // // ViewBag.LoanId = Convert.ToString(ln.id); // // ViewBag.LoanStatus = ""; // // ViewBag.CUName = Convert.ToString(ln.CUName); // // ViewBag.LTV = Convert.ToString(ln.LTV); // // ViewBag.Rate = Convert.ToString(ln.Rate); // // ViewBag.Term = Convert.ToString(ln.Term); // // ViewBag.ApprovalAmt = Convert.ToString(ln.ApprovalAmt); // // ViewBag.PreApprovExpirationDate = Convert.ToString(ln.PreApprovExpirationDate, new DateTimeFormatInfo()); // // ViewBag.LoanDoc = Convert.ToString(ln.LoanDoc); // //} // //else // //{ // // ViewBag.LoanId = "0"; // // ViewBag.LoanStatus = "Loan not Approved!"; // // ViewBag.CUName = ""; // // ViewBag.LTV = ""; // // ViewBag.Rate = ""; // // ViewBag.Term = ""; // // ViewBag.ApprovalAmt = ""; // // ViewBag.PreApprovExpirationDate = ""; // // ViewBag.LoanDoc = ""; // //} // //IVehicleInfo_DAL vehicleinfo = new VehicleInfo_DAL(); // //List<VehicleInfo> lsVehicle = vehicleinfo.GetAll(); // //var vehicles = from v in lsVehicle // // select v; // //vehicles = vehicles.Where(v => v.CustomerId.Equals(cus.id)); // //VehicleInfo vl = vehicles.First(); // //if (vehicles.Any()) // //{ // // ViewBag.vehicleId = vl.id; // // ViewBag.VehicleStatus = ""; // // ViewBag.Year = Convert.ToString(vl.Year); // // ViewBag.Make = Convert.ToString(vl.Make); // // ViewBag.Model = Convert.ToString(vl.Model); // // ViewBag.VinNum = Convert.ToString(vl.VinNum); // // ViewBag.Mileage = Convert.ToString(vl.Mileage); // // ViewBag.PayOff = Convert.ToString(vl.PayOff); // // ViewBag.PerDiem = Convert.ToString(vl.PerDiem); // // ViewBag.PayOffExpirationDate = Convert.ToString(vl.PayOffExpirationDate); // //} // //else // //{ // // ViewBag.vehicleId = "0"; // // ViewBag.VehicleStatus = "Vehicle Not found!"; // // ViewBag.Year = ""; // // ViewBag.Make = ""; // // ViewBag.Model = ""; // // ViewBag.VinNum = ""; // // ViewBag.Mileage = ""; // // ViewBag.PayOff = ""; // // ViewBag.PerDiem = ""; // // ViewBag.PayOffExpirationDate = ""; // //} // return View(cus); //} // // GET: /Employee/Details/5 public ActionResult Details(string searchSSNum, string searchLastName, int?id) { if (!String.IsNullOrEmpty(searchSSNum) & !String.IsNullOrEmpty(searchLastName)) { string cuid; try { if ((int)Session["cuid"] > 0) { cuid = (string)Session["cuid"]; } else { cuid = ""; } } catch (Exception e) { cuid = ""; } List <Customer> lstCustomer = _dashboard.GetAll(cuid); var customers = from s in lstCustomer select s; if (!String.IsNullOrEmpty(searchSSNum) & !String.IsNullOrEmpty(searchLastName)) { customers = customers.Where(s => s.CCSocialNum.EndsWith(searchSSNum) & s.LastName.Equals(searchLastName)); if (customers.Count() <= 0) { ModelState.AddModelError("", "No customer found!"); return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "Social Security number and last name both required information!"); return(RedirectToAction("Index", "Home")); } Customer cus = customers.First(); ViewBag.CustomerSearch = "1"; ICreditUnion_DAL _cu = new CreditUnion_DAL(); CreditUnion Cre = new CreditUnion(); Cre = _cu.Find(cus.CUId); ViewBag.CUName = Cre.CUName; ViewBag.address = Cre.Address; ViewBag.phone = Cre.Phone; ViewBag.Fax = Cre.Fax; return(View(cus)); } else { ViewBag.CustomerSearch = "0"; Customer _cust = new Customer(); _cust = _dashboard.Find(id); ICreditUnion_DAL _cu = new CreditUnion_DAL(); CreditUnion Cre = new CreditUnion(); Cre = _cu.Find(_cust.CUId); ViewBag.CUName = Cre.CUName; ViewBag.address = Cre.Address; ViewBag.phone = Cre.Phone; ViewBag.Fax = Cre.Fax; return(View(_cust)); } }