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