/// <summary>
/// Count the subscriptions
/// </summary>
/// <param name="ATable">table with subscriptions</param>
/// <param name="ATotalSubscriptions">returns the total number of subscriptions</param>
/// <param name="AActiveSubscriptions">returns the number of active subscriptions</param>
public static void CalculateTabCountsSubscriptions(PSubscriptionTable ATable, out Int32 ATotalSubscriptions, out Int32 AActiveSubscriptions)
{
// Inspect only CurrentRows (this excludes Deleted DataRows)
ATotalSubscriptions = new DataView(ATable, "", "", DataViewRowState.CurrentRows).Count;
// Inspect only CurrentRows (this excludes Deleted DataRows)
AActiveSubscriptions = new DataView(ATable,
PSubscriptionTable.GetSubscriptionStatusDBName() + " <> '" + MPartnerConstants.SUBSCRIPTIONS_STATUS_CANCELLED + "' AND " +
PSubscriptionTable.GetSubscriptionStatusDBName() + " <> '" + MPartnerConstants.SUBSCRIPTIONS_STATUS_EXPIRED + "'", "",
DataViewRowState.CurrentRows).Count;
}
/// <summary>
/// Called by the instantiator of this Dialog to retrieve the values of Fields
/// on the screen.
/// </summary>
/// <param name="ARow"></param>
/// <param name="AFieldsToChange"></param>
/// <returns>Boolean</returns>
public Boolean GetReturnedParameters(ref PSubscriptionRow ARow, ref List <String> AFieldsToChange)
{
Boolean ReturnValue = true;
ARow.InitValues();
AFieldsToChange.Clear();
// publication code needs to be set, otherwise change can not be performed
if (cmbPSubscriptionPublicationCode.GetSelectedString() == "")
{
return(false);
}
ARow.PublicationCode = cmbPSubscriptionPublicationCode.GetSelectedString();
if (chkChangeSubscriptionStatus.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetSubscriptionStatusDBName());
ARow.SubscriptionStatus = cmbPSubscriptionSubscriptionStatus.Text;
}
if (chkChangeGratisSubscription.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetGratisSubscriptionDBName());
ARow.GratisSubscription = chkPSubscriptionGratisSubscription.Checked;
}
if (chkChangeNumberComplimentary.Checked &&
txtPSubscriptionNumberComplimentary.NumberValueInt.HasValue)
{
AFieldsToChange.Add(PSubscriptionTable.GetNumberComplimentaryDBName());
ARow.NumberComplimentary = txtPSubscriptionNumberComplimentary.NumberValueInt.Value;
}
if (chkChangePublicationCopies.Checked &&
txtPSubscriptionPublicationCopies.NumberValueInt.HasValue)
{
AFieldsToChange.Add(PSubscriptionTable.GetPublicationCopiesDBName());
ARow.PublicationCopies = txtPSubscriptionPublicationCopies.NumberValueInt.Value;
}
if (chkChangeReasonSubsGivenCode.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetReasonSubsGivenCodeDBName());
ARow.ReasonSubsGivenCode = cmbPSubscriptionReasonSubsGivenCode.GetSelectedString();
}
if (chkChangeReasonSubsCancelledCode.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetReasonSubsCancelledCodeDBName());
ARow.ReasonSubsCancelledCode = cmbPSubscriptionReasonSubsCancelledCode.GetSelectedString();
}
if (chkChangeGiftFromKey.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetGiftFromKeyDBName());
ARow.GiftFromKey = Convert.ToInt64(txtPSubscriptionGiftFromKey.Text);
}
if (chkChangeStartDate.Checked &&
dtpPSubscriptionStartDate.Date.HasValue)
{
AFieldsToChange.Add(PSubscriptionTable.GetStartDateDBName());
ARow.StartDate = dtpPSubscriptionStartDate.Date.Value;
}
if (chkChangeExpiryDate.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetExpiryDateDBName());
ARow.ExpiryDate = dtpPSubscriptionExpiryDate.Date;
}
if (chkChangeRenewalDate.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetSubscriptionRenewalDateDBName());
ARow.SubscriptionRenewalDate = dtpPSubscriptionSubscriptionRenewalDate.Date;
}
if (chkChangeDateNoticeSent.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetDateNoticeSentDBName());
ARow.DateNoticeSent = dtpPSubscriptionDateNoticeSent.Date;
}
if (chkChangeDateCancelled.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetDateCancelledDBName());
ARow.DateCancelled = dtpPSubscriptionDateCancelled.Date;
}
if (chkChangeNumberIssuesReceived.Checked &&
txtPSubscriptionNumberIssuesReceived.NumberValueInt.HasValue)
{
AFieldsToChange.Add(PSubscriptionTable.GetNumberIssuesReceivedDBName());
ARow.NumberIssuesReceived = txtPSubscriptionNumberIssuesReceived.NumberValueInt.Value;
}
if (chkChangeFirstIssue.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetFirstIssueDBName());
ARow.FirstIssue = dtpPSubscriptionFirstIssue.Date;
}
if (chkChangeLastIssue.Checked)
{
AFieldsToChange.Add(PSubscriptionTable.GetLastIssueDBName());
ARow.LastIssue = dtpPSubscriptionLastIssue.Date;
}
return(ReturnValue);
}