static public void FavoriteAdd(byte companyID, short userID, byte favoriteCompanyID, short favoriteUserID, byte companyCount) { try { using (CSMessengerContext dbContext = new CSMessengerContext()) { UserFavorite NewUserFavorite = new UserFavorite(); NewUserFavorite.CompanyID = companyID; NewUserFavorite.UserID = userID; NewUserFavorite.FavoriteCompanyID = favoriteCompanyID; NewUserFavorite.FavoriteUserID = favoriteUserID; dbContext.UserFavorite.Add(NewUserFavorite); dbContext.SaveChanges(); string companyAbbreviation = dbContext.Company.Find(favoriteCompanyID).Abbreviation; string userName = dbContext.User.Find(favoriteCompanyID, favoriteUserID).Name; } } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException.InnerException.HResult == -2146232060) { MessageBox.Show("Este Contacto ya está en la lista de Favoritos.", My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { MessageBox.Show(string.Format("Error al agregar el Contacto a la lista de Favoritos.{0}{0}Error #{1}: {2}", System.Environment.NewLine, ex.HResult, ex.Message), My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
static public void FavoriteRemove(byte companyID, short userID, byte favoriteCompanyID, short favoriteUserID) { try { CSMessengerContext dbContext = new CSMessengerContext(); UserFavorite UserFavoriteToRemove = dbContext.UserFavorite.Find(companyID, userID, favoriteCompanyID, favoriteUserID); dbContext.UserFavorite.Remove(UserFavoriteToRemove); dbContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(string.Format("Error al quitar el Contacto a la lista de Favoritos.{0}{0}Error #{1}: {2}", System.Environment.NewLine, ex.HResult, ex.Message), My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool CheckUser(short userID, out string userName) { // Check if User exists in Company database and gets it's name if (GetUserFromCompanyDatabase(userID) == false) { userName = null; return(false); } // Check if User exists in local database mUser = mdbContext.User.Find(mCompany.CompanyID, userID); if (mUser == null) { try { // Doesn't exist, so add it mUser = new User(); mUser.CompanyID = mCompany.CompanyID; mUser.UserID = userID; mUser.Name = mUserNameOnCompanyDB; mUser.Semaphore = 0; mUser.IsActive = true; mdbContext.User.Add(mUser); // Update the Company Semaphore to advice others clients to refresh Company Users list mCompany.Semaphore = DateTime.Now.Millisecond; mdbContext.SaveChanges(); userName = mUser.Name; return(true); } catch (Exception ex) { MessageBox.Show(string.Format("Error agregando el Usuario a la base de datos.{0}{0}Error #{1}: {2}", System.Environment.NewLine, ex.HResult, ex.Message), My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error); userName = null; return(false); } } else { // Exists, so check data if (mUser.Name != mUserNameOnCompanyDB) { try { mUser.Name = mUserNameOnCompanyDB; // Update the Company Semaphore to advice others clients to refresh Company Users list mCompany.Semaphore = DateTime.Now.Millisecond; mdbContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(string.Format("Error actualizando el Nombre del Usuario a la base de datos.{0}{0}Error #{1}: {2}", System.Environment.NewLine, ex.HResult, ex.Message), My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error); userName = null; return(false); } } userName = mUser.Name; return(true); } }