/// <summary>
/// XML Comment
/// </summary>
/// <returns></returns>
/// <remarks></remarks>
public DataTable SelectDB2PaymentTypes()
{
//how to get company code, type code and active flag
MD501 md501Obj = new MD501(ref settings);
DataTable outputDataTable = md501Obj.SelectByCompAndType(settings.Company, MD501_TYPE_CODE);
return(outputDataTable);
}
/// <summary>
/// XML Comment
/// </summary>
/// <param name="givenTransaction"></param>
/// <returns></returns>
/// <remarks></remarks>
public override int DeleteCurrentValues(System.Data.SqlClient.SqlTransaction givenTransaction = null)
{
int affectedRows = 0;
MD501 dataObj = new MD501(ref settings);
affectedRows += dataObj.DeleteData("GEND", settings.VariableKey1);
return(affectedRows);
}
/// <summary>
/// XML Comment
/// </summary>
/// <param name="givenTransaction"></param>
/// <returns></returns>
/// <remarks></remarks>
public override int DeleteCurrentValues(System.Data.SqlClient.SqlTransaction givenTransaction = null)
{
int affectedRows = 0;
tbl_payment_type tblPaymentType = new tbl_payment_type(ref settings);
tbl_payment_type_bu tblPaymentTypeBu = new tbl_payment_type_bu(ref settings);
affectedRows = tblPaymentType.DeleteCurrentValues();
affectedRows += tblPaymentTypeBu.DeleteCurrentValues();
MD501 dataObj = new MD501(ref settings);
affectedRows += dataObj.DeleteData("PAYT", settings.VariableKey1);
return(affectedRows);
}
public override bool Validate()
{
// Validate the default validation first
bool retVal = base.Validate();
if (retVal)
{
DataAccess.DataObjects.tbl_payment_type objTblPaymentType = new DataAccess.DataObjects.tbl_payment_type(ref settings);
string paymentTypeCode = string.Empty;
string ticketingPaymentType = string.Empty;
string currentTicketingPaymentType = string.Empty;
bool CheckValid = true;
string ValidationMessage = string.Empty;
ModuleConfiguration objMConfig = null;
if (settings.Mode == "create")
{
// Validate that the payment type does not exist on the ebusiness tables
paymentTypeCode = System.Convert.ToString(MConfigs.Find(x => x.ConfigurationItem.DefaultName == "PAYMENT_TYPE_CODE").ConfigurationItem.UpdatedValue);
CheckValid = System.Convert.ToBoolean(objTblPaymentType.IsPaymentTypeUnique(paymentTypeCode));
if (!CheckValid)
{
ValidationMessage = "Payment type code already exists.";
objMConfig = MConfigs.Find(x => x.ConfigurationItem.DefaultName == "PAYMENT_TYPE_CODE");
objMConfig.ErrorMessage = ValidationMessage;
retVal = false;
}
}
// Has the ticketing payment type changed?
if (IsCustomPaymentTypeCode)
{
ticketingPaymentType = System.Convert.ToString(MConfigs.Find(x => x.ConfigID == VALU51).ConfigurationItem.UpdatedValue);
currentTicketingPaymentType = System.Convert.ToString(MConfigs.Find(x => x.ConfigID == VALU51).ConfigurationItem.CurrentValue);
if (!(string.IsNullOrWhiteSpace(ticketingPaymentType)) && (ticketingPaymentType != currentTicketingPaymentType))
{
// Ticketing payment type must also be unique
MD501 md501Obj = new MD501(ref settings);
CheckValid = md501Obj.IsPaymentTypeUnique(ticketingPaymentType);
if (!CheckValid)
{
ValidationMessage = "Ticketing code already exists.";
objMConfig = MConfigs.Find(x => x.ConfigID == VALU51);
objMConfig.ErrorMessage = ValidationMessage;
retVal = false;
}
}
}
}
return(retVal);
}
