Week-07-CRM

24 Oct 2010
Total: 4hours

1.  <Data List> 4hours ASP.net offers server control tools, which allows us to use without coding. However, there are many similar tools, such as GridView, DataList, ListView, FormView, DetailsView, and so on. I wonder who can use these similar controls correctly. Please reconsider these naming, so I don't need to consume time to search how to use. Anyway, I want to show many cases and case histories related to the particular case. After research, I found I can use DataList in DataList. First, the key is ClientID from session, and then nested DataList will get the CaseID from parent DataList.

23 Oct 2010
Total: 6hours

1.  <Create Table> 3hours Today I created table. Now we have 24 tables, so I wrote SQL statement, because other member also need this SQL. Therefore, they just execute this SQL, which is nice. And my team member has created data dictionary, so I don't need to take such a long time.
2. <Create Dummy data > 3hours When I created dummy data, I realized many status definitions are not decided yet. So we have to consider about that kind of definitions.

22 Oct 2010
Total: 7hours

1. <Coding for mail> 5hours I could get google mail, however I realized I could not get attached file. Uhh..., so I have to find solution. Mail handling is very difficult, that's why mail software is available. I got it. So I'm still struggling about retrieve mail from mail server. Especially, ASP.net is not enough references for beginner like me. The documents of Microsoft are normally not enough sample coding or too complex. I don't know why people prefer ASP.net.
   
2. <Group meeting> 2hours We talked about prototype coding. And I will do Create Database tables and dummy data. This is not so difficult, so maybe I will finish tomorrow.
   

21 Oct 2010
Total: 8hours

1. <Coding for mail> 6hours Finally, I could get e-mail form mail box. Using this article, my team mate told to me this link. But it is not perfect, so I need to modify or I think about another way. Anyway, we can do using pop server to get Google mail.
2. <Group meeting> 2hours We discuss about the project system, this idea is good, but I wondered some people are not happy with the 3rd semester. Maybe we need more buck up and suitable advices.

20 Oct 2010
Total: 8hours

1. <Coding for chart> 2hours I have done chart coding. I use Google chart tool. Because I just create query string like following URL. And then we can show the above char!! Cool! http://chart.apis.google.com/chart?cht=p3&chd=s:Uf9a&chs=250x100&chl=January|February|March|April                         
2. <Coding for mail> 6hours Today I also try to find coding for mail, however if I find the coding. Almost all not working, because ASP.net has many versions and those files are very complex, so it is hard for me to find problems. Uhh.. I wonder I can do or not.

19 Oct 2010
Total: 6hours

1. <Prepare presentation> 1hour Yesterday, we discussed and we focused on the only ERD, so we don't need to prepare so much.
2. <Presentation> 2hours We joined presentation, and we got many advices. However, I wondered what is the purpose of this presentation. I thought we showed progress, but maybe I misunderstood it. I still don't get point of the purpose. 
3. <Coding for chart> 2hours Finally, I decided to use Google chart, because it is much more handy than ASP.net add-on tool. So we can modify anything.
4. <Coding for mail> 1hour I have tried to use google mail for 2 weeks, but reading e-mail is very very difficult. And there are advantages and disadvantages, so I need to discuss with team members.

18 Oct 2010
Total: 5hours

1. <Prepare presentation> 3hours We practiced our presentation. This time we want to focus on ERD and UML, so I will explain ERD. Now our ERD becomes very well, I am interested in showing ERD.
2. <Coding for chart> 2hours I am still doing chart coding. I tried to use ASP.net Add-on tool. But it is too difficult, so maybe I think about the way again, because Google chart is just using query string. So maybe it is not so difficult!