public void UploadImageinformationTest()
        {
            var vehicle = new ImageInformationDto();
            var large   = "https://cvis.iaai.com/thumbnail?imageKeys=18693774~SID~I1";

            vehicle.StockNumber    = "18693774";
            vehicle.FileName       = "18693774_1";
            vehicle.ImageByteArray = new WebClient().DownloadData(large);

            var request = new ImageUploadRequest()
            {
                UserRequestInfo = User, ImageInformation = vehicle
            };
            var uploadStockImage = ImageClient.UploadImageInformation(request);

            Assert.IsTrue(uploadStockImage.WasSuccessful);
        }
Esempio n. 2
0
        public void ProcessImage()
        {
            var connection = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;

            DataSet   imageDS = new DataSet("root");
            DataTable imageDT = new DataTable("stock");

            imageDT.Columns.Add("StockNumber", typeof(string));
            imageDT.Columns.Add("ImageIndex", typeof(int));
            imageDT.Columns.Add("ImageUrl", typeof(string));
            imageDS.Tables.Add(imageDT);

            Dictionary <string, int> push = new Dictionary <string, int>();

            try
            {
                clsLog.LogInfo("ProcessImage - Getting stock numbers for downloading");
                var       ds = clsDB.funcExecuteSQLDS("SP_GETSTOCKNUMBER '" + Environment.MachineName + "'", connection, 300);
                DataTable dt = ds.Tables[0];
                clsLog.LogInfo("ProcessImage - Got stock numbers for downloading");

                dt.Rows.OfType <DataRow>().ToList().ForEach(p =>
                {
                    var imageUrls = GetImage(p["StockNumber"].ToString());
                    clsLog.LogInfo("ProcessImage - Got Image URLs for Stock " + p["StockNumber"].ToString());


                    //if (imageUrls[0] == "Specialty" || imageUrls[0] == "Offsite")
                    //    clsDB.funcExecuteSQL(string.Format("SP_UpdateStockImages @xml='{0}',@stockstatus=3", imageDS.GetXml()), connection);
                    //else if (string.IsNullOrEmpty(imageUrls[0]))
                    //    clsDB.funcExecuteSQL(string.Format("SP_UpdateStockImages @xml='{0}',@stockstatus=2", imageDS.GetXml()), connection);
                    //else
                    //{
                    //    imageDT.Rows.Clear();
                    for (int i = 0; i < 10; i++)
                    {
                        imageDT.Rows.Add(imageDT.NewRow());
                        imageDT.Rows[imageDT.Rows.Count - 1]["StockNumber"] = p["StockNumber"].ToString();
                        imageDT.Rows[imageDT.Rows.Count - 1]["ImageIndex"]  = i;
                        imageDT.Rows[imageDT.Rows.Count - 1]["ImageUrl"]    = imageUrls[i];
                    }
                    //clsDB.funcExecuteSQL(string.Format("SP_UpdateStockImages @xml='{0}'", imageDS.GetXml()), connection);
                    //}
                    clsLog.LogInfo("ProcessImage - HighRes Image URLs saved");


                    clsLog.LogInfo("ProcessImage - Sending Stock Image URLs " + p["StockNumber"].ToString());

                    var pushedSuccessful = true;
                    if (imageUrls[0] == "Specialty" || imageUrls[0] == "Offsite")
                    {
                        push.Add(p["StockNumber"].ToString(), 3);
                    }
                    else if (string.IsNullOrEmpty(imageUrls[0]))
                    {
                        push.Add(p["StockNumber"].ToString(), 2);
                    }
                    else
                    {
                        for (int i = 0; i < 10; i++)
                        {
                            var imageinfo = new ImageInformationDto()
                            {
                                StockNumber    = p["StockNumber"].ToString(),
                                FileName       = p["StockNumber"].ToString() + "_" + i,
                                ImageByteArray = GetImageBytes(imageUrls[i])
                            };

                            clsLog.LogInfo("ProcessImage - Sending Stock Image URLs " + p["StockNumber"].ToString() + " Index " + i);
                            var request = new ImageUploadRequest()
                            {
                                UserRequestInfo = User, ImageInformation = imageinfo
                            };
                            var response = ImageClient.UploadImageInformation(request);
                            if (response.WasSuccessful)
                            {
                                clsLog.LogInfo("ProcessImage - Sent Stock Image URLs " + p["StockNumber"] + "_" + i);

                                File.Delete(imageUrls[i]);
                            }
                            else
                            {
                                pushedSuccessful = false;
                                clsLog.LogError("ProcessImage - Unable to send Stock Image URLs " + p["StockNumber"] + "_" + i);
                            }
                        }

                        if (!push.Keys.ToList().Exists(e => p["StockNumber"].ToString() == e))
                        {
                            push.Add(p["StockNumber"].ToString(), pushedSuccessful ? 1 : 5);
                        }
                    }

                    //clsDB.funcExecuteSQL(string.Format("SP_UpdatePushedStatus @stocknumbers='{0}', @status='{1}'", p["StockNumber"].ToString(), pushedSuccessful ? 1 : 5), connection);
                });



                //-------------------------------------
                clsDB.funcExecuteSQL(string.Format("SP_UpdateStockImages @xml='{0}'", imageDS.GetXml()), connection);
                clsDB.funcExecuteSQL(string.Format("SP_UpdatePushedStatus @stocknumbers='{0}', @status='{1}'", string.Join(",", push.Keys), string.Join(",", push.Values)), connection);
            }
            catch (Exception ex)
            {
                clsLog.LogError("ProcessImage - Error while executing. " + ex.Message);
            }
        }
