示例#1
0
 public int?AddGroup(Group group)
 {
     try
     {
         var values = new Dictionary <string, object>
         {
             { GlobalAppSettings.DbColumns.DB_Group.Name, group.GroupName },
             { GlobalAppSettings.DbColumns.DB_Group.Description, group.GroupDescription },
             { GlobalAppSettings.DbColumns.DB_Group.Color, group.GroupColor },
             { GlobalAppSettings.DbColumns.DB_Group.IsActive, true },
             {
                 GlobalAppSettings.DbColumns.DB_Group.ModifiedDate,
                 DateTime.UtcNow.ToString(GlobalAppSettings.GetDateTimeFormat())
             }
         };
         var output = new List <string>
         {
             GlobalAppSettings.DbColumns.DB_Group.GroupId
         };
         var result = _dataProvider.ExecuteScalarQuery(_queryBuilder.AddToTable(
                                                           GlobalAppSettings.DbColumns.DB_Group.DB_TableName,
                                                           values, output));
         if (result.Status)
         {
             return(Convert.ToInt32(result.ReturnValue));
         }
         return(null);
     }
     catch (Exception e)
     {
         LogExtension.LogError("Error while adding group", e,
                               MethodBase.GetCurrentMethod(), " GroupName - " + group.GroupName + " GroupDescription - " + group.GroupDescription + " GroupColor - " + group.GroupColor);
         return(null);
     }
 }
示例#2
0
 public bool AddUserInGroup(int userId, int groupId)
 {
     try
     {
         var values = new Dictionary <string, object>
         {
             { GlobalAppSettings.DbColumns.DB_UserGroup.GroupId, groupId },
             { GlobalAppSettings.DbColumns.DB_UserGroup.UserId, userId },
             { GlobalAppSettings.DbColumns.DB_UserGroup.IsActive, true },
             {
                 GlobalAppSettings.DbColumns.DB_UserGroup.ModifiedDate,
                 DateTime.UtcNow.ToString(GlobalAppSettings.GetDateTimeFormat())
             }
         };
         var result = _dataProvider.ExecuteNonQuery(
             _queryBuilder.AddToTable(GlobalAppSettings.DbColumns.DB_UserGroup.DB_TableName, values));
         return(result.Status);
     }
     catch (Exception e)
     {
         LogExtension.LogError("Error while add user in group", e,
                               MethodBase.GetCurrentMethod(), " UserId - " + userId + " GroupId - " + groupId);
         return(false);
     }
 }
示例#3
0
        /// <summary>
        /// Initialize the Settings for the Server.
        /// </summary>
        /// <param name="path">Path of the configuration file</param>
        public static void InitializeSystemSettings(string path)
        {
            var tokenCryptography = new TokenCryptography();

            try
            {
                SystemSettings = new SystemSettingsSerializer().Deserialize(path);
                if (SystemSettings != null)
                {
                    SystemSettings.SqlConfiguration.ConnectionString =
                        tokenCryptography.Decrypt(SystemSettings.SqlConfiguration.ConnectionString);
                    ConnectionString = SystemSettings.SqlConfiguration.ConnectionString;
                    DbSupport        = SystemSettings.SqlConfiguration.ServerType;
                    if (DbSupport == DataBaseType.MSSQLCE)
                    {
                        DataProvider = new SqlCeRelationalDataAdapter(ConnectionString);
                        QueryBuilder = new SqlCeQueryBuilder();
                    }
                    else
                    {
                        QueryBuilder = new SqlQueryBuilder();
                        DataProvider = new SqlRelationalDataAdapter(ConnectionString);
                    }
                    var globalSettings = new GlobalAppSettings().GetSystemSettings().DataTable.AsEnumerable()
                                         .Select(a => new
                    {
                        Key   = a.Field <string>(DbColumns.DB_SystemSettings.Key),
                        Value = a.Field <string>(DbColumns.DB_SystemSettings.Value)
                    }
                                                 ).ToDictionary(a => a.Key, a => a.Value);

                    SystemSettings.OrganizationName =
                        globalSettings[SystemSettingKeys.OrganizationName.ToString()];
                    SystemSettings.LoginLogo      = globalSettings[SystemSettingKeys.LoginLogo.ToString()];
                    SystemSettings.MainScreenLogo =
                        globalSettings[SystemSettingKeys.MainScreenLogo.ToString()];
                    SystemSettings.FavIcon         = globalSettings[SystemSettingKeys.FavIcon.ToString()];
                    SystemSettings.WelcomeNoteText =
                        globalSettings[SystemSettingKeys.WelcomeNoteText.ToString()];
                    SystemSettings.Language   = globalSettings[SystemSettingKeys.Language.ToString()];
                    SystemSettings.TimeZone   = globalSettings[SystemSettingKeys.TimeZone.ToString()];
                    SystemSettings.DateFormat = globalSettings[SystemSettingKeys.DateFormat.ToString()];
                    SystemSettings.BaseUrl    = globalSettings[SystemSettingKeys.BaseUrl.ToString()];
                    SystemSettings.ActivationExpirationDays =
                        Convert.ToInt32(globalSettings[SystemSettingKeys.ActivationExpirationDays.ToString()]);
                    SystemSettings.MailSettingsAddress =
                        globalSettings[SystemSettingKeys.MailSettingsAddress.ToString()];
                    SystemSettings.MailSettingsHost =
                        globalSettings[SystemSettingKeys.MailSettingsHost.ToString()];
                    SystemSettings.MailSettingsSenderName =
                        globalSettings[SystemSettingKeys.MailSettingsSenderName.ToString()];
                    SystemSettings.MailSettingsPassword =
                        tokenCryptography.Decrypt(
                            globalSettings[SystemSettingKeys.MailSettingsPassword.ToString()]);
                    SystemSettings.MailSettingsPort =
                        Convert.ToInt32(globalSettings[SystemSettingKeys.MailSettingsPort.ToString()]);
                    SystemSettings.MailSettingsIsSecureAuthentication =
                        Convert.ToBoolean(
                            globalSettings[SystemSettingKeys.MailSettingsIsSecureAuthentication.ToString()]);
                    Serializer = new JavaScriptSerializer();
                }
            }
            catch (Exception e)
            {
                LogExtension.LogError("Exception while deserializing system settings", e, MethodBase.GetCurrentMethod(),
                                      " Path - " + path + " ConnectionString - " + ConnectionString + " OrganizationName - " +
                                      SystemSettings.OrganizationName + " LoginLogo - " + SystemSettings.LoginLogo + " MainScreenLogo - " +
                                      SystemSettings.MainScreenLogo + " FavIcon - " + SystemSettings.FavIcon + " WelcomeNoteText - " +
                                      SystemSettings.WelcomeNoteText + " Language - " + SystemSettings.Language + " TimeZone - " +
                                      SystemSettings.TimeZone + " DateFormat - " + SystemSettings.DateFormat + " BaseUrl - " +
                                      SystemSettings.BaseUrl + " ActivationExpirationDays - " + SystemSettings.ActivationExpirationDays +
                                      " MailSettingsAddress - " + SystemSettings.MailSettingsAddress + " MailSettingsHost - " +
                                      SystemSettings.MailSettingsHost + " MailSettingsSenderName - " +
                                      SystemSettings.MailSettingsSenderName + " MailSettingsPassword - " +
                                      SystemSettings.MailSettingsPassword + " MailSettingsPort - " + SystemSettings.MailSettingsPort +
                                      " MailSettingsIsSecureAuthentication - " + SystemSettings.MailSettingsIsSecureAuthentication);
            }
        }