private void UploadFile(string fullPath)
{
chsi.dat.payFileImports fi = new chsi.dat.payFileImports();
if (this.ddFileType.SelectedValue == "IEHP")
{
chsi.dom.pay.ImportIEHP i = new chsi.dom.pay.ImportIEHP();
i.ImportFile(fullPath);
}
if (this.ddFileType.SelectedValue == "LIHP")
{
chsi.dom.pay.ImportLIHP i = new chsi.dom.pay.ImportLIHP();
i.ImportFile(fullPath);
}
if (this.ddFileType.SelectedValue == "CHG")
{
chsi.dom.pay.ImportCHG i = new chsi.dom.pay.ImportCHG();
i.ImportFile(fullPath);
}
chsi.dat.CHSIEntities db = new chsi.dat.CHSIEntities();
chsi.dat.payFileImports fileImp = db.payFileImports.OrderByDescending(a => a.payFileImport).First();
decimal ratio = decimal.Round((decimal)fileImp.MembersWithVisits / (decimal)fileImp.MemberCount, 2);
int iRatio = (int)(ratio *100);
string sRatio = iRatio.ToString() + "%";
lblMessage.Text = string.Format("Members Added: <b>{0}</b><br/>Members Removed: <b>{1}</b><br/>Total Member Count: <b>{2}</b><br/>Members With Visits: <b>{3}</b><br/>Member/Visit Ratio: <b>{4}</b>",
fileImp.NewMembers, fileImp.DeletedMembers, fileImp.MemberCount, fileImp.MembersWithVisits, sRatio);
}
/// <summary>
/// Deprecated Method for adding a new object to the payFileImports EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTopayFileImports(payFileImports payFileImports)
{
base.AddObject("payFileImports", payFileImports);
}
//update file import table
protected int UpdateFileImportsTable(Payers payer, string fileName)
{
if (fileImport == null)
{
fileImport = new payFileImports();
}
fileImport.DeletedMembers = _deletedMemberCount;
fileImport.NewMembers = _newMemberCount;
fileImport.MemberCount = _activeMemberCount;
fileImport.Filename = fileName;
fileImport.ImportTimeStamp = DateTime.Now;
fileImport.Month = DateTime.Now.Month;
fileImport.payPayerId = (int)payer;
fileImport.Year = DateTime.Now.Year;
if (fileImport.payFileImport == 0)
{
db.AddTopayFileImports(fileImport);
}
db.SaveChanges();
return fileImport.payFileImport;
}
/// <summary>
/// Create a new payFileImports object.
/// </summary>
/// <param name="payFileImport">Initial value of the payFileImport property.</param>
/// <param name="payPayerId">Initial value of the payPayerId property.</param>
/// <param name="filename">Initial value of the Filename property.</param>
/// <param name="year">Initial value of the Year property.</param>
/// <param name="month">Initial value of the Month property.</param>
/// <param name="importTimeStamp">Initial value of the ImportTimeStamp property.</param>
/// <param name="memberCount">Initial value of the MemberCount property.</param>
/// <param name="newMembers">Initial value of the NewMembers property.</param>
/// <param name="deletedMembers">Initial value of the DeletedMembers property.</param>
/// <param name="membersWithVisits">Initial value of the MembersWithVisits property.</param>
public static payFileImports CreatepayFileImports(global::System.Int32 payFileImport, global::System.Int32 payPayerId, global::System.String filename, global::System.Int32 year, global::System.Int32 month, global::System.DateTime importTimeStamp, global::System.Int32 memberCount, global::System.Int32 newMembers, global::System.Int32 deletedMembers, global::System.Int32 membersWithVisits)
{
payFileImports payFileImports = new payFileImports();
payFileImports.payFileImport = payFileImport;
payFileImports.payPayerId = payPayerId;
payFileImports.Filename = filename;
payFileImports.Year = year;
payFileImports.Month = month;
payFileImports.ImportTimeStamp = importTimeStamp;
payFileImports.MemberCount = memberCount;
payFileImports.NewMembers = newMembers;
payFileImports.DeletedMembers = deletedMembers;
payFileImports.MembersWithVisits = membersWithVisits;
return payFileImports;
}