public object SendSponsorEmailOnFreeUpgrade(object[] objValue)
        {
            StringBuilder sb = new StringBuilder();
            UserRegistration objUserReg = new UserRegistration();
            BillingResource objBillingResource = new BillingResource();
            BillingHistory objBilling = new BillingHistory();
            EmailManager objEmailManager = new EmailManager();
            TributePackage objpackage = new TributePackage();
            // return objBillingResource.InsertRecord(objValue);
            UserCreditcardDetails objCCdetail = new UserCreditcardDetails();
            SessionValue objUser = new SessionValue();
            Tributes objTribute = new Tributes();
            String[] SponsorNameandMsgForEmail;

            object identity = new object();
            //using (TransactionScope trans = new TransactionScope())
            //{
            //    identity = objBillingResource.InsertRecord(objValue);
            //    //Transaction Commited
            //    trans.Complete();
            //}
            objUserReg = (UserRegistration)objValue[0];
            if (objValue.Length > 1)
            {
                objUser = (SessionValue)objValue[1];
                objTribute = (Tributes)objValue[2];
                objpackage = (TributePackage)objValue[3];
                SponsorNameandMsgForEmail = (String[])objValue[4];
                // Send the email to all the adminstrator

                if (objpackage.IsSponserHide)
                {
                    if (SponsorNameandMsgForEmail[0] != string.Empty)
                    {
                        objEmailManager.SendSponsorMailsWithMessage(SponsorNameandMsgForEmail[0], SponsorNameandMsgForEmail[1], objTribute.TributeId, objTribute.TypeDescription, objTribute.TributeName, objTribute.TributeUrl, objpackage.EndDate != null ? DateTime.Parse(objpackage.EndDate.ToString()).ToString("MMMM dd, yyyy") : "Never", objpackage.PackageId);
                    }
                 /* commented by Mohit  else if (objpackage.IsSponsor)
                    {
                        objEmailManager.SendSponsorMails(objUser.UserType == 1 ? objUser.UserName : objUser.FirstName, objUser.UserEmail, objTribute.TributeId, objTribute.TypeDescription, objTribute.TributeName, objTribute.TributeUrl, objpackage.EndDate != null ? DateTime.Parse(objpackage.EndDate.ToString()).ToString("MMMM dd, yyyy") : "Never", objpackage.PackageId);
                    } */
                    else
                    {
                        objEmailManager.SendSponsorMails("An anonymous person has", "Your " + WebConfig.ApplicationWord + "<" + WebConfig.NoreplyEmail + ">", objTribute.TributeId, objTribute.TypeDescription, objTribute.TributeName, objTribute.TributeUrl, objpackage.EndDate != null ? DateTime.Parse(objpackage.EndDate.ToString()).ToString("MMMM dd, yyyy") : "Never", objpackage.PackageId);
                    }
                    //objEmailManager.SendSponsorMails(objUser.UserName, objUser.UserEmail, objTribute.TributeId, objTribute.TypeDescription, objTribute.TributeName, objTribute.TributeUrl, objUserReg.UserCreditcardDetails.ExpirationDate.ToString("MMMM dd, yyyy"), objpackage.PackageId);

                }
            }

            return identity;
        }
        public void GetCreditCardDetails(object[] objValue)
        {
            UserRegistration objUserReg = (UserRegistration)objValue[0];
            try
            {
                object[] objParam = { objUserReg.Users.UserId };
                DataSet _objDataSet = GetDataSet("usp_GetCreditcardDetails", objParam);
                if (_objDataSet.Tables[0].Rows.Count > 0)
                {
                    UserCreditcardDetails objCarddetails = new UserCreditcardDetails();
                    objCarddetails.CreditCardId = int.Parse(_objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.CreditCardId.ToString()].ToString());
                    objCarddetails.UserId = int.Parse(_objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.UserId.ToString()].ToString());
                    objCarddetails.CreditCardType = _objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.CreditCardType.ToString()].ToString();
                    objCarddetails.CreditCardNo = _objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.CreditCardNo.ToString()].ToString();
                    objCarddetails.CardholdersName = _objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.CardholdersName.ToString()].ToString();
                    objCarddetails.ExpirationDate = DateTime.Parse(_objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.ExpirationDate.ToString()].ToString());
                    objCarddetails.Address = _objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.Address.ToString()].ToString();
                    objCarddetails.City = _objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.City.ToString()].ToString();
                    objCarddetails.Zip = _objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.Zip.ToString()].ToString();
                    if (!(_objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.State.ToString()].ToString().Equals("")))
                        objCarddetails.State = int.Parse(_objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.State.ToString()].ToString());
                    else
                        objCarddetails.State = null;

                    objCarddetails.Country = int.Parse(_objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.Country.ToString()].ToString());
                    objCarddetails.Telephone = _objDataSet.Tables[0].Rows[0][UserCreditcardDetails.CardDetais.Telephone.ToString()].ToString();
                    objCarddetails.CVC = _objDataSet.Tables[0].Rows[0]["CVC"].ToString();
                    objCarddetails.SponsorEmailAddress = _objDataSet.Tables[0].Rows[0]["SponsorEmailAddress"].ToString();
                    objUserReg.UserCreditcardDetails = objCarddetails;
                }
            }
            catch (System.Data.SqlClient.SqlException sqlEx)
            {
                if (sqlEx.Number >= 50000)
                {
                    Errors objError = new Errors();
                    objError.ErrorMessage = sqlEx.Message;
                    objUserReg.CustomError = objError;
                }
            }
        }
        public object InsertCreditPointCCDetails(object[] objValue)
        {
            StringBuilder sb = new StringBuilder();
            UserRegistration objUserReg = new UserRegistration();
            BillingResource objBillingResource = new BillingResource();
            BillingHistory objBilling = new BillingHistory();
            EmailManager objEmailManager = new EmailManager();
            TributePackage objpackage = new TributePackage();
            // return objBillingResource.InsertRecord(objValue);
            UserCreditcardDetails objCCdetail = new UserCreditcardDetails();
            SessionValue objUser = new SessionValue();
            Tributes objTribute = new Tributes();

            object identity = new object();
            using (TransactionScope trans = new TransactionScope())
            {
                identity = objBillingResource.InsertRecord(objValue);
                //Transaction Commited
                trans.Complete();
            }
            return identity;
        }