public void deleteDetail(PersonalDetail dt) { string delete = "UPDATE PersonalDetails SET usable=" + 0.ToString() + " WHERE Id=" + dt.id.ToString(); SqlCommand command = new SqlCommand(delete); command.Connection = DbConnection; command.ExecuteNonQuery(); }
public void createDetail(PersonalDetail dt) { string queryFrame = "INSERT INTO PersonalDetails (Id, person, category, subcategory, content, usable) " + "VALUES (@Id, @person, @category, @subcategory, @content, @usable)"; using (SqlCommand insert = new SqlCommand(queryFrame)) { insert.Connection = DbConnection; insert.Parameters.Add("@Id", SqlDbType.Int).Value = Convert.ToInt32((DateTime.Now.Ticks << 32) >> 32); insert.Parameters.Add("@person", SqlDbType.Int).Value = dt.account; insert.Parameters.Add("@category", SqlDbType.NChar, 20).Value = dt.category; insert.Parameters.Add("@subcategory", SqlDbType.Char, 20).Value = dt.subcategory; insert.Parameters.Add("@usable", SqlDbType.Int).Value = 1;/**/ insert.Parameters.Add("@content", SqlDbType.Text).Value = dt.content; insert.ExecuteNonQuery(); } } public void updateDetail(PersonalDetail origin, PersonalDetail update) { deleteDetail(origin); createDetail(update); } public void UpdatePerson(Person per) { string queryFrame = "UPDATE Persons SET name = @name, introduction=@introduction, created=@created WHERE Id=@Id"; using (SqlCommand update = new SqlCommand(queryFrame)) { update.Connection = DbConnection; update.Parameters.AddWithValue("@Id", SqlDbType.Int).Value = per.id; update.Parameters.AddWithValue("@name", SqlDbType.Text).Value = per.name; update.Parameters.AddWithValue("@introduction", SqlDbType.Text).Value = per.introduction; update.Parameters.AddWithValue("@created", SqlDbType.DateTime).Value = DateTime.Now;/**/ update.ExecuteNonQuery(); } }
public void SReceive(Object dest) { Socket other = dest as Socket; try { while (true) { byte[] data = new byte[1024 * 5000]; other.Receive(data); string msg = (string)DeserializeMsg(data); string[] tokens = msg.Split('_'); if (tokens[0] == "STATUS") { if (tokens[1] == "DISCARD CONNECTION") { p.Remove(tokens[2].ToString().Trim()); Form1.getInstance().networkSubWindow1.UpdateClientList(p, others); Form1.getInstance().UpdateConnectionStatus("Connected to " + tokens[2].ToString().Trim()); } else { p.Add(tokens[2]); Form1.getInstance().networkSubWindow1.UpdateClientList(p, others); Form1.getInstance().UpdateConnectionStatus("Connected to " + tokens[2].ToString().Trim()); } } else if (tokens[0] == "ACCOUNT") { Account a = new Account() { username = tokens[3].ToString().Trim(), id = Convert.ToInt32(tokens[1]), password = tokens[2].ToString().Trim(), created = Convert.ToDateTime(tokens[4].ToString().Trim()), }; Form1.getInstance().UpdateConnectionStatus("Received information from account " + tokens[3].ToString().Trim()); if (DataHandle.getInstance().doesAccountExit(a)) { Form1.getInstance().UpdateConnectionStatus("Account " + tokens[3].ToString().Trim() + " has already existed"); } else { DataHandle.getInstance().saveAccount(a); } } else if (tokens[0] == "DETAILS") { PersonalDetail d = new PersonalDetail() { id = Convert.ToInt32(tokens[1]), account = Convert.ToInt32(tokens[5]), category = tokens[4].ToString().Trim(), subcategory = tokens[2].ToString().Trim(), content = tokens[3].ToString().Trim(), }; DataHandle.getInstance().createDetail(d); } else if (tokens[0] == "REMINDER") { Reminders r = new Reminders() { ID = Convert.ToInt32(tokens[1]), Tittle = tokens[2].ToString().Trim(), Content = tokens[3].ToString().Trim(), Time = tokens[4].ToString().Trim(), Check = Convert.ToInt32(tokens[5]), User_id = Convert.ToInt32(tokens[6]), }; Form1.getInstance().UpdateConnectionStatus("Received reminder from account " + tokens[tokens.Length - 1]); DataHandle.getInstance().CreateNewReminder(r); } else if (tokens[0] == "NOTE") { Notes n = new Notes() { id = Convert.ToInt32(tokens[1]), Tittle = tokens[2].ToString().Trim(), Content = tokens[4].ToString().Trim(), user_id = Convert.ToInt32(tokens[3]), }; Form1.getInstance().UpdateConnectionStatus("Received reminder from account " + tokens[tokens.Length - 1]); DataHandle.getInstance().CreateNewNote(n); } } } catch { others.Remove(other); other.Close(); } }
public void CReceive() { try { while (true) { byte[] data = new byte[1024 * 5000]; peer.Receive(data); string msg = (string)DeserializeMsg(data); string[] tokens = msg.Split('_'); if (tokens[0] == "STATUS") { if (tokens[1] == "DISCARD CONNECTION") { Form1.getInstance().UpdateConnectionStatus("Disconnected to account " + tokens[tokens.Length - 1]); Close(); } else { Form1.getInstance().UpdateConnectionStatus("Connected to account " + tokens[tokens.Length - 1]); } /*p.Add(tokens[2]);*/ } else if (tokens[0] == "ACCOUNT") { Account a = new Account() { username = tokens[3].ToString().Trim(), id = Convert.ToInt32(tokens[1]), password = tokens[2].ToString().Trim(), created = Convert.ToDateTime(tokens[4].ToString().Trim()), }; DataHandle.getInstance().saveAccount(a); /* Form1.getInstance().networkSubWindow1.UpdateClientList(p, others); */ } else if (tokens[0] == "DETAILS") { PersonalDetail d = new PersonalDetail() { id = Convert.ToInt32(tokens[1]), account = Convert.ToInt32(tokens[5]), category = tokens[4].ToString().Trim(), subcategory = tokens[2].ToString().Trim(), content = tokens[3].ToString().Trim(), }; DataHandle.getInstance().createDetail(d); } else if (tokens[0] == "REMINDER") { Reminders r = new Reminders() { ID = Convert.ToInt32(tokens[1]), Tittle = tokens[2].ToString().Trim(), Content = tokens[3].ToString().Trim(), Time = tokens[4].ToString().Trim(), Check = Convert.ToInt32(tokens[5]), User_id = Convert.ToInt32(tokens[6]), }; DataHandle.getInstance().CreateNewReminder(r); } else if (tokens[0] == "NOTE") { Notes n = new Notes() { id = Convert.ToInt32(tokens[1]), Tittle = tokens[2].ToString().Trim(), Content = tokens[4].ToString().Trim(), user_id = Convert.ToInt32(tokens[3]), }; DataHandle.getInstance().CreateNewNote(n); } } } catch { Close(); } }