Example #1
0
        public static int ValidateDisbursement(string loanRefNumber)

        {
            try
            {
                //uvDb
                UvlotAEntities uvDB    = new UvlotAEntities();
                var            userObj = uvDB.NyscLoanApplications.Where(x => x.RefNumber == loanRefNumber && x.NYSCApplicationStatus_FK == 5).FirstOrDefault();

                return(userObj == null ? 0 : 1);
            }
            catch
            {
                return(1);
            }
        }
Example #2
0
        public static int ValidateReferralCode(string referralCode)

        {
            try
            {
                //uvDb
                UvlotAEntities uvDB    = new UvlotAEntities();
                var            userObj = uvDB.Users.Where(x => x.ReferralCode == referralCode).FirstOrDefault();

                return(userObj == null ? 1 : 2);
            }
            catch
            {
                return(1);
            }
        }
Example #3
0
        public static string GetFlutterwaveBankCodeByRemitaCode(string RemitaCode)

        {
            string myCode = RemitaCode;

            try
            {
                //uvDb
                UvlotAEntities uvDB    = new UvlotAEntities();
                var            userObj = uvDB.Banks.Where(x => x.Code == RemitaCode).FirstOrDefault();
                myCode = userObj == null ? RemitaCode : userObj.FlutterWaveBankCode;
            }
            catch
            {
            }
            return(myCode);
        }
