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