Esempio n. 3
0
        //run every 10 minutes
        public bool PushImageData()
        {
            bool successWhilePushing = true;

            try
            {
                clsLog.LogInfo("PushImageData - Getting StockImage URLs to push");

                var       connection = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;
                DataTable dt         = new DataTable();

                using (SqlConnection con = new SqlConnection(connection))
                    using (SqlCommand cmd = new SqlCommand("dyndata.dbo.SP_PUSHIMAGEDATA", con))
                    {
                        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                        {
                            cmd.CommandType = CommandType.StoredProcedure;
                            da.Fill(dt);
                        }
                    }
                var stocks = dt.Rows.OfType <DataRow>().ToList().ConvertAll(c => new Stock()
                {
                    ImageIndex = Convert.ToInt16(c["imageindex"]), ImageURL = c["ImageUrl"].ToString().Trim(), StockNumber = c["stocknumber"].ToString().Trim()
                });
                var stack = new ConcurrentStack <Stock>(stocks);

                clsLog.LogInfo("PushImageData - Got StockImage URLs to push");


                Parallel.ForEach(stack, new ParallelOptions()
                {
                    MaxDegreeOfParallelism = 10
                }, p =>
                                 //stocks.ForEach(p =>
                {
                    clsLog.LogInfo("PushImageData - Sending Stock Image URLs " + p.StockNumber);

                    var imageinfo = new ImageInformationDto()
                    {
                        StockNumber    = p.StockNumber,
                        FileName       = p.StockNumber + "_" + p.ImageIndex,
                        ImageByteArray = GetImageBytes(p.ImageURL)
                    };

                    try
                    {
                        var request = new ImageUploadRequest()
                        {
                            UserRequestInfo = User, ImageInformation = imageinfo
                        };
                        var response = ImageClient.UploadImageInformation(request);
                        if (response.WasSuccessful)
                        {
                            clsLog.LogInfo("PushImageData - Sent Stock Image URLs " + p.StockNumber + "_" + p.ImageIndex);
                            p.Pushed = true;

                            File.Delete(p.ImageURL);
                        }
                        else
                        {
                            clsLog.LogInfo("PushImageData - Unable to send Stock Image URLs " + p.StockNumber + "_" + p.ImageIndex);
                        }
                    }
                    catch (Exception ex1)
                    {
                        clsLog.LogError("PushImageData - Error while sending HighRes stock Image urls. Stock" + p.StockNumber + "_" + p.ImageIndex + " Error " + ex1.Message);
                        successWhilePushing = false;
                    }
                });

                using (SqlConnection con = new SqlConnection(connection))
                {
                    con.Open();
                    using (SqlCommand cmd = new SqlCommand("dyndata.dbo.SP_UpdatePushedStatus", con))
                        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                        {
                            cmd.CommandType = CommandType.StoredProcedure;
                            cmd.Parameters.AddWithValue("@stocknumbers", string.Join(",", stack.Where(w => w.Pushed).Select(s => s.StockNumber).ToArray()));
                            cmd.ExecuteNonQuery();
                        }
                    con.Close();
                }
            }
            catch (Exception ex)
            {
                clsLog.LogError("PushImageData - Error while sending HighRes stock Image urls. Error " + ex.Message);
            }

            return(successWhilePushing);
        }