Example #4
0
        public ActionResult uploaddata(LoginViewModel lvm, FormCollection form)
        {
            try
            {
                UvlotAEntities db = new UvlotAEntities();
                //string refNumber = MyUtility.GenerateRefNo();
                DataTable  dt = (DataTable)Session["myDtVal"];
                DataReader dr = new DataReader();
                GetMenus();
                foreach (DataRow row in dt.Rows)
                {
                    try
                    {
                        //  LoanApplication inst = new LoanApplication();
                        if (row["SURNAME"] != null)
                        {
                            if (row["SURNAME"].ToString().Length < 2 && row["FIRST NAME"].ToString().Length < 2)
                            {
                                break;
                            }
                        }

                        LoanApplication instObj = new LoanApplication();

                        instObj.AccomodationType_FK = dr.GetAccomType(row["ACCOMMODATION TYPE"].ToString());
                        instObj.AccountName         = row["ACCOUNT NAME"].ToString();
                        instObj.AccountNumber       = row["ACCOUNT NUMBER"].ToString();

                        instObj.ApplicantID          = row["MEANS OF ID"].ToString();
                        instObj.ApplicationStatus_FK = 3;//Pending status,
                        instObj.BVN            = row["BANK VERIFICATION NUMBER"].ToString();
                        instObj.ClosestBusStop = row["CLOSEST BUSTOP"].ToString();

                        string DOB = row["DATE OF BIRTH"].ToString();
                        instObj.ContactAddress = row["HOME ADDRESS"].ToString();
                        instObj.CreatedBy      = ""; //Change To User ID

                        instObj.DateCreated = MyUtility.getCurrentLocalDateTime();

                        instObj.DateModified = MyUtility.getCurrentLocalDateTime();
                        instObj.DateOfBirth  = DOB;// Helper.isDate(DOB) == true ? Convert.ToDateTime(DOB) : MyUtility.getCurrentLocalDateTime();
                        instObj.EmailAddress = row["PERSONAL EMAIL"].ToString();
                        instObj.ExistingLoan = row["ANY EXISTING LOAN"].ToString().ToUpper() == "YES" ? true : false;

                        instObj.ExistingLoan_NoOfMonthsLeft = 0;

                        instObj.ExistingLoan_OutstandingAmount = 0;
                        instObj.Firstname = row["FIRST NAME"].ToString();
                        instObj.Gender_FK = row["GENDER"].ToString().ToUpper() == "MALE" ? 1 : 2;

                        instObj.IdentficationNumber = row["IDENTIFICATION NUMBER"].ToString();
                        instObj.Landmark            = row["LANDMARK"].ToString();
                        instObj.LGA_FK     = dr.GetLocalGovt(row["LGA"].ToString());
                        instObj.LoanAmount = Convert.ToDouble(row["LOAN AMOUNT"]);

                        instObj.LoanComment      = "";
                        instObj.LoanRefNumber    = MyUtility.GenerateRefNo();
                        instObj.MaritalStatus_FK = dr.GetStatus(row["MARITAL STATUS"].ToString());
                        instObj.BankCode         = Convert.ToString(dr.GetBankCode(row["BANK NAME"].ToString().Trim()));
                        instObj.MeansOfID_FK     = dr.GetMeansofIdbyname(row["MEANS OF ID"].ToString());

                        instObj.NOK_EmailAddress = row["NOK_EMAIL ADDRESS"].ToString();
                        instObj.NOK_FullName     = row["NOK_NAME"].ToString();
                        instObj.NOK_HomeAddress  = row["NOK_HOME ADDRESS"].ToString();
                        instObj.NOK_PhoneNumber  = row["NOK_PHONE"].ToString();


                        instObj.NOK_Relationship = row["NOK_RELATIONSHIP"].ToString();
                        instObj.Organization     = row["EMPLOYER"].ToString();
                        instObj.Othernames       = "";
                        instObj.PhoneNumber      = row["MOBILE NUMBER"].ToString();

                        instObj.Institution_FK      = dr.GetInstitution(row["INSTITUTION"].ToString());
                        instObj.RepaymentMethod_FK  = 0;
                        instObj.StateofResidence_FK = dr.GetState(row["STATE OF RESIDENCE"].ToString());
                        instObj.Surname             = row["SURNAME"].ToString();
                        instObj.Title_FK            = dr.GetTitleIDByName(row["TITLE"].ToString());

                        instObj.IsVisible = 1;
                        instObj.ValueDate = MyUtility.getCurrentLocalDateTime().ToString("yyyy/MM/dd");
                        instObj.ValueTime = MyUtility.getCurrentLocalDateTime().ToString("H:mmss");
                        db.LoanApplications.Add(instObj);
                        db.SaveChanges();


                        EmployerLoanDetail empObj = new EmployerLoanDetail();
                        empObj.ClosestBusStop = row["CLOSEST BUSTOP"].ToString();
                        empObj.DateCreated    = MyUtility.getCurrentLocalDateTime();
                        empObj.DateModified   = MyUtility.getCurrentLocalDateTime();

                        empObj.Department          = row["DEPARTMENT"].ToString();
                        empObj.Designation         = row["DESIGNATION"].ToString();
                        empObj.EmployerID          = row["EMPLOYEE ID"].ToString();
                        empObj.EmploymentStatus_FK = dr.GetEmpoStatus(row["EMPLOYMENT STATUS"].ToString());

                        empObj.IsVisible = 1;
                        empObj.LandMark  = row["LANDMARK"].ToString();
                        var loss = row["LENGTH OF SERVICE WITH CURRENT EMPLOYER"].ToString();
                        int los  = Helper.isNumeric(loss) == true?Convert.ToInt16(loss) : 0;

                        empObj.LengthOfServiceInMth = los;
                        empObj.LGA_FK           = row["LGA"].ToString();
                        empObj.NetMonthlyIncome = Convert.ToDouble(row["NET MONTHLY INCOME"]);
                        empObj.Occupation       = row["OCCUPATION"].ToString();

                        empObj.OfficialEmailAddress = row["EMAIL"].ToString();
                        empObj.ValueDate            = MyUtility.getCurrentLocalDateTime().ToString("yyyy/MM/dd");
                        empObj.ValueTime            = MyUtility.getCurrentLocalDateTime().ToString("H:mmss");
                        empObj.LoanApplication_FK   = instObj.ID;

                        db.EmployerLoanDetails.Add(empObj);
                        db.SaveChanges();



                        LoanLedger lonObj = new LoanLedger();
                        lonObj.ApplicantID = row["EMPLOYEE ID"].ToString();
                        lonObj.Credit      = 0;
                        lonObj.Debit       = 0;

                        lonObj.Institution_FK = instObj.Institution_FK;
                        lonObj.IsVisible      = 1;
                        lonObj.LastUpdated    = MyUtility.getCurrentLocalDateTime();
                        lonObj.RefNumber      = instObj.LoanRefNumber;

                        lonObj.PartnerRefNumber = "";
                        lonObj.TranxDate        = MyUtility.getCurrentLocalDateTime();
                        lonObj.ValueDate        = MyUtility.getCurrentLocalDateTime().ToString("yyyy/MM/dd");
                        lonObj.ValueTime        = MyUtility.getCurrentLocalDateTime().ToString("H:mmss");

                        db.LoanLedgers.Add(lonObj);
                        db.SaveChanges();

                        //DataWriter.CreateLoanApplication(instObj);
                    }

                    catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
                    {
                        Exception raise = dbEx;
                        foreach (var validationErrors in dbEx.EntityValidationErrors)
                        {
                            foreach (var validationError in validationErrors.ValidationErrors)
                            {
                                string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage);
                                //raise a new exception inserting the current one as the InnerException
                                raise = new InvalidOperationException(message, raise);
                            }
                        }
                        WebLog.Log(raise);
                    }
                }
            }


            catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
            {
                Exception raise = dbEx;
                foreach (var validationErrors in dbEx.EntityValidationErrors)
                {
                    foreach (var validationError in validationErrors.ValidationErrors)
                    {
                        string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage);
                        //raise a new exception inserting the current one as the InnerException
                        raise = new InvalidOperationException(message, raise);
                    }
                }
                WebLog.Log(raise);
            }

            return(View("ImportExcel1"));
        }