/* [Randy] Add new registration entry */ public string addRegistration(registration reg, user user, membership mem) { /*int type, string firstname, string lastname, string affiliationName, bool registrationstatus, bool hasapplied, bool acceptancestatus*/ try { using (conferenceadminContext context = new conferenceadminContext()) { address address = new address(); context.addresses.Add(address); //encryption var userPassword = mem.password; mem.password = Security.GetSHA1HashData(mem.password); //end encryption mem.emailConfirmation = true; mem.deleted = false; context.memberships.Add(mem); context.SaveChanges(); user.addressID = address.addressID; user.membershipID = mem.membershipID; user.registrationStatus = "Accepted"; user.hasApplied = true; user.acceptanceStatus = "Accepted"; user.title = ""; user.phone = ""; user.userFax = ""; user.deleted = false; context.users.Add(user); context.SaveChanges(); reg.userID = user.userID; reg.paymentID = 1; reg.byAdmin = true; reg.deleted = false; context.registrations.Add(reg); context.SaveChanges(); try { sendEmailConfirmation(mem.email, userPassword); } catch (Exception ex) { Console.Write("AdminManager.ConfirmationEmail error " + ex); return null; } return reg.registrationID + "," + user.userTypeID; } } catch (Exception ex) { Console.Write("AdminManager.addRegistration error " + ex); return null; } }
/* [Randy] Register as a complementary user without paying */ public bool complementaryPayment(UserInfo user, string key) { try { using (conferenceadminContext context = new conferenceadminContext()) { payment payment = new payment { paymentTypeID = 2, deleted = false, creationDate = DateTime.Now.Date }; context.payments.Add(payment); context.SaveChanges(); registration registration = new registration { userID = user.userID, paymentID = payment.paymentID, date1 = user.date1, date2 = user.date2, date3 = user.date3, byAdmin = false, deleted = false, note = user.notes }; user saveUser = context.users.Where(u => u.userID == user.userID).FirstOrDefault(); saveUser.registrationStatus = "Accepted"; complementarykey complementaryKey = context.complementarykeys.Where(k => k.key == key).FirstOrDefault(); complementaryKey.isUsed = true; paymentcomplementary complementaryPay = new paymentcomplementary { paymentID = payment.paymentID, deleted = false, complementaryKeyID = complementaryKey.complementarykeyID }; context.registrations.Add(registration); context.paymentcomplementaries.Add(complementaryPay); context.SaveChanges(); return true; } } catch (Exception ex) { Console.Write("ProfileAuthorizationManager.complementaryPaymentError error " + ex); return false; } }
public PaymentInfo userPayment(UserInfo user) { try { using (conferenceadminContext context = new conferenceadminContext()) { PaymentInfo pay = new PaymentInfo(); payment payment = new payment(); var registrationExist = context.registrations.Where(x => x.userID == user.userID).FirstOrDefault(); if (registrationExist == null) { payment.paymentTypeID = 1; payment.deleted = false; payment.creationDate = DateTime.Now.Date; context.payments.Add(payment); context.SaveChanges(); //Check if exist a registration then take it and edit it registration registration = new registration { userID = user.userID, paymentID = payment.paymentID, date1 = user.date1, date2 = user.date2, date3 = user.date3, byAdmin = false, deleted = false, note = user.notes, }; pay.paymentID = payment.paymentID; context.registrations.Add(registration); context.SaveChanges(); } else { registrationExist.date1 = user.date1; registrationExist.date2 = user.date2; registrationExist.date3 = user.date3; registrationExist.byAdmin = false; registrationExist.deleted = false; registrationExist.note = user.notes; context.SaveChanges(); pay.paymentID = registrationExist.paymentID; } //add check if is lateregistration o regular registration*****************************************IMPORTANT pay.amount = user.amount; return pay; } } catch (Exception ex) { Console.Write("ProfileAuthorizationManager.UserPayment error " + ex); return null; } }
public bool makePaymentFree(UserInfo user) { try { using (conferenceadminContext context = new conferenceadminContext()) { payment payment = new payment { paymentTypeID = 1, deleted = false, creationDate = DateTime.Now.Date }; context.payments.Add(payment); context.SaveChanges(); registration registration = new registration { userID = user.userID, paymentID = payment.paymentID, date1 = user.date1, date2 = user.date2, date3 = user.date3, byAdmin = false, deleted = false, note = user.notes }; user saveUser = context.users.Where(u => u.userID == user.userID).FirstOrDefault(); saveUser.registrationStatus = "Accepted"; paymentbill bill = new paymentbill { paymentID = payment.paymentID, addressID = saveUser.addressID, deleted = false, AmountPaid = (double)saveUser.usertype.registrationCost, transactionid = "N/A", methodOfPayment = "N/A", tandemID ="N/A", batchID ="N/A", completed=true, date =DateTime.Now, firstName=saveUser.firstName, lastName=saveUser.lastName, email=saveUser.membership.email, telephone =saveUser.phone, }; context.registrations.Add(registration); context.paymentbills.Add(bill); context.SaveChanges(); return true; } } catch (Exception ex) { Console.Write("ProfileAuthorizationManager.MakePaymentFree error " + ex); return false; } }