public async Task <IActionResult> Edit(int id, [Bind("ReferrerId,FirstName,LastName,OrganisationName,PhoneNumber,Email,TownCity,RoleId")] Referrer referrer)
        {
            if (id != referrer.ReferrerId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(referrer);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ReferrerExists(referrer.ReferrerId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["RoleId"] = new SelectList(_context.ReferrerRole, "RoleId", "RoleName", referrer.RoleId);
            return(View(referrer));
        }
Beispiel #2
0
        private void CreateReferrer(string url)
        {
            var referrer = new Referrer(url);

            Referrers.Add(referrer);
            ReferralCounts.Add(new ReferralCount(referrer));
        }
        public async Task <IActionResult> Edit(int id, [Bind("ReferrerId,Name,Type,Phone,Office")] Referrer referrer)
        {
            if (id != referrer.ReferrerId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(referrer);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ReferrerExists(referrer.ReferrerId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(referrer));
        }
Beispiel #4
0
        public ReferrerService()
        {
            if (Referrers == null || ReferralCounts == null)
            {
                //Constructor to populate List of Referrers and Counts if the lists do not already exist
                Referrers      = new List <Referrer>();
                ReferralCounts = new List <ReferralCount>();
                var referrer1 = new Referrer("https://www.google.com/");
                var referrer2 = new Referrer("https://www.facebook.com/");
                var referrer3 = new Referrer("https://www.amazon.com/");
                var referrer4 = new Referrer("https://www.intuit.com/");
                Referrers.Add(referrer1);
                Referrers.Add(referrer2);
                Referrers.Add(referrer3);
                Referrers.Add(referrer4);

                var referralCount1 = new ReferralCount(referrer1);
                referralCount1.Count = 15;
                var referralCount2 = new ReferralCount(referrer2);
                referralCount2.Count = 4;
                var referralCount3 = new ReferralCount(referrer3);
                referralCount3.Count = 12;
                var referralCount4 = new ReferralCount(referrer4);
                referralCount4.Count = 29;
                ReferralCounts.Add(referralCount1);
                ReferralCounts.Add(referralCount2);
                ReferralCounts.Add(referralCount3);
                ReferralCounts.Add(referralCount4);
            }
        }
    protected void GrdReferrer_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        Label        lblId         = (Label)GrdReferrer.Rows[e.RowIndex].FindControl("lblId");
        DropDownList ddlTitle      = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlTitle");
        TextBox      txtFirstname  = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtFirstname");
        TextBox      txtMiddlename = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtMiddlename");
        TextBox      txtSurname    = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtSurname");
        DropDownList ddlGender     = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlGender");

        Referrer referrer = ReferrerDB.GetByID(Convert.ToInt32(lblId.Text));

        if (referrer != null)
        {
            if (referrer.Person.Title.ID != Convert.ToInt32(ddlTitle.SelectedValue) ||
                referrer.Person.Firstname != Utilities.FormatName(txtFirstname.Text) ||
                referrer.Person.Middlename != Utilities.FormatName(txtMiddlename.Text) ||
                referrer.Person.Surname != Utilities.FormatName(txtSurname.Text) ||
                referrer.Person.Gender != ddlGender.SelectedValue)
            {
                PersonDB.Update(referrer.Person.PersonID, Convert.ToInt32(ddlTitle.SelectedValue), Utilities.FormatName(txtFirstname.Text), Utilities.FormatName(txtMiddlename.Text), Utilities.FormatName(txtSurname.Text), referrer.Person.Nickname, ddlGender.SelectedValue, referrer.Person.Dob, DateTime.Now);
            }
        }

        GrdReferrer.EditIndex = -1;
        FillGrid();
    }
Beispiel #6
0
 public override int GetHashCode()
 {
     unchecked
     {
         int result = (m_ObjPropertyCollection != null ? m_ObjPropertyCollection.GetHashCode() : 0);
         result = (result * 397) ^ (CharacterSet != null ? CharacterSet.GetHashCode() : 0);
         result = (result * 397) ^ (ContentEncoding != null ? ContentEncoding.GetHashCode() : 0);
         result = (result * 397) ^ (ContentType != null ? ContentType.GetHashCode() : 0);
         result = (result * 397) ^ (Headers != null ? Headers.GetHashCode() : 0);
         result = (result * 397) ^ IsFromCache.GetHashCode();
         result = (result * 397) ^ IsMutuallyAuthenticated.GetHashCode();
         result = (result * 397) ^ LastModified.GetHashCode();
         result = (result * 397) ^ (Method != null ? Method.GetHashCode() : 0);
         result = (result * 397) ^ (OriginalReferrerUrl != null ? OriginalReferrerUrl.GetHashCode() : 0);
         result = (result * 397) ^ (OriginalUrl != null ? OriginalUrl.GetHashCode() : 0);
         result = (result * 397) ^ (ProtocolVersion != null ? ProtocolVersion.GetHashCode() : 0);
         result = (result * 397) ^ (Referrer != null ? Referrer.GetHashCode() : 0);
         result = (result * 397) ^ (ResponseUri != null ? ResponseUri.GetHashCode() : 0);
         result = (result * 397) ^ (Server != null ? Server.GetHashCode() : 0);
         result = (result * 397) ^ StatusCode.GetHashCode();
         result = (result * 397) ^ (StatusDescription != null ? StatusDescription.GetHashCode() : 0);
         result = (result * 397) ^ (Step != null ? Step.GetHashCode() : 0);
         result = (result * 397) ^ (Text != null ? Text.GetHashCode() : 0);
         result = (result * 397) ^ (Title != null ? Title.GetHashCode() : 0);
         result = (result * 397) ^ DownloadTime.GetHashCode();
         return(result);
     }
 }
Beispiel #7
0
        private static void ConfirmPaket(int menu, string paket, int giga, int price, int duration = 0)
        {
            Console.WriteLine("Anda akan membeli Paket {0} {1}GB/{2}hari \n" +
                              "dengan harga Rp.{3}? \n" +
                              "1. Beli \n" +
                              "99. Kembali", paket, giga, duration + 1, price);
            Console.Write("Jawab: ");
            string answer = Console.ReadLine();

            switch (answer)
            {
            case "1":
                Console.Clear();
                Paket(paket, giga, price, duration);
                break;

            case "99":
                Console.Clear();
                Referrer referrer = ReffMenu;
                referrer(menu);
                break;

            default:
                Console.Clear();
                Console.WriteLine("Tidak ada menu tersedia yang kamu pilih");
                Console.WriteLine();
                ConfirmPaket(menu, paket, giga, price, duration);
                break;
            }
        }
    public static Hashtable GetHashtableByReferrer(bool incDeleted = false)
    {
        Hashtable hashtable = new Hashtable();

        DataTable tbl = DBBase.ExecuteQuery(JoinedSql(incDeleted, incDeleted, incDeleted)).Tables[0];

        foreach (DataRow row in tbl.Rows)
        {
            if (row["organisation_id"] == DBNull.Value)
            {
                continue;
            }

            Referrer r = ReferrerDB.Load(row);
            r.Person       = PersonDB.Load(row, "", "person_entity_id");
            r.Person.Title = IDandDescrDB.Load(row, "title_id", "descr");
            Organisation o = OrganisationDB.Load(row, "", "organisation_entity_id", "organisation_is_deleted");

            if (hashtable[r.ReferrerID] == null)
            {
                hashtable[r.ReferrerID] = new ArrayList();
            }
            ((ArrayList)hashtable[r.ReferrerID]).Add(o);
        }

        return(hashtable);
    }
        public string Insert(Referrer referrer)
        {
            try
            {
                // TODO : Move this to a cache lookup.  We don't want to query on every ADD.
                // TODO :  Expected Volumes could be immense to so we need to optimise
                var refType = _unitOfWork.GetRepository <ThreatType>().GetList().Items.Where(x => x.Name == Referer).SingleOrDefault();
                var status  = _unitOfWork.GetRepository <Status>().GetList().Items.Where(x => x.Name == Moderate).SingleOrDefault();

                var threat = Mapper.Map <Threat>(referrer);

                threat.StatusId   = status.Id;
                threat.TypeId     = refType.Id;
                threat.ThreatType = refType;
                threat.Status     = status;

                _unitOfWork.GetRepository <Threat>().Add(threat);
                _unitOfWork.SaveChanges();

                return(threat.Identifier);
            }
            catch (Exception ex)
            {
                return(null);
            }
        }
        public ActionResult HelpfulnessVotes_POST(
            [IoCModelBinder(typeof(SetIPAddressModelBinder))] HelpfulnessVoteModel voteModel)
        {
            var response = _helpfulnessVoteService.Upvote(voteModel);

            if (Request.IsAjaxRequest())
            {
                return(Json(response.IsSuccess()));
            }

            TempData["productreview-response-info"] = response;
            return
                (Redirect(string.IsNullOrWhiteSpace(response.RedirectUrl)
                    ? Referrer != null
                        ? Referrer.ToString()
                        : "~/"
                    : response.RedirectUrl));

            //if (CurrentRequestData.CurrentUser != null)
            //    vote.User = CurrentRequestData.CurrentUser;

            //vote.IsHelpful = true;

            //_helpfulnessVoteService.Add(vote);

            //TempData["vote-submitted"] = true;

            //return Redirect(Referrer.ToString());
        }
Beispiel #11
0
        private List <Referrer> getReferrersFromFile(FileInfo file, DateTime day)
        {
            List <Referrer> referrers = new List <Referrer>();

            XmlDocument doc = new XmlDocument();

            doc.Load(file.FullName);

            XmlNodeList nodes = doc.SelectNodes("referrers/referrer");

            foreach (XmlNode node in nodes)
            {
                Referrer refer = new Referrer()
                {
                    Url          = node.Attributes["url"] == null ? null : new Uri(node.Attributes["url"].InnerText),
                    Count        = node.Attributes["count"] == null ? 0 : int.Parse(node.Attributes["count"].InnerText),
                    Day          = day,
                    PossibleSpam = node.Attributes["isSpam"] == null ? false : bool.Parse(node.Attributes["isSpam"].InnerText),
                    ReferrerUrl  = new Uri(node.InnerText),
                    Id           = Guid.NewGuid()
                };

                refer.MarkOld();
                referrers.Add(refer);
            }

            return(referrers);
        }
 public AdminkaCrudRoutinePageConsumer(PageModel pageModel, Referrer referrer,
                                       PageRoutineFeature pageRoutineFeature,
                                       Func <User, UserContext> createUserContext,
                                       ApplicationSettings applicationSettings, IMemoryCache memoryCache, MemberTag memberTag) :
     base(pageModel, pageRoutineFeature,
          getUserAndFailedActionResultInitialisedAsync:
          (aspRoutineFeature) =>
          AspNetCoreManager.GetUserAndFailedActionResultInitialisedAsync(
              applicationSettings,
              memberTag,
              pageModel,
              aspRoutineFeature,
              memoryCache,
              pageRoutineFeature),
          getContainerHandler: (aspRoutineFeature, getInput, user, containerFactory) =>
 {
     var userContext = createUserContext(user);
     return(MvcAppManager.GetContainerStorageHandler(
                containerFactory,
                memberTag,
                aspRoutineFeature,
                getInput,
                userContext,
                applicationSettings,
                uc => uc.AuditStamp
                ));
 })
 {
     this.Referrer = referrer;
 }
    public static IEnumerable <Referral> GetReferrals(string fileName)
    {
        using (var rdr = new StreamReader(fileName))
        {
            var next = new Referrer();

            int    state = 0;
            string line;
            while ((line = rdr.ReadLine()) != null)
            {
                switch (state)
                {
                case 0:
                    next.ReferrerText = line;
                    state             = 1;
                    break;

                case 1:
                    next.ReferrerDescription = line;
                    state = 2;
                    break;

                case 2:
                    next.ReferringId = int.Parse(line);
                    yield return(next);

                    next  = new Referral();
                    state = 0;
                    break;
                }
            }
        }
    }
Beispiel #14
0
        public static async Task SetTier(BitcornContext dbContext, Referrer referrer)
        {
            var banned = await dbContext.User.Where(s => s.UserId == referrer.UserId).Select(u => u.IsBanned).FirstOrDefaultAsync();

            if (banned)
            {
                return;
            }
            var stats = await dbContext.UserStat.FirstOrDefaultAsync(s => s.UserId == referrer.UserId);

            if (stats.TotalReferrals == null)
            {
                stats.TotalReferrals = 0;
            }

            if (stats.TotalReferrals < 50 && referrer.Tier < 1)
            {
                referrer.Tier = 0;
            }
            if (stats.TotalReferrals >= 50 && referrer.Tier < 1)
            {
                referrer.Tier = 1;
            }
            if (stats.TotalReferrals >= 500 && referrer.Tier < 2)
            {
                referrer.Tier = 2;
            }
            if (stats.TotalReferrals >= 20000 && referrer.Tier < 3)
            {
                referrer.Tier = 3;
            }

            await dbContext.SaveAsync();
        }
    protected void btnSetExistingReferrer_Click(object sender, EventArgs e)
    {
        Referrer referrer = ReferrerDB.GetByID(Convert.ToInt32(jsSetId.Value));

        if (referrer == null)
        {
            lblId.Text = "-1";
            SetErrorMessage("Error getting selected referrer. Plase contact the system administrator.<br />");
        }
        else
        {
            lblId.Text             = referrer.ReferrerID.ToString();
            ddlTitle.SelectedValue = referrer.Person.Title.ID.ToString();
            txtFirstname.Text      = referrer.Person.Firstname;
            txtMiddlename.Text     = referrer.Person.Middlename;
            txtSurname.Text        = referrer.Person.Surname;
            if (ddlGender.Items.FindByValue(referrer.Person.Gender) == null)
            {
                ddlGender.Items.Add(new ListItem(referrer.Person.Gender == "" ? "--" : referrer.Person.Gender, referrer.Person.Gender));
            }
            ddlGender.SelectedValue = referrer.Person.Gender;

            ddlTitle.Enabled      = false;
            txtFirstname.Enabled  = false;
            txtMiddlename.Enabled = false;
            txtSurname.Enabled    = false;
            ddlGender.Enabled     = false;
        }
    }
Beispiel #16
0
        /// <summary>
        /// Registers click.
        /// </summary>
        /// <param name="url">
        /// The url Uri.
        /// </param>
        /// <param name="referrer">
        /// The referrer Uri.
        /// </param>
        private static void RegisterClick(Uri url, Uri referrer)
        {
            Referrer refer = null;

            if (Referrer.Referrers != null && Referrer.Referrers.Count > 0)
            {
                refer =
                    Referrer.Referrers.Find(
                        r => r.ReferrerUrl.Equals(referrer) && r.Url.Equals(url) && r.Day == DateTime.Today);
            }

            if (refer == null)
            {
                refer = new Referrer
                {
                    Day          = DateTime.Today,
                    ReferrerUrl  = referrer,
                    Url          = url,
                    PossibleSpam = IsSpam(referrer, url)
                };
            }

            refer.Count += 1;

            refer.Save();
        }
        public void ValidationInConstructor()
        {
            using (var session = Domain.OpenSession())
                using (session.OpenTransaction()) {
                    Reference reference1 = null;
                    AssertEx.Throws <ValidationFailedException>(() => {
                        reference1 = new Reference();
                        session.Validate();
                    });
                    reference1.Remove();
                    var reference2 = new Reference {
                        Title = "Test"
                    };
                    session.Validate();

                    var      reference3 = new Reference("Test");
                    Referrer referrer2  = null;
                    AssertEx.Throws <ValidationFailedException>(() => {
                        referrer2 = new Referrer();
                        session.Validate();
                    });
                    referrer2.Remove();
                    var referrer3 = new Referrer {
                        Title = "Test", Reference = reference3
                    };
                    session.Validate();
                    var referrer1 = new Referrer(reference3, "Test");
                }
        }
 /// <summary>
 /// Populates the row.
 /// </summary>
 /// <param name="tableRow">
 /// The table row.
 /// </param>
 /// <param name="refer">
 /// The refer.
 /// </param>
 private void PopulateRow(DataRow tableRow, Referrer refer)
 {
     tableRow["url"]         = this.Server.HtmlEncode(refer.ReferrerUrl.ToString());
     tableRow["shortUrl"]    = this.MakeShortUrl(refer.ReferrerUrl.ToString());
     tableRow["target"]      = this.Server.HtmlEncode(refer.Url.ToString());
     tableRow["shortTarget"] = this.MakeShortUrl(refer.Url.ToString());
     tableRow["hits"]        = refer.Count;
 }
        /// <summary>
        /// Inserts a Referrer.
        /// </summary>
        /// <param name="referrer">
        /// Must be a valid Referrer object.
        /// </param>
        public override void InsertReferrer(Referrer referrer)
        {
            Referrer.Referrers.Add(referrer);

            referrer.MarkOld();
            var day = Referrer.Referrers.FindAll(r => r.Day.ToShortDateString() == referrer.Day.ToShortDateString());
            this.WriteReferrerFile(day, referrer.Day);
        }
Beispiel #20
0
        public RedirectResult Add_POST(ProductReview productReview)
        {
            _productReviewUIService.Add(productReview);

            TempData["review-submitted"] = true;

            return(Redirect(Referrer.ToString()));
        }
Beispiel #21
0
        public void CanSetAndGetSimpleProperties()
        {
            var referrer = new Referrer();

            referrer.ReferrerUrl = "localhost";
            Assert.AreEqual("http://localhost", referrer.ReferrerUrl);
            UnitTestHelper.AssertSimpleProperties(referrer, "ReferrerUrl");
        }
Beispiel #22
0
    public static Referrer LoadAll(DataRow row, string staff_prefix = "", string person_prefix = "", string person_title_id = "title_id", string person_title_descr = "descr")
    {
        Referrer r = Load(row, staff_prefix);

        r.Person       = PersonDB.Load(row, person_prefix);
        r.Person.Title = IDandDescrDB.Load(row, person_title_id, person_title_descr);
        return(r);
    }
Beispiel #23
0
        public static async Task <decimal> TotalReward(BitcornContext dbContext, Referrer referrer)
        {
            await SetTier(dbContext, referrer);

            var referralTier = await dbContext.ReferralTier.FirstOrDefaultAsync(r => r.Tier == referrer.Tier);

            return(referrer.Amount * referralTier.Bonus);
        }
        public ActionResult DeleteConfirmed(int id)
        {
            Referrer referrer = db.Referrers.Find(id);

            db.Referrers.Remove(referrer);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Beispiel #25
0
        /// <summary>
        /// Inserts a Referrer.
        /// </summary>
        /// <param name="referrer">
        /// Must be a valid Referrer object.
        /// </param>
        public override void InsertReferrer(Referrer referrer)
        {
            Referrer.Referrers.Add(referrer);

            referrer.MarkOld();
            var day = Referrer.Referrers.FindAll(r => r.Day.ToShortDateString() == referrer.Day.ToShortDateString());

            this.WriteReferrerFile(day, referrer.Day);
        }
Beispiel #26
0
        /// <summary>
        /// Gets a Referrer based on the Id.
        /// </summary>
        /// <param name="Id">The Referrer's Id.</param>
        /// <returns>A matching Referrer.</returns>
        public override Referrer SelectReferrer(Guid Id)
        {
            Referrer refer = Referrer.Referrers.Find(r => r.Id.Equals(Id));

            if (refer == null)
            {
                refer = new Referrer();
            }
            refer.MarkOld();
            return(refer);
        }
        public async Task <IActionResult> Create([Bind("ReferrerId,Name,Type,Phone,Office")] Referrer referrer)
        {
            if (ModelState.IsValid)
            {
                _context.Add(referrer);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(referrer));
        }
Beispiel #28
0
 public ActionResult LoggedIn([IoCModelBinder(typeof(SetIPAddressModelBinder))] LoggedInUserAddCommentModel model)
 {
     if (ModelState.IsValid)
     {
         PostCommentResponse response = _commentsUiService.AddLoggedInComment(model);
         return(RedirectToPage(response));
     }
     return(RedirectToPage(new PostCommentResponse {
         Valid = false, RedirectUrl = Referrer.ToString()
     }));
 }
        public static object SelectUserProperties(User user,
                                                  UserIdentity userIdentity,
                                                  UserWallet userWallet,
                                                  UserStat userStats,
                                                  UserReferral userReferral,
                                                  Referrer referrer,
                                                  bool guestView)
        {
            Dictionary <string, object> output = new Dictionary <string, object>();

            AppendUserOutput(output, new Type[] {
                typeof(int),
                typeof(string),
                typeof(DateTime?),
                typeof(bool)
            }, user, "Username");

            if (!guestView)
            {
                AppendUserOutput(output,
                                 new Type[] { typeof(string) },
                                 userIdentity);
            }
            else
            {
                output.Add("auth0Id", userIdentity.Auth0Id);
                output.Add("auth0Nickname", userIdentity.Auth0Nickname);

                //Auth0Id = userIdentity.Auth0Id,
                //Auth0Nickname = userIdentity.Auth0Nickname,
            }

            if (!guestView)
            {
                AppendUserOutput(output, new Type[] { typeof(decimal?), typeof(int?), typeof(string) }, userWallet);
            }
            if (!guestView)
            {
                AppendUserOutput(output, new Type[] { typeof(decimal?), typeof(int?), typeof(string) }, userStats);
            }
            if (!guestView && referrer != null)
            {
                AppendUserOutput(output, new Type[] { typeof(decimal?), typeof(int?), typeof(string), typeof(DateTime?), typeof(int) }, referrer, "userId");
            }

            if (!guestView && userReferral != null)
            {
                AppendUserOutput(output, new Type[] { typeof(decimal), typeof(int), typeof(string), typeof(int) }, userReferral, "userId");
            }



            return(output);
        }
 public AdminkaCrudRoutinePageConsumer(
     PageModel pageModel, Referrer referrer,
     [CallerMemberName] string member = null) :
     this(pageModel, referrer,
          AspNetCoreManager.SetAndGetPageRoutineFeature(pageModel, referrer),
          u => MvcAppManager.SetAndGetUserContext(pageModel, u),
          (ApplicationSettings)pageModel.HttpContext.RequestServices.GetService(typeof(ApplicationSettings)),
          (IMemoryCache)pageModel.HttpContext.RequestServices.GetService(typeof(IMemoryCache)),
          new MemberTag(pageModel.GetType().Namespace, pageModel.GetType().Name, member))
 {
 }
Beispiel #31
0
        protected ActionResult RedirectToPage(ICommentResponseInfo response)
        {
            TempData["comment-response-info"] = response;
            var url = string.IsNullOrWhiteSpace(response.RedirectUrl)
                ? Referrer != null
                    ? Referrer.ToString()
                    : "~/"
                : response.RedirectUrl;

            return
                (Redirect(url + "#comments"));
        }
    public static BulkLetterSendingQueueAdditionalLetter GetFileInfo(Letter.FileFormat fileFormat, Booking booking, Patient patient, HealthCard hc, Letter.TreatmentLetterType treatmentLetterType, Booking.InvoiceType invType, int fieldID, int siteID, int staffID, Referrer referrer, bool keepInHistory, int letterPrintHistorySendMethodID)
    {
        // 1. Add to healthcardaction
        int healthCardActionID = -1;
        if (treatmentLetterType == Letter.TreatmentLetterType.First || treatmentLetterType == Letter.TreatmentLetterType.Last || treatmentLetterType == Letter.TreatmentLetterType.LastWhenReplacingEPC)
            healthCardActionID = HealthCardActionDB.Insert(hc.HealthCardID, Letter.GetHealthCardActionTypeID(treatmentLetterType), DateTime.Now);

        // 2.create document and put it in history
        int letterID = Letter.GetLetterIDByTreatmentLetterTypeAndInvoiceType(treatmentLetterType, invType, fieldID, siteID);
        if (letterID == -1)
            return null;

        string lettersDir = Letter.GetLettersDirectory();
        if (!Directory.Exists(lettersDir))
            throw new CustomMessageException("Letters directory doesn't exist");

        Letter letter = LetterDB.GetByID(letterID);
        bool useDefaultDocs = letter.Organisation == null ? true : !LetterDB.OrgHasdocs(letter.Organisation.OrganisationID);
        string sourceTemplatePath = lettersDir + (useDefaultDocs ? @"Default\" + letter.Site.SiteID + @"\" : letter.Organisation.OrganisationID + @"\") + letter.Docname;
        if (!File.Exists(sourceTemplatePath))
            throw new CustomMessageException("File doesn't exist: " + Path.GetFileName(sourceTemplatePath));

        // get temp directory
        string tmpLettersDirectory = Letter.GetTempLettersDirectory();
        if (!Directory.Exists(tmpLettersDirectory))
            throw new CustomMessageException("Temp letters directory doesn't exist");

        return new BulkLetterSendingQueueAdditionalLetter(
            -1,
            -1,
            letter.LetterID,
            keepInHistory && Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["StoreLettersHistoryInDB"]),
            keepInHistory && Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["StoreLettersHistoryInFlatFile"]),
            letterPrintHistorySendMethodID,
            Letter.GetLettersHistoryDirectory(booking.Organisation.OrganisationID),
            letter.Docname.Replace(".dot", ".doc"),
            siteID,
            booking.Organisation.OrganisationID,
            booking.BookingID,
            patient.PatientID,
            -1, // register_referrer_id_to_use_instead_of_patients_reg_ref
            staffID,
            healthCardActionID,
            sourceTemplatePath,
            tmpLettersDirectory + letter.Docname.Replace(".dot", ".doc"),
            true,
            "",
            ""
            );
    }
Beispiel #33
0
 /// <summary>
 /// Updates an existing Referrer in the data store specified by the provider.
 /// </summary>
 /// <param name="referrer">
 /// The referrer to update.
 /// </param>
 public abstract void UpdateReferrer(Referrer referrer);
Beispiel #34
0
 /// <summary>
 /// Inserts a new Referrer into the data store specified by the provider.
 /// </summary>
 /// <param name="referrer">
 /// The referrer to insert.
 /// </param>
 public abstract void InsertReferrer(Referrer referrer);
 /// <summary>
 /// Updates an existing Referrer.
 /// </summary>
 /// <param name="referrer">
 /// The referrer to update.
 /// </param>
 public static void UpdateReferrer(Referrer referrer)
 {
     LoadProviders();
     provider.UpdateReferrer(referrer);
 }
 /// <summary>
 /// Persists a new Referrer in the current provider.
 /// </summary>
 /// <param name="referrer">
 /// The referrer to insert.
 /// </param>
 public static void InsertReferrer(Referrer referrer)
 {
     LoadProviders();
     provider.InsertReferrer(referrer);
 }
Beispiel #37
0
        /// <summary>
        /// Gets all Referrers from the database.
        /// </summary>
        /// <returns>List of Referrers.</returns>
        public override List<Referrer> FillReferrers()
        {
            deleteOldReferrers();

            List<Referrer> referrers = new List<Referrer>();

            string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
            string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
            DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);

            using (DbConnection conn = provider.CreateConnection())
            {
                conn.ConnectionString = connString;
                conn.Open();
                using (DbCommand cmd = conn.CreateCommand())
                {
                    string sqlQuery = "SELECT ReferrerId, ReferralDay, ReferrerUrl, ReferralCount, Url, IsSpam " +
                        "FROM " + tablePrefix + "Referrers ";
                    cmd.CommandText = sqlQuery;
                    cmd.CommandType = CommandType.Text;

                    using (DbDataReader rdr = cmd.ExecuteReader())
                    {
                        if (rdr.HasRows)
                        {
                            while (rdr.Read())
                            {
                                Referrer refer = new Referrer()
                                {
                                    Id = rdr.GetGuid(0),
                                    Day = rdr.GetDateTime(1),
                                    ReferrerUrl = new Uri(rdr.GetString(2)),
                                    Count = rdr.GetInt32(3),
                                    Url = rdr.IsDBNull(4) ? null : new Uri(rdr.GetString(4)),
                                    PossibleSpam = rdr.IsDBNull(5) ? false : rdr.GetBoolean(5)
                                };

                                referrers.Add(refer);
                                refer.MarkOld();
                            }
                        }
                    }
                }
            }

            return referrers;
        }
        /// <summary>
        /// Adds a new Referrer to the database.
        /// </summary>
        /// <param name="referrer">
        /// Referrer to add.
        /// </param>
        public override void InsertReferrer(Referrer referrer)
        {
            var referrers = Referrer.Referrers;
            referrers.Add(referrer);

            using (var conn = this.CreateConnection())
            {
                if (conn.HasConnection)
                {
                    var sqlQuery = string.Format("INSERT INTO {0}Referrers (BlogId, ReferrerId, ReferralDay, ReferrerUrl, ReferralCount, Url, IsSpam) VALUES ({1}BlogId, {1}ReferrerId, {1}ReferralDay, {1}ReferrerUrl, {1}ReferralCount, {1}Url, {1}IsSpam)", this.tablePrefix, this.parmPrefix);

                    using (var cmd = conn.CreateTextCommand(sqlQuery))
                    {
                        this.AddReferrersParametersToCommand(referrer, conn, cmd);
                        cmd.ExecuteNonQuery();
                    }
                }
            }
        }
        /// <summary>
        /// The add referrers parameters to command.
        /// </summary>
        /// <param name="referrer">
        /// The referrer.
        /// </param>
        /// <param name="conn">
        /// The connection.
        /// </param>
        /// <param name="cmd">
        /// The command.
        /// </param>
        private void AddReferrersParametersToCommand(Referrer referrer, DbConnectionHelper conn, DbCommand cmd)
        {
            var parms = cmd.Parameters;

            parms.Add(conn.CreateParameter("BlogId", Blog.CurrentInstance.Id.ToString()));
            parms.Add(conn.CreateParameter("ReferrerId", referrer.Id.ToString()));
            parms.Add(conn.CreateParameter(FormatParamName("ReferralDay"), referrer.Day));
            parms.Add(conn.CreateParameter(FormatParamName("ReferrerUrl"), (referrer.ReferrerUrl != null ? (object)referrer.ReferrerUrl.ToString() : DBNull.Value)));
            parms.Add(conn.CreateParameter(FormatParamName("ReferralCount"), referrer.Count));
            parms.Add(conn.CreateParameter(FormatParamName("Url"), (referrer.Url != null ? (object)referrer.Url.ToString() : DBNull.Value)));
            parms.Add(conn.CreateParameter(FormatParamName("IsSpam"), referrer.PossibleSpam));
        }
        public ActionResult FinishRegister(UserProfilePoco model)
        {
            if (ModelState.IsValid)
            {
                var user = new Users
                    {
                        Name = model.Name,
                        Nickname = model.Nickname,
                        Email = model.Email,
                        Phone = model.Phone,
                        Country = model.Country,
                        City = model.City,
                        BirthDay = model.BirthDay,
                        Password = model.Password
                    };

                if (Request.Cookies["owner"] != null)
                {
                    user.OwnerId = Convert.ToInt64(Request.Cookies["owner"].Value);

                    var owner = _usersService.GetById((long)user.OwnerId);
                    if (owner != null)
                    {
                        // Если в куках есть информация о реферальном url, то добавляем эту информацию в статистику
                        var hostCookie = Request.Cookies["Host"];
                        if (hostCookie != null)
                        {
                            var host = hostCookie["shortHost"];
                            var fullHostUrl = hostCookie["fullHostUrl"];

                            var entity = new Referrer
                                {
                                    Host = host,
                                    FullReferrerUrl = fullHostUrl,
                                    Date = DateTime.Now,
                                    IsDeleted = false,
                                    OwnerId = owner.Id,
                                    Registered = true
                                };

                            _statService.AddReferrer(entity);
                        }
                    }
                }

                _usersService.Insert(user);

                return RedirectToAction("LogOn", "Account");
            }

            return this.View("RegisterForm");
        }
        /// <summary>
        /// Adds a new Referrer to the database.
        /// </summary>
        /// <param name="referrer">
        /// Referrer to add.
        /// </param>
        public override void InsertReferrer(Referrer referrer)
        {
            var referrers = Referrer.Referrers;
            referrers.Add(referrer);

            var connString = ConfigurationManager.ConnectionStrings[this.connStringName].ConnectionString;
            var providerName = ConfigurationManager.ConnectionStrings[this.connStringName].ProviderName;
            var provider = DbProviderFactories.GetFactory(providerName);

            using (var conn = provider.CreateConnection())
            {
                if (conn == null)
                {
                    return;
                }

                conn.ConnectionString = connString;
                conn.Open();
                using (var cmd = conn.CreateCommand())
                {
                    var sqlQuery = string.Format("INSERT INTO {0}Referrers (ReferrerId, ReferralDay, ReferrerUrl, ReferralCount, Url, IsSpam) VALUES (@ReferrerId, @ReferralDay, @ReferrerUrl, @ReferralCount, @Url, @IsSpam)", this.tablePrefix);
                    if (this.parmPrefix != "@")
                    {
                        sqlQuery = sqlQuery.Replace("@", this.parmPrefix);
                    }

                    cmd.CommandText = sqlQuery;
                    cmd.CommandType = CommandType.Text;

                    this.AddReferrersParametersToCommand(referrer, provider, cmd);

                    cmd.ExecuteNonQuery();
                }
            }
        }
 /// <summary>
 /// Populates the row.
 /// </summary>
 /// <param name="tableRow">
 /// The table row.
 /// </param>
 /// <param name="refer">
 /// The refer.
 /// </param>
 private void PopulateRow(DataRow tableRow, Referrer refer)
 {
     tableRow["url"] = this.Server.HtmlEncode(refer.ReferrerUrl.ToString());
     tableRow["shortUrl"] = this.MakeShortUrl(refer.ReferrerUrl.ToString());
     tableRow["target"] = this.Server.HtmlEncode(refer.Url.ToString());
     tableRow["shortTarget"] = this.MakeShortUrl(refer.Url.ToString());
     tableRow["hits"] = refer.Count;
 }
 /// <summary>
 /// Persists a new Referrer in the current provider.
 /// </summary>
 /// <param name="referrer">
 /// The referrer to insert.
 /// </param>
 public static void InsertReferrer(Referrer referrer)
 {
     Provider.InsertReferrer(referrer);
 }
 /// <summary>
 /// Updates a Referrer.
 /// </summary>
 /// <param name="referrer">
 /// Must be a valid Referrer object.
 /// </param>
 public override void UpdateReferrer(Referrer referrer)
 {
     var day = Referrer.Referrers.FindAll(r => r.Day.ToShortDateString() == referrer.Day.ToShortDateString());
     this.WriteReferrerFile(day, referrer.Day);
 }
 /// <summary>
 /// Updates an existing Referrer.
 /// </summary>
 /// <param name="referrer">
 /// The referrer to update.
 /// </param>
 public static void UpdateReferrer(Referrer referrer)
 {
     Provider.UpdateReferrer(referrer);
 }
Beispiel #46
0
        /// <summary>
        /// Saves an existing Referrer to the database.
        /// </summary>
        /// <param name="referrer">Referrer to be saved.</param>
        public override void UpdateReferrer(Referrer referrer)
        {
            List<Referrer> referrers = Referrer.Referrers;
            referrers.Remove(referrer);
            referrers.Add(referrer);

            string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
            string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
            DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);

            using (DbConnection conn = provider.CreateConnection())
            {
                conn.ConnectionString = connString;
                conn.Open();
                using (DbCommand cmd = conn.CreateCommand())
                {
                    string sqlQuery = "UPDATE " + tablePrefix + "Referrers " +
                                      "SET ReferralDay = @ReferralDay, " +
                                      "ReferrerUrl = @ReferrerUrl, " +
                                      "ReferralCount = @ReferralCount, " +
                                      "Url = @Url, " +
                                      "IsSpam = @IsSpam " +
                                      "WHERE ReferrerId = @ReferrerId";
                    if (parmPrefix != "@")
                        sqlQuery = sqlQuery.Replace("@", parmPrefix);
                    cmd.CommandText = sqlQuery;
                    cmd.CommandType = CommandType.Text;

                    addReferrersParametersToCommand(referrer, provider, cmd);

                    cmd.ExecuteNonQuery();
                }
            }
        }
    protected static BulkLetterSendingQueueAdditionalLetter[] GetFilesInfo(Booking booking, Letter.FileFormat fileFormat, Patient patient, HealthCard hc, int fieldID, Referrer referrer, bool keepInHistory, bool needToGenerateFirstLetter, bool needToGenerateLastLetter, bool needToGenerateTreatmentLetter, int siteID, int staffID, int letterPrintHistorySendMethodID)
    {
        System.Collections.ArrayList lettersList = new System.Collections.ArrayList();

        if (needToGenerateFirstLetter)
            lettersList.Add(GetFileInfo(fileFormat, booking, patient, hc, Letter.TreatmentLetterType.First, Booking.InvoiceType.Medicare, fieldID, siteID, staffID, null, keepInHistory, letterPrintHistorySendMethodID));
        if (needToGenerateLastLetter)
            lettersList.Add(GetFileInfo(fileFormat, booking, patient, hc, Letter.TreatmentLetterType.Last, Booking.InvoiceType.Medicare, fieldID, siteID, staffID, null, keepInHistory, letterPrintHistorySendMethodID));
        if (needToGenerateTreatmentLetter)
            lettersList.Add(GetFileInfo(fileFormat, booking, patient, hc, Letter.TreatmentLetterType.TreatmentNotes, Booking.InvoiceType.Medicare, fieldID, siteID, staffID, referrer, keepInHistory, letterPrintHistorySendMethodID));

        return (BulkLetterSendingQueueAdditionalLetter[])lettersList.ToArray(typeof(BulkLetterSendingQueueAdditionalLetter));
    }
        /// <summary>
        /// Gets all Referrers from the database.
        /// </summary>
        /// <returns>
        /// List of Referrers.
        /// </returns>
        public override List<Referrer> FillReferrers()
        {
            this.DeleteOldReferrers();

            var referrers = new List<Referrer>();

            var connString = ConfigurationManager.ConnectionStrings[this.connStringName].ConnectionString;
            var providerName = ConfigurationManager.ConnectionStrings[this.connStringName].ProviderName;
            var provider = DbProviderFactories.GetFactory(providerName);

            using (var conn = provider.CreateConnection())
            {
                if (conn != null)
                {
                    conn.ConnectionString = connString;
                    conn.Open();
                    using (var cmd = conn.CreateCommand())
                    {
                        var sqlQuery = string.Format("SELECT ReferrerId, ReferralDay, ReferrerUrl, ReferralCount, Url, IsSpam FROM {0}Referrers ", this.tablePrefix);
                        cmd.CommandText = sqlQuery;
                        cmd.CommandType = CommandType.Text;

                        using (var rdr = cmd.ExecuteReader())
                        {
                            if (rdr.HasRows)
                            {
                                while (rdr.Read())
                                {
                                    var refer = new Referrer
                                        {
                                            Id = rdr.GetGuid(0),
                                            Day = rdr.GetDateTime(1),
                                            ReferrerUrl = new Uri(rdr.GetString(2)),
                                            Count = rdr.GetInt32(3),
                                            Url = rdr.IsDBNull(4) ? null : new Uri(rdr.GetString(4)),
                                            PossibleSpam = rdr.IsDBNull(5) ? false : rdr.GetBoolean(5)
                                        };

                                    referrers.Add(refer);
                                    refer.MarkOld();
                                }
                            }
                        }
                    }
                }
            }

            return referrers;
        }
        /// <summary>
        /// Saves an existing Referrer to the database.
        /// </summary>
        /// <param name="referrer">
        /// Referrer to be saved.
        /// </param>
        public override void UpdateReferrer(Referrer referrer)
        {
            var referrers = Referrer.Referrers;
            referrers.Remove(referrer);
            referrers.Add(referrer);

            using (var conn = this.CreateConnection())
            {
                if (conn.HasConnection)
                {
                    var sqlQuery = string.Format("UPDATE {0}Referrers SET ReferralDay = {1}ReferralDay, ReferrerUrl = {1}ReferrerUrl, ReferralCount = {1}ReferralCount, Url = {1}Url, IsSpam = {1}IsSpam WHERE BlogId = {1}BlogId AND ReferrerId = {1}ReferrerId", this.tablePrefix, this.parmPrefix);

                    using (var cmd = conn.CreateTextCommand(sqlQuery))
                    {
                        this.AddReferrersParametersToCommand(referrer, conn, cmd);

                        cmd.ExecuteNonQuery();
                    }
                }
            }
        }
 public static Referrer[] GetReferrersOf(int organistion_id, bool showDeletedRefs = false, bool showDeletedRegRefs = false)
 {
     DataTable tbl = GetDataTable_ReferrersOf(organistion_id, showDeletedRefs, showDeletedRegRefs);
     Referrer[] list = new Referrer[tbl.Rows.Count];
     for (int i = 0; i < tbl.Rows.Count; i++)
     {
         list[i] = ReferrerDB.Load(tbl.Rows[i]);
         list[i].Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id");
         list[i].Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr");
     }
     return list;
 }
        /// <summary>
        /// Gets all Referrers from the database.
        /// </summary>
        /// <returns>
        /// List of Referrers.
        /// </returns>
        public override List<Referrer> FillReferrers()
        {
            this.DeleteOldReferrers();

            var referrers = new List<Referrer>();

            using (var conn = this.CreateConnection())
            {
                if (conn.HasConnection)
                {
                    using (var cmd = conn.CreateTextCommand(string.Format("SELECT ReferrerId, ReferralDay, ReferrerUrl, ReferralCount, Url, IsSpam FROM {0}Referrers WHERE BlogId = {1}blogid ", this.tablePrefix, this.parmPrefix)))
                    {
                        cmd.Parameters.Add(conn.CreateParameter(FormatParamName("blogid"), Blog.CurrentInstance.Id.ToString()));

                        using (var rdr = cmd.ExecuteReader())
                        {
                            while (rdr.Read())
                            {
                                var refer = new Referrer
                                    {
                                        Id = rdr.GetGuid(0),
                                        Day = rdr.GetDateTime(1),
                                        ReferrerUrl = new Uri(rdr.GetString(2)),
                                        Count = rdr.GetInt32(3),
                                        Url = rdr.IsDBNull(4) ? null : new Uri(rdr.GetString(4)),
                                        PossibleSpam = rdr.IsDBNull(5) ? false : rdr.GetBoolean(5)
                                    };

                                referrers.Add(refer);
                                refer.MarkOld();
                            }
                        }
                    }
                }
            }

            return referrers;
        }
