create account

DayBook Application 2nd Attempt Using C# and SQL by animecraze

View this thread on: hive.blogpeakd.comecency.com
· @animecraze ·
$1.61
DayBook Application 2nd Attempt Using C# and SQL
**Hello Steemians!**
**I Hope you are all fine and doing well**

I was learning these new things that is why I wasn't available here, now i am dealing with my work and other activities so from now on I will be posting my work-related or favorite things here frequently.

**This is my 2nd attempt of making an application that is already on the internet but I am trying to learn C# and SQL for my semester projects, that is why I made this desktop application.**

I will be explaining some things about my application after images, forgive me if I do some mistakes explaining things incorrectly because my English is not that good :P
<center>
**DayBook Main Form**
![DayBook Main Form 1.png](https://ipfs.busy.org/ipfs/QmRCyqYheGbUbXLcg4oyoSkecHGr2CjSy8vPZ3Co676cqa)
[Click Here to See Full Picture : ](https://ipfs.busy.org/ipfs/QmRCyqYheGbUbXLcg4oyoSkecHGr2CjSy8vPZ3Co676cqa)
</center>
In this main form, there are records of transactions made on selected accounts from the account chart. The other fields are for displaying data from that account on the same day and full report from when the software will be installed and is in use. You can not update once a transaction is made however you can delete it and enter new one again.
<center>
**Account Group - Save Form**
</center>
![Account Group Save.png](https://ipfs.busy.org/ipfs/QmYbhisEHDr9moAFEZNRD3meXvvSkrgadDDPKU4AVBCGSS)
[Click to See Full Picture ](https://ipfs.busy.org/ipfs/QmYbhisEHDr9moAFEZNRD3meXvvSkrgadDDPKU4AVBCGSS)
Account Group sections are used to make new accounts like adding a place to add customers, bills, purchases and much more.
This is my Save Tab Form for Saving a New Group.
<center>
**Account Group - Delete Form**
</center>
![delete group.png](https://ipfs.busy.org/ipfs/QmaXk7uUAWDfdkZD9JtQXonJRxxNE5sNTMB1pR8pNSCn5t)
[Click Here To See Full Picture ](https://ipfs.busy.org/ipfs/QmaXk7uUAWDfdkZD9JtQXonJRxxNE5sNTMB1pR8pNSCn5t)
Place Id as group id and once you leave that field the Group will automatically will be displayed in its field and then you can delete it from the accounts group section.
<center>
**Account Group - Update Form**
</center>
![update groups.png](https://ipfs.busy.org/ipfs/QmbTLHwEg7grtaiDPsW5y7G42n94Wk2UrWWveapXg5Mco1)
[Click Here To See Full Picture ](https://ipfs.busy.org/ipfs/QmbTLHwEg7grtaiDPsW5y7G42n94Wk2UrWWveapXg5Mco1)
The working is same as Delete form just by placing id on field you can update any accounts created before.
<center>
**Account Group - Print Form**
</center>
![print view.png](https://ipfs.busy.org/ipfs/QmPrcy7LKVUQ8zJ48wqmEr3A4KtXVLjpz14GPBztbka7bi)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmPrcy7LKVUQ8zJ48wqmEr3A4KtXVLjpz14GPBztbka7bi)
This print report i designed myself that is why it looks so weird.

<center>
**Account Chart - Main Form**
</center>
![Data Entry.png](https://ipfs.busy.org/ipfs/QmaAP46Nm68eNsdwveb1RiywvXumeyGdsi13n7dEEwj9BW)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmaAP46Nm68eNsdwveb1RiywvXumeyGdsi13n7dEEwj9BW)
The work is same as i defined account groups, so it dosen't need much explanation.
<center>
**Account Chart - Saving Form**
</center>
![Saving Data.png](https://ipfs.busy.org/ipfs/QmccSamXVSRLJRzi7DyeMW476UT9frEiUdGa389Brkwyp6)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmccSamXVSRLJRzi7DyeMW476UT9frEiUdGa389Brkwyp6)
Data has been saved by clicking on the button.
<center>
**Account Chart - Refreshing Form**
</center>
![Refresh Look.png](https://ipfs.busy.org/ipfs/QmT8nHzfWRoXRjmkBrHuZ89KYwwTwNDHGUFYXnuzVi75E2)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmT8nHzfWRoXRjmkBrHuZ89KYwwTwNDHGUFYXnuzVi75E2)
After clicking refresh buttons all the fields i want empty are emptied.
<center>
**Account Chart - Print Preview**
</center>
![Print View.png](https://ipfs.busy.org/ipfs/QmW16mxrsfvHUtg6aCfjanjUH9fKVy3JdR6dtRbSxjbn6H)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmW16mxrsfvHUtg6aCfjanjUH9fKVy3JdR6dtRbSxjbn6H)
Print Button Shows the Report that is ready to be printed on A4 Selected paper size.
<center>
**Account Chart - Viewing Account Lists**
</center>
![Viewing Account Lists.png](https://ipfs.busy.org/ipfs/QmQPudhZBPgZc1JzAPezb4278g6RWyuLKsf3c3RxRxHpSw)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmQPudhZBPgZc1JzAPezb4278g6RWyuLKsf3c3RxRxHpSw)
By clicking on the preview account lists it will display all the fields in Grid and it has no print option just you can view it and update any field you want but i disabled that function too :P
<center>
**Account Ledger - Main Form**
</center>
![Account Ledger Main Form.png](https://ipfs.busy.org/ipfs/QmXjc9VQS4os3zRrkvRTCWkRtddDzVdvt5qt7iWZQmnioR)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmXjc9VQS4os3zRrkvRTCWkRtddDzVdvt5qt7iWZQmnioR)
This is Account Ledger Form, here you can check which transactions you made on which account on any dates you want. By clicking on Show field after inputting the required data it will display all the data matching your conditions.
<center>
**Account Ledger - Preview of Data**
</center>
![Data View.png](https://ipfs.busy.org/ipfs/QmSvqqGdB1ypr7gK4wCaFXKK9uV6acKNvcatxTw5E3avYP)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmSvqqGdB1ypr7gK4wCaFXKK9uV6acKNvcatxTw5E3avYP)
After Clicking on Show that is how your report will look like.
<center>
**Account Ledger - Print Preview**
</center>
![Print View.png](https://ipfs.busy.org/ipfs/QmSsXSKcaE3N6ryisaoMLo4NiD2jVAquAFuFQDYZWREVcP)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmSsXSKcaE3N6ryisaoMLo4NiD2jVAquAFuFQDYZWREVcP)
That is how it will be printed on the Paper.
<center>
**DayBook Exiting**
</center>
![End.png](https://ipfs.busy.org/ipfs/QmUdWLEcimcf4g6893Vhonk6JnoDhiBKeNTeEV2v6NDD5B)
[Click Here To See Full Picture](https://ipfs.busy.org/ipfs/QmUdWLEcimcf4g6893Vhonk6JnoDhiBKeNTeEV2v6NDD5B)
Obviously, when you press Exit button it will close all the windows and ta-da your application will close.

<center>
**Thank You for reading :) :) It means a lot**
</center>


<center>
**Every individual with good efforts and working skills, who knows how to co-operate with each other and join our [Discord Channel](https://discord.gg/2qhhdzK) to be part of ADSACTLY and find yourself in a place filled with Projects and workable things.**

> "Vote @adsactly-witness for Steem witness!
Witness proposal is here:[Click Here](https://discord.gg/2qhhdzK)"
![adsactly.png](https://ipfs.busy.org/ipfs/QmeLRauMFC9snDF3XAaT4snsoNJfwxaReqi9vEzyKE2JvJ)

</center>
<center>
>Here is the Invitation to Steem Schools.
[Click Here to Join Today](https://discord.gg/uwJdw92)
**Here we help each other by giving classes and knowledge to Grow, Learn and Achieve our Dreams, Goals and anything we want.
Here is More to Steemit than just Scrooling, Believe me.
You Will be flattered to see Steemians working together.**
I'm inviting you people to join and get benefits for sure: @amina-khalid, @rabiagilani, @bkrish, @moneybomber, @abidjutt.pkr, @anwerkhan, @kmayegaindia, @rahul7734

**Thanks to these people for motivating me and others 
(@dlive, @wales, @abdulmanan, @flysky, @gloeze, @followforupvotes, @fabrik, @steemitboard, @k3nb0b, @ionutciobanu, @hurapon, @leurbanexplorer, @anomaly, @mostafamd, @faisalrajput, @affirmation, @arcangelarts, @elmicta)**

**Resteem This post to invite all of your followers and friends.**
![U5drvWcwdAcNGA6APYbtD9gncpFnaN1.gif](https://ipfs.busy.org/ipfs/QmVpwuKN38UaW5Rd1zfiaiwrd3T1oyiokBtAjFqnGt1vY4)

Recent Post :
[Musing! Do you know about it? ](https://steemit.com/musing/@animecraze/musing-do-you-know-about-it)

![followme.gif](https://ipfs.busy.org/ipfs/QmbT7JSSw8wX4qnUq7Q31btYMDjDMMMmJSyuiGMXAwbaSk)

</center>
👍  , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
authoranimecraze
permlinkdaybook-application-2nd-attempt-using-c-and-sql
categorysteemit
json_metadata{"community":"busy","app":"busy/2.5.6","format":"markdown","tags":["steemit","money","life","steem","llifesteemesteemphotography"],"users":["adsactly-witness","amina-khalid","rabiagilani","bkrish","moneybomber","abidjutt.pkr","anwerkhan","kmayegaindia","rahul7734","dlive","wales","abdulmanan","flysky","gloeze","followforupvotes","fabrik","steemitboard","k3nb0b","ionutciobanu","hurapon","leurbanexplorer","anomaly","mostafamd","faisalrajput","affirmation","arcangelarts","elmicta","animecraze"],"links":["https://ipfs.busy.org/ipfs/QmRCyqYheGbUbXLcg4oyoSkecHGr2CjSy8vPZ3Co676cqa","https://ipfs.busy.org/ipfs/QmYbhisEHDr9moAFEZNRD3meXvvSkrgadDDPKU4AVBCGSS","https://ipfs.busy.org/ipfs/QmaXk7uUAWDfdkZD9JtQXonJRxxNE5sNTMB1pR8pNSCn5t","https://ipfs.busy.org/ipfs/QmbTLHwEg7grtaiDPsW5y7G42n94Wk2UrWWveapXg5Mco1","https://ipfs.busy.org/ipfs/QmPrcy7LKVUQ8zJ48wqmEr3A4KtXVLjpz14GPBztbka7bi","https://ipfs.busy.org/ipfs/QmaAP46Nm68eNsdwveb1RiywvXumeyGdsi13n7dEEwj9BW","https://ipfs.busy.org/ipfs/QmccSamXVSRLJRzi7DyeMW476UT9frEiUdGa389Brkwyp6","https://ipfs.busy.org/ipfs/QmT8nHzfWRoXRjmkBrHuZ89KYwwTwNDHGUFYXnuzVi75E2","https://ipfs.busy.org/ipfs/QmW16mxrsfvHUtg6aCfjanjUH9fKVy3JdR6dtRbSxjbn6H","https://ipfs.busy.org/ipfs/QmQPudhZBPgZc1JzAPezb4278g6RWyuLKsf3c3RxRxHpSw"],"image":["https://ipfs.busy.org/ipfs/QmRCyqYheGbUbXLcg4oyoSkecHGr2CjSy8vPZ3Co676cqa","https://ipfs.busy.org/ipfs/QmYbhisEHDr9moAFEZNRD3meXvvSkrgadDDPKU4AVBCGSS","https://ipfs.busy.org/ipfs/QmaXk7uUAWDfdkZD9JtQXonJRxxNE5sNTMB1pR8pNSCn5t","https://ipfs.busy.org/ipfs/QmbTLHwEg7grtaiDPsW5y7G42n94Wk2UrWWveapXg5Mco1","https://ipfs.busy.org/ipfs/QmPrcy7LKVUQ8zJ48wqmEr3A4KtXVLjpz14GPBztbka7bi","https://ipfs.busy.org/ipfs/QmaAP46Nm68eNsdwveb1RiywvXumeyGdsi13n7dEEwj9BW","https://ipfs.busy.org/ipfs/QmccSamXVSRLJRzi7DyeMW476UT9frEiUdGa389Brkwyp6","https://ipfs.busy.org/ipfs/QmT8nHzfWRoXRjmkBrHuZ89KYwwTwNDHGUFYXnuzVi75E2","https://ipfs.busy.org/ipfs/QmW16mxrsfvHUtg6aCfjanjUH9fKVy3JdR6dtRbSxjbn6H","https://ipfs.busy.org/ipfs/QmQPudhZBPgZc1JzAPezb4278g6RWyuLKsf3c3RxRxHpSw","https://ipfs.busy.org/ipfs/QmXjc9VQS4os3zRrkvRTCWkRtddDzVdvt5qt7iWZQmnioR","https://ipfs.busy.org/ipfs/QmSvqqGdB1ypr7gK4wCaFXKK9uV6acKNvcatxTw5E3avYP","https://ipfs.busy.org/ipfs/QmSsXSKcaE3N6ryisaoMLo4NiD2jVAquAFuFQDYZWREVcP","https://ipfs.busy.org/ipfs/QmUdWLEcimcf4g6893Vhonk6JnoDhiBKeNTeEV2v6NDD5B","https://ipfs.busy.org/ipfs/QmeLRauMFC9snDF3XAaT4snsoNJfwxaReqi9vEzyKE2JvJ","https://ipfs.busy.org/ipfs/QmVpwuKN38UaW5Rd1zfiaiwrd3T1oyiokBtAjFqnGt1vY4","https://ipfs.busy.org/ipfs/QmbT7JSSw8wX4qnUq7Q31btYMDjDMMMmJSyuiGMXAwbaSk"]}
created2018-09-03 07:36:36
last_update2018-09-03 07:36:36
depth0
children3
last_payout2018-09-10 07:36:36
cashout_time1969-12-31 23:59:59
total_payout_value1.342 HBD
curator_payout_value0.271 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length7,729
author_reputation293,462,478,746
root_title"DayBook Application 2nd Attempt Using C# and SQL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id70,160,959
net_rshares1,319,577,011,549
author_curate_reward""
vote details (23)
@fabrik ·
I just realized my name is on the list, and I'm honoured to be.  Keep up the great work, I got into C# and MySQL myself, cheers and thanks!!
properties (22)
authorfabrik
permlinkre-animecraze-daybook-application-2nd-attempt-using-c-and-sql-20190122t142957370z
categorysteemit
json_metadata{"tags":["steemit"],"app":"steemit/0.1"}
created2019-01-22 14:29:57
last_update2019-01-22 14:29:57
depth1
children0
last_payout2019-01-29 14:29:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length140
author_reputation58,086,707,951
root_title"DayBook Application 2nd Attempt Using C# and SQL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id78,764,811
net_rshares0
@resteemator ·
@resteemator is a new bot casting votes for its followers. Follow @resteemator and vote this comment to increase your chance to be voted in the future!
properties (22)
authorresteemator
permlink20180904t132004395z
categorysteemit
json_metadata{"tags":["steem"],"app":"steemjs/test"}
created2018-09-04 13:20:06
last_update2018-09-04 13:20:06
depth1
children0
last_payout2018-09-11 13:20:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length151
author_reputation-248,953,111,874
root_title"DayBook Application 2nd Attempt Using C# and SQL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id70,290,252
net_rshares0
@steemitboard ·
Congratulations @animecraze! You have completed the following achievement on Steemit and have been rewarded with new badge(s) :

[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png)](http://steemitboard.com/@animecraze) Award for the number of upvotes received

<sub>_Click on the badge to view your Board of Honor._</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>



> You can upvote this notification to help all Steemit users. Learn why [here](https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png)!
properties (22)
authorsteemitboard
permlinksteemitboard-notify-animecraze-20180903t155814000z
categorysteemit
json_metadata{"image":["https://steemitboard.com/img/notify.png"]}
created2018-09-03 15:58:15
last_update2018-09-03 15:58:15
depth1
children0
last_payout2018-09-10 15:58:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length623
author_reputation38,975,615,169,260
root_title"DayBook Application 2nd Attempt Using C# and SQL"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id70,199,102
net_rshares0