Пример #1
0
        public ActionResult AddPayee(AddPayeeViewModel model)
        {
            CustomerDAL objOfCustomerDAL = new CustomerDAL();

            string result = (new CommonDAL()).CheckValidation("Customer", this.Session);

            if (result.Equals("LogIn"))
                return RedirectToAction("Login", "CommonBiz");
            else if (result.Equals("Unauthorised"))
                return RedirectToAction("Unauthorised", "CommonBiz");

            ModelState.Clear();

            long customerID = (Session["User"] as UserRole).customerID;
            if (objOfCustomerDAL.ValidatePayeeAccountNumber(model.payeeAccountNumber, customerID) != null)
            {
                objOfCustomerDAL.AddPayee(model, customerID);
                ViewBag.message = "success";
                return View();
            }
            else
            {
                ViewBag.message = "Operation failed";
                return View();
            }
        }
Пример #2
0
        public ActionResult Index()
        {
            CustomerDAL newObj = new CustomerDAL();
               AdminDAL adminObj = new AdminDAL();

               List<BranchViewModel> list= adminObj.GetAllBranchDetails();

               foreach(var v in list)
               MessageBox.Show(v.branchCode);

               return View();
        }
Пример #3
0
        public ActionResult ApplyForLoan()
        {
            CommonDAL objCommonDal = new CommonDAL();
            ViewBag.cityList = objCommonDal.GetCityList();
            long customerID = (Session["User"] as UserRole).customerID;
            CustomerDAL objCustomerDal = new CustomerDAL();
            LoanRequestViewModel objLoanRequest = new LoanRequestViewModel();
            objLoanRequest.customerID = customerID;
            objLoanRequest.age = objCustomerDal.GetAgeByCustomerID(customerID);
            objLoanRequest.salaryProof = new byte[1024];
            objLoanRequest.addressProof = new byte[1024];
            @ViewBag.loanTypeList = new List<SelectListItem>()
            {
                new SelectListItem(){Text = "Personal",Value="P"},
                new SelectListItem(){Text = "Home",Value="H"},
                new SelectListItem(){Text = "Vehicle",Value="V"},
            };

            return View(objLoanRequest);
        }
Пример #4
0
        public ActionResult MiniDetailedstatements()
        {
            string result = (new CommonDAL()).CheckValidation("Customer", this.Session);

            if (result.Equals("LogIn"))
                return RedirectToAction("Login", "CommonBiz");
            else if (result.Equals("Unauthorised"))
                return RedirectToAction("Unauthorised", "CommonBiz");

            List<TransactionStatementViewModel> transactionsList = new List<TransactionStatementViewModel>();
            List<long> accountsList = new List<long>();

            CustomerDAL customerDALObject = new CustomerDAL();
            long customerID = (Session["User"] as UserRole).customerID;

            accountsList = customerDALObject.GetAccountsListAsLongListByCustomerID(customerID);

            ViewBag.accountsList = accountsList;

            if (accountsList != null)
                ViewBag.transactionDetails = customerDALObject.GetLastFiveTransactions(accountsList[0]);

            return View();
        }
Пример #5
0
        public JsonResult UploadSalaryProof()
        {
            string imgPath = string.Empty;
            long requestID;
            CustomerDAL customerDALObj = new CustomerDAL();

            for (int i = 0; i < Request.Files.Count; i++)
            {
                HttpPostedFileBase file = Request.Files[i]; //Uploaded file
                //Use the following properties to get file's name, size and MIMEType
                int fileSize = file.ContentLength;
                string fileName = file.FileName;
                string mimeType = file.ContentType;
                System.IO.Stream fileContent = file.InputStream;
                requestID = customerDALObj.GetNextLoanAccountRequestID();
                //To save file, use SaveAs method
                imgPath = "Images/ApplyForLoan/" + "AFL_SP_" + requestID + ".jpg";
                file.SaveAs(Server.MapPath("~/") + imgPath); //File will be saved in directory
            }
            return Json("Image uploaded successfully !");
        }
Пример #6
0
        public JsonResult ValidateAccountNumber(int accountNumber)
        {
            CustomerDAL objOfCustomerDAL = new CustomerDAL();
            long customerID = (Session["User"] as UserRole).customerID;

            AddPayeeViewModel obj = objOfCustomerDAL.ValidatePayeeAccountNumber(accountNumber, customerID);

            //if(accountNumber==0)
            //    return null;
            //AddPayeeViewModel obj = new AddPayeeViewModel {payeeName="virat",branchName="kormangala" };
            ViewBag.message = "";
            return Json(obj);
        }
