public string PostDuesPayment(DuesPayment duesPayment)
{
string lodgeFileName = Server.MapPath("\\App_Data\\") + MasonMasterData.GetUserProfile(User.Identity.Name).DatabaseName;
var d = new List<DuesPayment>(); d.Add(duesPayment);
string success = CashDataXml.PostDuesPayment(d, lodgeFileName);
return success;
}
public static List<DuesPayment> GetDuesGrid(string masonicYear, string xmlFileName)
{
var duesPayments = new List<DuesPayment>();
string personId; string firstName; string middleName; string lastName;
XmlNode duesPaymentNode; XmlNode personNode;
XmlDocument xdoc = new XmlDocument();
xdoc.Load(xmlFileName);
XmlNodeList members = xdoc.SelectNodes("//Members/Member");
string currentStatus = "";
string[] desiredStatuses = new[] { "MBA", "MBC", "MBD", "MBG", "MBH", "MBI", "MBE", "MBJ", "LIF" };
//{ "Active", "Endowed Member", "Elected", "Life Member", "Entered Apprentice", "Fellowcraft", "Life & Endowed Mbr", "Petition Read" };
foreach (XmlNode memberNode in members)
{
currentStatus = memberNode.Attributes["Status"].InnerText;
if (desiredStatuses.Contains(currentStatus))
{
var duesPayment = new DuesPayment();
duesPaymentNode = memberNode.SelectSingleNode("DuesPayments/Payment[@MasonicYear='" + masonicYear + "']");
if (duesPaymentNode != null)
{
duesPayment.DuesPaymentId = duesPaymentNode.Attributes["PaymentId"].InnerText;
duesPayment.Amount = duesPaymentNode.Attributes["Amount"].InnerText;
duesPayment.PostedDate = duesPaymentNode.Attributes["PostedDate"].InnerText;
}
else
{
duesPayment.Amount = "";
duesPayment.PostedDate = "";
}
duesPayment.CurrentStatus = xdoc.SelectSingleNode("//Refs/refItem[@refCode='" + currentStatus + "']").Attributes["refDescription"].InnerText;
duesPayment.MasonId = int.Parse(memberNode.Attributes["MasonId"].InnerText);
personId = memberNode.Attributes["PersonId"].InnerText;
personNode = xdoc.SelectSingleNode("//People/Person[@PersonId='" + personId + "']");
firstName = personNode.Attributes["FirstName"].InnerText;
lastName = personNode.Attributes["LastName"].InnerText;
middleName = personNode.Attributes["MiddleName"].InnerText;
duesPayment.FullName = firstName + (middleName == "" ? " " : " " + middleName + " ") + lastName;
duesPayments.Add(duesPayment);
}
}
return duesPayments;
}
public static IList<DuesPayment> GetDuesHistory(int masonId, string xmlFileName)
{
var duesPayments = new List<DuesPayment>();
try
{
XmlDocument xdoc = new XmlDocument();
xdoc.Load(xmlFileName);
XmlNode DuesPaymentsNode = xdoc.SelectSingleNode("//Members//Member[@MasonId='" + masonId + "']//DuesPayments");
if (DuesPaymentsNode != null)
{
foreach (XmlNode payment in DuesPaymentsNode.ChildNodes)
{
var duesPayment = new DuesPayment();
duesPayment.DuesPaymentId = payment.Attributes["PaymentId"].InnerText;
duesPayment.MasonicYear = xdoc.SelectSingleNode("//Refs/refItem[@refCode='" + payment.Attributes["MasonicYear"].InnerText + "']").Attributes["refDescription"].InnerText;
duesPayment.Amount = payment.Attributes["Amount"].InnerText;
duesPayment.PostedDate = payment.Attributes["PostedDate"].InnerText;
duesPayments.Add(duesPayment);
}
}
}
catch (Exception ex) { duesPayments.Add(new DuesPayment() { MasonicYear = ex.Message }); }
return duesPayments;
}