public void Update(Contact contact)
{
db.Entry(contact).State = EntityState.Modified;
//try
//{
// SqlParameter contactId = new SqlParameter("@contactId", item.ContactId);
// SqlParameter firstName = new SqlParameter("@firstName", item.FirstName);
// SqlParameter secondName = new SqlParameter("@secondName", item.SecondName);
// SqlParameter middleName = new SqlParameter("@middleName", item.MiddleName);
// SqlParameter sex = new SqlParameter("@sex", item.Sex);
// SqlParameter birthDate = new SqlParameter("@birthDate", item.BirthDate);
// SqlParameter email = new SqlParameter("@email", item.Email);
// SqlParameter phone = new SqlParameter("@phone", item.Phone);
// SqlParameter comment = new SqlParameter("@comment", item.Comment);
// SqlParameter creationDate = new SqlParameter("@creationDate", item.CreationDate);
// SqlParameter modificationDate = new SqlParameter("@modificationDate", item.ModificationDate);
// SqlParameter disable = new SqlParameter("@disable", item.Disable);
// SqlParameter notRelevant = new SqlParameter("@notRelevant", item.NotRelevant);
// db.Database.SqlQuery<int>("Contact_UpdateContact @contactId @firstName, @secondName, @middleName, @sex, @birthDate, @email, @phone, @comment, @creationDate, @modificationDate, @disable, @notRelevant",
// contactId, firstName, secondName, middleName, sex, birthDate, email, phone, comment, creationDate, modificationDate, disable, notRelevant).FirstOrDefault();
//}
//catch (SqlException e)
//{
// Console.Write("SqlException " + e.Message);
//}
//catch (Exception e)
//{
// Console.Write(" " + e.Message);
//}
}
public ActionResult Edit([Bind(Include = "UserId,UserName,UserEmail,UserPassword,UserImage")] User user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public override Task OnConnected()
{
//Interlocked.Increment(ref _usersCount);
User user = db.Users.First(r => r.Email == HttpContext.Current.User.Identity.Name);
user.ConnectionId = Context.ConnectionId;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(base.OnConnected());
}
private void DoConnect()
{
string login = Context.Request.Headers["login"];
string password = Context.Request.Headers["password"];
User user = null;
using (var db = new MessengerContext())
{
var login_qout = string.Format(@"""{0}""", login);
var password_qout = string.Format(@"""{0}""", password);
var users = db.Users.SqlQuery("select * from messengerbd.users where binary Login = "******" and binary Password = "******"";
user_to_result.Login = "";
Clients.Others.singedIn(user_to_result);
Clients.Caller.singIn(user);
FromUsers.TryAdd(Context.ConnectionId, userName);
ToUsers.TryAdd(userName, Context.ConnectionId);
}
else
{
Clients.Caller.Exception("error in db when change status");
}
}
else
{
string firstName = Context.Request.Headers["first_name"];
string LastName = Context.Request.Headers["last_name"];
if (firstName == null && LastName == null)
{
Clients.Caller.singIn(null);
}
addNewUser(firstName, login, password, LastName);
}
}
}
private string setChanges(string FirstName, string LastName, byte[] photo)
{
var id = Context.ConnectionId;
var users = ToUsers.Where(x => x.Value == id).ToList();
var user = users.First();
try
{
using (var db = new MessengerContext())
{
var login = user.Key;
var login_qout = string.Format(@"""{0}""", login);
var users_db = db.Users.SqlQuery("select * from messengerbd.users where binary Login = "******"ok");
}
else
{
return("error in SaveChanges");
}
}
else
{
return("user is null");
}
}
}
catch (Exception)
{
return("exception(no user in hub)");
}
}
public void Update(ListContact listContact)
{
db.Entry(listContact).State = System.Data.Entity.EntityState.Modified;
//try
//{
// SqlParameter listContactId = new SqlParameter("@listContactId", listContact.ListContactId);
// SqlParameter listId = new SqlParameter("@listId", listContact.ListId);
// SqlParameter contactId = new SqlParameter("@contactId", listContact.ContactId);
// SqlParameter notRelevant = new SqlParameter("@notRelevant", listContact.NotRelevant);
// db.Database.SqlQuery<int>("ListContact_UpdateListContact @listContactId, @listId, @contactId, @notRelevant",
// listContactId, listId, contactId, notRelevant).FirstOrDefault();
//}
//catch (SqlException e)
//{
// Console.Write("SqlException " + e.Message);
//}
//catch (Exception e)
//{
// Console.Write(" " + e.Message);
//}
}
public override Task OnDisconnected(bool stopCalled)
{
using (var db = new MessengerContext())
{
var users = ToUsers.Where(x => x.Value == Context.ConnectionId).ToList();
var user = users.First();
try
{
{
var login = user.Key;
var login_qout = string.Format(@"""{0}""", login);
var users_db = db.Users.SqlQuery("select * from messengerbd.users where binary Login = "******"no user found in db when disconect");
}
}
}
catch (Exception e)
{
Clients.Caller.Ecxeption("no user found in ToUsers when delete");
}
}
string id = Context.ConnectionId;
Clients.Others.Offline("id " + id);
FromUsers.TryRemove(id, out userName);
ToUsers.TryRemove(userName, out id);
return(base.OnDisconnected(stopCalled));
}
public void Update(MessageType messageType)
{
db.Entry(messageType).State = EntityState.Modified;
}
public void Update(DialogMessageText dialogMessageText)
{
db.Entry(dialogMessageText).State = System.Data.Entity.EntityState.Modified;
}
public void Update(Dialog dialog)
{
db.Entry(dialog).State = System.Data.Entity.EntityState.Modified;
}
