protected void btnDelete_Click(object sender, EventArgs e)
 {
     if (BAL_Rules.DeleteRecords(ReturnIds()) == true)
     {
         ShowMessage("Record Deleted Successfully.");
         FillGrid();
     }
     else
     {
         ShowMessage("Error in record deletion.");
     }
 }
 protected void btnInActive_Click(object sender, EventArgs e)
 {
     if (BAL_Rules.ActivateRecords(ReturnIds(), false) == true)
     {
         ShowMessage("Record Deactivated succefully");
         FillGrid();
     }
     else
     {
         ShowMessage("Error in record deactivation.");
     }
 }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            if (ValidateInput() == false)
            {
                //Page.Validate("AddCategory");
                if (Page.IsValid == true)
                {
                    //txtLink.Text = Server.HtmlEncode(txtLink.Text);
                    clsRulesProps obj = setInput();

                    if (!string.IsNullOrEmpty(lblMode.Text))
                    {
                        obj.IsActive      = true;
                        obj.DeletedStatus = false;
                        obj.RuleId        = Convert.ToInt32(lblMode.Text);
                        if (BAL_Rules.UpdateRules(obj) == true)
                        {
                            ShowMessage("Record Updated Susseccfully.");
                            FillGrid();
                            ClearInput();
                            lblMode.Text = string.Empty;
                        }
                        else
                        {
                            ShowMessage("Error in record updation.");
                        }
                    }
                    else
                    {
                        obj.IsActive      = true;
                        obj.DeletedStatus = false;
                        if (BAL_Rules.InsertRules(obj, isUpdate: false) == true)
                        {
                            ShowMessage("Record Inserted Susseccfully.");
                            FillGrid();
                            ClearInput();
                        }
                        else
                        {
                            ShowMessage("Error in record insertion.");
                        }
                    }
                }
                else
                {
                    ShowMessage("Some Required Field Missing");
                }
            }
        }
        private void GetRecords(int Id)
        {
            DataTable table = BAL_Rules.GetRuleById(Id);
            {
                txtRuleName.Text = Convert.ToString(table.Rows[0]["RuleName"]);

                //ddlAgeFrom.SelectedValue = Convert.ToString(table.Rows[0]["AgeFrom"]);
                //ddlAgeTo.SelectedValue = Convert.ToString(table.Rows[0]["AgeTo"]);
                //ddlNCAge.SelectedValue = Convert.ToString(table.Rows[0]["NCAge"]);

                //ddlMileageFrom.SelectedValue = Convert.ToString(table.Rows[0]["MileageFrom"]);
                //ddlMileageTo.SelectedValue = Convert.ToString(table.Rows[0]["MileageTo"]);
                //ddlNCMileage.SelectedValue = Convert.ToString(table.Rows[0]["NCMileage"]);


                //SetSelectedVehicleType(Convert.ToString(table.Rows[0]["VehicleType"]));
                //ddlNCBodyType.SelectedValue = Convert.ToString(table.Rows[0]["NCBodyType"]);

                //SetFuelType(Convert.ToString(table.Rows[0]["FuelType"]));
                //ddlNCFuelType.SelectedValue = Convert.ToString(table.Rows[0]["NCFuelType"]);


                //ddlEngineSizeFrom.SelectedValue = Convert.ToString(table.Rows[0]["EngineSizeFrom"]);
                //ddlEngineSizeTo.SelectedValue = Convert.ToString(table.Rows[0]["EngineSizeTo"]);
                //ddlNCEngineSize.SelectedValue = Convert.ToString(table.Rows[0]["NCEngineSize"]);


                //ddlGearbox.SelectedValue = Convert.ToString(table.Rows[0]["Gearbox"]);
                //ddlNCGearbox.SelectedValue = Convert.ToString(table.Rows[0]["NCGearbox"]);

                //ddlDoors.SelectedValue = Convert.ToString(table.Rows[0]["NCGearbox"]);

                txtCAPValueFrom.Text = Convert.ToString(table.Rows[0]["CAPCleanFrom"]);
                txtCAPValueTo.Text   = Convert.ToString(table.Rows[0]["CAPCleanTo"]);

                ddlWantToPay.SelectedValue = Convert.ToString(table.Rows[0]["WantToPay"]);

                ddlIsInPercentage.SelectedValue = Convert.ToString(table.Rows[0]["IsInPercentage"]).ToLower();


                txtPayout.Text = Convert.ToString(table.Rows[0]["Payout"]);
            }
        }