Пример #7
0
 public ActionResult TransferFunds(FundTransferViewModel model)
 {
     long customerID = (Session["User"] as UserRole).customerID;
     BankerDAL objBDAL = new BankerDAL();
     CustomerDAL objCDAL = new CustomerDAL();
     ViewBag.savingsAccountList = objCDAL.GetAllSavingsAccountByCustomerID(customerID);
     ViewBag.payeeAccounts = objCDAL.GetAllPayeeAccountByCustomerID(customerID);
     string message="";
     if (model.Amount <= 0)
     {
         //ModelState.AddModelError("", "Source and Dest cant be same");
         message =  "Amount must be positive";
         @ViewBag.message = message;
         return View(model);
     }
     if (model.FromAccount == model.ToAccount)
     {
         //ModelState.AddModelError("", "Source and Dest cant be same");
         message =  "Source and Destination account can't be same";
         @ViewBag.message = message;
         return View(model);
     }
     if (model.Amount > objBDAL.GetAccountBalance(model.FromAccount))
     {
         message =  "Insufficient funds. Please check balance";
         @ViewBag.message = message;
         return View(model);
     }
     if (objCDAL.ValidateTransactionPassword(customerID, model.TransactionPassword) == false)
     {
         message =  "Password is not valid";
         @ViewBag.message = message;
         return View(model);
     }
     if (objBDAL.GetAccountType(model.ToAccount) == 'L')
     {
         if (model.Amount > objBDAL.GetAccountBalance(model.ToAccount))
         {
             message =  "Invalid transaction";
             @ViewBag.message = message;
             return View(model);
         }
     }
     objCDAL.DoFundTransfer(model);
     message =  "Transaction Successful";
     @ViewBag.message = message;
     return View(model);
 }
Пример #8
0
        public JsonResult UploadPhotoIDProof(string Token)
        {
            string imgPath = string.Empty;
            CustomerDAL customerDALObj = new CustomerDAL();
            Customer customer;

            for (int i = 0; i < Request.Files.Count; i++)
            {
                HttpPostedFileBase file = Request.Files[i]; //Uploaded file
                //Use the following properties to get file's name, size and MIMEType
                int fileSize = file.ContentLength;
                string fileName = file.FileName;
                string mimeType = file.ContentType;
                System.IO.Stream fileContent = file.InputStream;

                customer = customerDALObj.GetUserByTokenID(Token);
                    //To save file, use SaveAs method
                imgPath = "Images/FinishRegistration/" + "CID_" + customer.CustomerID + ".jpg";
                file.SaveAs(Server.MapPath("~/") + imgPath); //File will be saved in directory
            }
            return Json("Image uploaded successfully !");
        }
Пример #9
0
        public ActionResult CreateNewAccount(NewAccountRequestView model, HttpPostedFileBase Image)
        {
            CustomerDAL customerDALobject = new CustomerDAL();
               // ModelState.Clear();

            CommonDAL obj = new CommonDAL();
            ViewBag.cityList = obj.GetCityList();

            if (Image == null)
            {
                ViewBag.message = "Please upload image first ! ";
                return View(model);
            }

            if (customerDALobject.AddNewAccountRequest(model))
            {
                ViewBag.message = "Request Submitted. Thank You !";
                return View(model);
            }

            else
            {
                ViewBag.message = "Oops... Error in submitting request.";
                return View(model);
            }
        }
Пример #10
0
        public ActionResult TransferFunds()
        {
            string result = (new CommonDAL()).CheckValidation("Customer", this.Session);

            if (result.Equals("LogIn"))
                return RedirectToAction("Login", "CommonBiz");
            else if (result.Equals("Unauthorised"))
                return RedirectToAction("Unauthorised", "CommonBiz");

            long customerID = (Session["User"] as UserRole).customerID;
            CustomerDAL objCustomerDAL = new CustomerDAL();
            //List<int> savingsAccounts = new List<int>(){4,8,9};
            //ViewBag.savingsAccountList = savingsAccounts;
            List<long>  savingsAccountList = objCustomerDAL.GetAllSavingsAccountByCustomerID(customerID);
            if (savingsAccountList == null)
            {
                ViewBag.savingsAccountList = new List<long>();
            }
            else
            {
                ViewBag.savingsAccountList = savingsAccountList;
            }
            //ViewBag.savingsAccountList = objCustomerDAL.GetAllSavingsAccountByCustomerID(customerID);

            //List<SelectListItem> payeeAccounts = new List<SelectListItem>()
            //{
            //    new SelectListItem(){Text = "sham",Value="4"},
            //    new SelectListItem(){Text = "ram",Value="8"},
            //    new SelectListItem(){Text = "suresh",Value="12"},
            //};
            //ViewBag.payeeAccounts = payeeAccounts;
            List<FundTransferPayeeModel> payeeAccounts = objCustomerDAL.GetAllPayeeAccountByCustomerID(customerID);
            if (payeeAccounts == null)
            {
                ViewBag.payeeAccounts = new List<FundTransferPayeeModel>();
            }
            else
            {
                ViewBag.payeeAccounts = payeeAccounts;
            }
            //ViewBag.payeeAccounts = objCustomerDAL.GetAllPayeeAccountByCustomerID(customerID);
            ViewBag.message = "";
            return View();
        }
