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; }