Notify icon to all employee computer's when adding new employee

[ahm1985]

Hi guys I need to make notification icon to any computers in Hr department when i added new Employee

because my employee in my company forget to tell each others about any new employee added

so that some process will by delayed

Meaning

IF i have 4 computers in HR Department and 4 computers connected by DOMAIN
computer 1 ip 192.168.1.105

computer 2 ip 192.168.1.106

computer 3 ip 192.168.1.107

computer 4 ip 192.168.1.108

and computer 1 his ip 192.168.1.105 added new Employee successfully

after added employee computer 2 AND computer 3 AND computer 4 must have notification from computer 1

that new employee added

SqlConnection con = new SqlConnection();
cmd = new SqlCommand("INSERT_EmployeEa12", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DriverID", textBox1.Text);
cmd.Parameters.AddWithValue("@DriverName", textBox2.Text);
cmd.Parameters.AddWithValue("@EmplyeeName", textBox18.Text);
cmd.Parameters.AddWithValue("@ResidentNo", textBox6.Text);
cmd.Parameters.AddWithValue("@PlaceOfBirth", textBox17.Text);
cmd.Parameters.AddWithValue("@PassportNo", textBox21.Text);
con.Open();
int n = cmd.ExecuteNonQuery();
con.Close();
if (n > 0)
{
MessageBox.Show("record inserted Success");
}
else
{
MessageBox.Show("record inserted Failed");
}
Code insert OK working but my problem how to implement notification for new Employee added

 

[craigber]

You can use SignalR. It says it's for ASP.Net, but it works for web, winforms, wpf.

http://www.asp.net/signalr

Craig Berntson
MCSD, Visual C# MVP,

http://www.craigberntson.com/blog

 

[johnny9864]

Since you are using SQL, the best thing to do is to use SQL notifications, it's very simple to implement in C# and reliable. I implemented that in 2008 for a customer that deals with a list of members and I even notify if a second employee opens a same member.

 

[craigber]

I found this blog post that shows how to accomplish this with SignalR and why SQL notification may not work.

http://weblogs.asp.net/ricardoperes/broadcasting-database-changes-through-signalr

Craig Berntson
MCSD, Visual C# MVP,

http://www.craigberntson.com/blog