static public bool LoadListOfFavorites(ref ListView listviewFavorites, byte companyID, short userID, byte companyCount)
{
CSMessengerContext dbContext = new CSMessengerContext();
listviewFavorites.SuspendLayout();
listviewFavorites.Items.Clear();
try
{
foreach (var item in dbContext.usp_User_ListFavorites(companyID, userID))
{
//UserFavoriteFunctions.FavoriteAdd(ref listviewFavorites, item.CompanyID, item.CompanyAbbreviation, item.UserID, item.UserName, companyCount);
}
}
catch (Exception ex)
{
MessageBox.Show(string.Format("No se pudo cargar la lista de Favoritos.{0}{0}Error #{1}: {2}", System.Environment.NewLine, ex.HResult, ex.Message), My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error);
listviewFavorites.ResumeLayout();
return(false);
}
listviewFavorites.ResumeLayout();
return(true);
}
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 void Main(string[] args)
{
System.Windows.Forms.Cursor.Current = Cursors.AppStarting;
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
// Get DB connection properties and create ConnectionString
CS_Database_SQL pDatabase = new CS_Database_SQL();
pDatabase.applicationName = My.Application.Info.Title;
pDatabase.datasource = CSMessenger.Properties.Settings.Default.DBConnection_Datasource;
pDatabase.initialCatalog = CSMessenger.Properties.Settings.Default.DBConnection_Database;
pDatabase.userID = CSMessenger.Properties.Settings.Default.DBConnection_UserID;
// Unencrypt database connection password
CS_Encrypt_TripleDES PasswordDecrypter = new CS_Encrypt_TripleDES(CS_Constants.UserEncryptionPassword);
string tempPassword = "";
if (PasswordDecrypter.Decrypt(CSMessenger.Properties.Settings.Default.DBConnection_Password, ref tempPassword) == false)
{
MessageBox.Show("La contraseña encriptada del usuario de conexión a la base de datos es incorrecta.", My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
pDatabase = null;
PasswordDecrypter = null;
return;
}
pDatabase.password = tempPassword;
PasswordDecrypter = null;
pDatabase.MultipleActiveResultsets = true;
pDatabase.workstationID = Environment.MachineName;
pDatabase.CreateConnectionString();
CSMessengerContext.CreateConnectionString(CSMessenger.Properties.Settings.Default.DBConnection_Provider, pDatabase.connectionString);
Application.Run(new formMain(args));
}
public Semaphores(byte companyID, short userID)
{
mdbContext = new CSMessengerContext();
mCompany = mdbContext.Company.Find(companyID);
mCompanySemaphore = mCompany.Semaphore;
mUser = mdbContext.User.Find(companyID, userID);
mUserSemaphore = mUser.Semaphore;
}
public ChatMessageList(byte companyID, short userID)
{
try
{
mdbContext = new CSMessengerContext();
mUser = mdbContext.User.Find(companyID, userID);
}
catch (Exception e)
{
MessageBox.Show(string.Format("Error al inicializar las funciones de Mensajes.{0}{0}Error #{1}: {2}", System.Environment.NewLine, e.HResult, e.Message), My.Application.Info.Title, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadUsersOfCompany(CSMessengerContext dbContext, byte companyID, short userID, byte usersCompanyID, ref ListView listviewCurrent)
{
listviewCurrent.SuspendLayout();
foreach (User UserCurrent in dbContext.User.Where(u => u.CompanyID == usersCompanyID).OrderBy(u => u.Name))
{
if (!(UserCurrent.UserID == Constants.UserID_Administrator || (usersCompanyID == companyID && UserCurrent.UserID == userID)))
{
listviewCurrent.Items.Add(CS_Constants.KeyStringer + UserCurrent.CompanyID + CS_Constants.KeyDelimiter + UserCurrent.UserID, UserCurrent.Name, "");
}
}
listviewCurrent.ResumeLayout();
}
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 void CreateCompanyControlsAndLoadUsers(CSMessengerContext dbContext, byte companyID, short userID, ref TabControlAdv tabUsers, ref ContextMenuStrip contextmenuControl, EventHandler DoubleClickEventHandler)
{
foreach (UserCompany UserCompanyCurrent in dbContext.UserCompany.Where(uc => uc.CompanyID == companyID && uc.UserID == userID).OrderBy(uc => uc.CompanyGranted.Name))
{
// Add a new Tab Page to the Tab control
TabPageAdv tabpageNew = new TabPageAdv(UserCompanyCurrent.CompanyGranted.Name);
tabUsers.TabPages.Add(tabpageNew);
// Add a ListView to the TabPage
ListView ListViewNew = AddControlsToTabPage(Constants.ListView_Company_Prefix + UserCompanyCurrent.CompanyID, ref tabpageNew, ref contextmenuControl, DoubleClickEventHandler);
// Load Users
LoadUsersOfCompany(dbContext, companyID, userID, UserCompanyCurrent.AccessCompanyID, ref ListViewNew);
}
}