Exemple #5
0
    //public static decimal GetValuationBasedonRules(int iVehicleAge, int iMileage, int iCapClean)
    //{
    //    int TotalCount = 0;
    //    DataTable dtCAPUpdates = BAL_Rules.GetRules(0, 0, "0", out TotalCount);
    //    decimal newValuation = 0;

    //    foreach (DataRow iRow in dtCAPUpdates.Rows)
    //    {
    //        int iAgeFrom = Convert.ToInt32(iRow["AgeFrom"]);
    //        int iAgeTo = Convert.ToInt32(iRow["AgeTo"]);
    //        string NCAge = Convert.ToString(iRow["NCAge"]);

    //        int iMileageFrom = Convert.ToInt32(iRow["MileageFrom"]);
    //        int iMileageTo = Convert.ToInt32(iRow["MileageTo"]);
    //        string NCMileage = Convert.ToString(iRow["NCMileage"]);

    //        int iCAPCleanFrom = Convert.ToInt32(iRow["CAPCleanFrom"]);
    //        int iCAPCleanTo = Convert.ToInt32(iRow["CAPCleanTo"]);

    //        if (iAgeFrom <= iVehicleAge && iAgeTo >= iVehicleAge)
    //        {
    //            if (iMileageFrom <= iMileage && iMileageTo >= iMileage)
    //            {
    //                if (iCAPCleanFrom <= iCapClean && iCAPCleanTo >= iCapClean)
    //                {
    //                    bool isPercentage = Convert.ToBoolean(iRow["IsInPercentage"]);
    //                    bool isPlus = Convert.ToString(iRow["WantToPay"]) == "Over" ? true : false;
    //                    decimal iPayout = Convert.ToDecimal(iRow["Payout"]);
    //                    if (isPercentage)
    //                    {
    //                        if (isPlus)
    //                            newValuation = iCapClean + (iCapClean) * (iPayout / 100);
    //                        else
    //                            newValuation = iCapClean - (iCapClean) * (iPayout / 100);
    //                    }
    //                    else
    //                    {
    //                        if (isPlus)
    //                            newValuation = iCapClean + iPayout;
    //                        else
    //                            newValuation = iCapClean - iPayout;
    //                    }
    //                }
    //            }
    //        }
    //    }
    //    return newValuation;
    //}

    public static double GetValuationBasedonRules(double iCapClean)
    {
        int       TotalCount   = 0;
        DataTable dtCAPUpdates = BAL_Rules.GetRules(0, 0, "0", out TotalCount);
        double    newValuation = iCapClean;

        foreach (DataRow iRow in dtCAPUpdates.Rows)
        {
            int iCAPCleanFrom = Convert.ToInt32(iRow["CAPCleanFrom"]);
            int iCAPCleanTo   = Convert.ToInt32(iRow["CAPCleanTo"]);

            if (iCAPCleanFrom <= iCapClean && iCAPCleanTo >= iCapClean)
            {
                bool   isPercentage = Convert.ToBoolean(iRow["IsInPercentage"]);
                bool   isPlus       = Convert.ToString(iRow["WantToPay"]) == "Over" ? true : false;
                double iPayout      = Convert.ToDouble(iRow["Payout"]);
                if (isPercentage)
                {
                    if (isPlus)
                    {
                        return(newValuation = iCapClean + (iCapClean) * (iPayout / 100));
                    }
                    else
                    {
                        return(newValuation = iCapClean - (iCapClean) * (iPayout / 100));
                    }
                }
                else
                {
                    if (isPlus)
                    {
                        return(newValuation = iCapClean + iPayout);
                    }
                    else
                    {
                        return(newValuation = iCapClean - iPayout);
                    }
                }
            }
        }
        return(newValuation);
    }
        private void FillGrid()
        {
            int TotalCount = 0;

            gvRulesList.PageIndex = gvIndex;
            DataTable table = BAL_Rules.GetRules(gvRulesList.PageIndex, gvRulesList.PageSize, gvRulesList.OrderBy, out TotalCount);

            gvRulesList.VirtualItemCount = TotalCount;
            gvRulesList.DataSource       = table;
            gvRulesList.DataBind();
            if (gvRulesList.Rows.Count > 0)
            {
                lblsearch2.Visible = true;
                ddlPerpage.Visible = true;
                lable123.Visible   = true;
            }
            else
            {
                lblsearch2.Visible = false;
                ddlPerpage.Visible = false;
                lable123.Visible   = false;
            }
        }
