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); }
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); }
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); }
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); } }
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); } }
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); } }
//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
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); } }
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); } }
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); } }
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); } }
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); }