Ejemplo n.º 1
0
        public static bool CreateNewProfile(string name)
        {
            if (!Profiles.Exists(a => a.Parameters.ProfileName == name))
            {
                var newProfileModel = new ProfileModel
                    {
                        ProfileName = name,
                        EnableLinkExport = false,
                        EnableScheduleJob = false
                    };
                DataExportClientDataManager.AddNewProfile(newProfileModel, UserId);

                return true;
            }
            return false;
        }
Ejemplo n.º 2
0
 public static void EditCurrentProfile(ProfileModel newProfileModel)
 {
     DataExportClientDataManager.EditProfile(CurrentProfile.Parameters.ProfileId, newProfileModel);
     LoadProfiles();
     SetCurrentProfile(newProfileModel.ProfileName);
 }
Ejemplo n.º 3
0
        public static List<ProfileModel> GetProfilesForUser(int userId)
        {
            var profilesList = new List<ProfileModel>();

            var sql = "SELECT * FROM " + TblProfiles + " WHERE UserID = '" + userId + "';";

            var reader = GetReader(sql);
            if (reader != null)
            {
                try
                {
                    while (reader.Read())
                    {
                        var profile = new ProfileModel
                                          {
                                              ProfileId = reader.GetInt32(0),
                                              UserId = reader.GetInt32(1),
                                              ProfileName = reader.GetString(2),
                                              EnableLinkExport = reader.GetBoolean(3),
                                              EnableScheduleJob = reader.GetBoolean(4)
                                          };
                        profilesList.Add(profile);
                    }
                }
                finally
                {
                    reader.Close();
                }

                for (int index = 0; index < profilesList.Count; index++)
                {
                    var item = profilesList[index];
                    item.SheduleJobs = new List<SheduleJobModel>(GetShedulesForProfile(item.ProfileId));
                    profilesList[index] = item;
                }
            }
            return profilesList;
        }
Ejemplo n.º 4
0
        public static bool RenameCurrentProfile(string name)
        {
            if (!Profiles.Exists(a => a.Parameters.ProfileName == name) && CurrentProfile.Parameters.ProfileName != name)
            {
                var newProfileModel = new ProfileModel
                {
                    ProfileName = name,
                    EnableLinkExport = CurrentProfile.Parameters.EnableLinkExport,
                    EnableScheduleJob = CurrentProfile.Parameters.EnableScheduleJob,
                    SheduleJobs = CurrentProfile.Parameters.SheduleJobs ?? new List<SheduleJobModel>()
                };
                DataExportClientDataManager.EditProfile(CurrentProfile.Parameters.ProfileId, newProfileModel);

                return true;
            }
            return false;
        }
Ejemplo n.º 5
0
        public static bool EditProfile(int profileId, ProfileModel newProfile)
        {
            var sql = "UPDATE " + TblProfiles
                        + " SET ProfileName = '" + newProfile.ProfileName
                        + "', EnableLink = " + newProfile.EnableLinkExport
                        + ", EnableShedule = " + newProfile.EnableScheduleJob
                        + " WHERE ID = '" + profileId + "' ; COMMIT;";

            if (DoSql(sql))
            {
                var sheduleJobs = GetShedulesForProfile(profileId);

                foreach (var shedule in sheduleJobs)
                {
                    if (!newProfile.SheduleJobs.Exists(a => a.Id == shedule.Id &&
                        a.Date == shedule.Date && a.Name == shedule.Name && a.IsDaily == shedule.IsDaily && a.SelectedDays == shedule.SelectedDays))
                    {
                        DoSql("DELETE FROM `" + TblSheduleJobs + "` WHERE ID = " + shedule.Id + ";COMMIT;");
                    }
                    else
                    {
                        newProfile.SheduleJobs.Remove(shedule);
                    }
                }

                foreach (var sheduleJobModel in newProfile.SheduleJobs)
                {
                    AddSheduleToProfile(profileId, sheduleJobModel);
                }

                return true;
            }
            return false;
        }
