public void CreateWholeSaleReport()
{
_phoneList = GetUsers();
foreach (string theUser in _phoneList)
{
SprintWholesaleUser u = new SprintWholesaleUser();
u.UserNumber = theUser;
_users.Add(u);
}
// get the voice, sms and data usage for the users
Hashtable sms = this.GetSMSUsage();
Hashtable data = GetDataUsage( );
Hashtable voice = GetVoiceUsage( );
// generate a temporary report for now
foreach ( SprintWholesaleUser u in _users )
{
// get the sms data
//StringBuilder theMsg = new StringBuilder("UsageFor::" + u.UserNumber);
//theMsg.Append(" \t\t**SMS::" + sms[u.UserNumber]);
//theMsg.Append(" \t\t**Data::" + data[u.UserNumber]);
//theMsg.Append(" \t\t**Voice::" + voice[u.UserNumber] + "\r\n");
StringBuilder theMsg = new StringBuilder(u.UserNumber + "," + sms[u.UserNumber] + "," + data[u.UserNumber] + "," + voice[u.UserNumber] );
// for now
LogFileMgr.Instance.WriteToFile(@"d:/apps/logs/SprintMayUsage.txt", theMsg.ToString() );
}
}
public void CreateWholeSaleReport()
{
_phoneList = GetUsers();
foreach (string theUser in _phoneList)
{
SprintWholesaleUser u = new SprintWholesaleUser();
u.UserNumber = theUser;
_users.Add(u);
}
// get the voice, sms and data usage for the users
Hashtable sms = this.GetSMSUsage();
Hashtable data = GetDataUsage( );
Hashtable voice = GetVoiceUsage( );
// generate a temporary report for now
foreach (SprintWholesaleUser u in _users)
{
// get the sms data
//StringBuilder theMsg = new StringBuilder("UsageFor::" + u.UserNumber);
//theMsg.Append(" \t\t**SMS::" + sms[u.UserNumber]);
//theMsg.Append(" \t\t**Data::" + data[u.UserNumber]);
//theMsg.Append(" \t\t**Voice::" + voice[u.UserNumber] + "\r\n");
StringBuilder theMsg = new StringBuilder(u.UserNumber + "," + sms[u.UserNumber] + "," + data[u.UserNumber] + "," + voice[u.UserNumber]);
// for now
LogFileMgr.Instance.WriteToFile(@"d:/apps/logs/SprintMayUsage.txt", theMsg.ToString());
}
}
/// <summary>
/// method to get a list of unique users in the Sprint data
/// </summary>
/// <returns></returns>
public SprintWholesaleUser GetUserInfo(string u)
{
StringBuilder cmdStr = new StringBuilder("SELECT firstName, lastName, GroupId FROM cellPhoneSubscribers ");
string order = "where mdn = '" + u + "' ";
cmdStr.Append(order);
DataSet ds = new DataSet();
SprintWholesaleUser user = new SprintWholesaleUser();
try
{
ds = GetData(cmdStr.ToString());
// make sure there is only one SID/BID returned here
foreach (DataTable myTable in ds.Tables)
{
//r.count = myTable.Rows.Count.ToString();
// only one row with the sidbid
foreach (DataRow myRow in myTable.Rows)
{
user.FirstName = ((String)myRow.ItemArray[0]);
if (!user.FirstName.Equals("FTS"))
{
user.LastName = ((String)myRow.ItemArray[1]);
}
user.GroupId = ((String)myRow.ItemArray[2]);
}
}
}
catch (System.Exception ex)
{
LogFileMgr.Instance.WriteToLogFile("DbProcessor::GetUsers():FailedTryingToGetTheListOfUsers");
LogFileMgr.Instance.WriteToLogFile("ECaught:" + ex.Message + ex.StackTrace);
}
return(user);
}
/// <summary>
/// method to get a list of unique users in the Sprint data
/// </summary>
/// <returns></returns>
public SprintWholesaleUser GetUserInfo(string u)
{
StringBuilder cmdStr = new StringBuilder("SELECT firstName, lastName, GroupId FROM cellPhoneSubscribers ");
string order = "where mdn = '" + u + "' ";
cmdStr.Append(order);
DataSet ds = new DataSet();
SprintWholesaleUser user = new SprintWholesaleUser();
try
{
ds = GetData(cmdStr.ToString());
// make sure there is only one SID/BID returned here
foreach (DataTable myTable in ds.Tables)
{
//r.count = myTable.Rows.Count.ToString();
// only one row with the sidbid
foreach (DataRow myRow in myTable.Rows)
{
user.FirstName=((String)myRow.ItemArray[0]);
if (! user.FirstName.Equals("FTS") )
user.LastName = ((String)myRow.ItemArray[1]);
user.GroupId = ((String)myRow.ItemArray[2]);
}
}
}
catch (System.Exception ex)
{
LogFileMgr.Instance.WriteToLogFile("DbProcessor::GetUsers():FailedTryingToGetTheListOfUsers");
LogFileMgr.Instance.WriteToLogFile("ECaught:" + ex.Message + ex.StackTrace);
}
return user;
}
private SprintWholesaleUser GetUserInfo(string user)
{
SprintWholesaleUser u = _db.GetUserInfo(user);
return(u);
}
public void CreateWholeSaleReport()
{
_phoneList = GetUsers();
foreach (string theUser in _phoneList)
{
// get the user name and group info
SprintWholesaleUser u = GetUserInfo(theUser);
u.UserNumber = theUser;
_users.Add(u);
}
// get the voice, sms and data usage for the users
Hashtable sms = this.GetSMSUsage();
Hashtable data = GetDataUsage();
Hashtable lte = this.GetLTEDataUsage();
Hashtable voice = GetVoiceUsage();
// generate a temporary report for now
foreach (SprintWholesaleUser u in _users)
{
double dataCharge = 0.00;
double smsCharge = 0.00;
double voiceCharge = 0.00;
double lteCharge = 0.00;
if (data[u.UserNumber] != null)
{
dataCharge = GetDataCharge((int)data[u.UserNumber]);
}
if (sms[u.UserNumber] != null)
{
smsCharge = GetSMSCharge((int)sms[u.UserNumber]);
}
if (voice[u.UserNumber] != null)
{
voiceCharge = GetVoiceCharge((int)voice[u.UserNumber]);
}
if (lte[u.UserNumber] != null)
{
lteCharge = GetLTEDataCharge((int)lte[u.UserNumber]);
}
double total = GetTotal(dataCharge, smsCharge, voiceCharge, lteCharge);
try
{
String thePhone = "Phone # " + u.UserNumber + "\t" + u.FirstName + " " + u.LastName + "\t\t\t\t $" + total.ToString("0.00") + "\r\n";
String v = "Voice " + "\t\t\t\t" + voice[u.UserNumber] + "\t\t $" + voiceCharge.ToString("0.00") + "\r\n";
String m = "Messaging" + "\t\t\t" + sms[u.UserNumber] + "\t\t $" + smsCharge.ToString("0.00") + "\r\n";
String d = "Data" + "\t\t\t\t" + data[u.UserNumber] + "\t\t $" + dataCharge.ToString("0.00") + "\r\n";
String l = "LTE" + "\t\t\t\t" + lte[u.UserNumber] + "\t\t $" + lteCharge.ToString("0.00") + "\r\n";
String msg = thePhone + v + m + d + l;
String csvmsg = u.UserNumber + "," + sms[u.UserNumber] + "," + data[u.UserNumber] + "," + voice[u.UserNumber] + "," + lte[u.UserNumber] + "," + smsCharge.ToString("0.00") + "," + dataCharge.ToString("0.00") + "," + voiceCharge.ToString("0.00")
+ "," + lteCharge.ToString("0.00") + "," + total.ToString("0.00") + "," + u.GroupId;
// for now
LogFileMgr.Instance.WriteToFile(@"C:\Users\RobertL\Documents\apps\logs\SprintJuly2015_Usage.txt", msg);
LogFileMgr.Instance.WriteToFile(@"C:\Users\RobertL\Documents\apps\logs\SprintJuly2015_Usage.csv", csvmsg);
}
catch (SystemException se)
{
LogFileMgr.Instance.WriteToLogFile("WholeSaleDataProcessor::CreateWholeSaleReport():ExceptionCaught:" + se.Message);
}
}
}
