Dynamic WinForm

  • Durum: Closed
  • Ödül: $290
  • Alınan Girdiler: 13
  • Kazanan: rodhall85

Yarışma Özeti

Description:
- Environment: WinForms, C#, Entity Framework, MS SQL
- Based on certain criteria the results of a search (derived from MS SQL by Entity Framework statement) shall be dynamically shown on a WinForm
- For each entry in the database the criteria are stored (see attached screenshot of the database – table “Entry”)
- Additionally, for each entry the following characteristics are stored: Name , Street, Address, Postal Code, DateofBirth, TelephoneNo, Description
Tasks:
1. Create EF statement for the search based on hierarchical criteria
- There shall be four search criteria in a hierarchical order
- Criterion 1 is always given (i.e. for this criterion there is always a value stored in the database) whereas criteria 2 – 4 are optional (i.e. for these criteria there is not always a value stored in the database)
- It shall be searched “backwards”: if a value is selected for criterion 4 it shall primarily searched for this criterion in the database and all matching results shall be selected for displaying on WinForm
- If there is no match for this criterion then search for criterion 3 (if a value has been selected for this criterion 3) and display matching results on WinForm; if there is no match for this criterion search for criterion 2 (if a value has been selected for this criterion 2) and display matching results on WinForm
- Finally, if there is no match for criteria 2 – 4 and/or no values have been selected for criteria 2 – 4 then search for the “must have” criterion 1 and display all matching results on WinForm

2. Display of the result(s) on WinForms
- Each result and its corresponding characteristics (name, street, address, postalcode, dateofbirth, telephoneno, description) shall be displayed in the same layout: each characteristic shall be displayed in a label and all characteristics which belong to one result shall be grouped in a groupbox - one after another on the winform (see attached screenshot as an example for two results)
- For each result a checkbox shall be displayed on the WinForm (see attached screenshot)
- The description can be of different length - therefore the label shall accept "multiline" and the subsequent controls shall be arranged lower on the winform depending on the height of the description label

3. Save selected results in database
- If Save-Button is clicked, the uniqueID for the respective selected result(s) shall be stored in a different table in the database (see attached file – table “Matches”)
The database with some “dummy” entries will be provided in case of selecting the offer.

Tavsiye Edilen Beceriler

İşveren Geribildirimi

“Rod made a very good job - he immediately got the point and delivered everything in time and exactly as requested. I definitely will hire him again. Alexander Lotsch”

Profil Görüntüsü alotsch, Germany.

Bu yarışmadan başlıca girdiler

Daha Fazla Katılım Görüntüle

Genel Açıklama Panosu

  • alotsch
    Yarışma Sahibi
    • 2 yıl önce

    Dear All, many thanks for your participation in this contest! I very much appreciate your efforts. Best regards Alexander

    • 2 yıl önce
    1. endlessflier
      endlessflier
      • 2 yıl önce

      I would like to work this project.

      • 2 yıl önce
    2. endlessflier
      endlessflier
      • 2 yıl önce

      How are you?

      I think I can complete within a day.

      Best regards.

      • 2 yıl önce
  • rodhall85
    rodhall85
    • 2 yıl önce

    Can you please let me know how to get hold of the database? Many Thanks

    • 2 yıl önce
    1. alotsch
      Yarışma Sahibi
      • 2 yıl önce

      Hi Rod, your proposal seems to match what I requested. But one question: I am not familiar with the MVC pattern but have just basic knowledge in programming. Therefore, is it possible that you provide me with a "streamlined" solution without MVC pattern? Thanks Alex

      • 2 yıl önce
    2. rodhall85
      rodhall85
      • 2 yıl önce

      Thanks Alex. Certainly, I have messaged you and will await the database before packaging up. Rod

      • 2 yıl önce
  • epushkareva
    epushkareva
    • 2 yıl önce

    Maxkoryukov. I think, he is the best:)

    • 2 yıl önce
  • endlessflier
    endlessflier
    • 2 yıl önce

    I will update this as you wanted.

    • 2 yıl önce
  • endlessflier
    endlessflier
    • 2 yıl önce

    How are you?
    I would like to know about your suggestion for #3.
    Best regards.

    • 2 yıl önce
  • sherifyouseef97
    sherifyouseef97
    • 2 yıl önce

    Hello i have created the database and i will move to the application now

    • 2 yıl önce
  • winwix
    winwix
    • 2 yıl önce

    Please tell what is the search criteria?

    • 2 yıl önce
    1. andrivanrooyen
      andrivanrooyen
      • 2 yıl önce

      Ok sounds good. How can I get a copy of the DB?

      • 2 yıl önce
    2. alotsch
      Yarışma Sahibi
      • 2 yıl önce

      I will provide the mssql database files (.mdf and .ldf) via dropbox or onedrive

      • 2 yıl önce
  • tomaneki
    tomaneki
    • 2 yıl önce

    You have 4 different criteria types which can have multiple values, so on your database schematics table/tables criteria is missing. Also data types are not shown. Will you provide exact/accurate database or this schematic is just for guideline and I need to make database also ? Thanks

    • 2 yıl önce
    1. alotsch
      Yarışma Sahibi
      • 2 yıl önce

      The database will be provided by me

      • 2 yıl önce
  • shahidkhan1982
    shahidkhan1982
    • 2 yıl önce

    i can do this.pls contact me.

    • 2 yıl önce
  • karkimanoj007
    karkimanoj007
    • 2 yıl önce

    i am ready to do

    • 2 yıl önce

Daha fazla yorum göster

Yarışmalara nasıl başlanır

  • Projenizi ilan edin

    Yarışmanızı İlan Edin Hızlı ve kolay

  • Tonlarca girdi alın

    Tonlarca Girdi Alın Bütün dünyadan

  • En iyi girdiyi seçin

    En iyi girdiyi seçin Dosyaları indirin - Kolay!

Şimdi bir Yarışma İlan Et ya da Bugün Bize Katılın!