Ejemplo n.º 1
0
        /* [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;
            }
        }
Ejemplo n.º 2
0
        /* [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;
            }
        }
Ejemplo n.º 3
0
        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;
            }
        }
Ejemplo n.º 4
0
        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;
            }
        }