예제 #1
0
        protected void ButtonAppAckLetter_Click(object sender, EventArgs e)
        {
            int id = 0;

            //InvestorApplicationDS investor = new InvestorApplicationDS();

            DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter();

            //DataUtils.InvestorApplicationTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorApplicationTableAdapters.InvestorApplicationsTableAdapter();

            DataUtils.InvestorDS.InvestorApplicationsDataTable dt = new InvestorDS.InvestorApplicationsDataTable();
            dt = dta.GetDataById(id);

            if (dt.Rows.Count != 1)
            {
                throw new ArgumentException(String.Concat("InvestorApplication with Id ", id, " could not be found."), "InvestorApplication.Id");
            }

            DataUtils.InvestorDS.InvestorApplicationsRow currentRow = dt.Rows[0] as InvestorDS.InvestorApplicationsRow;
            if (null != currentRow)
            {
                currentRow.CondCreditDecisionDate = DateTime.Now;
                currentRow.CondCreditDecisionBy   = "pdvorak";
                currentRow.CondCreditDecision     = ((char)CondCreditDecisionResult.Accepted).ToString();
                dta.Update(currentRow);
            }



            Response.Redirect("~/InvestorApplicantsNewAll.aspx");
        }
예제 #2
0
        protected void btnCondRejectModal_Click(object sender, EventArgs e)
        {
            int id = GetIdFromReqParam();

            if (id <= 0)
            {
                throw new ArgumentException(String.Format("The Application Id {0} is not valid: ", id), "id");
            }


            DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter();

            //DataUtils.InvestorApplicationTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorApplicationTableAdapters.InvestorApplicationsTableAdapter();

            DataUtils.InvestorDS.InvestorApplicationsDataTable dt = new InvestorDS.InvestorApplicationsDataTable();
            dt = dta.GetDataById(id);

            if (dt.Rows.Count != 1)
            {
                throw new ArgumentException(String.Concat("InvestorApplication with Id ", id, " could not be found."), "InvestorApplication.Id");
            }

            DataUtils.InvestorDS.InvestorApplicationsRow currentRow = dt.Rows[0] as InvestorDS.InvestorApplicationsRow;
            if (null != currentRow)
            {
                try
                {
                    currentRow.CondCreditDecisionDate = DateTime.Now;
                    currentRow.CondCreditDecisionBy   = "pdvorak";
                    currentRow.CondCreditDecision     = ((char)CondCreditDecisionResult.Rejected).ToString();
                    dta.Update(currentRow);
                    SetErrorText(String.Empty);
                    Response.Redirect("~/InvestorApplicantsNewAll.aspx");
                }
                catch (Exception ex)
                {
                    SetErrorText("Error saving Conditional Decision on Application Id: " + id.ToString() + ex.Message + ex.StackTrace);
                    return;
                }
            }
            else
            {
                SetErrorText("Error finding Application Id: " + id.ToString());
            }
        }
