Example #1
0
        public List <string> LoadData()
        {
            List <string> lERP = new List <string>();

            try
            {
                using (SqlCommand cmd = GetSQLConnection().CreateCommand())
                {
                    cmd.CommandText = "SELECT distinct ItemId FROM[Analize].[dbo].[item_table]";
                    //cmd.ExecuteNonQuery();

                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            lERP.Add(reader["ItemId"].ToString().ToUpper() + ".JPG");
                        }
                    }
                    GetSQLConnection().Close();
                }
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "LoadData");
            }

            return(lERP);
        }
Example #2
0
        public string FindBookmarkIni(string FileName, string Parametar)
        {
            string[] bookmark;
            string   uslov;
            string   rezultat = "";

            try
            {
                bookmark = File.ReadAllLines(Application.StartupPath + "\\" + FileName);

                foreach (var onebookmark in bookmark)
                {
                    if (onebookmark.StartsWith(uslov = Parametar + "="))
                    {
                        rezultat = onebookmark.Substring(uslov.Length, onebookmark.Length - uslov.Length);
                    }
                }
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "FindBookmarkIni");
                //throw;
            }
            return(rezultat);
        }
Example #3
0
        public static List <string> scanDestination(string Path, string Extension)
        {
            List <string> lScanDestination = new List <string>();

            if (Path == string.Empty)
            {
                MessageBox.Show("Destination folder is empty.");
                return(lScanDestination);
            }

            if (!Directory.Exists(Path))
            {
                MessageBox.Show("Destination doesn't exists");
                return(lScanDestination);
            }

            try
            {
                DirectoryInfo d     = new DirectoryInfo(Path);
                FileInfo[]    Files = d.GetFiles("*." + Extension);
                foreach (FileInfo file in Files)
                {
                    lScanDestination.Add(file.Name.ToUpper());
                }
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "scanDestination");
            }

            return(lScanDestination);
        }
Example #4
0
        public static int ResizePicture(String PathPicture, String Extension, String PathResize, int Width, int Height)
        {
            int Count = 0;

            if (PathResize == string.Empty)
            {
                MessageBox.Show("Resized picture is empty");
                return(0);
            }

            if (!Directory.Exists(PathResize))
            {
                MessageBox.Show("Resized picture folder doesn't exists");
                return(0);
            }

            if (PathPicture == string.Empty)
            {
                MessageBox.Show("Destination FTP is empty");
                return(0);
            }

            if (!Directory.Exists(PathPicture))
            {
                MessageBox.Show("Destination FTP folder doesn't exists");
            }

            if (Width == null || Width == 0 || Height == null || Height == 0)
            {
                MessageBox.Show("Invalid resolution");
                return(0);
            }

            try
            {
                Array.ForEach(Directory.GetFiles(PathResize), File.Delete);

                DirectoryInfo d1    = new DirectoryInfo(PathPicture);
                FileInfo[]    Files = d1.GetFiles("*." + Extension);
                foreach (FileInfo file in Files)
                {
                    Util.SaveImage(file.FullName, file.Name, PathResize, Width, Height);
                    Count += 1;
                }

                return(Count);
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "ResizePicture");
                return(0);
            }
        }
Example #5
0
 public static List <string> DifferenceERPDifference(List <string> ERP, List <string> Difference)
 {
     try
     {
         return(ERP.Intersect(Difference).ToList());
     }
     catch (Exception err)
     {
         LogErr.log(err.StackTrace + "++++++++" + err.Message, "DifferenceERPDifference");
         return(null);
     }
 }
Example #6
0
        public static int DownloadFromFTP(List <Tuple <string, string> > Source, List <string> Difference, String User, String Pass, String Path)
        {
            int Count = 0;

            if (Path == string.Empty)
            {
                MessageBox.Show("Destination FTP is empty");
                return(0);
            }

            if (!Directory.Exists(Path))
            {
                Directory.CreateDirectory(Path);
            }


            if (User == string.Empty || Pass == string.Empty)
            {
                MessageBox.Show("Incorrect FTP connection parameter");
                return(0);
            }

            if (Source.Count == 0)
            {
                return(0);
            }

            try
            {
                Array.ForEach(Directory.GetFiles(Path), File.Delete);

                var query = Source.Where(t => Difference.Contains(t.Item1));

                using (WebClient ftpClient = new WebClient())
                {
                    ftpClient.Credentials = new NetworkCredential(User, Pass);

                    foreach (var element in query)
                    {
                        ftpClient.DownloadFile(element.Item2, Path + "\\" + element.Item2.Substring(element.Item2.LastIndexOf('/')));
                        Count += 1;
                    }
                }

                return(Count);
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "DownloadFromFTP");
                return(-1);
            }
        }