Exemple #7
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (!Page.IsValid)
        {
            return;
        }

        /*get the CAPID*/
        /* get the data using CARWEB service */

        CarweBVRRWebService obj = new CarweBVRRWebService();
        string CarRegNumber     = txtRegistration.Text;

        if (!string.IsNullOrEmpty(CarRegNumber))
        {
            CarRegNumber = CarRegNumber.Replace(" ", "").Trim();
        }
        /*Load data from CarWeb*/
        string strURL               = "https://www1.carwebuk.com/CarweBVRRB2Bproxy/carwebvrrwebservice.asmx?op=strB2BGetVehicleByVRM";
        string strUsername          = "******";
        string strPassword          = "******";
        string strClientRef         = "test";
        string strClientDescription = "test";
        string str1Key              = "cf45ht67";
        string strVRM               = CarRegNumber;
        string strVersion           = "0.31.1";

        System.Xml.XmlNode xmlCarWeb = obj.strB2BGetVehicleByVRM(strUsername, strPassword, strClientRef, strClientDescription, str1Key, strVRM, strVersion);
        XmlTextReader      xtr       = new XmlTextReader(xmlCarWeb.OuterXml, XmlNodeType.Element, null);
        DataSet            dataset   = new DataSet();

        dataset.ReadXml(xtr);
        if (dataset != null)
        {
            string strCapID = string.Empty;
            if (dataset.Tables["CapCodes"] != null)
            {
                if (!string.IsNullOrEmpty(Convert.ToString(dataset.Tables["CapCodes"].Rows[0]["Capcodes_ID"])))
                {
                    strCapID = Convert.ToString(dataset.Tables["CapCodes"].Rows[0]["Capcodes_ID"]);
                }
            }
            if (dataset.Tables["CapCode1"] != null)
            {
                if (!string.IsNullOrEmpty(Convert.ToString(dataset.Tables["CapCode1"].Rows[0]["Capcode_part1"])))
                {
                    strCapID = Convert.ToString(dataset.Tables["CapCode1"].Rows[0]["Capcode_part1"]);
                }
            }
            if (dataset.Tables["CapCode2"] != null)
            {
                if (!string.IsNullOrEmpty(Convert.ToString(dataset.Tables["CapCode2"].Rows[0]["Capcode_part1"])))
                {
                    strCapID = Convert.ToString(dataset.Tables["CapCode2"].Rows[0]["Capcode_part1"]);
                }
            }
            if (dataset.Tables["CapCode3"] != null)
            {
                if (!string.IsNullOrEmpty(Convert.ToString(dataset.Tables["CapCode3"].Rows[0]["Capcode_part1"])))
                {
                    strCapID = Convert.ToString(dataset.Tables["CapCode3"].Rows[0]["Capcode_part1"]);
                }
            }
            if (dataset.Tables["CapCode4"] != null)
            {
                if (!string.IsNullOrEmpty(Convert.ToString(dataset.Tables["CapCode4"].Rows[0]["Capcode_part1"])))
                {
                    strCapID = Convert.ToString(dataset.Tables["CapCode4"].Rows[0]["Capcode_part1"]);
                }
            }
            if (dataset.Tables["CapCode5"] != null)
            {
                if (!string.IsNullOrEmpty(Convert.ToString(dataset.Tables["CapCode5"].Rows[0]["Capcode_part1"])))
                {
                    strCapID = Convert.ToString(dataset.Tables["CapCode5"].Rows[0]["Capcode_part1"]);
                }
            }
            if (dataset.Tables["CapCode6"] != null)
            {
                if (!string.IsNullOrEmpty(Convert.ToString(dataset.Tables["CapCode6"].Rows[0]["Capcode_part1"])))
                {
                    strCapID = Convert.ToString(dataset.Tables["CapCode6"].Rows[0]["Capcode_part1"]);
                }
            }
            if (dataset.Tables["CapCode7"] != null)
            {
                if (!string.IsNullOrEmpty(Convert.ToString(dataset.Tables["CapCode7"].Rows[0]["Capcode_part1"])))
                {
                    strCapID = Convert.ToString(dataset.Tables["CapCode7"].Rows[0]["Capcode_part1"]);
                }
            }

            if (!string.IsNullOrEmpty(strCapID))
            {
                if (dataset.Tables["vehicle"] != null)
                {
                    string lblRegistration = Convert.ToString(dataset.Tables["vehicle"].Rows[0]["VRM_Curr"]);
                    string lblManufacturer = Convert.ToString(dataset.Tables["vehicle"].Rows[0]["DVLA_Make"]);
                    string lblModel        = Convert.ToString(dataset.Tables["vehicle"].Rows[0]["DVLA_Model"]);
                    string lblModelYear    = Convert.ToString(dataset.Tables["vehicle"].Rows[0]["DVLAYearOfManufacture"]);
                    string lblColour       = Convert.ToString(dataset.Tables["vehicle"].Rows[0]["ColourCurrent"]);
                    string lblEngineSize   = Convert.ToString(dataset.Tables["vehicle"].Rows[0]["EngineCapacity"]) + " cc";
                    string lblTransmission = Convert.ToString(dataset.Tables["vehicle"].Rows[0]["Transmission"]);
                    string lblRegistered   = Convert.ToString(dataset.Tables["vehicle"].Rows[0]["DateFirstRegistered"]);

                    //get the car valuation
                    string strYear           = Convert.ToDateTime(lblRegistered).Year.ToString();
                    string strMonth          = Convert.ToDateTime(lblRegistered).Month.ToString();
                    string strCurrentMileage = Convert.ToString(Convert.ToInt32(txtMileage.Text) * 1000);

                    //lblError.Text = strCapID + " " + strYear + " " + strMonth + " " + strCurrentMileage;
                    DataTable dtResult = BAL_Valuation.GetValuationAdmin(strCapID, Convert.ToInt32(strYear), Convert.ToInt32(strMonth), strCurrentMileage, rbValuationType.SelectedValue.ToString());
                    gvValuation.DataSource = dtResult;
                    gvValuation.DataBind();


                    if (dtResult.Rows.Count > 0)
                    {
                        //strYear -> its a registration year so we can get the age by current year - strYear
                        int iVehicleAge = DateTime.Now.Year - Convert.ToInt32(strYear);
                        int iMileage    = Convert.ToInt32(strCurrentMileage);
                        int iCapClean   = Convert.ToInt32(dtResult.Rows[0]["uvt_average"]);

                        double newValuation = BAL_Rules.GetValuationBasedonRules(iCapClean);

                        log.Debug("Admin Valuation -> Old Valuation : " + Convert.ToString(dtResult.Rows[0]["uvt_average"]) + " New Valuation: " + newValuation.ToString());
                        lblCarValuation.Text = newValuation.ToString();

                        //lblCarValuation.Text = Convert.ToString(dtResult.Rows[0]["uvt_average"]);
                    }

                    btnBookanAppointment.Enabled = true;
                }
                else if (dataset.Tables["Details"] != null)
                {
                    lblError.Text = "Can't found the CAPID, Please enter correct number plate";
                }
            }
            else
            {
                lblError.Text = "Can't found the CAPID, Please try again";
            }
        }
    }
