public PositiveResponseViewModel()
{
point = null;
wasOpenOptionsWindow = false;
wasOpenAboutWindow = false;
wasOpenHelpWindow = false;
ExpanderOneOpen = true;
model = PositiveResponseModel.CreateNewDocument();
}
public async Task <HttpResponseMessage> PositiveResponse()
{
var method = MethodInfo.GetCurrentMethod();
var ipInfo = Util.GetIPInfo(HttpContext.Current.Request);
try
{
TransactionalInformation transaction = new TransactionalInformation();
ResponseCasesApiModel apiModel = new ResponseCasesApiModel();
if (!Request.Content.IsMimeMultipartContent())
{
return(Request.CreateResponse(HttpStatusCode.UnsupportedMediaType));
}
List <PositiveResponseModel> PositiveResponseL = new List <PositiveResponseModel>();
var provider = new MultipartMemoryStreamProvider();
await Request.Content.ReadAsMultipartAsync(provider);
foreach (var file in provider.Contents)
{
var filename = file.Headers.ContentDisposition.FileName.Trim('\"');
int i = filename.LastIndexOf('.');
string fileExtension = filename.Substring(filename.Length - 4);
if (fileExtension == "xlsx".ToLower() || fileExtension == ".xls".ToLower())
{
apiModel.isPositiveResponce = true;
var buffer = await file.ReadAsByteArrayAsync();
MemoryStream ms = new MemoryStream(buffer);
bool hasHeader = true;
System.Data.DataTable excelData = ExcelUtils.getDataFromExcelFileNoPath(ms, hasHeader);
try
{
foreach (System.Data.DataRow item in excelData.Rows)
{
if (item.ItemArray.Any() && item.ItemArray[0].ToString() != "")
{
PositiveResponseModel positiveModel = new PositiveResponseModel();
try
{
string invoiceNo = item.ItemArray[2].ToString();
if (invoiceNo != "")
{
var bill_position_number = "000000000000";
bill_position_number += (double.Parse(item.ItemArray[2].ToString())).ToString();
bill_position_number = bill_position_number.Substring(bill_position_number.Length - 12, 12);
positiveModel.InvoiceNumberHIP = bill_position_number;
PositiveResponseL.Add(positiveModel);
}
}
catch (Exception ex)
{
};
}
}
}
catch (Exception ex)
{
var userSecurityTicket = new BaseVerification().VerifySessionToken(SessionToken);
Logger.LogInfo(new LogEntry(ipInfo.address, ipInfo.agent, connectionString, method, userSecurityTicket, ex));
transaction.ReturnMessage = new List <string>();
transaction.IsException = true;
transaction.ReturnMessage.Add(ex.StackTrace);
transaction.ReturnMessage.Add(ex.Message);
return(Request.CreateResponse <TransactionalInformation>(HttpStatusCode.BadRequest, transaction));
}
}
else if (fileExtension.ToLower() == ".edi" || fileExtension.ToLower() == ".txt")
{
try
{
var buffer = await file.ReadAsByteArrayAsync();
MemoryStream ms = new MemoryStream(buffer);
EDIMessage ediMsg = new EDIMessage(ms);
var result = ediMsg.GetParsedEdifactFile();
List <NegativeResponseModel> negativeResponseList = new List <NegativeResponseModel>();
foreach (var item in result.transmitionMessages)
{
NegativeResponseModel response = new NegativeResponseModel();
response.billPositionNumber = item.Rgi.Segment5.Value.Split('K').Last();
PositiveResponseL.Add(new Models.PositiveResponseModel()
{
InvoiceNumberHIP = item.Rgi.Segment5.Value.Split('K').Last()
});
response.message = String.Join("; ", item.Fhl.Select(t => t.Segment4.Value).ToArray());
response.hipId = item.Ivk.Segment4.Value;
negativeResponseList.Add(response);
}
var billNumberIDsList = negativeResponseList.Select(j => j.billPositionNumber).ToList();
var nonEligibleStatuses = dashboardDataService.CasesWithNonEligibleStatuses(billNumberIDsList, connectionString, SessionToken, out transaction);
apiModel.NonEligibleStatuses += nonEligibleStatuses.Count;
apiModel.TotalCases += negativeResponseList.Count;
apiModel.isPositiveResponce = false;
apiModel.NegativeModel.ediMessage = ediMsg.RawMessage;
apiModel.NegativeModel.ediName = filename;
var dateToHip_string = result.Unb.Segment5.Value;
try
{
apiModel.NegativeModel.dateOfTransmitionToHIP = DateTime.ParseExact(dateToHip_string, "yyyyMMdd", new CultureInfo("de", true));
}
catch
{
}
if (nonEligibleStatuses.Count > 0)
{
foreach (var billNumber in nonEligibleStatuses)
{
var itemToRemove = negativeResponseList.Where(h => double.Parse(h.billPositionNumber) == double.Parse(billNumber)).SingleOrDefault();
if (itemToRemove != null)
{
negativeResponseList.Remove(itemToRemove);
}
}
apiModel.NegativeModel.NegativeResponseList.AddRange(negativeResponseList);
}
else
{
apiModel.NegativeModel.NegativeResponseList.AddRange(negativeResponseList);
}
}
catch (Exception ex)
{
var userSecurityTicket = new BaseVerification().VerifySessionToken(SessionToken);
Logger.LogInfo(new LogEntry(ipInfo.address, ipInfo.agent, connectionString, method, userSecurityTicket, ex));
transaction.ReturnMessage = new List <string>();
transaction.IsException = true;
transaction.ReturnMessage.Add(ex.StackTrace);
transaction.ReturnMessage.Add(ex.Message);
return(Request.CreateResponse <TransactionalInformation>(HttpStatusCode.BadRequest, transaction));
}
}
}
PositioveResponseCaseModel model = dashboardDataService.positiveResponse(PositiveResponseL, connectionString, SessionToken, out transaction);
apiModel.PositiveModel = model;
apiModel.TotalCases = model.CasesImported;
apiModel.NonEligibleStatuses = model.CasesImportedXLs;
if (transaction.ReturnStatus)
{
return(Request.CreateResponse(HttpStatusCode.OK, apiModel));
}
return(Request.CreateResponse <TransactionalInformation>(HttpStatusCode.BadRequest, transaction));
}
catch (Exception ex)
{
var userSecurityTicket = new BaseVerification().VerifySessionToken(SessionToken);
Logger.LogInfo(new LogEntry(ipInfo.address, ipInfo.agent, connectionString, method, userSecurityTicket, ex));
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
