IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
var sdr = new SqlDataRecord(
new[]
{
new SqlMetaData("ID", SqlDbType.VarChar, 36),
//new SqlMetaData("WORKORDERID", SqlDbType.VarChar, 36),
//new SqlMetaData("LOCATIONID", SqlDbType.VarChar, 6),
new SqlMetaData("STARTDATE", SqlDbType.DateTime),
new SqlMetaData("ENDDATE", SqlDbType.DateTime),
new SqlMetaData("ASSIGNMENTTYPE", SqlDbType.Int),
new SqlMetaData("ASSIGNMENTSTATUS", SqlDbType.Int),
//new SqlMetaData("DESCRIPTION", SqlDbType.VarChar, 200),
//new SqlMetaData("PRIORITY", SqlDbType.Int),
//new SqlMetaData("REGISTERDATE", SqlDbType.DateTime),
//new SqlMetaData("ESTIMATEDSTARTDATE", SqlDbType.DateTime),
//new SqlMetaData("ESTIMATEDENDDATE", SqlDbType.DateTime),
});
foreach (var activity in this)
{
sdr.SetString(0, activity.Id);
sdr.SetDateTime(1, activity.StartDate);
sdr.SetDateTime(2, activity.EndDate);
sdr.SetInt32(3, (int)activity.AssignmentType);
sdr.SetInt32(4, (int)activity.Status);
//sdr.SetString(1, activity.WorkOrderId);
//sdr.SetString(2, activity.Location.Id);
//sdr.SetString(5, activity.Description);
//sdr.SetDateTime(6, activity.RequestDate);
//sdr.SetDateTime(7, activity.EstimatedStartDate);
//sdr.SetDateTime(8, activity.EstimatedEndDate);
yield return(sdr);
}
}
public static List <SqlDataRecord> GetSearchResultsList(string searchTerm, LoginUser loginUser)
{
SqlMetaData recordIDColumn = new SqlMetaData("recordID", SqlDbType.Int);
SqlMetaData relevanceColumn = new SqlMetaData("relevance", SqlDbType.Int);
SqlMetaData[] columns = new SqlMetaData[] { recordIDColumn, relevanceColumn };
List <SqlDataRecord> result = new List <SqlDataRecord>();
SearchResults results = GetSearchNotesResults(searchTerm, loginUser);
List <int> items = new List <int>();
for (int i = 0; i < results.Count; i++)
{
results.GetNthDoc(i);
SqlDataRecord record = new SqlDataRecord(columns);
record.SetInt32(0, int.Parse(results.CurrentItem.Filename));
record.SetInt32(1, results.CurrentItem.ScorePercent);
result.Add(record);
}
return(result);
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord ret = new SqlDataRecord(
new SqlMetaData("ID", SqlDbType.Int),
new SqlMetaData("ExportId", SqlDbType.Int),
new SqlMetaData("OrderColumn", SqlDbType.Int),
new SqlMetaData("ColumnName", SqlDbType.VarChar, 500),
new SqlMetaData("ColumnType", SqlDbType.VarChar, 500),
new SqlMetaData("ColumnValue", SqlDbType.VarChar, 500),
new SqlMetaData("TableName", SqlDbType.VarChar, 500),
new SqlMetaData("STATUS", SqlDbType.SmallInt),
new SqlMetaData("ACTION", SqlDbType.SmallInt)
);
foreach (tBaseExportColumns data in this)
{
ret.SetInt32(0, data.Id);
ret.SetInt32(1, data.ExportId);
ret.SetInt32(2, data.OrderColumn);
ret.SetString(3, String.IsNullOrEmpty(data.ColumnName) ? "" : data.ColumnName);
ret.SetString(4, String.IsNullOrEmpty(data.ColumnType) ? "" : data.ColumnType);
ret.SetString(5, String.IsNullOrEmpty(data.ColumnValue) ? "" : data.ColumnValue);
ret.SetString(6, String.IsNullOrEmpty(data.TableName) ? "" : data.TableName);
ret.SetInt16(7, data.Status);
ret.SetInt16(8, data.Action);
yield return(ret);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord ret = new SqlDataRecord(
new SqlMetaData("ID", SqlDbType.Int),
new SqlMetaData("QUERYID", SqlDbType.Int),
new SqlMetaData("TABLEQUERYID", SqlDbType.Int),
new SqlMetaData("TABLEQUERYCOLUMNID", SqlDbType.Int),
new SqlMetaData("QUERYCOMPARISONID", SqlDbType.Int),
new SqlMetaData("VALUE", SqlDbType.NVarChar, 500),
new SqlMetaData("OPERATOR", SqlDbType.SmallInt),
new SqlMetaData("STATUS", SqlDbType.SmallInt)
);
foreach (tQueryFilters data in this)
{
ret.SetInt32(0, data.Id);
ret.SetInt32(1, data.QueryId);
ret.SetInt32(2, data.TableQueryId);
ret.SetInt32(3, data.TableQueryColumnId);
ret.SetInt32(4, data.QueryComparisonId);
ret.SetString(5, data.Value);
ret.SetInt16(6, data.Operator);
ret.SetInt16(7, data.status);
yield return(ret);
}
}
public List <SqlDataRecord> BuildBaselines(List <ArtBaselineModel> baselines, int siteId)
{
var records = new List <SqlDataRecord>();
var errors = new List <ArtBaselineModel>();
SqlMetaData[] sqlMetaData = new SqlMetaData[8];
sqlMetaData[0] = new SqlMetaData("PatientIdentifier", SqlDbType.NVarChar, 450);
sqlMetaData[1] = new SqlMetaData("IdNo", SqlDbType.Int);
sqlMetaData[2] = new SqlMetaData("HivConfirmationDate", SqlDbType.DateTime2);
sqlMetaData[3] = new SqlMetaData("EnrolmentDate", SqlDbType.DateTime2);
sqlMetaData[4] = new SqlMetaData("ArtDate", SqlDbType.DateTime2);
sqlMetaData[5] = new SqlMetaData("DispositionDate", SqlDbType.NVarChar, 450);
sqlMetaData[6] = new SqlMetaData("DispositionCode", SqlDbType.NVarChar, 50);
sqlMetaData[7] = new SqlMetaData("FacilityId", SqlDbType.Int);
var duplicateBaselines = baselines.GroupBy(x => x.PatientIdentifier).Where(x => x.Count() > 1).Select(x => x.Key).ToList();
baselines.ForEach(p =>
{
var row = new SqlDataRecord(sqlMetaData);
row.SetString(0, p.PatientIdentifier);
row.SetInt32(1, p.IdNo);
row.SetDateTime(2, p.HivConfirmationDate != null ? p.HivConfirmationDate.Value : (DateTime)SqlDateTime.MinValue);
row.SetDateTime(3, p.EnrolmentDate != null ? p.EnrolmentDate.Value : (DateTime)SqlDateTime.MinValue);
row.SetDateTime(4, p.ArtDate != null ? p.ArtDate.Value : (DateTime)SqlDateTime.MinValue);
row.SetString(5, !string.IsNullOrEmpty(p.DispositionDate)? p.DispositionDate : string.Empty);
row.SetString(6, !string.IsNullOrEmpty(p.DispositionCode) ? p.DispositionCode : string.Empty);
row.SetInt32(7, siteId);
records.Add(row);
});
return(records);
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord ret = new SqlDataRecord(
new SqlMetaData("ID", SqlDbType.Int),
//new SqlMetaData("DISTRIBUTORID", SqlDbType.Int),
new SqlMetaData("ACCOUNTTYPE", SqlDbType.Int),
new SqlMetaData("BANKNAME", SqlDbType.VarChar, 50),
new SqlMetaData("ROUTINGNUMBER", SqlDbType.VarChar, 50),
new SqlMetaData("ACCOUNTNUMBER", SqlDbType.VarChar, 50),
new SqlMetaData("SETASDEFAULT", SqlDbType.SmallInt),
new SqlMetaData("ACTION", SqlDbType.SmallInt),
new SqlMetaData("POSITION", SqlDbType.Int)
);
foreach (tBaseBank data in this)
{
ret.SetInt32(0, data.ID);
ret.SetInt32(1, data.AccountType);
ret.SetString(2, data.BankName);
ret.SetString(3, data.RoutingNumber);
ret.SetString(4, data.AccountNumber);
ret.SetInt16(5, data.Setasdefault);
ret.SetInt16(6, data.Action);
ret.SetInt32(7, data.Position);
yield return(ret);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
var sdr = new SqlDataRecord(
new SqlMetaData("FormFieldId", SqlDbType.BigInt),
new SqlMetaData("SortOrder", SqlDbType.Int),
new SqlMetaData("FormFieldType", SqlDbType.Int),
new SqlMetaData("Label", SqlDbType.NVarChar, 100),
new SqlMetaData("Required", SqlDbType.Bit)
);
foreach (FormElementField field in this)
{
if (field.FormFieldId != 0)
{
sdr.SetInt64(0, field.FormFieldId);
}
else
{
sdr.SetDBNull(0);
}
sdr.SetInt32(1, field.SortOrder);
sdr.SetInt32(2, (int)field.FieldType);
sdr.SetString(3, field.Label);
sdr.SetBoolean(4, field.Required);
yield return(sdr);
}
}
private IEnumerable <SqlDataRecord> ToSqlDataRecords(IEnumerable <Observation> observations)
{
// Construct the Data Record with the MetaData:
SqlDataRecord sdr = new SqlDataRecord(
new SqlMetaData("Province", SqlDbType.NVarChar, 100),
new SqlMetaData("Country", SqlDbType.NVarChar, 100),
new SqlMetaData("Timestamp", SqlDbType.DateTime2),
new SqlMetaData("Confirmed", SqlDbType.Int),
new SqlMetaData("Deaths", SqlDbType.Int),
new SqlMetaData("Recovered", SqlDbType.Int),
new SqlMetaData("Lat", SqlDbType.Real),
new SqlMetaData("Lon", SqlDbType.Real)
);
// Now yield the Measurements in the Data Record:
foreach (var observation in observations)
{
sdr.SetString(0, observation.Province);
sdr.SetString(1, observation.Country);
sdr.SetDateTime(2, observation.Timestamp);
sdr.SetInt32(3, observation.Confirmed);
sdr.SetInt32(4, observation.Deaths);
sdr.SetInt32(5, observation.Recovered);
sdr.SetFloat(6, (float)observation.Lat);
sdr.SetFloat(7, (float)observation.Lon);
yield return(sdr);
}
}
private static IEnumerable <SqlDataRecord> BindDishRows(IEnumerable <DishEntity> dishesToUpdate)
{
foreach (var dish in dishesToUpdate)
{
SqlDataRecord record = new SqlDataRecord(typ_DishTable);
record.SetInt64(0, dish.DishId);
record.SetInt64(1, dish.ProviderId);
record.SetInt32(2, (int)dish.DishType);
record.SetString(3, dish.DishName);
record.SetString(4, dish.Description);
record.SetString(5, dish.Ingredients);
record.SetDecimal(6, dish.Price);
record.SetInt32(7, dish.WaitingTimeInMins);
if (!dish.ThumbNailPictureKey.HasValue)
{
record.SetDBNull(8);
}
else
{
record.SetGuid(8, dish.ThumbNailPictureKey.Value);
}
record.SetBoolean(9, dish.Available);
yield return(record);
}
}
private IEnumerable <SqlDataRecord> ToSqlDataRecords(IEnumerable <Flight> items)
{
// Construct the Data Record with the MetaData:
SqlDataRecord sdr = new SqlDataRecord(
new SqlMetaData("Year", SqlDbType.Int),
new SqlMetaData("Month", SqlDbType.Int),
new SqlMetaData("DayOfMonth", SqlDbType.Int),
new SqlMetaData("DayOfWeek", SqlDbType.Int),
new SqlMetaData("FlightDate", SqlDbType.DateTime2),
new SqlMetaData("UniqueCarrier", SqlDbType.NVarChar, 55),
new SqlMetaData("TailNumber", SqlDbType.NVarChar, 55),
new SqlMetaData("FlightNumber", SqlDbType.NVarChar, 55),
new SqlMetaData("OriginAirport", SqlDbType.NVarChar, 55),
new SqlMetaData("OriginState", SqlDbType.NVarChar, 55),
new SqlMetaData("DestinationAirport", SqlDbType.NVarChar, 55),
new SqlMetaData("DestinationState", SqlDbType.NVarChar, 55),
new SqlMetaData("DepartureDelay", SqlDbType.Int),
new SqlMetaData("TaxiOut", SqlDbType.Int),
new SqlMetaData("TaxiIn", SqlDbType.Int),
new SqlMetaData("ArrivalDelay", SqlDbType.Int),
new SqlMetaData("CancellationCode", SqlDbType.NVarChar, 55),
new SqlMetaData("CarrierDelay", SqlDbType.Int),
new SqlMetaData("WeatherDelay", SqlDbType.Int),
new SqlMetaData("NasDelay", SqlDbType.Int),
new SqlMetaData("SecurityDelay", SqlDbType.Int),
new SqlMetaData("LateAircraftDelay", SqlDbType.Int)
);
// Now yield the Measurements in the Data Record:
foreach (var item in items)
{
sdr.SetInt32(0, item.Year);
sdr.SetInt32(1, item.Month);
sdr.SetInt32(2, item.DayOfMonth);
sdr.SetInt32(3, item.DayOfWeek);
sdr.SetDateTime(4, item.FlightDate);
sdr.SetString(5, item.UniqueCarrier);
sdr.SetString(6, item.TailNumber);
sdr.SetString(7, item.FlightNumber);
sdr.SetString(8, item.OriginAirport);
sdr.SetString(9, item.OriginState);
sdr.SetString(10, item.DestinationAirport);
sdr.SetString(11, item.DestinationState);
sdr.SetNullableInt32(12, item.DepartureDelay);
sdr.SetNullableInt32(13, item.TaxiOut);
sdr.SetNullableInt32(14, item.TaxiIn);
sdr.SetNullableInt32(15, item.ArrivalDelay);
sdr.SetString(16, item.CancellationCode);
sdr.SetNullableInt32(17, item.CarrierDelay);
sdr.SetNullableInt32(18, item.WeatherDelay);
sdr.SetNullableInt32(19, item.NasDelay);
sdr.SetNullableInt32(20, item.SecurityDelay);
sdr.SetNullableInt32(21, item.LateAircraftDelay);
yield return(sdr);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
var row = new SqlDataRecord(new SqlMetaData("value1", SqlDbType.Int), new SqlMetaData("value2", SqlDbType.Int));
foreach (Pair <int, int> kv in this)
{
row.SetInt32(0, kv.Item1);
row.SetInt32(1, kv.Item2);
yield return(row);
}
}
public static void PR_GER_FileCopy(SqlString nom_ArquivoOrigem, SqlString nom_ArquivoDestino, SqlBoolean ind_Substituir)
{
List <SqlMetaData> colunas = new List <SqlMetaData>();
colunas.Add(new SqlMetaData("nom_ArquivoOrigem", SqlDbType.VarChar, 700));
colunas.Add(new SqlMetaData("nom_ArquivoDestino", SqlDbType.VarChar, 700));
colunas.Add(new SqlMetaData("ind_Status", SqlDbType.Int));
colunas.Add(new SqlMetaData("nom_Msg", SqlDbType.VarChar, 1000));
SqlDataRecord record = new SqlDataRecord(colunas.ToArray());
try
{
if (File.Exists(nom_ArquivoOrigem.Value))
{
FileInfo fileDestino = new FileInfo(nom_ArquivoDestino.Value);
if (Directory.Exists(fileDestino.DirectoryName))
{
File.Copy(nom_ArquivoOrigem.Value, nom_ArquivoDestino.Value, ind_Substituir.Value);
record.SetString(0, nom_ArquivoOrigem.Value);
record.SetString(1, nom_ArquivoDestino.Value);
record.SetInt32(2, 1);
record.SetString(3, "Operação executada com sucesso");
}
else
{
record.SetString(0, nom_ArquivoOrigem.Value);
record.SetString(1, nom_ArquivoDestino.Value);
record.SetInt32(2, -2);
record.SetString(3, "Diretório destino não existe");
}
}
else
{
record.SetString(0, nom_ArquivoOrigem.Value);
record.SetString(1, nom_ArquivoDestino.Value);
record.SetInt32(2, -1);
record.SetString(3, "Arquivo origem não existe");
}
}
catch (Exception e)
{
record.SetString(0, nom_ArquivoOrigem.Value);
record.SetString(1, nom_ArquivoDestino.Value);
record.SetInt32(2, 0);
record.SetString(3, e.Message);
}
// Send the record to the client.
SqlContext.Pipe.Send(record);
}
/// <summary>
/// Retrieves master page zone element records.
/// </summary>
/// <returns>Enumerable SQL data records.</returns>
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
var sdr = new SqlDataRecord(
new SqlMetaData("MasterPageZoneId", SqlDbType.BigInt),
new SqlMetaData("MasterPageZoneElementId", SqlDbType.BigInt),
new SqlMetaData("MasterPageZoneSortOrder", SqlDbType.Int),
new SqlMetaData("SortOrder", SqlDbType.Int),
new SqlMetaData("ElementId", SqlDbType.BigInt),
new SqlMetaData("BeginRender", SqlDbType.NVarChar, -1),
new SqlMetaData("EndRender", SqlDbType.NVarChar, -1)
);
foreach (MasterPageZoneElement masterPageZoneElement in this)
{
if (masterPageZoneElement.MasterPageZoneId != 0)
{
sdr.SetInt64(0, masterPageZoneElement.MasterPageZoneId);
}
else
{
sdr.SetDBNull(0);
}
if (masterPageZoneElement.MasterPageZoneElementId != 0)
{
sdr.SetInt64(1, masterPageZoneElement.MasterPageZoneElementId);
}
else
{
sdr.SetDBNull(1);
}
sdr.SetInt32(2, masterPageZoneElement.MasterPageZoneSortOrder);
sdr.SetInt32(3, masterPageZoneElement.SortOrder);
sdr.SetInt64(4, masterPageZoneElement.ElementId);
if (masterPageZoneElement.BeginRender != null)
{
sdr.SetString(5, masterPageZoneElement.BeginRender);
}
else
{
sdr.SetDBNull(5);
}
if (masterPageZoneElement.EndRender != null)
{
sdr.SetString(6, masterPageZoneElement.EndRender);
}
else
{
sdr.SetDBNull(6);
}
yield return(sdr);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
var row = new SqlDataRecord(new SqlMetaData("order_id", SqlDbType.Int), new SqlMetaData("value1", SqlDbType.Int), new SqlMetaData("value2", SqlDbType.Bit));
int ordinal = 0;
foreach (KeyValuePair <int, bool> kv in this)
{
row.SetInt32(0, ordinal++);
row.SetInt32(1, kv.Key);
row.SetBoolean(2, kv.Value);
yield return(row);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
var row = new SqlDataRecord(new SqlMetaData("value", SqlDbType.Int), new SqlMetaData("order_id", SqlDbType.Int));
int ordinal = 0;
foreach (int val in this)
{
row.SetInt32(0, val);
row.SetInt32(1, ordinal++);
yield return(row);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord ret = new SqlDataRecord(
new SqlMetaData("DireccionesAnexasId", SqlDbType.Int),
new SqlMetaData("EmpresaId", SqlDbType.Int),
new SqlMetaData("DepartamentoId", SqlDbType.Int),
new SqlMetaData("ProvinciaId", SqlDbType.Int),
new SqlMetaData("DistritoId", SqlDbType.Int),
new SqlMetaData("Direccion", SqlDbType.NVarChar, 100),
new SqlMetaData("Riesgo", SqlDbType.Bit),
new SqlMetaData("CreatedDate", SqlDbType.DateTime),
new SqlMetaData("CreatedBy", SqlDbType.Int),
new SqlMetaData("LastUpdateDate", SqlDbType.DateTime),
new SqlMetaData("LastUpdateBy", SqlDbType.Int),
new SqlMetaData("Estado", SqlDbType.Int)
);
foreach (clsAddressesRisk data in this)
{
ret.SetInt32(0, data.ID);
ret.SetInt32(1, data.EmpresaId);
ret.SetInt32(2, data.DepartamentoId);
ret.SetInt32(3, data.ProvinciaId);
ret.SetInt32(4, data.DistritoId);
ret.SetString(5, data.Direccion);
ret.SetBoolean(6, data.Riesgo);
ret.SetDateTime(7, data.CreationDate);
ret.SetInt32(8, data.Createdby);
ret.SetDateTime(9, data.UpdateDate);
ret.SetInt32(10, data.Updatedby);
ret.SetInt32(11, data.Estado);
yield return(ret);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord ret = new SqlDataRecord(
new SqlMetaData("RowID", SqlDbType.Int),
new SqlMetaData("TestStep_ID", SqlDbType.Int)
);
foreach (clsTestStepIdTableDataTable data in this)
{
ret.SetInt32(0, data.RowID);
ret.SetInt32(1, data.TestStep_ID);
yield return(ret);
}
}
private static IEnumerable <SqlDataRecord> BindOrderItemRows(IEnumerable <OrderItemEntity> orderItemsToUpdate)
{
foreach (var orderItem in orderItemsToUpdate)
{
SqlDataRecord record = new SqlDataRecord(typ_OrderItemTable);
record.SetInt64(0, orderItem.OrderId);
record.SetInt64(1, orderItem.DishId);
record.SetInt32(2, orderItem.Quantity);
record.SetInt32(3, (int)orderItem.ItemStatus);
yield return(record);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord rec = new SqlDataRecord(
new SqlMetaData("ProjectId", System.Data.SqlDbType.Int),
new SqlMetaData("ParticipantId", System.Data.SqlDbType.Int)
);
foreach (ParticipantUser ans in this)
{
rec.SetInt32(0, ans.ProjectId);
rec.SetInt32(1, ans.ParticipantId);
yield return(rec);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
var sdr = new SqlDataRecord(
new SqlMetaData("orderyear", SqlDbType.Int),
new SqlMetaData("qty", SqlDbType.Int));
foreach (MyTVP o in this)
{
sdr.SetInt32(0, o.orderyear);
sdr.SetInt32(1, o.qty);
yield return(sdr);
}
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord ret = new SqlDataRecord(
new SqlMetaData("ALERTID", SqlDbType.Int),
new SqlMetaData("MARKETID", SqlDbType.Int),
new SqlMetaData("STATUS", SqlDbType.SmallInt)
);
foreach (tBaseAlertSystem_Market data in this)
{
ret.SetInt32(0, data.AlertId);
ret.SetInt32(1, data.MarketId);
ret.SetInt16(2, data.Status);
yield return(ret);
}
}
private static void ReturnSalesProcessedRecords(List <Total> _totalRevenueList)
{
SqlPipe pipe = SqlContext.Pipe;
SqlMetaData[] cols = new SqlMetaData[4];
cols[0] = new SqlMetaData("id", SqlDbType.Int);
cols[1] = new SqlMetaData("TotalRevenue", SqlDbType.Decimal, 38, 4);
cols[2] = new SqlMetaData("DatetimeStamp", SqlDbType.DateTime);
cols[3] = new SqlMetaData("TotalRevenueNew", SqlDbType.Decimal, 38, 4);
SqlDataRecord row = new SqlDataRecord(cols);
pipe.SendResultsStart(row);
//TODO: Sort the list once more time before projecting them into a table
foreach (var _totalRevenueItem in _totalRevenueList)
{
row.SetInt32(0, _totalRevenueItem.Id);
row.SetDecimal(1, _totalRevenueItem.TotalRevenue);
row.SetDateTime(2, _totalRevenueItem.DatetimeStamp);
row.SetDecimal(3, _totalRevenueItem.TotalRevenueNew);
pipe.SendResultsRow(row);
}
pipe.SendResultsEnd();
}
public static void uspSplitString(string str, string sep)
{
SqlPipe pipe = SqlContext.Pipe;
String[] subStrings = str.Split(new string[] { sep }, StringSplitOptions.RemoveEmptyEntries);
SqlDataRecord record = new SqlDataRecord(
new SqlMetaData("substringIndex", SqlDbType.Int),
new SqlMetaData("substring", SqlDbType.NVarChar, 100)
);
// Mark the begining of the result-set.
SqlContext.Pipe.SendResultsStart(record);
int index = 0;
foreach (string subStr in subStrings)
{
// Set values for each column in the row.
record.SetInt32(0, index++);
record.SetString(1, subStr);
// Send the row back to the client.
SqlContext.Pipe.SendResultsRow(record);
}
// Mark the end of the result-set.
SqlContext.Pipe.SendResultsEnd();
}
public static void CreateNewRecord()
{
// Variables.
SqlMetaData column1Info;
SqlMetaData column2Info;
SqlMetaData column3Info;
SqlDataRecord record;
// Create the column metadata.
column1Info = new SqlMetaData("Column1", SqlDbType.NVarChar, 12);
column2Info = new SqlMetaData("Column2", SqlDbType.Int);
column3Info = new SqlMetaData("Column3", SqlDbType.DateTime);
// Create a new record with the column metadata.
record = new SqlDataRecord(new SqlMetaData[] { column1Info,
column2Info,
column3Info });
// Set the record fields.
record.SetString(0, "Hello World!");
record.SetInt32(1, 42);
record.SetDateTime(2, DateTime.Now);
// Send the record to the calling program.
SqlContext.Pipe.Send(record);
}
/// <summary>
/// Mark the list of notifications as seen
/// </summary>
/// <param name="userId">user id</param>
/// <param name="notificationsId">seen notification id list</param>
public void MarkNotifications(int userId, int[] notificationsId)
{
this.Session.CreateCommand("CTMarkNotifications", true);
List <SqlDataRecord> listItemsID = new List <SqlDataRecord>();
SqlMetaData[] tvp_definition = { new SqlMetaData("NotificationsId", SqlDbType.Int) };
SqlParameter parameter = new SqlParameter("@NotificationsId", SqlDbType.Structured);
parameter.Direction = ParameterDirection.Input;
parameter.TypeName = "int_list";
if (notificationsId != null && notificationsId.Length > 0)
{
foreach (int id in notificationsId)
{
SqlDataRecord rec = new SqlDataRecord(tvp_definition);
rec.SetInt32(0, id);
listItemsID.Add(rec);
}
}
else
{
SqlDataRecord rec = new SqlDataRecord(tvp_definition);
rec.SetInt32(0, 0);
listItemsID.Add(rec);
}
parameter.Value = listItemsID;
this.Session.AddParameter(parameter);
this.Session.AddParameter("@UserId", userId, System.Data.ParameterDirection.Input, System.Data.DbType.Int32);
this.Session.ExecuteNonQuery();
}
//</Snippet1>
public static void CreateNewRecord1()
{
//<Snippet2>
//using Microsoft.Data.SqlClient.Server;
// Variables.
SqlMetaData column1Info;
SqlMetaData column2Info;
SqlDataRecord record;
// Create the column metadata.
column1Info = new SqlMetaData("Column1", SqlDbType.NVarChar, 12);
column2Info = new SqlMetaData("Column2", SqlDbType.Int);
// Create a new record with the column metadata.
record = new SqlDataRecord(new SqlMetaData[] { column1Info,
column2Info });
//</Snippet2>
// Set the record fields.
record.SetString(0, "Hello World!");
record.SetInt32(1, 42);
// Send the record to the calling program.
SqlContext.Pipe.Send(record);
}
IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord ret = new SqlDataRecord(
new SqlMetaData("Actual_Result", SqlDbType.VarChar, 500),
new SqlMetaData("Status", SqlDbType.Int),
new SqlMetaData("TestStepPlanID", SqlDbType.Int)
);
foreach (clsTestStepIdTableDataTable_c data in this)
{
ret.SetString(0, data.Actual_Result);
ret.SetInt32(1, data.Status);
ret.SetInt32(2, data.TestStepPlanID);
yield return(ret);
}
}
public static bool File_Batch_FolderID(List <File> filelist)
{
try
{
using (var conn = DbHelper.ResourceService())
{
var recordparam = new List <SqlDataRecord>();
var recordcolumn = new[]
{
new SqlMetaData("id", SqlDbType.Int)
};
foreach (var r in filelist)
{
var record = new SqlDataRecord(recordcolumn);
record.SetInt32(0, r.FileID);
recordparam.Add(record);
}
var ids = new TableValueParameter("@ids", "IDList", recordparam);
conn.Execute("File_Batch_FolderID", ids, commandType: CommandType.StoredProcedure);
return(true);
}
}
catch (Exception e)
{
return(false);
}
}
public static void CreateGeometryDartboard(SqlGeometry centre, double radius, int numrings)
{
int srid = (int)centre.STSrid;
List <SqlDataRecord> Grid = new List <SqlDataRecord>();
SqlMetaData[] Columns =
{
new SqlMetaData("CellId", SqlDbType.Int),
new SqlMetaData("Cell", SqlDbType.Udt, typeof(SqlGeometry))
};
for (int x = 0; x < numrings; x++)
{
SqlGeometry Ring = centre.STBuffer(radius * (x + 1));
SqlGeometry Hole = centre.STBuffer(radius * x);
Ring = Ring.STDifference(Hole);
SqlDataRecord rec = new SqlDataRecord(Columns);
rec.SetInt32(0, x);
rec.SetValue(1, Ring);
Grid.Add(rec);
}
SqlContext.Pipe.SendResultsStart(new SqlDataRecord(Columns));
foreach (SqlDataRecord d in Grid)
{
SqlContext.Pipe.SendResultsRow(d);
}
SqlContext.Pipe.SendResultsEnd();
}
/// <summary>
/// Set property value to sql record.
/// </summary>
/// <param name="dataRecord">
/// Instance of sql data record.
/// </param>
/// <param name="databaseType">
/// Type of database column.
/// </param>
/// <param name="propValue">
/// Value to be inserted.
/// </param>
/// <param name="ordinal">
/// The zero based ordinal of the data record column.
/// </param>
private void SetDataRecordValue(SqlDataRecord dataRecord, DbType databaseType, object propValue, int ordinal)
{
switch (databaseType)
{
case DbType.String:
dataRecord.SetString(ordinal, propValue.ToString());
break;
case DbType.Int32:
dataRecord.SetInt32(ordinal, Convert.ToInt32(propValue));
break;
case DbType.DateTime:
dataRecord.SetDateTime(ordinal, Convert.ToDateTime(propValue));
break;
case DbType.Boolean:
dataRecord.SetBoolean(ordinal, Convert.ToBoolean(propValue));
break;
default:
dataRecord.SetString(ordinal, propValue.ToString());
break;
}
}
