public void ImportFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "CID.xls", "CID10");
var list = new List<CID>();
foreach (DataRow row in data.Rows)
{
var cid = new CID();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "CODIGO":
cid.Code = (string)row[column];
break;
case "DESCRICAO":
cid.Description = (string)row[column];
break;
case "DESCRABREV":
cid.AbbreviatedDescription = (string)row[column];
break;
}
}
list.Add(cid);
}
var cids = new CIDRepository();
cids.SaveList(list);
}
public void Execute()
{
var browsers = ConfigurationManager.AppSettings["browsers"].Split(',');
foreach (var browser in browsers)
{
ExcelRepository target = new ExcelRepository();
TestManager manager = new TestManager(target);
string masterfile = Path.IsPathRooted(ConfigurationManager.AppSettings["masterfile"]) ? ConfigurationManager.AppSettings["masterfile"] :
Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationManager.AppSettings["masterfile"]);
string sequenceFilename = Path.IsPathRooted(ConfigurationManager.AppSettings["sequencefile"]) ? ConfigurationManager.AppSettings["sequencefile"] :
Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationManager.AppSettings["sequencefile"]);
string uimapFilename = Path.IsPathRooted(ConfigurationManager.AppSettings["uimapfile"]) ? ConfigurationManager.AppSettings["uimapfile"] :
Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationManager.AppSettings["uimapfile"]);
string dataDirectory = Path.IsPathRooted(ConfigurationManager.AppSettings["datadirectory"]) ? ConfigurationManager.AppSettings["datadirectory"] :
Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationManager.AppSettings["datadirectory"]);
string resultsFolder = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Results");
var config = new WebAutoConfiguration();
config.DataDirectory = dataDirectory;
config.UIMapFile = uimapFilename;
config.ResultsFolder = resultsFolder;
config.Browser = browser.Trim();
config.FileExtension = ".xlsx";
manager.Execute(target.GetTestSuites(masterfile, sequenceFilename), config);
}
}
public void ImportFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "ESPECIALIDADES.xls", "Plan1");
var list = new List<Specialty>();
foreach (DataRow row in data.Rows)
{
var specialty = new Specialty();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "Código do Termo":
specialty.CodeTerm = row[column].ToString();
break;
case "Termo":
specialty.Description = row[column].ToString();
break;
}
}
list.Add(specialty);
}
var specialties = new Specialties();
specialties.SaveList(list);
}
public void ImportPrescriptionItemFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "DEF.xls", "Sheet1");
var list = new List<PrescriptionItem>();
foreach (DataRow row in data.Rows)
{
var def = new PrescriptionItem();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "PRINCÍPIO ATIVO":
def.ActivePrinciple = (string)row[column];
break;
case "PRODUTO":
def.Description = (string)row[column];
break;
}
}
def.code = Guid.NewGuid().ToString();
def.PrescriptionItemType = PrescriptionItemType.Medicamentos;
list.Add(def);
}
var defs = new DEFRepository();
defs.SaveList(list);
}
public void ImportFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "DEF.xls", "Sheet1");
var list = new List<DEF>();
foreach (DataRow row in data.Rows)
{
var def = new DEF();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "PRINCÍPIO ATIVO":
def.ActivePrinciple = (string)row[column];
break;
case "PRODUTO":
def.Description = (string)row[column];
break;
}
}
list.Add(def);
}
var defs = new DEFRepository();
defs.SaveList(list);
}
public void ImportFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "TUSS.xls", "TUSS");
var list = new List<TUSS>();
foreach (DataRow row in data.Rows)
{
var tus = new TUSS();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "Código do Termo":
tus.Code = row[column].ToString();
break;
case "Termo":
tus.Description = row[column].ToString();
break;
}
}
list.Add(tus);
}
var tusRepository = new TUSSRepository();
tusRepository.SaveList(list);
}
private void OpenFile(string path)
{
_excelRepository = new ExcelRepository(path);
listSheetnames.Items.Clear();
foreach (var sheetName in _excelRepository.GetSheetNames())
{
listSheetnames.Items.Add(sheetName);
}
listSheetnames.SelectedItem = listSheetnames.Items[0];
}
public void GetSequences()
{
ExcelRepository target = new ExcelRepository(); // TODO: Initialize to an appropriate value
string filename = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "..//..//TestFiles//sequences.xlsx");
Assert.IsTrue(File.Exists(filename), "file doesnt exist " + filename);
var result = target.GetCommandSequences(filename, new string[] { });
Assert.AreNotEqual(result.Sequences.Count, 0);
}
public void GetData()
{
ExcelRepository target = new ExcelRepository(); // TODO: Initialize to an appropriate value
string filename = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "..//..//TestFiles//datasample.xlsx");
Assert.IsTrue(File.Exists(filename), "file doesnt exist " + filename);
var result = target.GetData(filename);
Assert.AreNotEqual(result.DataTables.Count, 0);
Assert.AreNotEqual(result.DataValues.Count, 0);
}
static void Main(string[] args)
{
IDataRepository r = new ExcelRepository();
ListeAfPersoner listeAfPersoner = new ListeAfPersoner {
Personer = r.HentPersoner()
};
// Fra objekter til JSON
string jsonFraObjekter = Newtonsoft.Json.JsonConvert.SerializeObject(listeAfPersoner);
System.IO.File.WriteAllText(@"c:\tmp\personer.json", jsonFraObjekter);
// Fra JSON til Objekter
string jsonFraFil = System.IO.File.ReadAllText(@"c:\tmp\personer.json");
ListeAfPersoner fraJSON = Newtonsoft.Json.JsonConvert.DeserializeObject <ListeAfPersoner>(jsonFraFil);
// Fra objekter til XML
XmlSerializer xs2 = new XmlSerializer(typeof(ListeAfPersoner));
using (FileStream fs = File.Create(@"c:\tmp\personer.xml"))
xs2.Serialize(fs, listeAfPersoner);
// Fra XML til objekter
XmlSerializer xs4 = new XmlSerializer(typeof(ListeAfPersoner));
ListeAfPersoner fraXml;
using (StreamReader fs = File.OpenText(@"c:\tmp\personer.xml"))
fraXml = xs4.Deserialize(fs) as ListeAfPersoner;
IDataRepository rep = RepositoryFind.FindRepository();
var res = rep.HentPersoner();
foreach (var person in res)
{
Console.WriteLine(person.Navn);
foreach (var bil in person.Biler)
{
Console.WriteLine("\t" + bil.Mærke);
}
}
var biler = res.SelectMany(i => i.Biler).ToList();
foreach (var bil in biler)
{
Console.WriteLine(bil.Mærke + " som tilhører " + bil.Person.Navn);
}
}
private static ProduceTestDataCommand GetSut()
{
var fileLocationOptions =
new OptionsWrapper <FileLocationOptions>(new FileLocationOptions {
WorkRoot = @"DefaultInput"
});
var excelRepository = new ExcelRepository(TestLogger.Create <ExcelRepository>(),
new IEntityAdapter[]
{
new CounselorEntityAdapter(), new EventEntityAdapter(), new LocationEntityAdapter(),
new RequestEntityAdapter()
}, fileLocationOptions
);
var testDataCreationService =
new TestDataCreationService(TestLogger.Create <TestDataCreationService>(), excelRepository);
return(new ProduceTestDataCommand(TestLogger.Create <ProduceTestDataCommand>(),
fileLocationOptions, excelRepository, testDataCreationService));
}
public MergeServiceTests()
{
_fixture = new Fixture();
var fileLocationOptions =
new OptionsWrapper <FileLocationOptions>(new FileLocationOptions {
WorkRoot = @"DefaultInput"
});
var excelRepository = new ExcelRepository(TestLogger.Create <ExcelRepository>(),
new IEntityAdapter[]
{
new CounselorEntityAdapter(),
new EventEntityAdapter(),
new LocationEntityAdapter(),
new RequestEntityAdapter(),
new ResultEntityAdapter(),
}, fileLocationOptions
);
_sut = new MergeService(TestLogger.Create <MergeService>(), excelRepository);
_testDataCreationService = new TestDataCreationService(TestLogger.Create <TestDataCreationService>(), excelRepository);
}
// private IAuthenticationManager Authentication => Request.GetOwinContext().Authentication;
public ExcelController()
{
_arepo = new ExcelRepository();
}
/// <summary>
/// Parses the file.
/// </summary>
/// <returns></returns>
internal List<Login> ParseFile()
{
IExcelRepository<Login> repo = new ExcelRepository<Login>(_filePath);
repo.AddMapping(x => x.UserName, _userColumn);
repo.AddMapping(x => x.EmailAddress, _emailColumn);
var Logins = from p in repo.Worksheet(_worksheetName)
select p;
return Logins.ToList<Login>();
}
public ExcelBusiness(string _pathArchivo)
{
excelRepository = new ExcelRepository(_pathArchivo);
}
public JsonResult UploadFile()
{
if (!Directory.Exists(ProjectUploadFolder))
{
Directory.CreateDirectory(ProjectUploadFolder);
}
//var streamProvider = new bytera(ServerUploadFolder);
var data = Request.Content.ReadAsFormDataAsync().Result;
//var messages = UploadFiles(streamProvider, false);
var filename = Request.GetQueryNameValuePairs().First().Value;
filename = string.Format(@"{0}\{1}_{2}", ProjectUploadFolder, DateTime.Now.Ticks, filename);
var html = data.Keys[0];
html = html.Substring(html.IndexOf("base64,") + "base64,".Length).Trim().Replace(' ', '+');
try
{
if (html.Length % 4 > 0)
{
html = html.PadRight(html.Length + 4 - html.Length % 4, '=');
}
var image64 = Convert.FromBase64String(html);
File.WriteAllBytes(filename, image64);
}
catch (Exception exception)
{
html = exception.ToString();
//throw;
}
var racejson = "";
var athletejson = "";
try
{
using (var excelRepository = new ExcelRepository(filename))
{
foreach (var sheetName in excelRepository.GetSheetNames())
{
var exceldata = excelRepository.Load(sheetName);
var athleteRepository = new AthleteRepository(exceldata);
var races = athleteRepository.GetRaces().ToList();
racejson = Newtonsoft.Json.JsonConvert.SerializeObject(races);
var raceAthletes = new RaceAthletes(athleteRepository.GetAthletes(), excelRepository.GetFiletime());
athletejson = Newtonsoft.Json.JsonConvert.SerializeObject(raceAthletes);
break;
}
}
}
catch (Exception exception)
{
racejson = exception.Message;
athletejson = exception.ToString();
}
//foreach (var message in messages)
//{
// if (!string.IsNullOrEmpty(html)) html += "<br>";
// html += string.Format("<a href=\"{0}\">{0}</a>", message.Second);
//}
var rr = new JsonResult
{
Data = new jsondata
{
races = racejson,
athletes = athletejson
}
};
return(rr);
//var response = new HttpResponseMessage
//{
// Content = new StringContent(string.Format("<p>{0}</p><p>{1}</p>", racejson, athletejson))
//};
//response.Content.Headers.ContentType = new MediaTypeHeaderValue("text/html");
//return response;
}
