public PaymentQuery getUserPayment(long id)
{
try
{
using (conferenceadminContext context = new conferenceadminContext())
{
var paymentInfo = (from s in context.paymentbills
from sp in context.registrations
where s.paymentID == sp.paymentID && s.deleted == false && sp.userID == id && s.completed == true
select new PaymentQuery
{
paymentBillID = s.paymentBillID,
date = s.date,
affiliationName = sp.user.affiliationName,
transactionid = s.transactionid,
AmountPaid = s.AmountPaid,
methodOfPayment = s.methodOfPayment,
firstName = s.firstName,
lastName = s.lastName,
email = s.email,
tandemID = s.tandemID,
batchID = s.batchID,
userFirstName = sp.user.firstName,
userLastName = sp.user.lastName,
type = sp.user.usertype.userTypeName,
description = "User Registration"
}).FirstOrDefault();
if (paymentInfo == null)
{
paymentInfo = (from r in context.paymentcomplementaries
join p in context.complementarykeys on r.complementaryKeyID equals p.complementarykeyID
join pay in context.payments on r.paymentID equals pay.paymentID
join y in context.sponsor2 on p.sponsorID2 equals y.sponsorID
join x in context.registrations on r.paymentID equals x.paymentID
where id == x.userID && x.deleted == false && r.deleted == false && p.deleted == false && pay.deleted == false
select new PaymentQuery
{
paymentBillID = r.paymentcomplementaryID,
complementaryKey = p.key,
date = (DateTime)pay.creationDate,
affiliationName = x.user.affiliationName,
transactionid = "N/A",
AmountPaid = 0,
methodOfPayment = "Complementary Key",
userFirstName = x.user.firstName,
userLastName = x.user.lastName,
email = x.user.membership.email,
tandemID = "N/A",
batchID = "N/A",
firstName = y.user.firstName,
lastName = y.user.lastName,
description = "User Registration",
type = x.user.usertype.userTypeName,
}).FirstOrDefault();
}
if (paymentInfo == null)
{
PaymentQuery error = new PaymentQuery();
error.paymentBillID = -1;///not found
return error;
}
else { return paymentInfo; }
}
}
catch (Exception ex)
{
Console.Write("PaymetnManager.getPaymentReceiptInfo error " + ex);
return null;
}
}
public PaymentQuery getPayment(long id)
{
try
{
using (conferenceadminContext context = new conferenceadminContext())
{
var paymentInfo = (from s in context.paymentbills
from sp in context.sponsor2
where s.paymentBillID == id && s.deleted == false && sp.paymentID == s.paymentID && s.completed == true
select new PaymentQuery
{
paymentBillID = s.paymentBillID,
date = s.date,
affiliationName = sp.user.affiliationName,
transactionid = s.transactionid,
AmountPaid = s.AmountPaid,
methodOfPayment = s.methodOfPayment,
firstName = s.firstName,
lastName = s.lastName,
email = s.email,
tandemID = s.tandemID,
batchID = s.batchID,
userFirstName = sp.user.firstName,
userLastName = sp.user.lastName,
type = sp.sponsortype1.name,
description = "Sponsor Donation"
}).FirstOrDefault();
if (paymentInfo == null)
{
paymentInfo = (from s in context.paymentbills
from r in context.registrations
where s.paymentBillID == id && s.deleted == false && r.paymentID == s.paymentID && s.completed == true
select new PaymentQuery
{
paymentBillID = s.paymentBillID,
date = (DateTime)s.payment.creationDate,
transactionid = s.transactionid,
AmountPaid = s.AmountPaid,
methodOfPayment = s.methodOfPayment,
firstName = s.firstName,
lastName = s.lastName,
email = s.email,
tandemID = s.tandemID,
batchID = s.batchID,
userFirstName = r.user.firstName,
userLastName = r.user.lastName,
affiliationName = r.user.affiliationName,
type = r.user.usertype.userTypeName,
description = "User Registration."
}).FirstOrDefault();
}
if (paymentInfo == null)
{
PaymentQuery error = new PaymentQuery();
error.paymentBillID = -1;//notify not found
return error;
}
return paymentInfo;
}
}
catch (Exception ex)
{
Console.Write("PaymetnManager.getPaymentReceiptInfo error " + ex);
return null;
}
}