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); }