// private static void SqlWrite(string sUnid) { System.Text.UTF8Encoding str = new System.Text.UTF8Encoding(); try { SqlCommand cmd2; byte[] sB1; if (cn.State != ConnectionState.Open) { cn.Open(); } cmd2 = new SqlCommand("usp_Rtv_Parms", cn); cmd2.CommandType = CommandType.StoredProcedure; string sXmlDoc; SqlDataReader dr; SqlCommandBuilder.DeriveParameters(cmd2); cmd2.Parameters["@unid"].Value = sUnid; dr = cmd2.ExecuteReader(); dr.Read(); sXmlDoc = (string)dr.GetString(0); dr.Close(); dr.Dispose(); string sXmlDoce; sB1 = str.GetBytes(sXmlDoc); // sB1 = str.GetBytes(sXmlDoc); sXmlDoce = Convert.ToBase64String(sB1); sB1 = str.GetBytes(sXmlDoce); // sB1 = str.GetBytes(sXmlDoc); BasicFtp.BasicFTPClient bftp = new BasicFtp.BasicFTPClient( ConfigurationManager.AppSettings["webusername"] , ConfigurationManager.AppSettings["webpassword"] , ConfigurationManager.AppSettings["webhost"]); string sPath = @"/XML/" + sUnid; // if missing build it! try { bftp.MakeDir(sPath); } catch { } sPath += @"/Cust.Xml"; bftp.Username = "******"; bftp.Password = "******"; bftp.Host = @"ccisupportsite.com"; bftp.UploadData(sPath, sB1); } catch (Exception ex) { throw ex; } }
// private static void SqlWrite(string sUnid) { System.Text.UTF8Encoding str = new System.Text.UTF8Encoding(); try { SqlCommand cmd2; byte[] sB1; if (cn.State != ConnectionState.Open) { cn.Open(); } cmd2 = new SqlCommand("usp_Rtv_Parms", cn); cmd2.CommandType = CommandType.StoredProcedure; string sXmlDoc; SqlDataReader dr; SqlCommandBuilder.DeriveParameters(cmd2); cmd2.Parameters["@unid"].Value = sUnid; dr = cmd2.ExecuteReader(); dr.Read(); sXmlDoc = (string)dr.GetString(0); string sXmlDoce; sB1 = str.GetBytes(sXmlDoc); // sB1 = str.GetBytes(sXmlDoc); sXmlDoce = Convert.ToBase64String(sB1); sB1 = str.GetBytes(sXmlDoce); // sB1 = str.GetBytes(sXmlDoc); dr.Close(); cmd2.CommandType = CommandType.Text; cmd2.CommandText = "select keyvalue,value from control.parms " + "where keyvalue in ('host','webusername','webpassword')"; dr = cmd2.ExecuteReader(); while (dr.Read()) { if ((string)dr.GetString(0) == "host") { host = (string)dr.GetString(1); } if ((string)dr.GetString(0) == "webusername") { webusername = (string)dr.GetString(1); } if ((string)dr.GetString(0) == "webpassword") { webpassword = (string)dr.GetString(1); } } BasicFtp.BasicFTPClient bftp = new BasicFtp.BasicFTPClient( LoadSingleUnid.Properties.Settings.Default.webusername , LoadSingleUnid.Properties.Settings.Default.webpassword , LoadSingleUnid.Properties.Settings.Default.Host); string sPath = @"/XML/" + sUnid; // if missing build it! try { bftp.MakeDir(sPath); } catch { } sPath += @"/Cust.Xml"; bftp.UploadData(sPath, sB1); } catch (Exception ex) { throw ex; } }
// private static void SqlWrite(string sUnid) { string host = "ftp://ccisupportsite.com"; string webusername = "******"; string webpassword = "******"; System.Text.UTF8Encoding str = new System.Text.UTF8Encoding(); SqlConnection cn; try { SqlDataReader dr; cn = new SqlConnection("Context Connection=true"); SqlCommand cmd2; byte[] sB1; if (cn.State != ConnectionState.Open) { cn.Open(); } cmd2 = new SqlCommand(); cmd2.Connection = cn; cmd2.CommandType = CommandType.Text; cmd2.CommandText = "select [Keyvalue] , [value] from [control].[parms] " + "where [keyvalue] in ('host','webusername','webpassword')"; dr = cmd2.ExecuteReader(); while (dr.Read()) { if ((string)dr.GetString(0) == "host") { host = (string)dr.GetString(1); } if ((string)dr.GetString(0) == "webusername") { webusername = (string)dr.GetString(1); } if ((string)dr.GetString(0) == "webpassword") { webpassword = (string)dr.GetString(1); } } dr.Close(); dr.Dispose(); cmd2 = new SqlCommand("usp_Rtv_Parms", cn); cmd2.CommandType = CommandType.StoredProcedure; string sXmlDoc; SqlCommandBuilder.DeriveParameters(cmd2); cmd2.Parameters["@unid"].Value = sUnid; dr = cmd2.ExecuteReader(); dr.Read(); sXmlDoc = (string)dr.GetString(0); dr.Close(); dr.Dispose(); string sXmlDoce; sB1 = str.GetBytes(sXmlDoc); // sB1 = str.GetBytes(sXmlDoc); sXmlDoce = Convert.ToBase64String(sB1); sB1 = str.GetBytes(sXmlDoce); // sB1 = str.GetBytes(sXmlDoc); BasicFtp.BasicFTPClient bftp = new BasicFtp.BasicFTPClient( "cooksupport" , "Helpme01" , "ccisupportsite.com"); string sPath = @"/XML/" + sUnid; // if missing build it! try { bftp.MakeDir(sPath); } catch (Exception ex) { } sPath += @"/Cust.Xml"; bftp.UploadData(sPath, sB1); } catch (Exception ex) { throw ex; } }
static int Main(string[] args) { try { int iRes = 0; BasicFtp.BasicFTPClient ftp = new BasicFtp.BasicFTPClient(Properties.Settings.Default.webusername , Properties.Settings.Default.webpassword, Properties.Settings.Default.Host); string sUnid = Convert.ToString(args[0]); if (sUnid.Length == 0) { return(-1); } else { if (args[0] == "/all") { // Lets pull a unid CookWebUtility.xml_instance xmli = new CookWebUtility.xml_instance(); NetworkCredential objCredential = new NetworkCredential("mmoen", "bobbob1", ""); CookCustomers.GetCustomersService cs = new CookCustomers.GetCustomersService(); cs.Credentials = objCredential; cs.Timeout = 600000; cs.PreAuthenticate = true; Console.WriteLine("Retrieving XML Begin!"); xmli.sXmlClean = cs.GETCUSTOMERS("changeor.nsf", "XMLOutput"); StreamWriter sw = new StreamWriter(@"c:\xml.xml"); sw.Write(xmli.sXmlClean); sw.Close(); sw.Dispose(); Console.WriteLine("Retrieving XML Completed!"); xmli.LoadXDoc(); xmli.xml_Configure(); CookWebUtility.DBWrite db = new CookWebUtility.DBWrite(xmli.sView); db.DBProcess(); Console.WriteLine("Ftp Unid Replace Begin!"); CookWebUtility.BldXml.MainSub(); Console.WriteLine("Process Completed!"); //Console.WriteLine("Press Enter Key to End"); //Console.ReadLine(); return(0); } else { // Lets pull a unid CookWebUtility.xml_instance xmli = new CookWebUtility.xml_instance(); NetworkCredential objCredential = new NetworkCredential("mmoen", "bobbob1", ""); CookSingleCustomer.GetCustomersNewService cs = new CookSingleCustomer.GetCustomersNewService(); cs.Credentials = objCredential; cs.Timeout = 600000; cs.PreAuthenticate = true; Console.WriteLine("Retrieving XML Begin!"); xmli.sXmlClean = cs.GETCUSTOMERSNEW("changeor.nsf", "XMLOutput", sUnid); Console.WriteLine("Retrieving XML Completed!"); StreamWriter sw = new StreamWriter(@"c:\xml.xml"); sw.Write(xmli.sXmlClean); sw.Close(); sw.Dispose(); xmli.LoadXDoc(); xmli.xml_Configure(); CookWebUtility.DBWrite db = new CookWebUtility.DBWrite(xmli.sView); db.DBProcessSingle(sUnid); Console.WriteLine("Ftp Unid Replace Begin!"); CookWebUtility.BldXml.MainSub(sUnid); Console.WriteLine("Process Completed!"); // Console.WriteLine("Press Enter Key to End"); // Console.ReadLine(); return(0); } } } catch (Exception ex) { Console.WriteLine(ex.Message + " - BOMBED!"); return(-1); } }