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