public DataSet PaymentTypeSearch(string searchText, int pageOffset, int pageSize, string sortColumn = "PAYMENT_TYPE_CODE", bool sortOrder = false)
{
TalentDataAccess talentSqlAccessDetail = new TalentDataAccess();
ErrorObj err = new ErrorObj();
DataSet paymentTypeData = new DataSet();
var strQuery = "SELECT COUNT(*) FROM tbl_payment_type WHERE PAYMENT_TYPE_DESCRIPTION LIKE @SearchText; SELECT PAYMENT_TYPE_CODE AS ID, PAYMENT_TYPE_DESCRIPTION AS DESCRIPTION, \'tbl_payment_type\' as TABLE_NAME FROM tbl_payment_type WHERE PAYMENT_TYPE_DESCRIPTION like @SearchText";
try
{
talentSqlAccessDetail.Settings = settings;
talentSqlAccessDetail.CommandElements.CommandExecutionType = CommandExecution.ExecuteDataSet;
talentSqlAccessDetail.CommandElements.CommandText = strQuery;
talentSqlAccessDetail.CommandElements.CommandParameter.Clear();
talentSqlAccessDetail.CommandElements.CommandParameter.Add(ConstructParameter("@SearchText", "%" + searchText + "%"));
err = talentSqlAccessDetail.SQLAccess(DestinationDatabase.SQL2005);
if ((!(err.HasError)) && (!(talentSqlAccessDetail.ResultDataSet == null)))
{
paymentTypeData = talentSqlAccessDetail.ResultDataSet;
}
}
catch (Exception)
{
throw;
}
finally
{
talentSqlAccessDetail = null;
}
return(paymentTypeData);
}
/// <summary>
/// XML Comment
/// </summary>
/// <param name="objtalentSqlAccessDetail"></param>
/// <param name="settings"></param>
/// <remarks></remarks>
public static void SerializeTransaction(TalentDataAccess objtalentSqlAccessDetail, DESettings settings)
{
DataAccess.ConfigObjects.tbl_config_detail_audit objAudit = new DataAccess.ConfigObjects.tbl_config_detail_audit(ref settings);
MemoryStream ms = new MemoryStream();
BinaryFormatter bf = new BinaryFormatter();
// serialize the object
bf.Serialize(ms, objtalentSqlAccessDetail);
if (settings.GroupID == "")
{
settings.GroupID = GetGroupID(settings).ToString();
}
// add it to DB
objAudit.Insert(ms, settings.GroupID, settings.Module_Name, settings.AgentName, objtalentSqlAccessDetail.TableName, objtalentSqlAccessDetail.Action, objtalentSqlAccessDetail.DataSource, objtalentSqlAccessDetail.Catalog, settings.BusinessUnit);
}
