Total 6 hours
- <Group Meeting> 2 hours We discussed about the table layout. In this time we haven't done normalization. So there are many tables, which have duplicated information, for example, status, category and so on.
- <Coding for Reminder function> 4 hours Honestly, I want to finish up the reminder function today, however I could not finish. So I will continue that on weekend. This weekend I have an appointment, so I don't know I can finish or not. Anyway I will do my best:)
28 Oct 2010
Total 6 hours
- <Coding for mail> 1hours I created to display part of the recent e-mail address. I checked the recent e-mail and I could get result, which I expected.
- <Coding for Reminder function > 5hours Now I make the programming for the reminder function. I realized one page has many functions, so I have to coding many things. And also I need to send e-mail to the using smtp, however sending e-mail function has already done at the last semester, so I can do.
27 Oct 2010
Total 8 hours
- <Coding for mail> 3hours I searched internet and I found the C# console application can create exe file. So I can make exe file and I create schedule to do this execute file every 5 min.
- <Coding for Reminder function > 5hours I make the reminder function, however I need to take a time using ASP.net, because I don't know many functions, and also sometimes working is different from my expectation. So I need time.
Tool bar > Build > Batch build > select release and then press Build button. You can fine bin file in the release folder, there is exe file.
I create record using control panel in side scheduler.
26 Oct 2010
Total 5 hours
- <Coding for mail> 3hours I thought the web application is not suitable for getting e-mail, because someone must go to this web site. So I need to create bat file or some kind of executable file. This programming can get e-mail automatically, which means no one action to get e-mail. Therefore, system can do to get data automatically.
- <Presentation meeting> 2hours We attend the meeting.This time only two group made a presentation, so we have a time to do.
Total 4 hours
- <Coding for mail> 4hours Today is Labor day, which is New Zealand National holiday. New Zealand's holidays are less than Japanese ones. So I got a little rest. Today, I could get to read Google mail using ATOM Feed. Finally, I understood C# XML classes. Actually, there are many similar naming classes, so I need to research one by one. I can already read some ATOM feed, but I could not get attribute of the link, for example "href=". So if someone may try to do same thing, I will write down coding.
GmailHandler Class
I downloaded this class form http://fci-h.blogspot.com
using System; using System.Data; using System.Xml; using System.Net; using System.IO; /* * this code made by Ahmed Essawy * AhmedEssawy@gmail.com * http://fci-h.blogspot.com */ ////// Summary description for Class1 /// public class GmailHandler { private string username; private string password; private string gmailAtomUrl; public string GmailAtomUrl { get { return gmailAtomUrl; } set { gmailAtomUrl = value; } } public string Password { get { return password; } set { password = value; } } public string Username { get { return username; } set { username = value; } } public GmailHandler(string _Username, string _Password, string _GmailAtomUrl) { Username = _Username; Password = _Password; GmailAtomUrl = _GmailAtomUrl; } public GmailHandler(string _Username, string _Password) { Username = _Username; Password = _Password; GmailAtomUrl = "https://mail.google.com/mail/feed/atom"; } public XmlDocument GetGmailAtom() { byte[] buffer = new byte[8192]; int byteCount = 0; XmlDocument _feedXml = null; try { System.Text.StringBuilder sBuilder = new System.Text.StringBuilder(); WebRequest webRequest = WebRequest.Create(GmailAtomUrl); webRequest.PreAuthenticate = true; System.Net.NetworkCredential credentials = new NetworkCredential(this.Username, this.Password); webRequest.Credentials = credentials; WebResponse webResponse = webRequest.GetResponse(); Stream stream = webResponse.GetResponseStream(); while ((byteCount = stream.Read(buffer, 0, buffer.Length)) > 0) sBuilder.Append(System.Text.Encoding.ASCII.GetString(buffer, 0, byteCount)); _feedXml = new XmlDocument(); _feedXml.LoadXml(sBuilder.ToString()); } catch (Exception ex) { //add error handling throw ex; } return _feedXml; } }
Default.aspx.cs
This page calls Google mail Atom feed and displays result.
I was struggling "if (entrychild.Name == "link")" part, because Atom feed uses link for attribute. If it was <link> URL </link>, there would be no problem:)
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Xml;
using System.Net;
using System.IO;
using System.Net.Sockets;
using System.Net.Security;
using System.Text.RegularExpressions;
using System.Xml.XPath;
public partial class _Default : System.Web.UI.Page
{
public string r = null;
protected void Page_Load(object sender, EventArgs e)
{
//Create the object from GmailHandler class
GmailHandler gmailFeed = new GmailHandler("your username", "password");
//Get the feed :)
XmlDocument myXml = gmailFeed.GetGmailAtom();
//For to get Name and Innner Text From Atom Feed
XmlElement root = myXml.DocumentElement;
XmlNodeList xmlnode = myXml.GetElementsByTagName("entry");
foreach (XmlElement entry in xmlnode)
{
foreach (XmlElement entrychild in entry)
{
if (entrychild.Name == "author")
{
foreach (XmlElement entry2ndchild in entrychild)
{
Response.Write(entry2ndchild.Name);
Response.Write(":\t" + entry2ndchild.InnerText + " \n
");
}
}
Response.Write(entrychild.Name);
Response.Write(":\t" + entrychild.InnerText + " \n
");
if (entrychild.Name == "link")
{
string target = entrychild.OuterXml;
Match match = Regex.Match(target,
@"href=""([^""]+)""");
if (match.Success)
{
string href = match.Groups[1].Value;
Response.Write(href + " \n
");
}
}
}
Response.Write("\r\n\r\n
");
}
}
}