Example #7
0
        //metoda koja vrši slanje email poruke
        //public void SendMail(string from, string fromName, ArrayList to, string subject, string messageBody)
        public void SendMail(string from, string fromName, string to, string subject, string messageBody)
        {
            SmtpClient emailClient;

            try
            {
                emailClient      = new SmtpClient(FindBookmarkIni("MailSettings.ini", "MAILSERVER"));
                emailClient.Port = Convert.ToInt32(FindBookmarkIni("MailSettings.ini", "MAILPORT"));

                // Prepare the MailMessage contents
                MailMessage message = new MailMessage();
                message.Subject = subject;
                message.Body    = messageBody;

                MailAddress fromAddress = new MailAddress(from, fromName);
                message.From = fromAddress;

                string[] clan1 = to.Split(new char[] { ';' });

                foreach (string clan in clan1)
                {
                    if (clan != string.Empty)
                    {
                        //myToAL.Add(clan);
                        message.To.Add(new MailAddress(clan));
                        emailClient.Credentials = new System.Net.NetworkCredential(FindBookmarkIni("MailSettings.ini", "MAILUSER"), FindBookmarkIni("MailSettings.ini", "MAILPASSWORD"));
                        emailClient.Send(message);
                        message.To.Clear();
                    }
                }


                // Set the receivers' addresses
                //foreach (string address in to)
                //message.To.Add(new MailAddress(address));

                // set the encoding for the message body
                //message.BodyEncoding = System.Text.Encoding.UTF8;
                //message.SubjectEncoding = System.Text.Encoding.UTF8;

                //emailClient.Credentials = new System.Net.NetworkCredential(FindBookmarkIni("MailSettings.ini", "MAILUSER"), FindBookmarkIni("MailSettings.ini", "MAILPASSWORD"));
                //emailClient.Send(message);
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "SendMail");
                //throw;
            }
        }//SendMail
Example #8
0
        public SqlConnection GetSQLConnection()
        {
            SqlConnection myConnection;

            try
            {
                myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
                myConnection.Open();
                return(myConnection);
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "GetSQLConnection");
                return(null);
            }
        }
Example #9
0
        public static List <string> DifferenceSourceDestination(List <Tuple <string, string> > Source, List <string> Destination)
        {
            if (Source.Count() == 0)
            {
                MessageBox.Show("Source folder is empty.");
                return(null);
            }

            try
            {
                return(Source.Select(t => t.Item1).Except(Destination).ToList());
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "DifferenceSourceDestination");
                return(null);
            }
        }
Example #10
0
        public static int MissingPicture(List <string> ERPItem, List <string> Destination, String Path)
        {
            List <string> lMissingPicture;

            if (ERPItem.Count == 0)
            {
                MessageBox.Show("ERP item is empty");
                return(0);
            }

            if (Destination.Count == 0)
            {
                MessageBox.Show("Destination item is empty");
                return(0);
            }

            if (Path == String.Empty)
            {
                MessageBox.Show("Destination Missing path is empty");
                return(0);
            }

            if (!File.Exists(Path))
            {
                FileStream fs = new FileStream(Path, FileMode.CreateNew);
                fs.Close();
            }

            try
            {
                lMissingPicture = ERPItem.Except(Destination).ToList();
                File.WriteAllLines(Path, lMissingPicture);
                return(lMissingPicture.Count);
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "MissingPicture");
                return(0);
            }
        }
Example #11
0
        public static int CopyResizedPicture(String Source, String Destination, String Extension)
        {
            int Count = 0;

            try
            {
                DirectoryInfo d1    = new DirectoryInfo(Source);
                FileInfo[]    Files = d1.GetFiles("*." + Extension);

                foreach (FileInfo file in Files)
                {
                    File.Copy(file.FullName, Destination + "\\" + file.Name, true);
                    Count += 1;
                }
                return(Count);
            }
            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "CopyResizedPicture");
                return(0);
            }
        }
Example #12
0
        public static List <Tuple <string, string> > scanFTP(String FtpUri, String User, String Pass)
        {
            List <Tuple <string, string> > lScanFTP = new List <Tuple <string, string> >();

            if (FtpUri == string.Empty || User == string.Empty || Pass == string.Empty)
            {
                MessageBox.Show("You must enter parameter for connection on FTP");
                return(lScanFTP);
            }

            try
            {
                Queue <String> folders = new Queue <String>();
                folders.Enqueue("ftp://" + FtpUri + "/");

                while (folders.Count > 0)
                {
                    String        fld      = folders.Dequeue();
                    List <String> newFiles = new List <String>();

                    FtpWebRequest ftp = (FtpWebRequest)FtpWebRequest.Create(fld);
                    ftp.Credentials = new NetworkCredential(User, Pass);
                    ftp.UsePassive  = false;
                    ftp.Method      = WebRequestMethods.Ftp.ListDirectory;
                    using (StreamReader resp = new StreamReader(ftp.GetResponse().GetResponseStream()))
                    {
                        String line = resp.ReadLine();
                        while (line != null)
                        {
                            newFiles.Add(line.Trim());
                            line = resp.ReadLine();
                        }
                    }

                    ftp             = (FtpWebRequest)FtpWebRequest.Create(fld);
                    ftp.Credentials = new NetworkCredential(User, Pass);
                    ftp.UsePassive  = false;
                    ftp.Method      = WebRequestMethods.Ftp.ListDirectoryDetails;
                    using (StreamReader resp = new StreamReader(ftp.GetResponse().GetResponseStream()))
                    {
                        String line = resp.ReadLine();
                        while (line != null)
                        {
                            if (line.Trim().ToLower().StartsWith("d") || line.Contains(" <DIR> "))
                            {
                                String dir = newFiles.First(x => line.EndsWith(x));
                                newFiles.Remove(dir);
                                folders.Enqueue(fld + dir + "/");
                            }
                            line = resp.ReadLine();
                        }
                    }

                    for (int j = 0; j < newFiles.Count; j++)
                    {
                        lScanFTP.Add(new Tuple <string, string>(newFiles[j].ToUpper(), fld + newFiles[j]));
                    }
                }
            }

            catch (Exception err)
            {
                LogErr.log(err.StackTrace + "++++++++" + err.Message, "scanFTP");
            }

            return(lScanFTP);
        }