public IAlertsDalSetAlertStatusResult SetAlertSubscriptionStatus(IAlertsDalSetAlertStatusParams setSubsStatusParams) { IAlertsDalSetAlertStatusResult result = new MSSQL.AlertsDalSetAlertStatusResult(); string spName = "[SP_Set_Alert_Subscription_Status]"; SqlConnection conn = OpenConnection(connName); SqlCommand cmd = new SqlCommand(); cmd.CommandText = schema + "." + spName; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; try { if (setSubsStatusParams.Subscriptions != null) { foreach (var s in setSubsStatusParams.Subscriptions) { cmd.Parameters.Clear(); SqlParameter paramAlertId = new SqlParameter("@Alert_Subscription_Id", SqlDbType.BigInt, 0, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, s.Id); SqlParameter paramStatusId = new SqlParameter("@Status_Id", SqlDbType.BigInt, 0, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, s.StatusId); cmd.Parameters.Add(paramAlertId); cmd.Parameters.Add(paramStatusId); cmd.ExecuteNonQuery(); } } result.Success = true; } catch (Exception ex) { result.Success = false; result.Errors.Add(new Interfaces.Error() { Code = Interfaces.EErrorCodes.AlertsSourceFail, Type = Interfaces.EErrorType.Error, Message = ex.Message }); } conn.Close(); return(result); }
public void SetAlertSubscriptionStatus_Success() { RunInitSql("040.SetAccountSubscriptionStatus_Success", _conn); IAlertsDal dal = PrepareAlertsDal(); IAlertsDalGetAccountSubscriptionsParams getGetSubsParams = dal.CreateGetAccountSubscrParams(); getGetSubsParams.AccountKey = ConfigurationManager.AppSettings["AccountKey"]; var getSubsResult = dal.GetAccountSubscriptions(getGetSubsParams); IAlertsDalSetAlertStatusParams updSubParam = dal.CreateSetAlertStatusParams(); getSubsResult.Subscriptions[0].StatusId = Int32.Parse(ConfigurationManager.AppSettings["Status_Id_Disabled"]); updSubParam.Subscriptions.Add(getSubsResult.Subscriptions[0]); IAlertsDalSetAlertStatusResult updSubsResult = dal.SetAlertSubscriptionStatus(updSubParam); RunFinalizeSql("040.SetAccountSubscriptionStatus_Success", _conn); Assert.IsTrue(updSubsResult.Success); }