예제 #3
0
        protected void btn_CondApprovedModal_Click(object sender, EventArgs e)
        {
            int investAppid = GetIdFromReqParam();

            #region oldCode
            //InvestorApplicationDS investor = new InvestorApplicationDS();

            //DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter idta = new DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter();

            ////DataUtils.InvestorApplicationTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorApplicationTableAdapters.InvestorApplicationsTableAdapter();

            //DataUtils.InvestorDS.InvestorApplicationsDataTable dt = new InvestorDS.InvestorApplicationsDataTable();
            //dt = idta.GetDataById(id);

            //if (dt.Rows.Count != 1)
            //{
            //    throw new ArgumentException(String.Concat("InvestorApplication with Id ", id, " could not be found."), "InvestorApplication.Id");
            //}
            //DataUtils.InvestorDS.InvestorApplicationsRow invApp = dt.Rows[0] as InvestorDS.InvestorApplicationsRow;


            //if (null != invApp)
            //{
            //    DataUtils.InvestorDS.InvestorDataTable idt = new InvestorDS.InvestorDataTable();
            //    DataUtils.InvestorDSTableAdapters.InvestorTableAdapter ita = new InvestorTableAdapter();
            //    DataUtils.InvestorDS.InvestorRow newInv = idt.NewInvestorRow();
            //    DataUtils.InvestorDS.InvestorRow newInvOth;

            //    newInv.InvestorApplicationId = invApp.Id;
            //    newInv.LastName = invApp.Primary_LastName;
            //    newInv.FirstName = invApp.Primary_FirstName;
            //    newInv.DOB = invApp.Primary_DOB;
            //    newInv.Res_Street1 = invApp.Primary_Res_Street1;
            //    newInv.Res_Suburb = invApp.Primary_Res_Suburb;
            //    newInv.Res_Postcode = invApp.Primary_Res_PostCode;
            //    newInv.Res_State = invApp.Primary_Res_State;
            //    newInv.Res_Country = invApp.Primary_Res_Country;
            //    newInv.AssquireStatus = "N";
            //    newInv.AppliedDate = invApp.EntryDate;
            //    newInv.Created = DateTime.Now;
            //    newInv.CreatedBy = "dvorakpj";

            //    idt.AddInvestorRow(newInv);

            //    try
            //    {
            //        int updates = ita.Update(idt);
            //        if (updates != 1)
            //        {
            //            throw new ApplicationException("Failed to create a new permanent record for the Primary Investor from Application ID:" + id.ToString());
            //        }

            //    }
            //    catch (Exception ex)
            //    {
            //        this.txtValidationErrors.Visible = true;
            //        this.txtValidationErrors.Text = "Failed to create a new permanent record for the Primary Investor from Application ID:" + id.ToString() + ex.Message + ex.StackTrace;
            //        //this
            //    }

            //    if ((invApp.ApplicantType != "Single") && (invApp.IsOther_LastNameNull()))
            //    {
            //        //DataUtils.InvestorDS.InvestorDataTable idt = new InvestorDS.InvestorDataTable();
            //        newInvOth = idt.NewInvestorRow();

            //        newInvOth.PrimaryInvestorID = newInv.Id;
            //        newInvOth.InvestorApplicationId = invApp.Id;
            //        newInvOth.LastName = invApp.Other_LastName;
            //        newInvOth.FirstName = invApp.Other_FirstName;
            //        newInvOth.DOB = invApp.Other_DOB;
            //        newInvOth.Res_Street1 = invApp.Other_Res_Street1;
            //        newInvOth.Res_Suburb = invApp.Other_Res_Suburb;
            //        newInvOth.Res_Postcode = invApp.Other_Res_PostCode;
            //        newInvOth.Res_State = invApp.Other_Res_State;
            //        newInvOth.Res_Country = invApp.Other_Res_Country;
            //        newInvOth.AssquireStatus = "N";
            //        newInvOth.AppliedDate = invApp.EntryDate;
            //        newInvOth.Created = DateTime.Now;
            //        newInvOth.CreatedBy = "dvorakpj";

            //        idt.AddInvestorRow(newInvOth);

            //        try
            //        {
            //            int updates2 = ita.Update(idt);
            //            if (updates2 != 1)
            //            {
            //                throw new ApplicationException("Failed to create a permanent record for Other Investor for Application ID:" + id.ToString());
            //            }

            //        }
            //        catch (Exception ex)
            //        {
            //            this.txtValidationErrors.Visible = true;
            //            this.txtValidationErrors.Text = "Failed to create a permanent record for Other Investor for Application ID:" + id.ToString() + ex.Message + ex.StackTrace;
            //            return;
            //        }

            //    }

            //    invApp.CondCreditDecisionDate = DateTime.Now;
            //    invApp.CondCreditDecisionBy = "pdvorak";
            //    invApp.CondCreditDecision = ((char)CondCreditDecisionResult.Accepted).ToString();

            //    try
            //    {
            //        int updates3 = idta.Update(invApp);
            //    }
            //    catch (Exception ex)
            //    {
            //        this.txtValidationErrors.Visible = true;
            //        this.txtValidationErrors.Text = "Failed to record credit decision for application ID:" + id.ToString() + ex.Message + ex.StackTrace;
            //        return;
            //    }
            //}
            #endregion oldCode

            #region updateApplic
            DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter();
            DataUtils.InvestorDS.InvestorApplicationsDataTable dt = new InvestorDS.InvestorApplicationsDataTable();

            dt = dta.GetDataById(investAppid);

            if (dt.Rows.Count != 1)
            {
                throw new ArgumentException(String.Concat("InvestorApplication with Id ", investAppid, " could not be found."), "InvestorApplication.Id");
            }

            DataUtils.InvestorDS.InvestorApplicationsRow currentRow = dt.Rows[0] as InvestorDS.InvestorApplicationsRow;
            if (null != currentRow)
            {
                try
                {
                    currentRow.CondCreditDecisionDate = DateTime.Now;
                    currentRow.CondCreditDecisionBy   = "pdvorak";
                    currentRow.CondCreditDecision     = ((char)CondCreditDecisionResult.Accepted).ToString();
                    dta.Update(currentRow);
                    SetErrorText(String.Empty);
                }
                catch (Exception ex)
                {
                    SetErrorText("Error saving Conditional Decision on Application Id: " + investAppid.ToString() + ex.Message + ex.StackTrace);
                    return;
                }
            }
            else
            {
                SetErrorText("Error finding Application Id: " + investAppid.ToString());
                return;
            }
            #endregion

            //now create a permanent investor record
            string errmsg     = SaveInvestorPermRecord(investAppid);
            string properrmsg = SavePropertyPermRecord(investAppid);

            SetErrorText(errmsg);

            Response.Redirect("~/InvestorApplicantsNewAll.aspx");
        }