Ejemplo n.º 6
0
        public static ProfileModel GetProfileInfo(int profileId)
        {
            var profile = new ProfileModel();

            var sql = "SELECT * FROM " + TblProfiles + "WHERE ID = " + profileId + ";";

            var reader = GetReader(sql);
            if (reader != null)
            {
                try
                {

                    while (reader.Read())
                    {
                        profile = new ProfileModel
                                      {
                                          ProfileId = reader.GetInt32(0),
                                          UserId = reader.GetInt32(1),
                                          ProfileName = reader.GetString(2),
                                          EnableLinkExport = reader.GetBoolean(3),
                                          EnableScheduleJob = reader.GetBoolean(4)
                                      };
                    }
                }
                finally
                {
                    reader.Close();
                }
            }
            return profile;
        }
Ejemplo n.º 7
0
        public static bool AddNewProfile(ProfileModel profile, int userId)
        {
            var sql = "INSERT IGNORE INTO " + TblProfiles
                    + " (`UserID`, `ProfileName`, `EnableLink`, `EnableShedule`)"
                    + "VALUES('" + userId
                    + "', '" + profile.ProfileName
                    + "', '" + profile.EnableLinkExport
                    + "', '" + profile.EnableScheduleJob + "');COMMIT;";

            if (DoSql(sql))
            {
                if (profile.SheduleJobs != null && (profile.SheduleJobs.Count > 0))
                {
                    long profileId = 0;
                    const string sqlId = "SELECT LAST_INSERT_ID();";

                    var reader = GetReader(sqlId);
                    if (reader.Read())
                    {
                        profileId = reader.GetInt64(0);
                    }
                    reader.Close();

                    foreach (var shedule in profile.SheduleJobs)
                    {
                        AddSheduleToProfile(profileId, shedule);
                    }
                }
                return true;
            }
            return false;
        }
Ejemplo n.º 8
0
 public Profile(ProfileModel parameters)
 {
     Parameters = parameters;
     Queries = DataExportClientDataManager.GetQueriesForProfile(Parameters.ProfileId);
 }
Ejemplo n.º 9
0
 public Profile()
 {
     Parameters = new ProfileModel();
     Queries = new List<QueryModel>();
 }
Ejemplo n.º 10
0
        private void ScheduleJobControl_SaveClisk(object sender, EventArgs e)
        {
            var profileModel = new ProfileModel
            {
                ProfileName = ProfilesManager.CurrentProfile.Parameters.ProfileName,
                ProfileId = ProfilesManager.CurrentProfile.Parameters.ProfileId,
                EnableLinkExport = ui_EnableLiveExport_checkBox.Checked,
                EnableScheduleJob = ui_AutomaticJob_checkBox.Checked,
                SheduleJobs = _scheduleJobControl.Schedulas
            };
            ProfilesManager.EditCurrentProfile(profileModel);
            RefreshJobList(_scheduleJobControl.Schedulas);

            CloseScheduleJobControl();
        }
Ejemplo n.º 11
0
        private void ui_SaveProfile_button_Click(object sender, EventArgs e)
        {
            if (ui_Profiles_comboBox.SelectedIndex < 0)
            {
                ToastNotification.Show(this, @"Please select a profile.", 2000, eToastPosition.TopCenter);
                return;
            }

            var profileModel = new ProfileModel
                {
                    ProfileName = ProfilesManager.CurrentProfile.Parameters.ProfileName,
                    ProfileId = ProfilesManager.CurrentProfile.Parameters.ProfileId,
                    EnableLinkExport = ui_EnableLiveExport_checkBox.Checked,
                    EnableScheduleJob = ui_AutomaticJob_checkBox.Checked,
                    SheduleJobs = new List<SheduleJobModel>(ProfilesManager.CurrentProfile.GetSheduleTimes())
                };

            ProfilesManager.EditCurrentProfile(profileModel);
            if(!ProfilesManager.CurrentProfile.Parameters.EnableScheduleJob)
                _exportJobs.ClearJobs(ProfilesManager.CurrentProfile.Parameters.ProfileName);
            else
            RefreshJobList(ProfilesManager.CurrentProfile.Parameters.SheduleJobs);
        }