Chat in mvc asp.net through razor engine

Hi Ashutosh,

 

suppose you have chat window, then you need to capture enter event of it.

once enter is press  you need to call any method which insert that record into database.

 

private void SubmitNote(string message){

// Ensure parameter isn't null.

if(string.IsNullOrEmpty(message))

return;

// Our Insert Query:

string insert = @"INSERT INTO [Notes] ([Username], [Date], [Message])

VALUES (@Username, @Date, @Message);";

// Define our Connection & Command:

using(SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["db"].ConnectionString))

using(SqlCommand command = new SqlCommand(insert, connection)){

// Open Connection

connection.Open();

// Define our Command (AddWithValue / Add Approach)

command.Parameters.Add("@Username", SqlDbType.VarChar, 50).Values = User.Identity.Name;

command.Parameters.AddWithValue("@Date", DateTime.Now);

command.Parameters.Add("@Message", SqlDbType.VarChar).Value = message;

// Execute Query:

command.ExecuteNonQuery();

}

The method to save the chat in the database is similar to storing the data in database. Data can be anything, so it can be a message along with the UserID of the user who sent the message. 

 

You can create a table for this,

Messages
UserId | Message | Time

Then fill it with the data when user sends the messages using the service. Each message would always move through the server before going down to the clients. Then you can store that message in the database, something like, 

"INSERT INTO Messages (UserID, Message, Time) VALUES (@0, @1, @2)"

Then pass the parameters to fill the details and that is how you can store the message in the database.

Interesting question, but it has been answered many times and C# Corner contains many articles that already cover the teeny tiny bits of this concept at all. First of all, consider that ASP.NET MVC already uses Razor syntax to render the content. The code in ASP.NET MVC View is already Razor view, 

@model Type
 
@{
   ViewBag.Title = "Title for the page";
} 
 
@Model.Heading
 
@Model.Content

This is Razor! Read more about Razor here, http://weblogs.asp.net/scottgu/introducing-razor

 

Then, the thing that you have mentioned about chat system requires websockets programming. Fortunately, ASP.NET team have already developed a framework SignalR for your ease. SignalR is a powerful technology for real-time synchronization applications. You can share the content with other clients, in a run-time method! 

 

SignalR would require your attention. You need to learn the technology before you can build the chat system. I built the system for multiplayer game using SignalR and it proved that it was very much powerful. Read the following articles for that:

 

http://www.c-sharpcorner.com/UploadFile/22d000/an-overview-of-websocket-and-hub-in-signalr/

http://www.c-sharpcorner.com/UploadFile/8c19e8/Asp-Net-signalr-building-a-simple-real-time-chat-applicatio/ 

 

After that, you will automatically know how to store the data in database. You need to handle the requests coming to the server (hub) and save the data in the database along with the user ID. Since this project is a very broad topic, I cannot share any code snippet. However, you can still ask if you need more guidance. 

Ashutosh,

 

Go through below links that might help you:

 

http://www.codeproject.com/Articles/732190/Real-Time-Web-Solution-for-Chat-by-MVC-SignalR-H

 

http://www.codeproject.com/Articles/794147/MVC-Chat-room

 

https://code.msdn.microsoft.com/windowsapps/Chat-Web-Application-in-9a86e594