Пример #11
0
        public ActionResult ValidateToken(string token)
        {
            bool IsValid = true;
            CustomerDAL cd = new CustomerDAL();

            IsValid = cd.ValidateToken(token);

            if (IsValid)
            {
                return RedirectToAction("FinishRegistration", "Customer", new { token=token});
            }
            else
            {
                ModelState.AddModelError("", "Token is not valid.");
                return RedirectToAction("Index");
            }
            //MessageBox.Show("Token is: " + token);
        }
Пример #12
0
        public ActionResult RequestClosureOfAccount(CloseAccountCustomerViewModel model)
        {
            long customerID = (Session["User"] as UserRole).customerID;
            CustomerDAL objCustomerDAL = new CustomerDAL();
            //List<long> savingsAccountList = new List<long>() { 121212, 12123123421 };
            ViewBag.savingsAccountList = objCustomerDAL.GetAccountsListAsLongListByCustomerID(customerID);
            if (objCustomerDAL.AddCloseAccountRequest(model.accountNumber, customerID))
            {
                ViewBag.message = "Request for closure of account is successful";
            }
            else
            {
                ViewBag.message = "Request already exist";
            }

            return View();
        }
Пример #13
0
 public JsonResult GetListOfNewAccountRequests()
 {
     CustomerDAL objCustomerDal = new CustomerDAL();
     long customerID = (Session["User"] as UserRole).customerID;
     return Json(objCustomerDal.ViewNewAccountRequest(customerID));
 }
Пример #14
0
        public ActionResult ApplyForLoan(LoanRequestViewModel model)
        {
            CommonDAL objCommonDal = new CommonDAL();
            CustomerDAL objCustomerDal = new CustomerDAL();
            ViewBag.cityList = objCommonDal.GetCityList();
            @ViewBag.loanTypeList = new List<SelectListItem>()
            {
                new SelectListItem(){Text = "Personal",Value="P"},
                new SelectListItem(){Text = "Home",Value="H"},
                new SelectListItem(){Text = "Vehicle",Value="V"},
            };
            if(objCustomerDal.AddLoanAccountRequest(model) )
            {
                ModelState.AddModelError("", "You request for loan was successful. You may apply for yet another loan");
            }
            else
            {
                ModelState.AddModelError("", "Operation failed");
            }

            return View(model);
        }
Пример #15
0
        public ActionResult GetLastFiveTransactions(long accountNumber)
        {
            List<TransactionStatementViewModel> transactionsList = new List<TransactionStatementViewModel>();

            if (Session["User"] == null)
                return RedirectToAction("Login", "CommonBiz");

            CustomerDAL customerDALObject = new CustomerDAL();
            long customerID = (Session["User"] as UserRole).customerID;

            return Json(customerDALObject.GetLastFiveTransactions(accountNumber));
        }
Пример #16
0
        public ActionResult GetDetailedTransactions(long accountNumber, int fromDate, int fromMonth, int fromYear, int toDate, int toMonth, int toYear)
        {
            List<TransactionStatementViewModel> transactionsList = new List<TransactionStatementViewModel>();

            DateTime startDate = new DateTime(fromYear, fromMonth, fromDate);
            DateTime endDate = new DateTime(toYear, toMonth, toDate);

            if (Session["User"] == null)
                return RedirectToAction("Login", "CommonBiz");

            CustomerDAL customerDALObject = new CustomerDAL();
            long customerID = (Session["User"] as UserRole).customerID;

            return Json(customerDALObject.GetDetailedTransactions(accountNumber, startDate, endDate));
        }
Пример #17
0
        public ActionResult FinishRegistration(Customer model, HttpPostedFileBase Image)
        {
            //MessageBox.Show("I am in POST");
            CustomerDAL obj = new CustomerDAL();

            if (obj.IsUniqueUserID(model.UserID) && ModelState.IsValid)
            {
                if (Image != null)
                {
                   // product.ImageMimeType = image.ContentType;
                    model.PhotoIDProof = new byte[Image.ContentLength];
                    Image.InputStream.Read(model.PhotoIDProof, 0, Image.ContentLength);
                }
                obj.FinishReg(model);
                return RedirectToAction("Login", "CommonBiz");
            }
            else
            {
                ModelState.AddModelError("", "User Id not available");
                return View(model);
            }
        }
