public Model.File GetFile(string id)
{
Model.File file = null;
using (var entities = new Model.FlowerEntities())
{
file = (Model.File)(from e in entities.Files.AsEnumerable() where e.ID == id select e).Single();
}
return file;
}
public Model.File GetFile(string id)
{
Model.File file = null;
using (var entities = new Model.FlowerEntities())
{
file = (Model.File)(from e in entities.Files.AsEnumerable() where e.ID == id select e).Single();
}
return(file);
}
public void ＤＢを一旦クリアする()
{
using (var entities = new Model.FlowerEntities())
{
foreach (var file in entities.Files)
{
entities.Files.Remove(file);
}
entities.SaveChanges();
}
return;
}
public void ファイルDB登録()
{
var domain = new FileDomain(@".\TestCase\FileStore\");
var file = domain.Regist2DB("Test_Text.txt", "TestId");
Assert.True(file != null);
using (var entities = new Model.FlowerEntities())
{
var latestileId = (from e in entities.Files.AsEnumerable() select e.ID).Max();
Assert.True(file.ID == latestileId);
}
return;
}
public void ファイル登録_連続()
{
var domain = new FileDomain(@".\TestCase\FileStore\");
domain.Regist(@"TestCase\Data\Test_Text.txt");
domain.Regist(@"TestCase\Data\Test_Text.txt");
using (var entities = new Model.FlowerEntities())
{
var latestFileId = (from e in entities.Files.AsEnumerable() select e.ID).Max();
Assert.True(latestFileId == "2");
}
Assert.True(System.IO.File.Exists(@".\TestCase\FileStore\1.dat") == true);
Assert.True(System.IO.File.Exists(@".\TestCase\FileStore\2.dat") == true);
}
public void ファイル削除_１つ()
{
var domain = new FileDomain(@".\TestCase\FileStore\");
var newId = domain.Regist(@"TestCase\Data\Test_Text.txt");
var file = domain.Remove(newId);
Assert.True(System.IO.File.Exists(@".\TestCase\FileStore\1.dat") == false);
using (var entities = new Model.FlowerEntities())
{
Assert.True(entities.Files.Count() == 0);
}
Assert.True(file.ID == "1");
return;
}
public void ファイル削除DB()
{
var domain = new FileDomain(@".\TestCase\FileStore\");
var newId = domain.Regist(@"TestCase\Data\Test_Text.txt");
var cn = new EntityConnection("name=FlowerEntities");
cn.Open();
domain.removeFromDB(newId, cn);
using (var entities = new Model.FlowerEntities())
{
Assert.True(entities.Files.Count() == 0);
}
return;
}
public void ファイルDB登録_連続登録()
{
var domain = new FileDomain(@".\TestCase\FileStore\");
var file = domain.Regist2DB("Test_Text.txt", "TestId01");
file = domain.Regist2DB("Test_Text.txt", "TestId02");
Assert.True(file != null);
using (var entities = new Model.FlowerEntities())
{
var cnt = (from e in entities.Files.AsEnumerable() where e.Name == "Test_Text.txt" select e).Count();
Assert.True(cnt == 2);
}
return;
}
private string getId()
{
string latestId = "";
string newId = "";
using (var entities = new Model.FlowerEntities())
{
latestId = (from e in entities.Files.AsEnumerable() select e.ID).Max();
if (entities.Files.Count() == 0)
{
return("1");
}
}
// Next ID
newId = (decimal.Parse(latestId) + 1).ToString();
return(newId);
}
/// <summary>
/// ファイル情報のDB登録
/// </summary>
/// <param name="fileName"></param>
/// <param name="id"></param>
/// <returns></returns>
/// <remarks>トランザクションは管理しない</remarks>
private Model.File Regist2DB(string fileName, string id)
{
var fullpath = this.folder + fileName;
var file = new Model.File();
try
{
using (var entities = new Model.FlowerEntities())
{
file.ID = id;
file.Name = fileName;
file.CreateUser = "******";
file.CreateDate = DateTime.Now;
entities.Files.Add(file);
entities.SaveChanges();
}
}
catch
{
file = null;
}
return(file);
}
/// <summary>
/// ファイル情報のDB登録
/// </summary>
/// <param name="fileName"></param>
/// <param name="id"></param>
/// <returns></returns>
/// <remarks>トランザクションは管理しない</remarks>
private Model.File Regist2DB(string fileName, string id)
{
var fullpath = this.folder + fileName;
var file = new Model.File();
try
{
using (var entities = new Model.FlowerEntities())
{
file.ID = id;
file.Name = fileName;
file.CreateUser = "******";
file.CreateDate = DateTime.Now;
entities.Files.Add(file);
entities.SaveChanges();
}
}
catch
{
file = null;
}
return file ;
}
private string getId()
{
string latestId = "";
string newId = "";
using (var entities = new Model.FlowerEntities())
{
latestId = (from e in entities.Files.AsEnumerable() select e.ID).Max();
if (entities.Files.Count() == 0)
{
return "1";
}
}
// Next ID
newId = (decimal.Parse(latestId) + 1).ToString();
return newId;
}
