// GET api/<controller>/5
public ImportExcelModel Get(int id)
{
var info = ImportExcelRepository.GetInfo(id);
var retVal = ImportExcelModel.FromInfo(info);
if (retVal.ImportStatus.HasValue && retVal.ImportStatus == 1)
{
//StoreData.LoadData();
StoreData.LoadImportExcel();
}
return(retVal);
}
/// <summary>
/// Thread method that does the communication to the client. This
/// thread tries to receive from client and if client sends any data
/// then parses it and again wait for the client data to come in a
/// loop. The recieve is an indefinite time receive.
/// </summary>
private void SocketListenerThreadStart()
{
m_lastReceiveDateTime = DateTime.Now;
m_currentReceiveDateTime = DateTime.Now;
var t = new Timer(CheckClientCommInterval, null, 15000, 15000);
while (!m_stopClient)
{
try
{
var networkStream = new NetworkStream(m_clientSocket);
var streamReader = new StreamReader(networkStream);
var importId = ConvertHelper.ToInt32(streamReader.ReadLine());
var importInfo = ImportExcelRepository.GetInfo(importId);
if (importInfo == null)
{
continue;
}
var importProcess = new ImportProcess(importInfo);
var thread = new Thread(StartImport);
thread.Start(importProcess);
//size = m_clientSocket.Receive(byteBuffer);
//m_currentReceiveDateTime = DateTime.Now;
//ParseReceiveBuffer(byteBuffer, size);
//Console.WriteLine(m_oneLineBuf.ToString());
}
catch
{
m_stopClient = true;
m_markedForDeletion = true;
}
}
t.Change(Timeout.Infinite, Timeout.Infinite);
}
private void StartQueueImport()
{
while (!stopFlag)
{
var importId = 0;
Monitor.Enter(Messages.SyncRoot);
if (Messages.Count > 0)
{
importId = ConvertHelper.ToInt32(Messages.Dequeue());
}
Monitor.Exit(Messages.SyncRoot);
var importInfo = ImportExcelRepository.GetInfo(importId);
if (importInfo != null)
{
var importProcess = new ImportProcess(importInfo);
var t = new Thread(importProcess.Start);
t.Start();
Console.WriteLine(importInfo.FilePath);
}
Thread.Sleep(10);
}
}
public string Edit(FormDataCollection form)
{
var retVal = string.Empty;
var operation = form.Get("oper");
var id = ConvertHelper.ToInt32(form.Get("ImportExcelId"));
if (!string.IsNullOrEmpty(operation))
{
ImportExcelInfo info;
switch (operation)
{
case "edit":
info = ImportExcelRepository.GetInfo(id);
if (info != null)
{
/*
*
* info.ImportId = form.Get("ImportId");
*
* info.UserId = form.Get("UserId");
*
* info.TypeId = form.Get("TypeId");
*
* info.ChannelId = form.Get("ChannelId");
*
* info.CollectorId = form.Get("CollectorId");
*
* info.BranchId = form.Get("BranchId");
*
* info.Status = form.Get("Status");
*
* info.FilePath = form.Get("FilePath");
*
* info.TotalRow = form.Get("TotalRow");
*
* info.CheckCount = form.Get("CheckCount");
*
* info.ErrorCount = form.Get("ErrorCount");
*
* info.DuplicateCount = form.Get("DuplicateCount");
*
* info.ImportedDate = form.Get("ImportedDate");
*
* ImportExcelRepository.Update(info);
*/
}
break;
case "add":
info = new ImportExcelInfo();
/*
*
* info.ImportId = form.Get("ImportId");
*
* info.UserId = form.Get("UserId");
*
* info.TypeId = form.Get("TypeId");
*
* info.ChannelId = form.Get("ChannelId");
*
* info.CollectorId = form.Get("CollectorId");
*
* info.BranchId = form.Get("BranchId");
*
* info.Status = form.Get("Status");
*
* info.FilePath = form.Get("FilePath");
*
* info.TotalRow = form.Get("TotalRow");
*
* info.CheckCount = form.Get("CheckCount");
*
* info.ErrorCount = form.Get("ErrorCount");
*
* info.DuplicateCount = form.Get("DuplicateCount");
*
* info.ImportedDate = form.Get("ImportedDate");
*
*/
ImportExcelRepository.Create(info);
break;
case "del":
ImportExcelRepository.Delete(id);
break;
}
}
return(retVal);
}