Пример #18
0
        public ActionResult FinishRegistration(string token)
        {
            //MessageBox.Show("I am in GET Now get user details according to token"+token);
            CustomerDAL obj = new CustomerDAL();
            Customer customer = obj.GetUserByTokenID(token);
            customer.DOB = Convert.ToDateTime(customer.DOB.ToShortDateString());

            return View(customer);
        }
Пример #19
0
        //
        // GET: /Customer/
        public ActionResult DashBoard()
        {
            string result = (new CommonDAL()).CheckValidation("Customer", this.Session);

            if (result.Equals("LogIn"))
                return RedirectToAction("Login", "CommonBiz");
            else if (result.Equals("Unauthorised"))
                return RedirectToAction("Unauthorised", "CommonBiz");

            CustomerDAL customerDALObject = new CustomerDAL();

            long customerID = (Session["User"] as UserRole).customerID;

            ViewBag.approvedRequests = customerDALObject.GetNoOfApprovedRequests(customerID);
            ViewBag.rejectedRequests = customerDALObject.GetNoOfRejectedRequests(customerID);
            ViewBag.pendingRequests = customerDALObject.GetNoOfPendingRequests(customerID);

            return View();
        }
Пример #20
0
        public List<SearchCustomerViewModel> GetLockedCustomers()
        {
            List<SearchCustomerViewModel> customersList = new List<SearchCustomerViewModel>();
            long customerID;
            CustomerDAL customerDALObj = new CustomerDAL();

            using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ToString()), connection2 = new SqlConnection(ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ToString()), connection3 = new SqlConnection(ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ToString()))
            {
                connection.Open();
                connection2.Open();
                connection3.Open();

                SqlCommand command = new SqlCommand(String.Format("SELECT UserID FROM UserRoles WHERE Status = 'L' "), connection);
                SqlDataReader reader = command.ExecuteReader(), reader2, reader3;
                SqlCommand command2 = new SqlCommand("", connection2);
                SqlCommand command3 = new SqlCommand("", connection3);

                if (!reader.HasRows)
                    return null;

                while (reader.Read())
                {
                    var userID = reader[0].ToString();
                    customerID = customerDALObj.GetCustomerIDbyUserID(userID);

                    command2.CommandText = String.Format("SELECT CustomerName, PermanentAddress, CommunicationAddress, ContactNumber, Email FROM Customer WHERE CustomerID = {0}  ", customerID.ToString());
                    reader2 = command2.ExecuteReader();
                    reader2.Read();

                    string customerName = reader2[0].ToString();
                    string permanentAddress = reader2[1].ToString();
                    string communicationAddress = reader2[2].ToString();
                    string contactNumber = reader2[3].ToString();
                    string email = reader2[4].ToString();

                    reader2.Close();

                    command3.CommandText = "SELECT AccountNumber FROM Account WHERE CustomerID = " + customerID.ToString();
                    reader3 = command3.ExecuteReader();

                    if (reader3.HasRows)
                        while (reader3.Read())
                        {
                            SearchCustomerViewModel customerDetails = new SearchCustomerViewModel();

                            customerDetails.accountNumber = reader3[0].ToString();
                            customerDetails.customerName = String.Copy(customerName);
                            customerDetails.permanentAddress = String.Copy(permanentAddress);
                            customerDetails.communicationAddress = String.Copy(communicationAddress);
                            customerDetails.contactNumber = String.Copy(contactNumber);
                            customerDetails.email = String.Copy(email);

                            customersList.Add(customerDetails);
                        }

                    reader3.Close();
                }
                reader.Close();

            }

            return customersList;
        }
Пример #21
0
        public ActionResult RequestClosureOfAccount()
        {
            string result = (new CommonDAL()).CheckValidation("Customer", this.Session);

            if (result.Equals("LogIn"))
                return RedirectToAction("Login", "CommonBiz");
            else if (result.Equals("Unauthorised"))
                return RedirectToAction("Unauthorised", "CommonBiz");

            long customerID = (Session["User"] as UserRole).customerID;
            CustomerDAL objCustomerDAL = new CustomerDAL();
            ViewBag.savingsAccountList = objCustomerDAL.GetAccountsListAsLongListByCustomerID(customerID);
            ViewBag.message = "";
            return View();
        }