Beispiel #52
0
        /// <summary>
        /// Registers click.
        /// </summary>
        /// <param name="url">
        /// The url Uri.
        /// </param>
        /// <param name="referrer">
        /// The referrer Uri.
        /// </param>
        private static void RegisterClick(Uri url, Uri referrer)
        {
            Referrer refer = null;
            if (Referrer.Referrers != null && Referrer.Referrers.Count > 0)
            {
                refer =
                    Referrer.Referrers.Find(
                        r => r.ReferrerUrl.Equals(referrer) && r.Url.Equals(url) && r.Day == DateTime.Today);
            }

            if (refer == null)
            {
                refer = new Referrer
                    {
                        Day = DateTime.Today,
                        ReferrerUrl = referrer,
                        Url = url,
                        PossibleSpam = IsSpam(referrer, url)
                    };
            }

            refer.Count += 1;

            refer.Save();
        }
Beispiel #53
0
    public void Portal_SavePatient(Patient patient, Referrer referrer)
    {
        dl = new DataLayer(pConnectionString);
        SqlCommand cmd = new SqlCommand();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "Portal_SavePatient";

        cmd.Parameters.AddWithValue("@ID", patient.ID);
        cmd.Parameters.AddWithValue("@FirstName", patient.FirstName);
        cmd.Parameters.AddWithValue("@LastName", patient.LastName);
        cmd.Parameters.AddWithValue("@DateOfBirth", patient.DateOfBirth);
        cmd.Parameters.AddWithValue("@Gender", patient.Gender);
        cmd.Parameters.AddWithValue("@Ethnicity", patient.Ethnicity);
        cmd.Parameters.AddWithValue("@MedicaidNumber", patient.MedicaidNumber);
        cmd.Parameters.AddWithValue("@SocialSecurityNumber", patient.MedicaidNumber);
        cmd.Parameters.AddWithValue("@ResidingWithName", patient.ResidingWithName);
        cmd.Parameters.AddWithValue("@ResidingWithRelationship", patient.ResidingWithRelationship);
        cmd.Parameters.AddWithValue("@SchoolName", patient.SchoolName);
        cmd.Parameters.AddWithValue("@SchoolGrade", patient.SchoolName);
        cmd.Parameters.AddWithValue("@SchoolPhone", patient.SchoolPhone);
        cmd.Parameters.AddWithValue("@EmployerName", patient.EmployerName);
        cmd.Parameters.AddWithValue("@Occupation", patient.Occupation);
        cmd.Parameters.AddWithValue("@ClientOnProbation", patient.ClientOnProbation);
        cmd.Parameters.AddWithValue("@EmailAddress", patient.EmailAddress);
        cmd.Parameters.AddWithValue("@Diagnosis", patient.Diagnosis);
        cmd.Parameters.AddWithValue("@ServiceRequested", patient.ServiceRequested);
        cmd.Parameters.AddWithValue("@LocationofServices", patient.LocationofServices);
        cmd.Parameters.AddWithValue("@FinanciallyResponsiblePerson", patient.FinanciallyResponsiblePerson);
        cmd.Parameters.AddWithValue("@PaymentMethod", patient.PaymentMethod);
        cmd.Parameters.AddWithValue("@Email", patient.EmailAddress);
        cmd.Parameters.AddWithValue("@ReferralSourceName", referrer.ReferralSourceName);
        cmd.Parameters.AddWithValue("@ReferralSourceAgency", referrer.ReferralSourceAgency);
        cmd.Parameters.AddWithValue("@ReferrerPhone", referrer.ReferrerPhone);
        cmd.Parameters.AddWithValue("@ReferralFax", referrer.ReferralFax);
        cmd.Parameters.AddWithValue("@ReferralStreet", referrer.Street);
        cmd.Parameters.AddWithValue("@ReferralSuite", referrer.Suite);
        cmd.Parameters.AddWithValue("@ReferralCity", referrer.City);
        cmd.Parameters.AddWithValue("@ReferralState", referrer.State);
        cmd.Parameters.AddWithValue("@ReferralZipCode", referrer.ZipCode);
        cmd.Parameters.AddWithValue("@ReferralCountry", referrer.Country);
        cmd.Parameters.AddWithValue("@PatientStreet", patient.PatientStreet);
        cmd.Parameters.AddWithValue("@PatientSuite", patient.PatientSuite);
        cmd.Parameters.AddWithValue("@PatientCity", patient.PatientCity);
        cmd.Parameters.AddWithValue("@PatientState", patient.PatientState);
        cmd.Parameters.AddWithValue("@PatientZipCode", patient.PatientZipCode);
        cmd.Parameters.AddWithValue("@PatientCountry", patient.PatientCountry);

        dl.Execute(cmd);

        return;
    }
        protected void SubmitPatient_Click(object sender, EventArgs e)
        {
            if (txtReferralFax.Text.Length > 0)
            {
                Regex objPhonePattern = new Regex(@"^(?:\([2-9]\d{2}\)\ ?|[2-9]\d{2}(?:\-?|\ ?))[2-9]\d{2}[- ]?\d{4}$");

                if (!objPhonePattern.IsMatch(txtReferralFax.Text))
                {
                    lblErrorMessage.Text = "Invalid ReferralFax entered";
                    txtReferralFax.Focus();
                    return;
                }
            }

            string ServiceRequested = string.Empty;
            foreach (ListItem oItem in chkServiceRequested.Items)
            {
                if (oItem.Selected) // if you want only selected
                {
                    ServiceRequested = ServiceRequested + oItem.Value + ",";
                }

            }

            if (ServiceRequested.Length > 0)
            {
                ServiceRequested = ServiceRequested.Substring(0, ServiceRequested.Length - 1);
            }

            Patient patient = new Patient
            {
                FirstName = txtFirstName.Text,
                LastName = txtLastName.Text,
                DateOfBirth = DateTime.Parse(txtDateOfBirth.Text),
                ReferralDate = DateTime.Parse(DateofReferral.Text),
                Gender = drpGender.SelectedValue,
                Ethnicity = drpEthnicity.SelectedValue,
                MedicaidNumber = txtMedicaidNumber.Text,
                SocialSecurityNumber = SocialSecurityNumber.Text,
                ResidingWithName = txtResidingWithName.Text,
                ResidingWithRelationship = txtResidingWithRelationship.Text,
                SchoolName = txtSchoolName.Text,
                SchoolGrade = txtSchoolGrade.Text,
                SchoolPhone = txtSchoolPhone.Text,
                SchoolPhoneType = drpSchoolPhoneType.SelectedValue,
                EmployerName = txtEmployer.Text,
                Occupation = txtOccupation.Text,
                ClientOnProbation = chkOnProbation.Checked,
                Diagnosis = txtDiagnosis.Text,
                ServiceRequested = ServiceRequested,
                LocationofServices = drpLocationOfServices.SelectedValue,
                FinanciallyResponsiblePerson = txtFinanciallyRep.Text,
                PaymentMethod = drpPaymentMethods.SelectedValue,
                EmailAddress = txtEmailAddress.Text,
                PatientStreet = txtClientStreet.Text,
                PatientSuite = txtClientSuiteApt.Text,
                PatientCity = txtClientCity.Text,
                PatientState = drpClientState.SelectedValue,
                PatientCountry = drpClientCountry.SelectedValue,
                PatientZipCode = txtClientZipCode.Text,
                PresentingConcerns = txtPresentingConcerns.Text,
                LegalGuardian = txtLegalGUardian.Text,

            };

            Referrer referrer = new Referrer
            {
                ReferralSourceName = txtReferrerName.Text,
                ReferralSourceAgency = txtReferrerAgency.Text,
                ReferrerPhone = txtReferralPhone.Text,
                ReferrerPhoneType = drptxtReferralPhoneTypes.SelectedValue,
                ReferralFax = txtReferralFax.Text,
                Street = txtReferralStreet.Text,
                Suite = txtReferralSuiteApt.Text,
                City = txtReferralCity.Text,
                State = drpReferralState.SelectedValue,
                ZipCode = txtReferralZip.Text,
                Country = drpReferralCountry.SelectedValue,
            };

            try
            {

                int status = controller.Portal_SavePatient(patient, referrer, HttpContext.Current.Session["email"].ToString());

                if (status == -1)
                {
                    //ssn exists
                    Helper.DisplayAlert(this, "patient with the entered ssn already exists!, record was not saved.");
                }

                if (status == 1)
                {
                    //email exists
                    Helper.DisplayAlert(this, "patient with the entered email already exists!, record was not saved.");
                }

                if (status == 0)
                {
                    //success
                    var redirectPage = ConfigurationManager.AppSettings["DashBoardPage"];
                    Helper.DisplayAlert(this, "patient saved successfully, you will now be directed to patients dashboard.");
                    Helper.RegisterStartupScript(this, redirectPage);

                }

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #55
0
 /// <summary>
 /// Gets a Referrer based on an Id.
 /// </summary>
 /// <param name="id">The Referrers's Guid.</param>
 /// <returns>A matching Referrer</returns>
 public override Referrer SelectReferrer(Guid Id)
 {
     Referrer refer = Referrer.Referrers.Find(r => r.Id.Equals(Id));
     if (refer == null)
     {
         refer = new Referrer();
     }
     refer.MarkOld();
     return refer;
 }
        public ActionResult Index(string token)
        {
            var ownerUser = _usersService.GetUserByEmailHash(token);

            if (ownerUser != null)
            {
                if (Request.Cookies["owner"] == null)
                {
                    var cookie = new HttpCookie("owner");
                    cookie.Value = ownerUser.Id.ToString(CultureInfo.InvariantCulture);
                    cookie.Expires = DateTime.Now.AddHours(1);
                    ControllerContext.HttpContext.Response.Cookies.Add(cookie);

                    // Если есть реферальный url, то сохраняем в статистику
                    if (HttpContext.Request.UrlReferrer != null)
                    {
                        var urlReferrer = HttpContext.Request.UrlReferrer;

                        // Создаем новые cookie
                        if (Request.Cookies["Host"] == null)
                        {
                            var hostCookie = new HttpCookie("Host");
                            hostCookie.Values["shortHost"] = urlReferrer.Host;
                            hostCookie.Values["fullHostUrl"] = urlReferrer.OriginalString;
                            hostCookie.Expires = DateTime.Now.AddHours(1);
                            ControllerContext.HttpContext.Response.Cookies.Add(hostCookie);
                        }
                        else // или обновляем имеющиеся
                        {
                            Response.Cookies["Host"]["shortHost"] = urlReferrer.Host;
                            Response.Cookies["Host"]["fullHostUrl"] = urlReferrer.OriginalString;
                            Response.Cookies["Host"].Expires = DateTime.Now.AddHours(1);
                        }

                        var entity = new Referrer
                        {
                            Host = urlReferrer.Host,
                            FullReferrerUrl = urlReferrer.OriginalString,
                            Date = DateTime.Now,
                            IsDeleted = false,
                            OwnerId = ownerUser.Id,
                            Registered = false
                        };

                        _statService.AddReferrer(entity);
                    }
                    else
                    {
                        Response.Cookies["Host"]["shortHost"] = "undefined";
                        Response.Cookies["Host"]["fullHostUrl"] = "undefined";
                        Response.Cookies["Host"].Expires = DateTime.Now.AddHours(1);

                        var entity = new Referrer
                        {
                            Host = "undefined",
                            FullReferrerUrl = "",
                            Date = DateTime.Now,
                            IsDeleted = false,
                            OwnerId = ownerUser.Id,
                            Registered = false
                        };

                        _statService.AddReferrer(entity);
                    }
                }
                else
                {
                    Response.Cookies["owner"].Value = ownerUser.Id.ToString(CultureInfo.InvariantCulture);
                    Response.Cookies["owner"].Expires = DateTime.Now.AddHours(1);
                }
            }

            return View();
        }
Beispiel #57
0
        private void addReferrersParametersToCommand(Referrer referrer, DbProviderFactory provider, DbCommand cmd)
        {
            DbParameter dpId = provider.CreateParameter();
            dpId.ParameterName = "ReferrerId";
            dpId.Value = referrer.Id.ToString();
            cmd.Parameters.Add(dpId);

            DbParameter dpDay = provider.CreateParameter();
            dpDay.ParameterName = parmPrefix + "ReferralDay";
            dpDay.Value = referrer.Day;
            cmd.Parameters.Add(dpDay);

            DbParameter dpReferrer = provider.CreateParameter();
            dpReferrer.ParameterName = parmPrefix + "ReferrerUrl";
            dpReferrer.Value = referrer.ReferrerUrl != null ? (object)referrer.ReferrerUrl.ToString() : DBNull.Value;
            cmd.Parameters.Add(dpReferrer);

            DbParameter dpCount = provider.CreateParameter();
            dpCount.ParameterName = parmPrefix + "ReferralCount";
            dpCount.Value = referrer.Count;
            cmd.Parameters.Add(dpCount);

            DbParameter dpUrl = provider.CreateParameter();
            dpUrl.ParameterName = "Url";
            dpUrl.Value = referrer.Url != null ? (object)referrer.Url.ToString() : DBNull.Value;
            cmd.Parameters.Add(dpUrl);

            DbParameter dpIsSpam = provider.CreateParameter();
            dpIsSpam.ParameterName = "IsSpam";
            dpIsSpam.Value = referrer.PossibleSpam;
            cmd.Parameters.Add(dpIsSpam);
        }
Beispiel #58
0
        protected void Submitlogin_Click(object sender, EventArgs e)
        {
            /* validate form */

            //validate Referral Phone
            if (!Helper.IsNumeric(txtReferralPhonePt1.Text))
            {
                lblErrorMessage.Text = "Invalid referral phone number";
                txtReferralPhonePt1.Focus();
                return;
            }

            if (!Helper.IsNumeric(txtReferralPhonePt2.Text))
            {
                lblErrorMessage.Text = "Invalid referral phone number";
                txtReferralPhonePt2.Focus();
                return;
            }

            if (!Helper.IsNumeric(txtReferralPhonePt3.Text))
            {
                lblErrorMessage.Text = "Invalid referral phone number";
                txtReferralPhonePt3.Focus();
                return;
            }

            //validate Referral Fax

            if (!Helper.IsNumeric(txtReferralFaxPt1.Text))
            {
                lblErrorMessage.Text = "Invalid referral fax number";
                txtReferralFaxPt1.Focus();
                return;
            }

            if (!Helper.IsNumeric(txtReferralFaxPt2.Text))
            {
                lblErrorMessage.Text = "Invalid referral fax number";
                txtReferralFaxPt2.Focus();
                return;
            }

            if (!Helper.IsNumeric(txtReferralFaxPt3.Text))
            {
                lblErrorMessage.Text = "Invalid referral fax number";
                txtReferralFaxPt3.Focus();
                return;
            }

            //validate Social Security Number

            if (!Helper.IsNumeric(SocialSecurityNumberPt1.Text))
            {
                lblErrorMessage.Text = "Invalid Social Security Number";
                SocialSecurityNumberPt1.Focus();
                return;
            }

            if (!Helper.IsNumeric(SocialSecurityNumberPt2.Text))
            {
                lblErrorMessage.Text = "Invalid Social Security Number";
                SocialSecurityNumberPt2.Focus();
                return;
            }

            if (!Helper.IsNumeric(SocialSecurityNumberPt3.Text))
            {
                lblErrorMessage.Text = "Invalid Social Security Number";
                SocialSecurityNumberPt3.Focus();
                return;
            }

            //validate School Phone
            if (!Helper.IsNumeric(txtSchoolPhonePt1.Text))
            {
                lblErrorMessage.Text = "Invalid School Phone number";
                txtSchoolPhonePt1.Focus();
                return;
            }

            if (!Helper.IsNumeric(txtSchoolPhonePt2.Text))
            {
                lblErrorMessage.Text = "Invalid School Phone number";
                txtSchoolPhonePt2.Focus();
                return;
            }

            if (!Helper.IsNumeric(txtSchoolPhonePt3.Text))
            {
                lblErrorMessage.Text = "Invalid School Phone number";
                txtSchoolPhonePt3.Focus();
                return;
            }

            //validate chkServiceRequested

            if (!chkServiceRequestedSelected())
            {
                lblErrorMessage.Text = "Service Requested is not specified";
                chkServiceRequested.Focus();
                return;
            }

            //string values = string.Join(",", chkServiceRequested.Items.Cast<ListItem>()
            //                                 .Where(i => i.Selected)
            //                                 .Select(i => i.Value));

            string ServiceRequested = string.Empty;
            foreach (ListItem oItem in chkServiceRequested.Items)
            {
                if (oItem.Selected) // if you want only selected
                {
                    ServiceRequested = ServiceRequested + oItem.Value + ",";
                }

            }

            ServiceRequested = ServiceRequested.Substring(0, ServiceRequested.Length - 1);

            Patient patient = new Patient
            {
                ID = Int64.Parse(txtPatientNo.Text),
                FirstName = txtFirstName.Text,
                LastName = txtLastName.Text,
                DateOfBirth = DateTime.Parse(drpDateOfBirthYear.SelectedValue + "," + drpDateOfBirthMonth.SelectedValue + "," + drpDateOfBirthDay.SelectedValue),
                Gender = drpGender.SelectedValue,
                Ethnicity = drpEthnicity.SelectedValue,
                MedicaidNumber = txtMedicaidNumber.Text,
                SocialSecurityNumber = SocialSecurityNumberPt1.Text + '-' + SocialSecurityNumberPt2.Text + '-' + SocialSecurityNumberPt3.Text,
                ResidingWithName = txtResidingWithName.Text,
                ResidingWithRelationship = txtResidingWithRelationship.Text,
                SchoolName = txtSchoolName.Text,
                SchoolGrade = txtSchoolGrade.Text,
                SchoolPhone = txtSchoolPhonePt0.Text + txtSchoolPhonePt1.Text + txtSchoolPhonePt2.Text + txtSchoolPhonePt3.Text,
                EmployerName = txtEmployer.Text,
                Occupation = txtOccupation.Text,
                ClientOnProbation = chkOnProbation.Checked,
                Diagnosis = txtDiagnosis.Text,
                ServiceRequested = ServiceRequested,
                LocationofServices = drpLocationOfServices.SelectedValue,
                FinanciallyResponsiblePerson = txtFinanciallyRep.Text,
                PaymentMethod = drpPaymentMethods.SelectedValue,
                EmailAddress = txtEmailAddress.Text,
                PatientStreet = txtClientStreet.Text,
                PatientSuite = txtClientSuiteApt.Text,
                PatientCity = txtClientCity.Text,
                PatientState = drpClientState.SelectedValue,
                PatientCountry = drpClientCountry.SelectedValue,
                PatientZipCode = txtClientZipCode.Text,

            };

            Referrer referrer = new Referrer
            {
                ReferralSourceName = txtReferrerName.Text,
                ReferralSourceAgency =  txtReferrerAgency.Text,
                ReferrerPhone = txtReferralPhonePt0.Text + txtReferralPhonePt1.Text + txtReferralPhonePt2.Text + txtReferralPhonePt3.Text,
                ReferralFax = txtReferralFaxPt0.Text + txtReferralFaxPt1.Text + txtReferralFaxPt2.Text + txtReferralFaxPt3.Text,
                Street = txtReferralStreet.Text,
                Suite = txtReferralSuiteApt.Text,
                City = txtReferralCity.Text,
                State = drpReferralState.SelectedValue,
                ZipCode = txtReferralZip.Text,
                Country = drpReferralCountry.SelectedValue,
            };

            controller.Portal_SavePatient(patient, referrer);
        }
Beispiel #59
0
        /// <summary>
        /// Adds a new Referrer to the database.
        /// </summary>
        /// <param name="referrer">Referrer to add.</param>
        public override void InsertReferrer(Referrer referrer)
        {
            List<Referrer> referrers = Referrer.Referrers;
            referrers.Add(referrer);

            string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
            string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
            DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);

            using (DbConnection conn = provider.CreateConnection())
            {
                conn.ConnectionString = connString;
                conn.Open();
                using (DbCommand cmd = conn.CreateCommand())
                {
                    string sqlQuery = "INSERT INTO " + tablePrefix + "Referrers (ReferrerId, ReferralDay, ReferrerUrl, ReferralCount, Url, IsSpam) " +
                        "VALUES (@ReferrerId, @ReferralDay, @ReferrerUrl, @ReferralCount, @Url, @IsSpam)";
                    if (parmPrefix != "@")
                        sqlQuery = sqlQuery.Replace("@", parmPrefix);

                    cmd.CommandText = sqlQuery;
                    cmd.CommandType = CommandType.Text;

                    addReferrersParametersToCommand(referrer, provider, cmd);

                    cmd.ExecuteNonQuery();

                }
            }
        }
Beispiel #60
0
    public static Letter.FileContents SendTreatmentLetter(FileFormat fileFormat, Booking booking, Patient patient, HealthCard hc, Letter.TreatmentLetterType treatmentLetterType, Booking.InvoiceType invType, int fieldID, int siteID, int staffID, Referrer referrer, bool keepInHistory, int letterPrintHistorySendMethodID)
    {
        // 1. Add to healthcardaction
        int healthCardActionID = -1;
        if (treatmentLetterType == Letter.TreatmentLetterType.First || treatmentLetterType == Letter.TreatmentLetterType.Last || treatmentLetterType == Letter.TreatmentLetterType.LastWhenReplacingEPC)
            healthCardActionID = HealthCardActionDB.Insert(hc.HealthCardID, Letter.GetHealthCardActionTypeID(treatmentLetterType), DateTime.Now);

        // 2.create document and put it in history
        int letterID = Letter.GetLetterIDByTreatmentLetterTypeAndInvoiceType(treatmentLetterType, invType, fieldID, siteID);
        if (letterID == -1)
            return null;
        //string[] notes = (treatmentLetterType == TreatmentLetterType.TreatmentNotes) ? booking.GetNoteTextForTreatmentLetter(referrer) : null;
        string[] notes = null;
        Letter.FileContents fileContents = Letter.CreateLetter(fileFormat, SiteDB.GetByID(siteID), letterID, booking.Organisation.OrganisationID, patient.PatientID, staffID, booking.BookingID, healthCardActionID, 1, notes, keepInHistory, letterPrintHistorySendMethodID);
        return fileContents;

        //Letter.SendLetter(Response, SiteDB.GetByID(Convert.ToInt32(Session["SiteID"])), GetLetterID(treatmentLetterType, invType), booking.Organisation.OrganisationID, booking.Patient.PatientID, Convert.ToInt32(Session["StaffID"]), booking.BookingID, healthCardActionID, 1, null);
    }