private void UpdateDid(Info did)
{
SqlConnection dataConnection = null;
try
{
StringBuilder cmdStr = new StringBuilder("UPDATE DID SET DidStateId = 4, SPId = " + did.SPID + ",");
cmdStr.Append(" GroupId = " + did.GroupNum + " WHERE DID = '" + did.DID + "'");
// make the connection
OpenDataConn(ref dataConnection);
try
{
SqlCommand sqlCommand = new SqlCommand(cmdStr.ToString(), dataConnection);
sqlCommand.CommandType = CommandType.Text;
sqlCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
LogFileError("BWorksDNListParser::UpdateDid():ECaught:" + ex.Message + ex.StackTrace);
}
}//try
catch (Exception ex)
{
LogFileError("BWorksDNListParser::UpdateDid():ECaught:" + ex.Message + ex.StackTrace);
}
CloseDataConn(ref dataConnection);
}
/// <summary>
/// private method to parse the dids in the file
/// </summary>
/// <param name="fileName"></param>
/// <returns></returns>
private ArrayList ParseTheDIDs(string fileName)
{
// make the array size (number of cdrs per file ) configurable
System.Collections.ArrayList theControls = new System.Collections.ArrayList(1000);
char[] sep = new char[] { ',' };
char[] trim = new char[] { ' ' };
bool newGroup = false;
int groupNumber = 0;
try
{
using (StreamReader sr = new StreamReader(fileName))
{
String line;
while ((line = sr.ReadLine()) != null)
{
try
{
// parse the line
string[] controls = line.Split(sep);
if (controls[0].Contains("<command") )
{
newGroup = true;
// we have a non-data line -- header or footer... so skip it
continue;
}
else if ( controls[0].Contains("</command") )
{
newGroup = false;
groupNumber++;
continue;
}
else if (controls[0].Contains("phoneNumber") )
{
int indx = controls[0].IndexOf(">");
string did = controls[0].Substring(indx+1, 10 );
Info info = new Info();
info.DID = did;
info.GroupName = groups[groupNumber];
info.GroupNum = groupNum[groupNumber];
info.SPID = spId[groupNumber];
theControls.Add( info );
}
}
catch (System.Exception ex)
{
string errorMsg = "Error in File>" + fileName + " Line>" + groupNumber;
if (line != null)
{// add the line information if available
errorMsg += "Line>" + line;
}
LogFileError(errorMsg + "\r\n" + ex.Message + "\r\n" + ex.StackTrace);
}
}
}
}// try
catch (Exception e)
{
LogFileError(e.Message + "\r\n" + e.StackTrace);
}// catch
return theControls;
}
