public static List <metadataDataset> GetDataSet()
{
List <metadataDataset> list = new List <metadataDataset>();
ISheet sheet;
HSSFWorkbook hssfwb = new HSSFWorkbook(File.OpenRead(HostingEnvironment.MapPath("~/SeedFiles/EnMetadataDataSet.xls")));
sheet = hssfwb.GetSheetAt(0);
for (int row = 1; row <= sheet.LastRowNum; row++)
{
metadataDataset metadata = new metadataDataset();
if (sheet.GetRow(row) != null)
{
metadata.Id = Convert.ToInt32(sheet.GetRow(row).GetCell(0).NumericCellValue);
metadata.Name = sheet.GetRow(row).GetCell(1).StringCellValue;
metadata.Identifier = sheet.GetRow(row).GetCell(2).StringCellValue;
metadata.Code = Convert.ToString(sheet.GetRow(row).GetCell(3).StringCellValue);
metadata.Description = sheet.GetRow(row).GetCell(4) != null?sheet.GetRow(row).GetCell(4).StringCellValue : "";
metadata.CategoryID = Convert.ToInt32(sheet.GetRow(row).GetCell(5).NumericCellValue);
metadata.Direction = Convert.ToString(sheet.GetRow(row).GetCell(6).StringCellValue);
metadata.IsUPRDAttribute = sheet.GetRow(row).GetCell(7).NumericCellValue == 0 ? false : true;
metadata.IsActive = sheet.GetRow(row).GetCell(8).NumericCellValue == 0 ? false : true;
}
list.Add(metadata);
}
return(list);
}
private void SendMailOfSendingFile(string transactionId, bool GISBReceived)
{
try
{
Outbox newFile = _serviceOutbox.GetByTransactionId(Guid.Parse(transactionId));
if (newFile != null)
{
Pipeline pipeline = _servicePipeline.GetById(newFile.PipelineID);
Hashtable emailVariables = new Hashtable();
metadataDataset dataset = _servicemetadataDataset.GetById(newFile.DatasetID);
emailVariables.Add("%FileName", newFile.MessageID.ToString());
emailVariables.Add("%CreatedDate", newFile.CreatedDate);
emailVariables.Add("%Pipeline", pipeline.Name + "( " + pipeline.DUNSNo + " )");
emailVariables.Add("%Environment", newFile.IsTest ? "Test" : "Live");
emailVariables.Add("%TypeOfFile", dataset != null?dataset.Name:"Unknown");
if (GISBReceived)
{
emailVariables.Add("%GISB", newFile.GISB.Replace("\r\n", "<br>"));
}
else
{
emailVariables.Add("%Status", "Failed. Got empty Gisb in return.");
}
string mailTO = _serviceSetting.GetById((int)Settings.sendMailTo).Value;
//Email.SendEmail(new string[] { mailTO }, null, null, (int)TemplateType.FileSentReceipt, emailVariables, newFile.CreatedBy);
GISBOutbox outboxGisb = new GISBOutbox();
outboxGisb.MessageID = newFile.MessageID.ToString();
outboxGisb.Gisb = newFile.GISB;
outboxGisb.ErrorCode = newFile.StatusID == (int)NomStatus.Submitted ? 0 : 1;
outboxGisb.CreatedDate = DateTime.UtcNow;
int indexRequestStatus = newFile.GISB.IndexOf("request-status");
int indexServerid = newFile.GISB.IndexOf("server-id");
outboxGisb.ErrorDescription = newFile.StatusID == (int)NomStatus.Submitted ? "ok" : newFile.GISB.Substring(indexRequestStatus + 15, indexServerid - (indexRequestStatus + 15 + 3));
_serviceGISBOutbox.Add(outboxGisb);
_serviceGISBOutbox.Save();
}
}
catch (Exception ex)
{
throw ex;
}
}
