private static void ReadCsvAndCreateNameListCsv()
{
EncodingProvider provider = CodePagesEncodingProvider.Instance;
var encoding = provider.GetEncoding(932);
var body = System.IO.File.ReadAllText("C://Desktop//MemberList.csv", encoding);
var sr = new StringReader(body);
var nameList = new String[14];
var index = 0;
while (sr.Peek() > -1)
{
var line = sr.ReadLine();
if (index == 0)
{
index = index + 1;
continue;
}
var nameCount = line.IndexOf(',');
nameList[index - 1] = line.Substring(nameCount);
index = index + 1;
Console.WriteLine(line);
}
var newBody = "";
for (int i = 0; i < nameList.Length; i++)
{
newBody = newBody + nameList[i] + Environment.NewLine;
}
System.IO.File.WriteAllText("C://DEsktop//NameList.csv", newBody, encoding);
Console.WriteLine("Enterキーで終了します。");
Console.ReadLine();
}
public List <DbRecord> GetList(string Url)
{
//add win1251 coding page to read xml
var ret = new List <DbRecord>();
EncodingProvider win1251 = CodePagesEncodingProvider.Instance;
win1251.GetEncoding(1251);
Encoding.RegisterProvider(win1251);
//parse offers from xml
XmlDocument xDoc = new XmlDocument();
try
{
xDoc.Load(Url);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
XmlElement xRoot = xDoc.DocumentElement;
try
{
foreach (XmlElement xnode in xRoot)
{
if (xnode.Name == "shop")
{
foreach (XmlElement childnode in xnode)
{
if (childnode.Name == "offers")
{
foreach (XmlElement offernode in childnode)
{
if (offernode.Name == "offer")
{
foreach (XmlElement attnode in offernode)
{
if (attnode.Name == "name")
{
ret.Add(new DbRecord {
IdInShop = Int32.Parse(offernode.GetAttribute("id")), Name = attnode.InnerText
});
}
}
}
}
}
}
}
}
}
catch (NullReferenceException e)
{
Console.WriteLine(e.Message);
throw e;
}
return(ret);
}
public Encoding ToEncoding(EncodingProvider provider = default)
{
if (provider == null)
{
return(_codePage.HasValue ? Encoding.GetEncoding(_codePage.Value) : null);
}
return(_codePage.HasValue ? provider.GetEncoding(_codePage.Value) : null);
}
public void GetEncoding_calls_Switch_Case()
{
var encodingSwitchMock = new Mock <ISwitch <Encoding, System.Text.Encoding> >();
encodingSwitchMock.Setup(a => a.Case(It.IsAny <Encoding>())).Verifiable();
var sut = new EncodingProvider(encodingSwitchMock.Object);
sut.GetEncoding(Encoding.Ascii);
encodingSwitchMock.Verify(a => a.Case(It.IsAny <Encoding>()), Times.Once);
}
private static void CreateCsvFile()
{
EncodingProvider provider = CodePagesEncodingProvider.Instance;
var encoding = provider.GetEncoding(932);
var body = "名前,年齢,性別,学部,役職";
body = body + Environment.NewLine + "新井,19,女,文学部,なし";
body = body + Environment.NewLine + "森内,22,男,法学部,部長";
System.IO.File.WriteAllText("C://Desktop//NewMemberList.csv", body);
Console.WriteLine("保存しました！");
Console.WriteLine("Enterキーで終了します。");
Console.ReadLine();
}
private static void ReadCsvAndCreateNewListCsv()
{
EncodingProvider provider = System.Text.CodePagesEncodingProvider.Instance;
var encoding = provider.GetEncoding(932);
var body = System.IO.File.ReadAllText("C:\\Data\\MemberList.csv", encoding);
var sr = new StringReader(body);
var nameList = new String[14];
var gakubuList = new String[14];
var isFirstRow = true;
var index = 0;
while (sr.Peek() > -1)
{
var line = sr.ReadLine();
if (isFirstRow == true)
{
isFirstRow = false;
continue;
}
var ss = line.Split(',');
nameList[index] = ss[0];
gakubuList[index] = ss[3];
index = index + 1;
Console.WriteLine(line);
}
var newBody = "";
for (int i = 0; i < nameList.Length; i++)
{
newBody = newBody + nameList[i] + "," + gakubuList[i] + Environment.NewLine;
}
System.IO.File.WriteAllText("C:\\Data\\NameAndGakubuList.csv", newBody, encoding);
Console.WriteLine("Enterキーで終了します。");
Console.ReadLine();
}
public override Encoding GetEncoding(int codepage) => _staticInstance?.GetEncoding(codepage);
public byte[] GetBytes(EncodingProvider encodingProvider, string encodingName)
{
return(encodingProvider.GetEncoding(encodingName).GetBytes(_sb.ToString()));
}
protected DbaseTests(string fixturePath)
{
FixturePath = fixturePath;
DbfTable = new DbfTable(fixturePath, EncodingProvider.GetEncoding(1252));
}
public string Read(EncodingProvider encodingProvider, string encodingName)
{
var bytes = _bytes.SelectMany(item => item);
return(encodingProvider.GetEncoding(encodingName).GetString(bytes.ToArray()));
}
// override default encoding to use codepage 1252
public DbaseF5Tests() : base(DbaseF5FixturePath, EncodingProvider.GetEncoding(1252))
{
}
// override default encoding to use 1251 codepage
public MsKhdmTests()
: base(MsKhdmFixturePath, EncodingProvider.GetEncoding(1251))
{
}