Exemple #8
0
    protected void btnGetValuation_Click(object sender, EventArgs e)
    {
        try
        {
            if (Page.IsValid)
            {
                log.Debug("Entered code");
                Session["saluation"]    = ddlSaluation.SelectedItem.Text;
                Session["CustomerName"] = txtFirstName.Text + " " + txtLastName.Text;
                Session["Lastname"]     = txtLastName.Text;
                Session["Phonenumber"]  = txtPhoneNumber.Text;
                Session["EmailAddress"] = txtEmailAddress.Text;
                Session["PostCode"]     = txtPostcode.Text;
                Session["CarPlate"]     = ((clsCarselection)(Session["userdata"])).CarPlate;

                if (!chkAgree.Checked)
                {
                    lblMsg.ForeColor = System.Drawing.Color.Red;
                    lblMsg.Text      = "Please select";
                    return;
                }
                if (Session["userdata"] != null)
                {
                    try
                    {
                        DataTable dt = new DataTable();
                        /*Session["getCurrentTime"] = System.DateTime.Now;*/

                        log.Debug("Getting valuation");

                        /*here we have called -1 year*/
                        dt = BAL_Valuation.GetValuation(((clsCarselection)(Session["userdata"])).CapId.ToString(), -1, Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Month, ((clsCarselection)(Session["userdata"])).cs2_CurrentMileage + "!!" + Convert.ToString(Session["SValuation"]));

                        if (dt != null)
                        {
                            int iYear  = Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Year;
                            int iMonth = Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Month;

                            DataTable dt1 = new DataTable();
                            dt1 = BAL_Valuation.GetValuation(((clsCarselection)(Session["userdata"])).CapId.ToString(), iYear, iMonth, ((clsCarselection)(Session["userdata"])).cs2_CurrentMileage + "!!" + Convert.ToString(Session["SValuation"]));

                            if (dt1.Rows.Count > 0)
                            {
                                dt.Clear();
                                dt = dt1;
                            }

                            //if (dt.Rows.Count == 0)
                            //{
                            //    int iYear = Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Year;
                            //    int iMonth = Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Month;

                            //    dt = BAL_Valuation.GetValuation(((clsCarselection)(Session["userdata"])).CapId.ToString(), iYear, iMonth, ((clsCarselection)(Session["userdata"])).cs2_CurrentMileage + "!!" + Convert.ToString(Session["SValuation"]));
                            //}
                            //else
                            //{
                            //    if (Convert.ToInt32(dt.Rows[0]["Uvt_Month"]) != Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Month)
                            //    {
                            //        int iYear = Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Year;
                            //        int iMonth = Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Month;

                            //        dt = BAL_Valuation.GetValuation(((clsCarselection)(Session["userdata"])).CapId.ToString(), iYear, iMonth, ((clsCarselection)(Session["userdata"])).cs2_CurrentMileage + "!!" + Convert.ToString(Session["SValuation"]));
                            //    }
                            //}
                        }
                        else
                        {
                            int iYear  = Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Year;
                            int iMonth = Convert.ToDateTime(((clsCarselection)(Session["userdata"])).FirstRegister).Month;

                            dt = BAL_Valuation.GetValuation(((clsCarselection)(Session["userdata"])).CapId.ToString(), iYear, iMonth, ((clsCarselection)(Session["userdata"])).cs2_CurrentMileage + "!!" + Convert.ToString(Session["SValuation"]));
                        }

                        if (dt != null)
                        {
                            if (dt.Rows.Count > 0)
                            {
                                //mail code
                                string strMessage = "Value of Car : Retail - " + dt.Rows[0]["uvt_retail"].ToString() + " | | | Average : " + dt.Rows[0]["uvt_average"].ToString() + " | | | Below - " + dt.Rows[0]["uvt_below"].ToString();
                                log.Debug(strMessage);
                                // CODE BY MARK
                                double capAvg   = 0;
                                double capClean = 0;
                                double capBelow = 0;

                                double dCapAvg   = 0;
                                double dCapClean = 0;
                                double dCapBelow = 0;

                                double.TryParse(dt.Rows[0]["uvt_average"].ToString(), out capAvg);
                                double.TryParse(dt.Rows[0]["uvt_clean"].ToString(), out capClean);
                                double.TryParse(dt.Rows[0]["uvt_below"].ToString(), out capBelow);

                                string strAvg = string.Empty;

                                dCapAvg   = capAvg;
                                dCapBelow = capBelow;
                                dCapClean = capClean;

                                if (capAvg > 0 && capClean > 0)
                                {
                                    XmlDocument xmlDoc = new XmlDocument();
                                    xmlDoc.LoadXml(BAL_Valuation.GetValAdjustmentXML());

                                    // Establish what figures we are going to use
                                    //objcls.IsVan
                                    if (((clsCarselection)(Session["userdata"])).IsVan == false)
                                    {
                                        //getting new valuation
                                        capAvg   = BAL_Rules.GetValuationBasedonRules(capAvg);
                                        capClean = BAL_Rules.GetValuationBasedonRules(capClean);
                                        capBelow = BAL_Rules.GetValuationBasedonRules(capBelow);


                                        log.Debug("New Car Value Based on the Rules -> Clean - " + capClean.ToString() + " | | | Average : " + capAvg.ToString() + " | | | Below - " + capBelow.ToString());

                                        switch (xmlDoc.SelectSingleNode("ValResource/ValType").InnerText)
                                        {
                                        case "0":
                                        {
                                            strAvg = capClean.ToString("F0");
                                            break;
                                        }

                                        case "1":
                                        {
                                            strAvg = capAvg.ToString("F0");
                                            break;
                                        }

                                        case "2":
                                        {
                                            strAvg = capBelow.ToString("F0");
                                            break;
                                        }

                                        case "3":     // Custom calculation
                                        {
                                            strAvg = ((capAvg + capClean) / 2).ToString("F0");
                                            break;
                                        }
                                        }
                                    }
                                    else
                                    {
                                        // Its a van
                                        switch (xmlDoc.SelectSingleNode("ValResource/VanValType").InnerText)
                                        {
                                        case "0":
                                        {
                                            strAvg = capClean.ToString("F0");
                                            break;
                                        }

                                        case "1":
                                        {
                                            strAvg = capAvg.ToString("F0");
                                            break;
                                        }

                                        case "2":
                                        {
                                            strAvg = capBelow.ToString("F0");
                                            break;
                                        }

                                        case "3":     // Custom calculation
                                        {
                                            strAvg = ((capAvg + capClean) / 2).ToString("F0");
                                            break;
                                        }
                                        }
                                    }


                                    // Now check if we are adding any additional stuff
                                    double pounds  = 0;
                                    double percent = 0;

                                    if (((clsCarselection)(Session["userdata"])).IsVan == false)
                                    {
                                        double.TryParse(xmlDoc.SelectSingleNode("ValResource/PoundsMarkup").InnerText, out pounds);
                                        double.TryParse(xmlDoc.SelectSingleNode("ValResource/PercentMarkup").InnerText, out percent);
                                    }
                                    else
                                    {
                                        double.TryParse(xmlDoc.SelectSingleNode("ValResource/VanPounds").InnerText, out pounds);
                                        double.TryParse(xmlDoc.SelectSingleNode("ValResource/VanPercent").InnerText, out percent);
                                    }

                                    if (pounds != 0)
                                    {
                                        double tempVal = double.Parse(strAvg);
                                        tempVal += pounds;
                                        strAvg   = tempVal.ToString("F0");
                                    }
                                    if (percent != 0)
                                    {
                                        double tempVal = double.Parse(strAvg);
                                        tempVal += ((tempVal / 100) * percent);
                                        strAvg   = tempVal.ToString("F0");
                                    }
                                }
                                else
                                {
                                    strAvg = dt.Rows[0]["uvt_average"].ToString();
                                }
                                if (!string.IsNullOrEmpty(strAvg))
                                {
                                    if (strAvg.Contains("."))
                                    {
                                        string[] temp = strAvg.Split('.');

                                        if (temp[1].Length < 2)
                                        {
                                            temp[1] = temp[1] + "00";
                                            strAvg  = temp[0].ToString() + "." + temp[1].Substring(0, temp[1].Length - 1);
                                        }
                                    }
                                }
                                // ROUNDING - move this into it's own class at some point
                                double adjAverage = double.Parse(strAvg);
                                if (adjAverage <= 1000)
                                {
                                    strAvg = ((double)Math.Round(((double)adjAverage) / 10, 0, MidpointRounding.AwayFromZero) * 10).ToString();
                                }
                                else if (adjAverage <= 10000)
                                {
                                    strAvg = ((double)Math.Round(((double)adjAverage) / 25, 0, MidpointRounding.AwayFromZero) * 25).ToString();
                                }
                                else if (adjAverage <= 30000)
                                {
                                    strAvg = ((double)Math.Round(((double)adjAverage) / 50, 0, MidpointRounding.AwayFromZero) * 50).ToString();
                                }
                                else if (adjAverage > 30000)
                                {
                                    strAvg = ((double)Math.Round(((double)adjAverage) / 100, 0, MidpointRounding.AwayFromZero) * 100).ToString();
                                }

                                String strCustFileName = Server.MapPath("~/MailContent") + "\\email.html";

                                StreamReader  srCustHTML = new StreamReader(strCustFileName);
                                StringBuilder sbMessage  = new StringBuilder(srCustHTML.ReadToEnd());
                                srCustHTML.Close();

                                sbMessage.Replace("@avgValue", strAvg);

                                string strFirstName = ddlSaluation.SelectedItem.Text + " " + txtLastName.Text.ToString().Substring(0, 1).ToUpper() + txtLastName.Text.ToString().Substring(1).ToLower();
                                sbMessage.Replace("@firstname", strFirstName);
                                sbMessage.Replace("@footerValue", BAL_CMS.GetDetailsByLinkName("Home Page Footer"));

                                // This is nonsense - use one valuation session variable!
                                Session["CarValuation"] = strAvg;
                                Session["Valuation"]    = strAvg;

                                Utilities.SendMail(ConfigurationManager.AppSettings["adminEmailAddress"], txtEmailAddress.Text, "Value of Vehicle : " + ((clsCarselection)(Session["userdata"])).CarPlate, sbMessage.ToString(), string.Empty);

                                /*Administrator email*/
                                string    strBodyWork = string.Empty;
                                DataTable dtBodyWork  = ((clsCarselection)(Session["userdata"])).cs3_BodyWork;
                                if (dtBodyWork != null)
                                {
                                    if (dtBodyWork.Rows.Count > 0)
                                    {
                                        strBodyWork = "";
                                    }
                                }

                                String strFileName = Server.MapPath("~/MailContent") + "\\carregistrationdetail.html";

                                StreamReader  srHTML = new StreamReader(strFileName);
                                StringBuilder sb     = new StringBuilder(srHTML.ReadToEnd());
                                sb.Replace("@registration", ((clsCarselection)(Session["userdata"])).Registration);
                                sb.Replace("@valuation", "£" + Convert.ToString(strAvg));
                                sb.Replace("@capclean", "£" + Convert.ToString(BAL_Rules.RoundingValues(dCapClean)));
                                sb.Replace("@capaverage", "£" + Convert.ToString(BAL_Rules.RoundingValues(dCapAvg)));
                                sb.Replace("@capbelow", "£" + Convert.ToString(BAL_Rules.RoundingValues(dCapBelow)));
                                sb.Replace("@manufacturer", ((clsCarselection)(Session["userdata"])).Manufacturer);
                                sb.Replace("@model@", ((clsCarselection)(Session["userdata"])).Model);
                                sb.Replace("@modelyear@", ((clsCarselection)(Session["userdata"])).ModelYear);
                                sb.Replace("@colour", ((clsCarselection)(Session["userdata"])).Colour);
                                sb.Replace("@transmission", ((clsCarselection)(Session["userdata"])).Transmission);
                                sb.Replace("@enginesize", ((clsCarselection)(Session["userdata"])).EngineSize);
                                sb.Replace("@firstregistered", ((clsCarselection)(Session["userdata"])).FirstRegister);
                                sb.Replace("@noofdoors", ((clsCarselection)(Session["userdata"])).NoOfDoors);
                                sb.Replace("@bodystyle", ((clsCarselection)(Session["userdata"])).BodyStyle);

                                sb.Replace("@cs2_currentmileage", ((clsCarselection)(Session["userdata"])).cs2_CurrentMileage);
                                sb.Replace("@cs2_carimport", ((clsCarselection)(Session["userdata"])).cs2_CarImport);
                                sb.Replace("@cs2_pregistration", ((clsCarselection)(Session["userdata"])).cs2_PRegistration);
                                sb.Replace("@cs2_insurance", ((clsCarselection)(Session["userdata"])).cs2_Insurance);
                                sb.Replace("@cs2_powners", ((clsCarselection)(Session["userdata"])).cs2_POwners);
                                sb.Replace("@cs2_shistory", ((clsCarselection)(Session["userdata"])).cs2_SHistory);
                                sb.Replace("@cs2_mot", ((clsCarselection)(Session["userdata"])).cs2_MOT);
                                sb.Replace("@cs2_vcondition", ((clsCarselection)(Session["userdata"])).cs2_VCondition);
                                sb.Replace("@cs2_v5", ((clsCarselection)(Session["userdata"])).cs2_V5);
                                sb.Replace("@cs2_ofinance", ((clsCarselection)(Session["userdata"])).cs2_OFinance);

                                sb.Replace("@title", ddlSaluation.SelectedItem.Text);
                                sb.Replace("@firstname", txtFirstName.Text);
                                sb.Replace("@lastname", txtLastName.Text);
                                sb.Replace("@phonenumber", txtPhoneNumber.Text);
                                sb.Replace("@emailaddress", txtEmailAddress.Text);
                                sb.Replace("@postcode", txtPostcode.Text);

                                //Utilities.SendMail("*****@*****.**", "*****@*****.**", "Detailed Report " + ((clsCarselection)(Session["userdata"])).CarPlate, sb.ToString());
                                Utilities.SendMail(ConfigurationManager.AppSettings["adminEmailAddress"], ConfigurationManager.AppSettings["adminEmailAddress"], "Detailed Report " + ((clsCarselection)(Session["userdata"])).CarPlate, sb.ToString(), string.Empty);
                                Utilities.LogVisitor(ddlSaluation.SelectedItem.Text, txtFirstName.Text, txtLastName.Text, txtEmailAddress.Text, ((clsCarselection)(Session["userdata"])).CarPlate.ToString(), Convert.ToString(strAvg));

                                Response.Redirect("~/yourvaluation.aspx", false);
                            }
                            else
                            {
                                ShowMessage("There seems to be a problem with your particular plate, please call the office on 0845 519 0898 and we will provide you with an instant quote over the phone.");
                            }
                        }
                        else
                        {
                            ShowMessage("There seems to be a problem with your particular plate, please call the office on 0845 519 0898 and we will provide you with an instant quote over the phone.");
                        }
                    }
                    catch (Exception ex)
                    {
                        ShowMessage("There seems to be a problem with your particular plate, please call the office on 0845 519 0898 and we will provide you with an instant quote over the phone.");
                        //ShowMessage(ex.Message);
                    }
                }
            }
        }
        catch (Exception ex)
        {
            log.Error("Error in Val", ex);
        }
    }