private void btnSearch_Click(object sender, EventArgs e)
{
// If the user entered a Customer ID
if (txtSearchCustomer.Text != "")
{
// convert to integer and then find customer in soloserver
//int numCustID = Convert.ToInt32(txtSearchCustomer.Text)
XmlNode result = ApiAccess.searchSWKCustomer(CustID: txtSearchCustomer.Text);
// Check to make sure there was a good node of data back
XmlNode custNode = result.SelectSingleNode("Customer/CompanyName");
if (custNode == null)
{
txtCustInfo.Text = "No data found";
}
else
{
txtCustInfo.Text = custNode.InnerText;
}
}
}
/*
* addLicense - adds single license to SoloServer, plus updates UDF and CustomData,
* returns LicID if assigned, LicPwd and return result
*/
public static Tuple <string, string, string> addLicense(ListBox lstLicBox, string CustomerID, string OptionID, string qty, string purchased, string expire, string activation, string deactivation, string cores, string notes, string SN, string SNID, string LicName, string CData, string LicType, bool testLic)
{
string LicResult = "";
string LicID = "0";
string LicPwd = "";
string udf1 = "";
string udf2 = "";
DateTime thisday = DateTime.Today;
DateTime expireday = thisday.AddDays(45);
// for temp licensed dont indicate purchase date or prev serial number
// in Licensee Name or UDFs
if (LicType == "3temp")
{
udf1 = "45 Day Temporary License";
udf2 = "";
LicName = "45 Day Temp License";
expire = expireday.ToString("d");
}
else
{
udf1 = "Prev Serial Num: " + SN;
// this function trims time from date
string[] aryParts = purchased.Split(' ');
if (aryParts.Length > 1)
{
udf2 = "Originally Purchased: ";
udf2 += aryParts[0].Trim();
}
}
//AddSWKLicense(string OptionID, string Qty, string expire, string ActCount, string DeactCount, string cores, string note, string custID, bool test)
XmlNode resultAdd = ApiAccess.AddSWKLicense(OptionID, qty, expire, activation, deactivation, cores, notes, CustomerID, LicName, testLic);
// Check to make sure there was a good node of data back
XmlNode LicNode = resultAdd.SelectSingleNode("ResultCode");
if (LicNode == null)
{
LicResult = "Error - No data returned";
}
else if (LicNode.InnerText != "0")
{
LicResult = "Error - Insert : " + LicNode.InnerText;
}
else
{
LicNode = resultAdd.SelectSingleNode("LicenseID");
// txtLicInfo.Text = "LicenseID: " + LicNode.InnerText + " \n ";
LicID = LicNode.InnerText;
LicNode = resultAdd.SelectSingleNode("ActivationPassword");
//txtLicInfo.Text += "ActivationPassword: "******"Added";
// update User Defined fields
//UpdateSWKLicenseFields(string LicID, string LicPwd, string UDF1, string UDF2, string UDF3)
XmlNode resultUpdUDF = ApiAccess.UpdateSWKLicenseFields(LicID, LicPwd, udf1, udf2, "");
//Check results of update
XmlNode LicUpdUDF = resultUpdUDF.SelectSingleNode("ResultCode");
if (LicUpdUDF == null)
{
LicResult += " | UDF result: null";
}
else if (LicUpdUDF.InnerText != "0")
{
LicResult += " | UDF Error: " + LicUpdUDF.InnerText;
}
else
{
LicResult += " | UDF Added";
}
// update CustomData
//UpdateSWKLicenseCData(string LicID, string cdata)
//build Custom Data
//string inputCData = "<CustomParameters><IsLease>False</IsLease><IsExecsOverride>True</IsExecsOverride><ExecsAllowed>x</ExecsAllowed><KeyLength>256</KeyLength><Instances>31</Instances><MaxSize>65536</MaxSize><NumProcesses>63</NumProcesses><NumFiles>128</NumFiles><IsGUIsAllowed>True</IsGUIsAllowed><IsCLIAllowed>False</IsCLIAllowed><IsTimeLtd>False</IsTimeLtd></CustomParameters>";
// make the call to update custom data
XmlNode resultUpdCData = ApiAccess.UpdateSWKLicenseCData(LicID, CData);
//Check results of update
XmlNode LicUpdCData = resultUpdCData.SelectSingleNode("ResultCode");
if (LicUpdCData == null)
{
LicResult += " | CData result: null";
}
else if (LicUpdCData.InnerText != "0")
{
LicResult += " | CData Error: " + LicUpdCData.InnerText;
}
else
{
LicResult += " | CData Added";
}
}
return(new Tuple <string, string, string>(LicID, LicPwd, LicResult));
}
/*
* procAccounts - by range, single or allfrom SQL - fill the passed-in Cust list box with the names of processed accounts and
* License lst box with processed licenses
*/
public static void procAccounts(int searchtype, string clientid1, string clientid2, ListBox lstCustBox, ListBox lstLicBox, bool test, bool custonly)
{
lstCustBox.Items.Clear();
lstLicBox.Items.Clear();
string AddCustResult = "";
bool SkipError = false;
string newCustID = "";
//Set up file names to send results
// Set a variable to the Documents path.
string docPath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
//create file name
DateTime d = DateTime.Now;
string dateString = d.ToString("yyyyMMddHHmmss");
string custfilename = "customers-" + dateString + ".txt";
string custfullpath = Path.Combine(docPath, custfilename);
string licfilename = "licenses-" + dateString + ".txt";
string licfullpath = Path.Combine(docPath, licfilename);
// Write header line to a new results files
string custfiletext = "AcctName \t ClientID: \t Add Result \t LicResult" + Environment.NewLine;
File.WriteAllText(custfullpath, custfiletext);
string licfiletext = "AcctName \t clientID \t SerialNum \t LicType \t CustomerID \t AddLicResult \t LicID \t LicPW \t AddLicNotes" + Environment.NewLine;
File.WriteAllText(licfullpath, licfiletext);
// Open connection to SQL Server
string connectionString = ConfigurationManager.ConnectionStrings["NetlibApi1.Properties.Settings.custdb"].ConnectionString;
SqlConnection dbConAcct = new SqlConnection(connectionString); // "Server= 192.168.86.33;Database=SWKExchange;User Id=swkdata;Password=MollyLinus;"
dbConAcct.Open();
// Command
DbCommand dbCmdAcct = dbConAcct.CreateCommand();
// search all
if (searchtype == 1)
{
dbCmdAcct.CommandText = "select * from AcctContact order by AccountID";
}
else
//search single
if (searchtype == 2)
{
dbCmdAcct.CommandText = "select * from AcctContact";
dbCmdAcct.CommandText += " where ClientID = '" + clientid1 + "'";
dbCmdAcct.CommandText += " order by ClientID";
}
else
//search Range
{
dbCmdAcct.CommandText = "select * from AcctContact";
dbCmdAcct.CommandText += " where ClientID BETWEEN '" + clientid1 + "' and '" + clientid2 + "'";
dbCmdAcct.CommandText += " order by ClientID";
}
// Get the data
DbDataReader rsDataAcct = dbCmdAcct.ExecuteReader();
if (rsDataAcct.HasRows)
{
while (rsDataAcct.Read())
{
string AcctName = rsDataAcct["AccountName"].ToString();
string clientID = rsDataAcct["ClientID"].ToString();
string Acctid = rsDataAcct["AccountID"].ToString();
// Has this customer been added to Soloserver previously
string SWCustomerID = rsDataAcct["SWCustomerID"].ToString();
if (SWCustomerID == "")
{
// add Account to SoloServer
string firstName = rsDataAcct["FirstName"].ToString();
string lastName = rsDataAcct["LastName"].ToString();
string address1 = rsDataAcct["AddressLine1"].ToString();
string address2 = rsDataAcct["AddressLine2"].ToString();
string city = rsDataAcct["City"].ToString();
string state = rsDataAcct["StateProvince"].ToString();
string zip = rsDataAcct["PostalCode"].ToString();
string country = rsDataAcct["Country"].ToString();
string email = rsDataAcct["Email"].ToString();
string pwd = rsDataAcct["dnld_userpw"].ToString();
string nickname = "GMClientID: " + rsDataAcct["GMClientID"].ToString();
int newId = ApiAccess.addSWKCustomer(AcctName, firstName, lastName, address1, address2, city, state, zip, country, email, pwd, "", "", nickname);
if (newId < 0)
{
// Error with SWK add
AddCustResult = "Add Error: " + newId.ToString();
SkipError = true;
}
else
{
// successful SWK add
newCustID = newId.ToString();
AddCustResult = "Added: " + newCustID + "pw: " + pwd;
// update Account record in SQL with SWK data
string updResult = DataAccess.updateCustSWKData(Acctid, newCustID, pwd, email, "Insert");
AddCustResult += " " + updResult;
}
}
else
{
// has been previously added according to Account Record
// confirm customer on SoloServer and then process licenses.
newCustID = SWCustomerID;
AddCustResult = "Prev Add: " + newCustID;
}
if (custonly)
{
SkipError = true;
}
string licResult = "";
if (SkipError)
{ // dont process licenses
licResult = "Skipped Licenses";
}
else
{
// get licenses for this AcctID
int licensesProcessed;
licensesProcessed = ImportData.procLicenses(Acctid, newCustID, AcctName, clientID, lstLicBox, licfullpath, test);
licResult = "Lic: " + licensesProcessed.ToString();
}
//list customers processed in box and results file
custfiletext = AcctName + " \t ClientID: " + clientID + " \t Add Result: " + AddCustResult + " \t " + licResult;
lstCustBox.Items.Add(custfiletext);
File.AppendAllText(custfullpath, custfiletext + Environment.NewLine);
}
}
// Close Connection
dbConAcct.Close();
}
private void btnAddLicense_Click(object sender, EventArgs e)
{
//AddSWKLicense(string OptionID, string Qty, string expire, string ActCount, string DeactCount, string cores, string note, string custID, bool test)
XmlNode resultAdd = ApiAccess.AddSWKLicense("1036", "3", "12/31/2020", "1", "0", "12", "a note goes here", "4400028", "", checkBoxTest.Checked);
// Check to make sure there was a good node of data back
XmlNode LicNode = resultAdd.SelectSingleNode("ResultCode");
if (LicNode == null)
{
txtLicInfo.Text = "No data found";
}
else if (LicNode.InnerText != "0")
{
txtLicInfo.Text = "Insert Error: " + LicNode.InnerText;
}
else
{
LicNode = resultAdd.SelectSingleNode("LicenseID");
txtLicInfo.Text = "LicenseID: " + LicNode.InnerText + " \n ";
string LicID = LicNode.InnerText;
LicNode = resultAdd.SelectSingleNode("ActivationPassword");
txtLicInfo.Text += "ActivationPassword: "******"Previous Serial Number: 001-204290-001-001-0", "udf2", "udf3");
//Check results of update
XmlNode LicUpdUDF = resultUpdUDF.SelectSingleNode("ResultCode");
if (LicUpdUDF == null)
{
txtLicInfo.Text += " UDF result: null";
}
else if (LicUpdUDF.InnerText != "0")
{
txtLicInfo.Text += " UDF Error: " + LicUpdUDF.InnerText;
}
else
{
txtLicInfo.Text += " UDF Added";
}
// update CustomData
//UpdateSWKLicenseCData(string LicID, string cdata)
//build Custom Data
string inputCData = "<CustomParameters><IsServer>True</IsServer><IsExecsOverride>False</IsExecsOverride><ExecsAllowed>Example String Value</ExecsAllowed><SQLEdition>4</SQLEdition><IsWholeDB>True</IsWholeDB><IsColumn>True</IsColumn><KeyLength>256</KeyLength><IsFolder>True</IsFolder><Instances>31</Instances><SysIdent>True</SysIdent></CustomParameters>";
// make the call to update custom data
XmlNode resultUpdCData = ApiAccess.UpdateSWKLicenseCData(LicID, inputCData);
//Check results of update
XmlNode LicUpdCData = resultUpdCData.SelectSingleNode("ResultCode");
if (LicUpdCData == null)
{
txtLicInfo.Text += " CData result: null";
}
else if (LicUpdCData.InnerText != "0")
{
txtLicInfo.Text += " CData Error: " + LicUpdCData.InnerText;
}
else
{
txtLicInfo.Text += " CData Added";
}
}
}
