public static Object[] GetTaskActivity()
{
string lro2, lro3, lro4, lro5;
DateTime?lr2, nr2, lr3, nr3, lr4, nr4, lr5, nr5;
using (var context = new FxEDIEntities())
{
var r2 = context.TaskActivities.First(r => r.RowID == 2);
Debug.Assert(r2 != null, "rr != null");
lro2 = r2.LastRunOutcome;
lr2 = r2.LastRun;
nr2 = r2.NextRun;
var r3 = context.TaskActivities.First(r => r.RowID == 3);
Debug.Assert(r3 != null, "rr != null");
lro3 = r3.LastRunOutcome;
lr3 = r3.LastRun;
nr3 = r3.NextRun;
var r4 = context.TaskActivities.First(r => r.RowID == 4);
Debug.Assert(r4 != null, "rr != null");
lro4 = r4.LastRunOutcome;
lr4 = r4.LastRun;
nr4 = r4.NextRun;
var r5 = context.TaskActivities.First(r => r.RowID == 5);
Debug.Assert(r5 != null, "rr != null");
lro5 = r5.LastRunOutcome;
lr5 = r5.LastRun;
nr5 = r5.NextRun;
}
return(new object[] { lro2, lr2, nr2, lro3, lr3, nr3, lro4, lr4, nr4, lro5, lr5, nr5 });
}
public static List <BadFile> TryGetBadFiles()
{
using (var context = new FxEDIEntities())
{
return(context.BadFiles.ToList());
}
}
public static void RemoveBadFile(Int32?badFileRowID)
{
using (var context = new FxEDIEntities())
{
var tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
var result = new ObjectParameter("Result", typeof(Int32?));
context.usp_RemoveBadFile(badFileRowID, tranDT, result);
}
}
public static void UpdateReceiveFileLogForReplacedBadFile(Int32?replacedBadFileRowID)
{
using (var context = new FxEDIEntities())
{
var tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
var result = new ObjectParameter("Result", typeof(Int32?));
context.usp_UpdateReceiveFileLogForReplacedBadFile(replacedBadFileRowID, tranDT, result);
}
}
public static void UpdateReceivedDirectoryPoll()
{
using (var context = new FxEDIEntities())
{
var tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
var result = new ObjectParameter("Result", typeof(Int32?));
context.usp_UpdateReceivedDirectoryPoll(tranDT, result);
}
}
public static void RecordReceiveFileLog(string rdpFiles)
{
using (var context = new FxEDIEntities())
{
((IObjectContextAdapter)context).ObjectContext.CommandTimeout = 1200;
var tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
var result = new ObjectParameter("Result", typeof(Int32?));
context.usp_RecordReceiveFileLog(rdpFiles, tranDT, result);
}
}
public static DateTime[] GetPendingDateRange()
{
var range = new DateTime[2];
using (var context = new FxEDIEntities())
{
var rr = context.PendingRDPDateRanges.FirstOrDefault(r => r.RowID == 1);
Debug.Assert(rr != null, "rr != null");
range[0] = rr.FromDT;
range[1] = rr.ToDT;
}
return(range);
}
public static Object[] GetOverallStatus()
{
DateTime currentDT;
int filesMissing;
int corruptFiles;
using (var context = new FxEDIEntities())
{
var rr = context.OverallStatus.First(r => r.RowID == 1);
Debug.Assert(rr != null, "rr != null");
currentDT = rr.CurrentDatetime;
filesMissing = rr.FilesMissing ?? -1;
corruptFiles = rr.CorruptFiles ?? -1;
}
return(new Object[] { currentDT, filesMissing, corruptFiles });
}
