public void DeleteMessage(int id)
{
messages m = Ms.GetById(id);
Ms.Delete(m);
Ms.Commit();
}
public ActionResult AddLike(int id, int iduser)
{
if (iduser == 0)
{
msg = "Sorry, you have to connect";
return(RedirectToAction("Login"));
}
else
{
var listf = Ls.GetAll();
likes l = new likes();
l.idmessage = id;
l.iduser = iduser;
l.date = DateTime.Now;
messages messages = Ms.GetById(id);
messages.nbLike = messages.nbLike + 1;
Ms.Update(messages);
Ms.Commit();
Ls.Add(l);
Ls.Commit();
return(RedirectToAction("ViewTopic", new
{
id = messages.topic.idTopic,
idRep = id,
}));
}
}
public ActionResult Deletelike(int id, int iduser)
{
if (iduser == 0)
{
msg = "Sorry, you have to connect";
return(RedirectToAction("Login"));
}
else
{
var listf = Ls.GetAll();
likes l = new likes();
foreach (var item in listf)
{
if (item.idmessage == id && item.iduser == iduser)
{
l = item;
}
}
messages messages = Ms.GetById(id);
messages.nbLike = messages.nbLike - 1;
Ms.Update(messages);
Ms.Commit();
Ls.Delete(l);
Ls.Commit();
return(RedirectToAction("ViewTopic", new
{
id = messages.topic.idTopic,
idRep = id,
}));
}
}
public async Task <IActionResult> Edit(int id, [Bind("messageID,PicID,UserID,FriendCode,timestamp")] messages messages)
{
if (id != messages.messageID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(messages);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!messagesExists(messages.messageID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["PicID"] = new SelectList(_context.pictures, "PicID", "StoragePath", messages.PicID);
ViewData["UserID"] = new SelectList(_context.users, "UserID", "UserID", messages.UserID);
return(View(messages));
}
public IActionResult LikeMessage(int messageId)
{
if (HttpContext.Session.GetInt32("UserId") == null)
{
Dictionary <string, string> error = new Dictionary <string, string>();
error.Add("Message", "Error");
error.Add("error", "not logged in");
return(Json(error));
}
int User = HttpContext.Session.GetInt32("UserId") ?? default(int);
if (dbContext.messagelikes.Any(guest => guest.userId == User && guest.messageId == messageId))
{
Dictionary <string, string> error = new Dictionary <string, string>();
error.Add("Message", "Error");
error.Add("error", "Already Liked this message");
return(Json(error));
}
users usertoAdd = dbContext.users.FirstOrDefault(x => x.userId == User);
messages messagetoAdd = dbContext.messages.FirstOrDefault(x => x.messageId == messageId);
messagelikes newlike = new messagelikes
{
userId = User,
messageId = messageId,
};
dbContext.messagelikes.Add(newlike);
dbContext.SaveChanges();
Dictionary <string, string> success = new Dictionary <string, string>();
success.Add("Message", "Success");
return(Json(success));
}
public IActionResult leaveMessage(int id, [FromBody] messages newMessage)
{
if (HttpContext.Session.GetInt32("UserId") == null)
{
Dictionary <string, string> error = new Dictionary <string, string>();
error.Add("Message", "Error");
return(Json(error));
}
int userId = HttpContext.Session.GetInt32("UserId") ?? default(int);
if (ModelState.IsValid)
{
users addUser = dbContext.users.FirstOrDefault(u => u.userId == userId);
channels channelAdd = dbContext.channels.Where(c => c.channelId == id).FirstOrDefault();
newMessage.channelId = id;
newMessage.Channel = channelAdd;
newMessage.userId = userId;
newMessage.User = addUser;
dbContext.messages.Add(newMessage);
dbContext.SaveChanges();
Dictionary <string, string> success = new Dictionary <string, string>();
success.Add("Message", "Success");
return(Json(success));
}
else
{
return(Json(ModelState));
}
}
static public void CreateMessage(messages message)
{
var db = new VERK2015_H17Entities1();
db.messages.Add(message);
db.SaveChanges();
}
private async void Image_Click(messages messageList)
{
ShowImagePopUp ImagePopupview = new ShowImagePopUp();
ImagePopupview.BindingContext = this;
displayImage = messageList.MsgImageUrl;
await ShowPopup(ImagePopupview, false);
}
public ActionResult DeleteMessage(int id)
{
messages message = db.messages.Find(id);
db.Entry(message).State = EntityState.Deleted;
db.SaveChanges();
return(RedirectToAction("Messages"));
}
public ActionResult DeleteConfirmed(int id)
{
messages messages = db.messages.Find(id);
db.messages.Remove(messages);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private async void personIcon_Click(messages list)
{
ParticipantListPopup ParticipantPopupview = new ParticipantListPopup();
ParticipantPopupview.BindingContext = this;
this.GetParticipantData(list);
await ShowPopup(ParticipantPopupview, true);
}
public int ProcessNewRecords(string json)
{
SqlConnectionStringBuilder connBuilder = new SqlConnectionStringBuilder
{
DataSource = "10.10.0.28",
UserID = "phpuser",
Password = "******"
};
IDbConnection connection;
connection = new SqlConnection(connBuilder.ConnectionString);
DataContext db = new DataContext(connection);
Table <messages> msg = db.GetTable <messages>();
DataContractJsonSerializer deserializer = new DataContractJsonSerializer(typeof(RootObject));
var result = (RootObject)deserializer.ReadObject(new MemoryStream(Encoding.Unicode.GetBytes(json)));
Console.WriteLine(result.next + " next");
Console.WriteLine(result.total + " total");
foreach (var item in result.result)
{
Regex reg = new Regex("[D][0-9]{6}");
Match match = reg.Match(item.TITLE + item.DETAIL_TEXT);
int count = msg.Where(m => m.bitrix_message_id.ToString() == item.ID && m.author_id.ToString() == item.AUTHOR_ID).Select(m => m).Count();
if (match.Success == true && count == 0)
{
//создание нового объекта для вставки
messages toInsert = new messages
{
bitrix_message_id = Convert.ToInt32(item.ID),
date_publish = item.DATE_PUBLISH,
delivery_id = match.Value,
message = item.TITLE,
detail = item.DETAIL_TEXT,
message_url = @"https://bitrix.eltransplus.ru/company/personal/user/" + item.AUTHOR_ID + @"/blog/" + item.ID + @"/",
blog_id = Convert.ToInt32(item.BLOG_ID),
author_id = Convert.ToInt32(item.AUTHOR_ID)
};
msg.InsertOnSubmit(toInsert);
}
}
db.SubmitChanges();
if (String.IsNullOrWhiteSpace(result.next) == false)
{
return(Convert.ToInt32(result.next));
}
else
{
return(0);
}
}
public ActionResult sendmessage(messages details)
{
db.messages.Add(details);
db.SaveChanges();
return(RedirectToAction("index"));
}
public void StartMessages(messages message)
{
sentences.Clear();
foreach (string sentence in message.sentences)
{
sentences.Enqueue(sentence);
}
DisplayNextSentence();
}
public static void TriggerEvent(messages eventName)
{
UnityEvent thisEvent = null;
if (instance.eventDictionary.TryGetValue((int)eventName, out thisEvent))
{
thisEvent.Invoke();
}
}
public ActionResult Edit([Bind(Include = "id,name,Email,messageTxet")] messages messages)
{
if (ModelState.IsValid)
{
db.Entry(messages).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(messages));
}
public ActionResult Edit([Bind(Include = "Id,Occasionid,message")] messages messages)
{
if (ModelState.IsValid)
{
db.Entry(messages).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Occasionid = new SelectList(db.Occasion, "Occasionid", "name", messages.Occasionid);
return(View(messages));
}
public ActionResult Create([Bind(Include = "id,name,Email,messageTxet")] messages messages)
{
if (ModelState.IsValid)
{
db.messages.Add(messages);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(messages));
}
public bool SendInternalMessage(string host, messages message, List <messagerecipients> listMessageRecipients)
{
message.MessageSentDateTime = DateTime.Now;
if (true == _customDataAccess.SendInternalMessage(message, listMessageRecipients))
{
SendEmailsAndTextsForMessageRecipients(host, listMessageRecipients);
return(true);
}
return(false);
}
public ActionResult Edit([Bind(Include = "id,sender,receiver,name,date,text")] messages messages)
{
if (ModelState.IsValid)
{
db.Entry(messages).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.receiver = new SelectList(db.users, "id", "name", messages.receiver);
ViewBag.sender = new SelectList(db.users, "id", "name", messages.sender);
return(View(messages));
}
public ActionResult Create([Bind(Include = "Id,Occasionid,message")] messages messages)
{
if (ModelState.IsValid)
{
db.messages.Add(messages);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Occasionid = new SelectList(db.Occasion, "Occasionid", "name", messages.Occasionid);
return(View(messages));
}
/*
* //////////W//A//R//N//I//N//G////////////////////
* DO NOT INTEGRATE THIS API WITH ANY MESSENGER!! IT WILL FLOOD YOUR INBOX
*/
public IHttpActionResult getprov(string cardColor, string Govt, string serviceCity, string typeOfService)
{
//Type = Type.Replace(" ", "%20");
//AxaProvider x = new AxaProvider();
var providerList = _ctx.axaProviders.Select(w => new { w.Provider, w.NetworkName, w.Governorate, w.City, w.Address, w.Type, w.Phone, w.LocationOnMap });
if (cardColor.Contains("Green"))
{
providerList = _ctx.axaProviders.Select(w => new { w.Provider, w.NetworkName, w.Governorate, w.City, w.Address, w.Type, w.Phone, w.LocationOnMap })
.Where(q => q.NetworkName.Contains(cardColor) && q.Governorate.Contains(Govt) && q.City.Contains(serviceCity) &&
q.Type.Contains(typeOfService)).Take(5);
}
else if (cardColor.Contains("Silver"))
{
providerList = _ctx.axaProviders.Select(w => new { w.Provider, w.NetworkName, w.Governorate, w.City, w.Address, w.Type, w.Phone, w.LocationOnMap })
.Where(q => (q.NetworkName.Contains(cardColor) || q.NetworkName.Contains("Green")) &&
q.Governorate.Contains(Govt) && q.City.Contains(serviceCity) &&
q.Type.Contains(typeOfService)).Take(5);
}
else
{
providerList = _ctx.axaProviders.Select(w => new { w.Provider, w.NetworkName, w.Governorate, w.City, w.Address, w.Type, w.Phone, w.LocationOnMap })
.Where(q => (q.NetworkName.Contains(cardColor) || q.NetworkName.Contains("Green") || q.NetworkName.Contains("Silver")) &&
q.Governorate.Contains(Govt) && q.City.Contains(serviceCity) &&
q.Type.Contains(typeOfService)).Take(5);
}
var xx = _ctx.axaProviders.Select(w => new { w.Provider, w.NetworkName, w.Governorate, w.City, w.Address, w.Type, w.Phone, w.LocationOnMap })
.Where(q => q.NetworkName.Contains(cardColor));
//string x = "this is your address" + providerList.Select(w => w.Address).SingleOrDefault();
//.Where(e=>e.Governate == Govt).Where(r=>r.City == City)
//.Where(t=>t.Type == Type).SingleOrDefault();
//string json = JsonConvert.SerializeObject(providerList, Formatting.Indented, new customFbFormat(typeof(IQueryable)));
// var ww = providerList.Count();
int count = 0;
//string xx = "";
List <messages> qwe = new List <messages>();
foreach (var axa in providerList)
{
messages qw = new messages();
count++;
qw.text = "Provider " + count + " Name: " + axa.Provider + "\n" + "Address: " + axa.Address.Replace("\"\r\n", "") + "\n Phone(s): " + axa.Phone + "\n Location on map: " + axa.LocationOnMap;
qwe.Add(qw);
}
var x = new { messages = qwe };
//string json = JsonConvert.SerializeObject(x);
//var x = Regex.Replace(providerList, @"[^\u0009\u000A\u000D\u0020-\u007E]", "*");
return(Ok(x));
}
public async Task <IActionResult> Create([Bind("messageID,PicID,UserID,FriendCode,timestamp")] messages messages)
{
if (ModelState.IsValid)
{
_context.Add(messages);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PicID"] = new SelectList(_context.pictures, "PicID", "StoragePath", messages.PicID);
ViewData["UserID"] = new SelectList(_context.users, "UserID", "UserID", messages.UserID);
return(View(messages));
}
public ActionResult Contact(messages messages)
{
if (ModelState.IsValid)
{
messages.date = DateTime.UtcNow;
db.messages.Add(messages);
db.SaveChanges();
return(RedirectToAction("Contact", new { result = "success" }));
}
return(View());
}
public static void StopListening(messages eventName, UnityAction listener)
{
if (eventManager == null)
{
return;
}
UnityEvent thisEvent = null;
if (instance.eventDictionary.TryGetValue((int)eventName, out thisEvent))
{
thisEvent.RemoveListener(listener);
}
}
public IHttpActionResult test2(string longitude, string latitude, string typeOfService, string cardColor)
{
List <messages> qwe = new List <messages>();
//foreach (var axa in providerList)
{
messages qw = new messages();
qw.text = "This is echo: " + longitude + " , " + latitude + " , " + typeOfService + " , " + cardColor;
qwe.Add(qw);
}
var x = new { messages = qwe };
return(Ok(x));
}
private void OnBackendError(messages.BackendError obj)
{
DispatcherHelper.CheckBeginInvokeOnUI(() =>
{
_messages.Add(obj.reason);
if (_messages.Count > 1000)
{
while (_messages.Count > 500)
{
_messages.RemoveAt(0);
}
}
});
}
// GET: messages/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
messages messages = db.messages.Find(id);
if (messages == null)
{
return(HttpNotFound());
}
return(View(messages));
}
// GET: messages/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
messages messages = db.messages.Find(id);
if (messages == null)
{
return(HttpNotFound());
}
ViewBag.Occasionid = new SelectList(db.Occasion, "Occasionid", "name", messages.Occasionid);
return(View(messages));
}
public IActionResult CreateMessage(string message)
{
int? id = HttpContext.Session.GetInt32("Id");
messages NewMessage = new messages()
{
usersid = (long)id,
message = message,
created_at = DateTime.Now,
updated_at = DateTime.Now
};
_context.Add(NewMessage);
_context.SaveChanges();
return(RedirectToAction("Wall"));
}
public static void StartListening(messages eventName, UnityAction listener)
{
UnityEvent thisEvent = null;
if (instance.eventDictionary.TryGetValue((int)eventName, out thisEvent))
{
thisEvent.AddListener(listener);
}
else
{
thisEvent = new UnityEvent();
thisEvent.AddListener(listener);
instance.eventDictionary.Add((int)eventName, thisEvent);
}
}
public void ProcessCommand(GameSession session, messages.GenMessage msg)
{
Room room;
if (playerRoomDict.TryGetValue(session.SessionID, out room))
{
lock (room)
{
room.GetMessage(session, msg);
}
}
}
static void Xmpp_OnMessage(object sender, agsXMPP.protocol.client.Message msg)
{
if (msg.HasTag(typeof(AgIXML)))
{
AgIXML agiMsg = msg.SelectSingleElement(typeof(AgIXML)) as AgIXML;
agiMsg newMsg = new agiMsg();
newMsg.ID = agiMsg.ID;
newMsg.Type = agiMsg.Type;
newMsg.Path = agiMsg.Path;
newMsg.SessionID = agiMsg.SessionID;
newMsg.SessionKey = agiMsg.SessionKey;
newMsg.Data = agiMsg.Data;
newMsg.Flags = agiMsg.Flags;
switch (newMsg.Type)
{
case "tput":
xmppManager.world.agi.tput(newMsg);
break;
case "rput":
xmppManager.world.agi.rput(newMsg);
break;
case "tget":
xmppManager.world.agi.tget(newMsg);
break;
case "rget":
xmppManager.world.agi.rget(newMsg);
break;
case "tattach":
xmppManager.world.agi.tattach(newMsg);
break;
case "rattach":
xmppManager.world.agi.rattach(newMsg);
break;
case "tremove":
xmppManager.world.agi.tremove(newMsg);
break;
case "rremove":
xmppManager.world.agi.rremove(newMsg);
break;
case "tflush":
xmppManager.world.agi.tflush(newMsg);
break;
case "rflush":
xmppManager.world.agi.rflush(newMsg);
break;
}
}
if (msg.Body != null)
{
messages newMsg = new messages();
newMsg.body = msg.Body;
newMsg.from = msg.From.User;
int count = 0;
while (chats.Count != 0 && count < chats.Count)
{
if (chats.ElementAt(count).chatWith.userID == msg.From.User)
{
chats.ElementAt(count).msgChain.Add(newMsg);
return;
}
count++;
}
chat newchat = new chat();
newchat.msgChain.Add(newMsg);
newchat.chatWith.userID = msg.From.User.ToString();
chats.Add(newchat);
Console.WriteLine(newMsg.body.ToString());
}
}
private StringBuilder GetValues()
{
StringBuilder sb = new StringBuilder();
messagesMessage[] array = GetList(ASPxGridView1.ClientID).ToArray();
bool defaultFound = array.Any(t => t.lcid == 1033);
if (array.Length == 0)
{
return null;
}
if ((array.Length == 0) || (defaultFound == false))
{
throw new Exception(GetLocalResourceObject("lblFillDescription").ToString());
}
messages msg = new messages
{
Items = array
};
XmlSerializer ser = new XmlSerializer(typeof(messages));
XmlWriterSettings set = new XmlWriterSettings
{
OmitXmlDeclaration = true
};
XmlWriter xml = XmlWriter.Create(sb, set);
ser.Serialize(xml, msg);
return sb;
}
public void GetMessage(GameSession session, messages.GenMessage msg)
{
int frame = msg.Frame;
if (maxFrame < frame)
maxFrame = frame;
string pId = msg.PId;
var player = players.Find(x => x.id == pId);
if (player.GetCommand(msg))
{
player.TryRemoveHead();
player.session = session;
int msgId = msg.MsgId;
if (player.nextMsgId <= msgId)
{
player.nextMsgId = msgId;
}
var msgBytes = msg.ToByteArray();
for (int i = 0, iMax = players.Count; i < iMax; i++)
{
var sess = players[i].session;
if (sess != null)
{
sess.Send(msgBytes, 0, msgBytes.Length);
}
}
}
else
{
Console.WriteLine("Ignore Command");
}
}
