// get dummy records
private Collection <RepairOrder> GetDummyRecords(ImportFile importFile)
{
int j = _Model.MaxPreview == 0 ? 50 : _Model.MaxPreview;
var items = new Collection <RepairOrder>();
for (int i = 0; i < j; i++)
{
Thread.Sleep(100);
var item = new RepairOrder(
importFile,
60932,
string.Format("Lorem ipsum dolor sit amet {0:000}", i + 1),
67661,
"Y",
5,
(i + 1),
"Ea",
"USD",
100003628
);
item.SerialNumber = "EM1234567";
items.Add(item);
}
importFile._LoadedAll = true;
importFile.RefreshStatus();
return(items);
}
// import the repair order
internal bool Import(RepairOrder repairOrder)
{
if (_Model.InDemo)
{
Thread.Sleep(1000);
if (repairOrder.Quantity % 10 == 0 && repairOrder._File.FileId % 10 == 0)
{
return(false);
}
return(true);
}
var ro = new Accelerator.EBS.SharedServices.RepairOrder();
ro.Quantity = repairOrder.Quantity;
ro.UnitOfMeasure = repairOrder.UnitOfMeasure;
ro.ApprovalRequired = repairOrder.ApprovalRequiredFlag;
ro.Currency = repairOrder.Currency;
ro.ResourceID = _Model.EbsOwnerId;
ro.ProblemDescription = repairOrder.ProblemDescription;
ro.ServiceRequestID = _Model.EbsSrId;
ro.SerialNumber = repairOrder.SerialNumber;
if (ro.ValidateSerialNumber(_Model.EbsContactOrgId, _Model.RntIncidentId, _Model.RntContactId))
{
ro.Create(_Model.RntIncidentId, _Model.RntContactId);
}
else
{
NoticeLog(string.Format("EBS Bulk Import cannot create a repair order because the serial number {0} is not valid", repairOrder.SerialNumber), null);
return(false);
}
if (String.IsNullOrWhiteSpace(ro.RepairNumber))
{
return(false);
}
else
{
return(true);
}
}
private void updateSelected(RoutedEventArgs e, object sender)
{
if (null == _Model.CurrentFile)
{
return;
}
DataGrid dg = sender as DataGrid;
if (null == dg)
{
return;
}
if (!_Model.CurrentFile.IsImportEnabled)
{
return;
}
var col = dg.CurrentCell.Column;
if (null == col)
{
return;
}
if (!((string)col.Header == "Selected"))
{
return;
}
RepairOrder item = dg.CurrentItem as RepairOrder;
if (null == item)
{
return;
}
if (RepairOrder.ImportStatus.New != item.Status)
{
return;
}
item.Selected = !item.Selected;
e.Handled = true;
}
// parse the CSV file
internal Collection<RepairOrder> Parse(Stream stream)
{
var items = new Collection<RepairOrder>();
int max = _MaxPreview;
int ret = max;
if (_ShowAll | 0 == max)
{
max = 0;
}
else
{
max = _MaxPreview + 1;
}
CSV file = new CSV(stream,
hasHeaders: true, charDelimiter:',', charQuote:'"', charEscapeQuote:'\\', fileEncoding:Encoding.UTF8, maxRecords:max, name:Title);
DataTable table = file.ToDataTable();
if (null == table)
{
_Proxy.NoticeLog(string.Format("EBS Bulk Import cannot parse file {0} id {1}. Cannot create data table.",
Title, FileId), null);
_JobStatus = JobStatus.ParseError;
stream.Dispose();
items.Clear();
return items;
}
stream.Dispose();
DataRowCollection rows = table.Rows;
int rowCount = rows.Count;
ret = rowCount;
if (0 == rowCount || (rowCount <= _MaxPreview) || (0 == max))
{
_LoadedAll = true;
IsShowAllEnabled = false;
}
else if (rowCount == (_MaxPreview + 1))
{
_LoadedAll = false;
IsShowAllEnabled = true;
ret = rowCount - 1;
}
else
{
_LoadedAll = false;
IsShowAllEnabled = true;
}
int i = 0;
foreach (DataRow row in rows)
{
if (++i > ret)
{
break;
}
var item = new RepairOrder(
this,
this._Model.EbsSrId,
Convert.ToString(row.Field<object>("PROBLEM_DESCRIPTION")),
0,
Convert.ToString(row.Field<object>("APPROVAL_REQUIRED_FLAG")),
Convert.ToDecimal(row.Field<object>("REPAIR_TYPE_ID")),
Convert.ToDecimal(row.Field<object>("QUANTITY")),
Convert.ToString(row.Field<object>("UNIT_OF_MEASURE")),
Convert.ToString(row.Field<object>("CURRENCY_CODE")),
0
);
item.SerialNumber = Convert.ToString(row.Field<object>("SERIAL_NUMBER"));
items.Add(item);
}
return items;
}
// parse the CSV file
internal Collection <RepairOrder> Parse(Stream stream)
{
var items = new Collection <RepairOrder>();
int max = _MaxPreview;
int ret = max;
if (_ShowAll | 0 == max)
{
max = 0;
}
else
{
max = _MaxPreview + 1;
}
CSV file = new CSV(stream,
hasHeaders: true, charDelimiter: ',', charQuote: '"', charEscapeQuote: '\\', fileEncoding: Encoding.UTF8, maxRecords: max, name: Title);
DataTable table = file.ToDataTable();
if (null == table)
{
_Proxy.NoticeLog(string.Format("EBS Bulk Import cannot parse file {0} id {1}. Cannot create data table.",
Title, FileId), null);
_JobStatus = JobStatus.ParseError;
stream.Dispose();
items.Clear();
return(items);
}
stream.Dispose();
DataRowCollection rows = table.Rows;
int rowCount = rows.Count;
ret = rowCount;
if (0 == rowCount || (rowCount <= _MaxPreview) || (0 == max))
{
_LoadedAll = true;
IsShowAllEnabled = false;
}
else if (rowCount == (_MaxPreview + 1))
{
_LoadedAll = false;
IsShowAllEnabled = true;
ret = rowCount - 1;
}
else
{
_LoadedAll = false;
IsShowAllEnabled = true;
}
int i = 0;
foreach (DataRow row in rows)
{
if (++i > ret)
{
break;
}
var item = new RepairOrder(
this,
this._Model.EbsSrId,
Convert.ToString(row.Field <object>("PROBLEM_DESCRIPTION")),
0,
Convert.ToString(row.Field <object>("APPROVAL_REQUIRED_FLAG")),
Convert.ToDecimal(row.Field <object>("REPAIR_TYPE_ID")),
Convert.ToDecimal(row.Field <object>("QUANTITY")),
Convert.ToString(row.Field <object>("UNIT_OF_MEASURE")),
Convert.ToString(row.Field <object>("CURRENCY_CODE")),
0
);
item.SerialNumber = Convert.ToString(row.Field <object>("SERIAL_NUMBER"));
items.Add(item);
}
return(items);
}