예제 #4
0
        protected string SaveInvestorPermRecord(int invAppId)
        {
            StringBuilder validationErrorSB       = new StringBuilder();
            bool          IsOtherApplicantPresent = false;


            InvestorDS ds = new InvestorDS();

            InvestorDS.InvestorApplicationsDataTable invAppDT = ds.InvestorApplications;
            InvestorDS.InvestorDataTable             invDT    = ds.Investor;



            InvestorApplicationsTableAdapter invAppTA = new DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter();

            try
            {
                invAppTA.FillById(invAppDT, invAppId);
                //GetDataById(invAppId);
            }
            catch (System.Data.ConstraintException constrExc)
            {
                System.Data.DataRow[] rowsErr = invAppDT.GetErrors();
                for (int i = 0; i < rowsErr.Length; i++)
                {
                    if (rowsErr[i].HasErrors)
                    {
                        string err = rowsErr[i].RowError;
                        if (!String.IsNullOrWhiteSpace(err))
                        {
                            validationErrorSB.AppendLine(err);
                            return(validationErrorSB.ToString());
                        }
                    }
                }
            }


            if (invAppDT.Rows.Count != 1)
            {
                throw new ArgumentException(String.Concat("InvestorApplication with Id ", invAppId, " could not be found."), "InvestorApplication.Id");
            }

            DataUtils.InvestorDS.InvestorApplicationsRow currentInvAppRow = invAppDT.Rows[0] as InvestorDS.InvestorApplicationsRow;

            InvestorDS.InvestorRow invRow    = invDT.NewInvestorRow();
            InvestorDS.InvestorRow othinvRow = null;

            InvestorTableAdapter invTA  = new InvestorTableAdapter();
            PropertyTableAdapter prtyTA = new PropertyTableAdapter();


            TableAdapterManager tam = new TableAdapterManager();

            //tam.InvestorApplicationsTableAdapter = ;
            tam.PropertyTableAdapter = prtyTA;
            tam.InvestorTableAdapter = invTA;

            tam.UpdateOrder = TableAdapterManager.UpdateOrderOption.InsertUpdateDelete;


            //InvestorTableAdapter invTA = new InvestorTableAdapter();

            //if (currentInvAppRow.IsPrimary_FirstNameNull() || String.IsNullOrEmpty(currentInvAppRow.Primary_FirstName))
            //{
            //    validationErrorSB.AppendLine("Primary Applicant's First name is empty");
            //}

            invRow.InvestorApplicationId = currentInvAppRow.Id;
            if (!currentInvAppRow.IsOther_LastNameNull() && !String.IsNullOrWhiteSpace(currentInvAppRow.Other_LastName))
            {
                IsOtherApplicantPresent = true;
            }

            #region PrimaryInvestor
            //invRow.Id = -1;

            if (currentInvAppRow.IsPrimary_FirstNameNull())
            {
                invRow.FirstName = null;
            }
            else
            {
                invRow.FirstName = currentInvAppRow.Primary_FirstName.Trim();
            }


            if (currentInvAppRow.IsPrimary_OtherNamesNull())
            {
                invRow.OtherNames = null;
            }
            else
            {
                invRow.OtherNames = currentInvAppRow.Primary_OtherNames.Trim();
            }

            if (currentInvAppRow.IsPrimary_LastNameNull() || String.IsNullOrEmpty(currentInvAppRow.Primary_LastName))
            {
                validationErrorSB.AppendLine("Primary Applicant's Last name is empty");
            }
            else
            {
                invRow.LastName = currentInvAppRow.Primary_LastName.Trim();
            }

            if (currentInvAppRow.IsPrimary_DOBNull() || currentInvAppRow.Primary_DOB < DateTime.Today.AddYears(-100))
            {
                validationErrorSB.AppendLine("Primary Applicant's DOB is empty or invalid");
            }
            else
            {
                invRow.DOB = currentInvAppRow.Primary_DOB;
            }


            if (currentInvAppRow.IsPrimary_LastNameNull())
            {
                validationErrorSB.AppendLine("Primary Applicant's Last Name is empty or invalid");
            }
            else
            {
                invRow.LastName = currentInvAppRow.Primary_LastName.Trim();
            }

            if (currentInvAppRow.IsEmailNull() || String.IsNullOrWhiteSpace(currentInvAppRow.Email))
            {
                validationErrorSB.AppendLine("Primary Applicant's Email address is empty or invalid");
            }
            else
            {
                invRow.Email = currentInvAppRow.Email;
            }


            currentInvAppRow.Other_Email = null;

            //invRow.Gender =
            if (String.IsNullOrWhiteSpace(currentInvAppRow.Primary_Gender))
            {
                validationErrorSB.AppendLine("");
            }
            else
            {
                string gender = currentInvAppRow.Primary_Gender.Trim();

                if (gender.StartsWith("m", StringComparison.InvariantCultureIgnoreCase))
                {
                    invRow.Gender = 'M';
                }
                else if (gender.StartsWith("f", StringComparison.InvariantCultureIgnoreCase))
                {
                    invRow.Gender = 'F';
                }
                else
                {
                    invRow.Gender = 'O';
                }
            }


            if (currentInvAppRow.IsPrimary_Res_Street1Null() || String.IsNullOrWhiteSpace(currentInvAppRow.Primary_Res_Street1))
            {
                validationErrorSB.AppendLine("Primary Applicant's Street address is empty or invalid");
            }
            else
            {
                string unitKeyword    = "unit";
                string street1        = currentInvAppRow.Primary_Res_Street1;
                int    unitKeywdIndex = new CultureInfo("EN-AU").CompareInfo.IndexOf(street1, unitKeyword, CompareOptions.IgnoreCase);
                if (unitKeywdIndex > 0)
                {
                    string unitNo      = street1.Substring(unitKeywdIndex + unitKeyword.Length).TrimStart();
                    int    endOfUnitNo = unitNo.Length - unitNo.IndexOf(" ", StringComparison.InvariantCultureIgnoreCase);
                    unitNo = unitNo.Substring(0, endOfUnitNo);
                    if (!String.IsNullOrWhiteSpace(unitNo))
                    {
                        invRow.Res_UnitNum = unitNo;
                        invRow.Res_Street1 = street1.Substring(unitKeywdIndex + endOfUnitNo);
                    }
                    else
                    {
                        invRow.Res_Street1 = street1;
                    }
                }
                else
                {
                    invRow.Res_Street1 = currentInvAppRow.Primary_Res_Street1.Trim();
                }
            }

            if (String.IsNullOrWhiteSpace(currentInvAppRow.Primary_Res_Street2))
            {
                invRow.Res_Street2 = null;
            }
            else
            {
                invRow.Res_Street2 = currentInvAppRow.Primary_Res_Street2.Trim();
            }

            if (currentInvAppRow.IsPrimary_Res_PostCodeNull())
            {
                invRow.Res_Postcode = -1;
            }
            else
            {
                invRow.Res_Postcode = currentInvAppRow.Primary_Res_PostCode;
            }

            //  invRow.Res_Suburb = currentInvAppRow.Primary_Res

            if (currentInvAppRow.IsPrimary_Res_SuburbNull())
            {
                validationErrorSB.AppendLine("Primary current residence Suburb cannot be empty.");
                //invRow.Res_Suburb = null;
            }
            else
            {
                invRow.Res_Suburb = currentInvAppRow.Primary_Res_Suburb.Trim();
            }

            invRow.Res_City = null;

            if (currentInvAppRow.IsPrimary_Res_StateNull())
            {
                invRow.Res_State = null;
            }
            else
            {
                invRow.Res_State = currentInvAppRow.Primary_Res_State;
            }

            if (String.IsNullOrWhiteSpace(currentInvAppRow.Primary_Res_Country))
            {
                invRow.Res_Country = "Australia";
            }
            else
            {
                invRow.Res_Country = currentInvAppRow.Primary_Res_Country;
            }

            invRow.Res_Street3 = null;
            invRow.Res_Street4 = null;
            invRow.Res_Street5 = null;

            if (String.IsNullOrWhiteSpace(currentInvAppRow.Mobile))
            {
                invRow.PhoneMobile = null;
            }
            else
            {
                invRow.PhoneMobile = currentInvAppRow.Mobile.Trim();
            }


            if (currentInvAppRow.IsPrimary_HomePhoneNull())
            {
                invRow.PhoneHome = null;
            }
            else
            {
                invRow.PhoneHome = currentInvAppRow.Primary_HomePhone.Trim();
            }

            invRow.PhoneWork  = null;
            invRow.PhoneOther = null;

            invRow.Bill_Street1 = null;
            invRow.Bill_Street2 = null;
            invRow.Bill_Street3 = null;
            invRow.Bill_Street4 = null;
            invRow.Bill_Street5 = null;

            invRow.AssquireStatus = "New";
            invRow.AppliedDate    = currentInvAppRow.EntryDate;
            invRow.Created        = DateTime.Now;
            invRow.CreatedBy      = "pdvorak";

            invDT.AddInvestorRow(invRow);

            #endregion PrimaryInvestor

            #region PrimaryInvestorProperty

            // We will create property only if the details are provided and it must be confirmed
            //TODO
            bool hasProperty = true; //this.chckPrptyValFeePaid.Checked;
            InvestorDS.PropertyRow prptyNewR = null;
            // validate if property is included

            if (hasProperty)
            {
                //                InvestorDS.PropertyDataTable prptyDT = new InvestorDS.PropertyDataTable();

                AddPermPropertyFromInvAppRow(ds, currentInvAppRow, invRow);
            }

            #endregion PrimaryInvestorProperty

            #region OtherApplicant
            if (IsOtherApplicantPresent)
            {
                othinvRow = invDT.NewInvestorRow();


                othinvRow.PrimaryInvestorID = invRow.Id;
                //othinvRow.PrimaryInvestorID = invRow.Id;

                othinvRow.LastName = currentInvAppRow.Other_LastName;

                if (currentInvAppRow.IsOther_FirstNameNull())
                {
                    othinvRow = null;
                }
                else
                {
                    othinvRow.FirstName = currentInvAppRow.Other_FirstName;
                }

                if (currentInvAppRow.IsOther_OtherNamesNull())
                {
                    othinvRow.OtherNames = null;
                }
                else
                {
                    othinvRow.OtherNames = currentInvAppRow.Other_OtherNames.Trim();
                }


                if (currentInvAppRow.IsOther_DOBNull() || (currentInvAppRow.Other_DOB <= DateTime.Today.AddYears(-100)))
                {
                    validationErrorSB.AppendLine("Other Investor DOB cannot be null");
                }
                else
                {
                    othinvRow.DOB = currentInvAppRow.Other_DOB;
                }


                if (currentInvAppRow.IsOther_Res_Street1Null() || String.IsNullOrWhiteSpace(currentInvAppRow.Other_Res_Street1))
                {
                    validationErrorSB.AppendLine("Other Applicant's Street address is empty or invalid");
                }
                else
                {
                    string unitKeyword    = "unit";
                    string street1        = currentInvAppRow.Other_Res_Street1;
                    int    unitKeywdIndex = new CultureInfo("EN-AU").CompareInfo.IndexOf(street1, unitKeyword, CompareOptions.IgnoreCase);
                    if (unitKeywdIndex > 0)
                    {
                        string unitNo      = street1.Substring(unitKeywdIndex + unitKeyword.Length).TrimStart();
                        int    endOfUnitNo = unitNo.Length - unitNo.IndexOf(" ", StringComparison.InvariantCultureIgnoreCase);
                        unitNo = unitNo.Substring(0, endOfUnitNo);
                        if (!String.IsNullOrWhiteSpace(unitNo))
                        {
                            othinvRow.Res_UnitNum = unitNo;
                            othinvRow.Res_Street1 = street1.Substring(unitKeywdIndex + endOfUnitNo);
                        }
                        else
                        {
                            othinvRow.Res_Street1 = street1;
                        }
                    }
                    else
                    {
                        othinvRow.Res_Street1 = currentInvAppRow.Other_Res_Street1.Trim();
                    }
                }

                if (String.IsNullOrWhiteSpace(currentInvAppRow.Other_Res_Street2))
                {
                    othinvRow.Res_Street2 = null;
                }
                else
                {
                    othinvRow.Res_Street2 = currentInvAppRow.Other_Res_Street2.Trim();
                }

                if (currentInvAppRow.IsOther_Res_PostCodeNull())
                {
                    othinvRow.Res_Postcode = -1;
                }
                else
                {
                    othinvRow.Res_Postcode = currentInvAppRow.Other_Res_PostCode;
                }

                //  othinvRow.Res_Suburb = currentInvAppRow.Other_Res

                if (currentInvAppRow.IsOther_Res_SuburbNull())
                {
                    othinvRow.Res_Suburb = null;
                }
                else
                {
                    othinvRow.Res_Suburb = currentInvAppRow.Other_Res_Suburb.Trim();
                }

                othinvRow.Res_City = null;

                if (currentInvAppRow.IsOther_Res_StateNull())
                {
                    othinvRow.Res_State = null;
                }
                else
                {
                    othinvRow.Res_State = currentInvAppRow.Other_Res_State;
                }

                if (String.IsNullOrWhiteSpace(currentInvAppRow.Other_Res_Country))
                {
                    othinvRow.Res_Country = "Australia";
                }
                else
                {
                    othinvRow.Res_Country = currentInvAppRow.Other_Res_Country;
                }

                othinvRow.Res_Street3 = null;
                othinvRow.Res_Street4 = null;
                othinvRow.Res_Street5 = null;

                if (String.IsNullOrWhiteSpace(currentInvAppRow.Mobile))
                {
                    othinvRow.PhoneMobile = null;
                }
                else
                {
                    othinvRow.PhoneMobile = currentInvAppRow.Mobile.Trim();
                }


                if (currentInvAppRow.IsPrimary_HomePhoneNull())
                {
                    othinvRow.PhoneHome = null;
                }
                else
                {
                    othinvRow.PhoneHome = currentInvAppRow.Other_HomePhone.Trim();
                }

                othinvRow.PhoneWork  = null;
                othinvRow.PhoneOther = null;

                othinvRow.Bill_Street1 = null;
                othinvRow.Bill_Street2 = null;
                othinvRow.Bill_Street3 = null;
                othinvRow.Bill_Street4 = null;
                othinvRow.Bill_Street5 = null;

                othinvRow.InvestorApplicationId = currentInvAppRow.Id;

                othinvRow.AssquireStatus = "New";
                othinvRow.AppliedDate    = currentInvAppRow.EntryDate;
                othinvRow.Created        = DateTime.Now;
                othinvRow.CreatedBy      = "pdvorak";

                invDT.AddInvestorRow(othinvRow);
            }
            #endregion OtherApplicant


            if (validationErrorSB.Length > 0)
            {
                return(validationErrorSB.ToString());
            }
            else
            {
                //this.lblValidationErrorsTxtBoxLabel.Visible = false;
                //this.txtValidationErrors.Visible = false;
                //this.txtValidationErrors.Text = String.Empty();


                try
                {
                    //invTA.Update(invRow);
                    //invTA.Update(othinvRow);
                    //prtyTA.Update(prptyNewR);

                    //Inserts
                    tam.UpdateAll(ds);


                    //update relationships
                    bool refUpdate = false;
                    if (IsOtherApplicantPresent)
                    {
                        othinvRow.PrimaryInvestorID = invRow.Id;
                        refUpdate = true;
                    }

                    if (hasProperty)
                    {
                        //updates references
                        prptyNewR.PrimaryInvestorId = invRow.Id;
                        refUpdate = true;
                    }

                    if (refUpdate)
                    {
                        tam.UpdateAll(ds);
                    }
                }
                catch (SqlException se)
                {
                    return("Error adding new Investor(s): " + se.Message);
                }
            }

            return(null);
        }
