public int runTest()
{
try
{
// Send the Property File (FTP)
Wakefield wake = new Wakefield();
var getLastCollection = db.collections.OrderByDescending(c => c.CollectionsID).Select(a => a.CollectionsID).First();
string ftpPath = wake.ftp + wake.ftpFolder + "Collection" + getLastCollection.ToString() + ".csv";
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(ftpPath);
request.Method = WebRequestMethods.Ftp.UploadFile;
WebClient client = new WebClient();
Byte[] fileBytes = client.DownloadData("http://myirent.com/beta/collection.csv");
//byte[] fileBytes = Encoding.Default.GetBytes(sb.ToString());
//Enter FTP Server credentials
request.Credentials = new NetworkCredential(wake.UserName, wake.Password);
request.ContentLength = fileBytes.Length;
request.UsePassive = true;
request.UseBinary = true;
request.ServicePoint.ConnectionLimit = fileBytes.Length;
request.EnableSsl = true;
using (Stream requestStream = request.GetRequestStream())
{
requestStream.Write(fileBytes, 0, fileBytes.Length);
requestStream.Close();
}
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
// Send Email
SendUsEmail message = new SendUsEmail();
message.sendAlert(response.StatusCode + ": " + response.StatusDescription, "Test FTP Send to Collection");
response.Close();
} catch (Exception any)
{
Console.Write(any.ToString());
SendUsEmail error = new SendUsEmail();
error.sendError(any.ToString(), "Test FTP Send to Collections Error");
}
return(0);
}
public PostRecurringBills()
{
try
{
var GetRecurringBillsUpdate = (from rb in db.recurringbills
join pm in db.postmethods on rb.PostMethodID equals pm.PostMethodID
join f in db.frequencies on rb.FrequencyID equals f.FrequencyID
join p in db.properties on rb.PropertyID equals p.PropertyID
join et in db.expensetypes on rb.ExpenseTypeID equals et.ExpenseTypeID
join v in db.vendors on rb.VendorID equals v.VendorID
select rb).ToList();
// If first pay date is in the past, update to today
foreach (var rBills in GetRecurringBillsUpdate)
{
if (rBills.FirstPayDate < DateTime.Now)
{
rBills.FirstPayDate = DateTime.Now;
db.SaveChanges();
}
}
var GetRecurringBills = (from rb in db.recurringbills
join pm in db.postmethods on rb.PostMethodID equals pm.PostMethodID
join f in db.frequencies on rb.FrequencyID equals f.FrequencyID
join p in db.properties on rb.PropertyID equals p.PropertyID
join et in db.expensetypes on rb.ExpenseTypeID equals et.ExpenseTypeID
join v in db.vendors on rb.VendorID equals v.VendorID
where rb.FirstPayDate == DateTime.Now && rb.PostMethodID == 1
select rb).ToList();
foreach (var rBills in GetRecurringBills)
{
// Add Bill
checkregister cr = new checkregister();
cr.PropertyID = rBills.PropertyID;
cr.VendorID = rBills.VendorID;
cr.Amount = rBills.Amount;
cr.Memo = rBills.Memo;
cr.ExpenseTypeID = rBills.ExpenseTypeID;
cr.CheckDate = DateTime.Now;
cr.TransactionType = 1;
cr.Paid = rBills.Paid;
cr.Reconciled = 0;
cr.Escrow = rBills.Escrow;
cr.InvoiceDate = DateTime.Now;
cr.PaidDate = DateTime.Now;
cr.InvoiceNumber = rBills.InvoiceNumber;
cr.SubmittedBy = 16; // Will User's id
db.checkregisters.Add(cr);
db.SaveChanges();
DateTime nextPayDate = DateTime.Now;
if (rBills.FrequencyID == 1)
{
nextPayDate.AddDays(7);
}
if (rBills.FrequencyID == 2)
{
nextPayDate.AddDays(14);
}
if (rBills.FrequencyID == 3)
{
int days = DateTime.DaysInMonth(nextPayDate.Year, nextPayDate.Month);
days = days / 2;
nextPayDate.AddDays(days);
}
if (rBills.FrequencyID == 4)
{
nextPayDate.AddMonths(1);
}
if (rBills.FrequencyID == 5)
{
nextPayDate.AddMonths(3);
}
if (rBills.FrequencyID == 6)
{
nextPayDate.AddMonths(6);
}
if (rBills.FrequencyID == 7)
{
nextPayDate.AddYears(1);
}
if (rBills.Unlimited != 1)
{
int numPayments = rBills.NumberofPayments - 1;
if (numPayments == 0)
{
db.recurringbills.Remove(rBills);
}
else
{
rBills.NumberofPayments = numPayments;
rBills.FirstPayDate = nextPayDate;
db.SaveChanges();
}
}
else
{
rBills.FirstPayDate = nextPayDate;
db.SaveChanges();
}
}
string msg = "There were " + GetRecurringBills.Count.ToString() + " bills posted.";
SendUsEmail message = new SendUsEmail();
message.sendAlert(msg, "We just posted Recurring Bills.");
} catch (Exception any)
{
SendUsEmail message = new SendUsEmail();
message.sendAlert(any.ToString(), "Error - We just posted Recurring Bills.");
}
}