public static void DistributeReminder(Reminders r) { foreach (Socket other in others) { SSendReminder(other, r); } }
public static void SSendReminder(Socket other, Reminders r) { string msg = "REMINDER_" + r.ID.ToString() + "_" + r.Tittle + "_" + r.Content + "_" + r.Time + "_" + r.Check.ToString() + "_" + r.User_id.ToString() + "_" + DataHandle.getInstance().getRecentAccount().username; other.Send(SerializeMsg(msg)); }
public void CreateNewReminder(Reminders rmd) { string queryFrame = "INSERT into Reminder (Tittle,Content,Timer,Checker,Id_User) VALUES (@Tittle,@Content,@Timer,@Checker,@Id_User)"; using (SqlCommand newrmd = new SqlCommand(queryFrame)) { newrmd.Connection = DbConnection; Console.WriteLine("=========================="); newrmd.Parameters.Add("@Tittle", SqlDbType.NVarChar).Value = rmd.Tittle; newrmd.Parameters.Add("@Content", SqlDbType.NVarChar).Value = rmd.Content; newrmd.Parameters.Add("@Timer", SqlDbType.VarChar).Value = rmd.Time; newrmd.Parameters.Add("@Checker", SqlDbType.Int).Value = rmd.Check; newrmd.Parameters.Add("@Id_User", SqlDbType.Int).Value = rmd.User_id; newrmd.ExecuteNonQuery(); Console.WriteLine("Nhap du lieu thanh cong"); newrmd.Dispose(); } }
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(); } }