예제 #5
0
        protected void ButtonAppAckLetterSentModal_Click(object sender, EventArgs e)
        {
            int id = 0;


            // read current InvAppId
            if (String.IsNullOrEmpty(this.HiddenField1.Value))
            {
                return;
            }
            else if (!Int32.TryParse(this.HiddenField1.Value, out id))
            {
                return;
            }


            //get inv app row form DB for update
            DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter();
            DataUtils.InvestorDS.InvestorApplicationsDataTable dt = new InvestorDS.InvestorApplicationsDataTable();
            dt = dta.GetDataById(id);

            if (dt.Rows.Count != 1)
            {
                throw new ArgumentException(String.Concat("InvestorApplication with Id ", id, " could not be found."), "InvestorApplication.Id");
            }

            DataUtils.InvestorDS.InvestorApplicationsRow currentRow = dt.Rows[0] as InvestorDS.InvestorApplicationsRow;


            if (null != currentRow)
            {
                //bool condApproved = false;

                try
                {
                    //condApproved = (("A" == currentRow.CondCreditDecision) || ("L" == currentRow.CondCreditDecision));
                    if (!String.IsNullOrEmpty(currentRow.CondCreditDecision))
                    {
                        this.txtValidationErrors.Text = "Cannot send a letter of acknowledgement to already conditionally decisioned application.";
                        //currentRow.AutoAcceptedInformed = DateTime.Now;
                        //currentRow.AutoAcceptedInformedBy = "pdvorak";
                        //currentRow.AutoRejectedInformed = DateTime.Now;
                        //currentRow.AutoRejectedInformedBy = "pdvorak";
                        this.DetailsView1.DataBind();
                        return;
                    }
                    else
                    {
                        currentRow.AppAckLetterSent   = DateTime.Now;
                        currentRow.AppAckLetterSentBy = "pdvorak";
                        currentRow.Modified           = currentRow.AppAckLetterSent;
                        currentRow.ModifiedBy         = currentRow.AppAckLetterSentBy;
                        dta.Update(currentRow);
                    }
                }
                catch
                {
                    this.txtValidationErrors.Text = "Error saving update";
                    this.DetailsView1.DataBind();
                    return;
                    //error this app has to be approved first
                }
            }

            Response.Redirect("~/InvestorApplicantsNewAll.aspx");
            return;
        }
