public bool UpdateSetting(Common.UserEmailSetting userEmailSetting) { try { DataTable dataTable = base.FetchDataTable(@"SELECT COUNT(*) AS [Count] FROM [UserEmailSettings] WHERE [EmailAddress]=@EmailAddress AND [UserGuid] = @UserGuid AND [Guid]!=@Guid" , "@EmailAddress", userEmailSetting.EmailAddress, "@UserGuid", userEmailSetting.UserGuid, "@Guid", userEmailSetting.EmailSettingGuid); if (Helper.GetInt(dataTable.Rows[0]["Count"]) > 0) { throw new Exception(Language.GetString("DuplicateEmail")); } else { return(ExecuteSPCommand("UpdateSetting", "@Guid", userEmailSetting.EmailSettingGuid, "@EmailAddress", userEmailSetting.EmailAddress, "@Password", userEmailSetting.Password, "@Type", userEmailSetting.EmailHostType)); } } catch (Exception ex) { throw ex; } }
public Guid InsertSetting(Common.UserEmailSetting userEmailSetting) { try { DataTable dataTable = base.FetchDataTable(@"SELECT COUNT(*) AS [Count] FROM [UserEmailSettings] WHERE [EmailAddress]=@EmailAddress AND [UserGuid] = @UserGuid" , "@EmailAddress", userEmailSetting.EmailAddress, "@UserGuid", userEmailSetting.UserGuid); if (Helper.GetInt(dataTable.Rows[0]["Count"]) > 0) { throw new Exception(Language.GetString("DuplicateEmail")); } else { return(Insert(userEmailSetting)); } } catch (Exception ex) { throw ex; } }