public VideoChatSettings InitiateVideoChat(long conversationid, string message, long peerid, int messagetype) { try { int res = -1; List<VideoChatSettings> objcoll = new List<VideoChatSettings>(); VideoChatSettings objvideo = null; string constr = ConfigurationManager.ConnectionStrings["HickConnectionString"].ConnectionString.ToString(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = constr; conn.Open(); //using (SqlCommand command = new SqlCommand("select * from Hick_VideoConversation_Log as l where ConversationId=" + conversationid + " and l.PeerId=" + peerid + " and l.MessageType=" + (int)MessageTypes.Video + " and l.Status=" + (int)ReadStatus.CallInitiated + "", conn)) using (SqlCommand command = new SqlCommand("sp_hick_FetchVideoConvToInitiate", conn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ConvId", conversationid); command.Parameters.AddWithValue("@PeerId", peerid); command.Parameters.AddWithValue("@MsgType", (int)MessageTypes.Video); command.Parameters.AddWithValue("@Status", (int)ReadStatus.CallInitiated); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { //var cmd = "UPDATE Hick_Conversation_log set Conversation_log=@msg, Conversation_date=@date where Conversation_Id=" + conversationid + " and peerid=" + peerid + " and Message_Type=" + (int)MessageTypes.Video + ""; //using (SqlCommand command1 = new SqlCommand(cmd, conn)) //{ // command1.Parameters.AddWithValue("@msg", message); // command1.Parameters.AddWithValue("@date", DateTime.Now); // res = command1.ExecuteNonQuery(); //} objvideo = new VideoChatSettings(); objvideo.EnableVideoChat = Convert.ToBoolean(ConfigurationManager.AppSettings["EnableVideoChat"]); objvideo.FlashServerType = Convert.ToString(ConfigurationManager.AppSettings["FlashServerType"]).Trim(); objvideo.FlashMediaServer = Convert.ToString(ConfigurationManager.AppSettings["FlashMediaServer"]).Trim(); objvideo.BroadcastVideoWidth = Convert.ToString(ConfigurationManager.AppSettings["BroadcastVideoWidth"]).Trim(); objvideo.BroadcastVideoheight = Convert.ToString(ConfigurationManager.AppSettings["BroadcastVideoheight"]).Trim(); objvideo.BroadcastVideoGuid = Convert.ToString(reader["VideoId"]); objvideo.ParentVideoId = Convert.ToString(reader["ParentVideoId"]); objcoll.Add(objvideo); } } if (objcoll.Count > 0) { for (int i = 0; i < objcoll.Count; i++) { UpdateVideoCallStatus(conversationid, objcoll[i].BroadcastVideoGuid, String.IsNullOrEmpty(objcoll[i].ParentVideoId) ? string.Empty : objcoll[i].ParentVideoId, (int)ReadStatus.CallEnded, (int)MessageTypes.Video, 0); } } //var cmd = "INSERT INTO Hick_VideoConversation_Log (ConversationId,VideoId,ConversationDate,PeerId,MessageType,Status) VALUES (@conid,@msg,@date,@curntuserid,@messagetype,@status)"; using (SqlCommand command2 = new SqlCommand("sp_hick_InsertVideoConversationLog", conn)) { command2.CommandType = CommandType.StoredProcedure; command2.Parameters.AddWithValue("@conid", conversationid); command2.Parameters.AddWithValue("@msg", message); command2.Parameters.AddWithValue("@date", DateTime.Now); command2.Parameters.AddWithValue("@curntuserid", peerid); command2.Parameters.AddWithValue("@messagetype", messagetype); command2.Parameters.AddWithValue("@status", (int)ReadStatus.CallInitiated); res = command2.ExecuteNonQuery(); if (res >= 0) { objvideo = new VideoChatSettings(); objvideo.EnableVideoChat = Convert.ToBoolean(ConfigurationManager.AppSettings["EnableVideoChat"]); objvideo.FlashServerType = Convert.ToString(ConfigurationManager.AppSettings["FlashServerType"]).Trim(); objvideo.FlashMediaServer = Convert.ToString(ConfigurationManager.AppSettings["FlashMediaServer"]).Trim(); objvideo.BroadcastVideoWidth = Convert.ToString(ConfigurationManager.AppSettings["BroadcastVideoWidth"]).Trim(); objvideo.BroadcastVideoheight = Convert.ToString(ConfigurationManager.AppSettings["BroadcastVideoheight"]).Trim(); objvideo.BroadcastVideoGuid = message; } } } } } return objvideo; } catch (Exception) { throw; } }
public VideoChatSettings ReceiveVideo(long conversationid, long peerid, long currentuserid) { VideoChatSettings objvideo = new VideoChatSettings(); try { string constr = ConfigurationManager.ConnectionStrings["HickConnectionString"].ConnectionString.ToString(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = constr; conn.Open(); //using (SqlCommand command = new SqlCommand("select top 1 * from Hick_VideoConversation_Log as l where ConversationId=" + conversationid + " and l.PeerId=" + peerid + " and l.MessageType=" + (int)MessageTypes.Video + " and l.Status=" + (int)ReadStatus.CallInitiated + " order by l.ConversationDate desc", conn)) using (SqlCommand command = new SqlCommand("sp_hick_FetchTopVidConvLog", conn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ConvId", conversationid); command.Parameters.AddWithValue("@UserId", peerid); command.Parameters.AddWithValue("@MsgType", (int)MessageTypes.Video); command.Parameters.AddWithValue("@Status", (int)ReadStatus.CallInitiated); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { objvideo.ReceiveVideoGuid = Convert.ToString(reader["VideoId"]); objvideo.EnableVideoChat = Convert.ToBoolean(ConfigurationManager.AppSettings["EnableVideoChat"]); objvideo.FlashServerType = Convert.ToString(ConfigurationManager.AppSettings["FlashServerType"]).Trim(); objvideo.FlashMediaServer = Convert.ToString(ConfigurationManager.AppSettings["FlashMediaServer"]).Trim(); objvideo.BroadcastVideoWidth = Convert.ToString(ConfigurationManager.AppSettings["BroadcastVideoWidth"]).Trim(); objvideo.BroadcastVideoheight = Convert.ToString(ConfigurationManager.AppSettings["BroadcastVideoheight"]).Trim(); } } } } //using (SqlCommand command = new SqlCommand("select top 1 * from Hick_VideoConversation_Log as l where ConversationId=" + conversationid + " and l.PeerId=" + currentuserid + " and l.MessageType=" + (int)MessageTypes.Video + " and l.Status=" + (int)ReadStatus.CallInitiated + " order by l.ConversationDate desc", conn)) using (SqlCommand command = new SqlCommand("sp_hick_FetchTopVidConvLog", conn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ConvId", conversationid); command.Parameters.AddWithValue("@UserId", currentuserid); command.Parameters.AddWithValue("@MsgType", (int)MessageTypes.Video); command.Parameters.AddWithValue("@Status", (int)ReadStatus.CallInitiated); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { objvideo.BroadcastVideoGuid = Convert.ToString(reader["VideoId"]); } } } } if (objvideo != null) { if (!String.IsNullOrEmpty(objvideo.BroadcastVideoGuid) && !String.IsNullOrEmpty(objvideo.ReceiveVideoGuid)) { UpdateParentVedioId(conversationid, objvideo.BroadcastVideoGuid, objvideo.ReceiveVideoGuid); UpdateParentVedioId(conversationid, objvideo.ReceiveVideoGuid, objvideo.BroadcastVideoGuid); } } } } catch (Exception) { throw; } return objvideo; }
public VideoChatSettings BroadcastGroupVideo(long conversationid, string peerid, string groupId) { VideoChatSettings objvideo = new VideoChatSettings(); //try //{ // string guid = Convert.ToString(Guid.NewGuid()); // //objvideo = InitiateVideoChat(conversationid, guid, peerid, (int)MessageTypes.Video); //} //catch (Exception) //{ // throw; //} return objvideo; }
public VideoChatSettings BroadcastVideo(long conversationid, long peerid) { VideoChatSettings objvideo = new VideoChatSettings(); try { string guid = Convert.ToString(Guid.NewGuid()); objvideo = InitiateVideoChat(conversationid, guid, peerid, (int)MessageTypes.Video); } catch (Exception) { throw; } return objvideo; }