예제 #6
0
        /// <summary>
        /// Handler of button "Mark conditional Result as Sent"
        /// </summary>
        /// <param name="sender">originating control</param>
        /// <param name="e">event params</param>
        protected void ButtonCondResultSentModal_Click(object sender, EventArgs e)
        {
            int id = 0;

            id = GetIdFromReqParam();


            if (id <= 0)
            {
                return;
            }
            else if (!Int32.TryParse(this.HiddenField1.Value, out id))
            {
                return;
            }
            //InvestorApplicationDS investor = new InvestorApplicationDS();

            DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorDSTableAdapters.InvestorApplicationsTableAdapter();

            //DataUtils.InvestorApplicationTableAdapters.InvestorApplicationsTableAdapter dta = new DataUtils.InvestorApplicationTableAdapters.InvestorApplicationsTableAdapter();

            DataUtils.InvestorDS.InvestorApplicationsDataTable dt = new InvestorDS.InvestorApplicationsDataTable();
            dt = dta.GetDataById(id);

            if (dt.Rows.Count != 1)
            {
                throw new ArgumentException(String.Concat("InvestorApplication with Id ", id, " could not be found."), "InvestorApplication.Id");
            }

            DataUtils.InvestorDS.InvestorApplicationsRow currentRow = dt.Rows[0] as InvestorDS.InvestorApplicationsRow;


            if (null != currentRow)
            {
                bool?condApproved = false;

                try
                {
                    condApproved = (("A" == currentRow.CondCreditDecision) || ("L" == currentRow.CondCreditDecision));
                    if (condApproved.HasValue)
                    {
                        if (condApproved.Value)
                        {
                            //currentRow.AutoAcceptedInformed = DateTime.Now;
                            //currentRow.AutoAcceptedInformedBy = "pdvorak";
                        }
                        else
                        {
                            //currentRow.AutoRejectedInformed = DateTime.Now;
                            //currentRow.AutoRejectedInformedBy = "pdvorak";
                        }
                    }
                    else
                    {
                        //error this app has to be approved first
                    }
                }
                catch
                {
                    //error this app has to be approved first
                }
            }

            Response.Redirect("~/InvestorApplicantsNewAll.aspx");
        }