public static bool Eliminar(int id)
{
bool eliminado = false;
Contexto contexto = new Contexto();
try
{
Canto canto = contexto.cantos.Find(id);
contexto.cantos.Remove(canto);
if (contexto.SaveChanges() > 0)
{
eliminado = true;
}
contexto.Dispose();
}
catch (Exception)
{
throw;
}
return(eliminado);
}
public void createCanto_withGivenLine_shouldCreate()
{
Line line = new Line
{
Number = 1,
Text = "In the middle of life"
};
Canto f = new Canto
{
};
f.AddLine(line);
using (ISession session = sqliteSessionFactory.Session)
{
using (ITransaction transaction = session.BeginTransaction())
{
Assert.That(f.Id == 0);
session.SaveOrUpdate(f);
transaction.Commit();
Assert.That(f.Id > 0);
}
}
}
private void BuscarButton_Click(object sender, EventArgs e)
{
errorProvider.Clear();
if (Validar(1))
{
MessageBox.Show("Ingrese un ID");
return;
}
int id = Convert.ToInt32(CantoNumericUpDown.Value);
Canto canto = BLL.CantoBLL.Buscar(id);
if (canto != null)
{
NombreTextBox.Text = canto.Nombre;
VersiculoTextBox.Text = canto.Versiculo;
ColorComboBox.SelectedText = canto.Color;
MomentoComboBox.SelectedText = canto.Momento;
TiempoComboBox.SelectedText = canto.Tiempo;
PaginaNumericUpDown.Value = canto.pagina;
}
else
{
MessageBox.Show("No se encontro", "Fallo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void createBook_withFirst3LinesOfInferno_shouldCreate()
{
Line line1 = new Line
{
Number = 1,
Text = "Halfway along our journey to life's end"
};
Line line2 = new Line
{
Number = 2,
Text = "I found myself astray in a darkwood,"
};
Line line3 = new Line
{
Number = 3,
Text = "Since the rightway was no where to be found."
};
Canto canto1 = new Canto
{
Number = 1
};
canto1.AddLine(line1);
canto1.AddLine(line2);
canto1.AddLine(line3);
Book inferno = new Book
{
Number = 1,
Name = "Inferno"
};
inferno.AddCanto(canto1);
using (ISession session = sqliteSessionFactory.Session)
{
using (ITransaction transaction = session.BeginTransaction())
{
Assert.That(inferno.Id == 0);
session.SaveOrUpdate(inferno);
transaction.Commit();
Assert.That(inferno.Id > 0);
}
using (session.BeginTransaction())
{
var resbooks = session.CreateCriteria(typeof(Book)).List <Book>();
var resbook = resbooks[0];
var rescantos = resbooks[0].Cantos;
var text = rescantos[0].ToString();
Assert.That(resbook.Name == "Inferno");
Assert.That(text.StartsWith("Halfway"));
}
}
}
public static void Import_Book(string name, int number, string text0)
{
Book book = new Book
{
Number = number,
Name = name,
};
Canto canto = new Canto {
};
using (var reader = new StringReader(text0))
{
string txtline = string.Empty;
var cantoNumber = 1;
int lineNumber = 1;
do
{
txtline = reader.ReadLine();
if (txtline == null)
{
break;
}
txtline = txtline.Replace("\t", "").Trim(' ');
if (!string.IsNullOrEmpty(txtline))
{
if (txtline.StartsWith("##"))
{
cantoNumber = int.Parse(Regex.Replace(txtline, "## (.*)", "$1", RegexOptions.IgnoreCase));
lineNumber = 1;
canto = new Canto
{
Number = cantoNumber
};
book.AddCanto(canto);
}
else
{
var line = new Line
{
Number = lineNumber,
Text = txtline
};
canto.AddLine(line);
lineNumber++;
}
}
}while (txtline != null);
}
ISession session1 = SQLiteSessionManager.GetCurrentSession();
using (ITransaction transaction = session1.BeginTransaction())
{
session1.Save(book);
transaction.Commit();
}
}
private Canto LlenaClase()
{
Canto canto = new Canto();
canto.CantoId = Convert.ToInt32(CantoNumericUpDown.Value);
canto.Nombre = NombreTextBox.Text;
canto.Versiculo = VersiculoTextBox.Text;
canto.pagina = Convert.ToInt32(PaginaNumericUpDown.Value);
canto.Color = ColorComboBox.Text;
canto.Momento = MomentoComboBox.Text;
canto.Tiempo = TiempoComboBox.Text;
return(canto);
}
private Canto Vaciar()
{
Canto canto = new Canto();
CantoNumericUpDown.Value = 0;
NombreTextBox.Clear();
VersiculoTextBox.Clear();
PaginaNumericUpDown.Value = 0;
ColorComboBox.SelectedIndex = -1;
MomentoComboBox.SelectedIndex = -1;
TiempoComboBox.SelectedIndex = -1;
return(canto);
}
public static Canto Buscar(int id)
{
Canto canto = new Canto();
Contexto contexto = new Contexto();
try
{
canto = contexto.cantos.Find(id);
contexto.Dispose();
}
catch (Exception)
{
throw;
}
return(canto);
}
public void createCanto_byDefault_shouldCreate()
{
Canto f = new Canto
{
};
using (ISession session = sqliteSessionFactory.Session)
{
using (ITransaction transaction = session.BeginTransaction())
{
Assert.That(f.Id == 0);
session.SaveOrUpdate(f);
transaction.Commit();
Assert.That(f.Id > 0);
}
}
}
public static bool Guardar(Canto canto)
{
bool guardado = false;
Contexto contexto = new Contexto();
try
{
if (contexto.cantos.Add(canto) != null)
{
contexto.SaveChanges();
guardado = true;
}
contexto.Dispose();
}
catch (Exception)
{
throw;
}
return(guardado);
}
public static bool Modificar(Canto canto)
{
bool modificado = false;
Contexto contexto = new Contexto();
try
{
contexto.Entry(canto).State = EntityState.Modified;
if (contexto.SaveChanges() > 0)
{
modificado = true;
}
contexto.Dispose();
}
catch (Exception)
{
throw;
}
return(modificado);
}
public void createNote_fromTheFirst3LinesOfInferno()
{
Line line1 = new Line
{
Number = 1,
Text = "Halfway along our journey to life's end"
};
Line line2 = new Line
{
Number = 2,
Text = "I found myself astray in a dark wood,"
};
Line line3 = new Line
{
Number = 3,
Text = "Since the rightway was no where to be found."
};
Line line4 = new Line
{
Number = 4,
Text = "How hard a thing it is to express the horr"
};
Line line5 = new Line
{
Number = 5,
Text = "of that wild wood, so difficult, so dense"
};
Line line6 = new Line
{
Number = 6,
Text = "Even to think of it renews my terror."
};
Canto canto1 = new Canto
{
Number = 1
};
canto1.AddLine(line1);
canto1.AddLine(line2);
canto1.AddLine(line3);
canto1.AddLine(line4);
canto1.AddLine(line5);
canto1.AddLine(line6);
Book inferno = new Book
{
Number = 1,
Name = "Inferno"
};
inferno.AddCanto(canto1);
Note note = new Note
{
Commentary = "Life span is 70 years, at the midpoint is 1300 CE, Dante was 35 years old."
};
note.Loc = new Loc
{
Book = "Inferno",
Canto = 1,
Start = 1
};
using (ISession session = sqliteSessionFactory.Session)
{
using (ITransaction transaction = session.BeginTransaction())
{
Assert.That(note.Id == 0);
session.SaveOrUpdate(inferno);
session.SaveOrUpdate(note);
transaction.Commit();
Assert.That(note.Id > 0);
}
using (session.BeginTransaction())
{
var resnotes = session.CreateCriteria(typeof(Note)).List <Note>();
var resnote = resnotes[0];
var resCanto = session.CreateCriteria(typeof(Canto))
.CreateCriteria("Book")
.Add(Restrictions.Eq("Id", 1))
.List <Canto>();
var resCanto2 = session.CreateCriteria(typeof(Canto))
.CreateCriteria("Book")
.Add(Restrictions.InsensitiveLike("Name", "Inferno"))
.List <Canto>();
var search = session.CreateCriteria(typeof(Line))
.Add(Restrictions.Eq("Number", 2))
.CreateCriteria("Canto")
.CreateCriteria("Book")
.Add(Restrictions.InsensitiveLike("Name", "Inferno"))
.Add(Restrictions.Eq("Number", 1))
.List <Line>();
Assert.That(search[0].Text.Contains("wood") == true);
}
}
}
public void init()
{
sqliteSessionFactory = new InMemorySqLiteSessionFactory();
Line line1 = new Line
{
Number = 1,
Text = "Halfway along our journey to life's end"
};
Line line2 = new Line
{
Number = 2,
Text = "I found myself astray in a dark wood,"
};
Line line3 = new Line
{
Number = 3,
Text = "Since the rightway was no where to be found."
};
Line line4 = new Line
{
Number = 4,
Text = "How hard a thing it is to express the horr"
};
Line line5 = new Line
{
Number = 5,
Text = "of that wild wood, so difficult, so dense"
};
Line line6 = new Line
{
Number = 6,
Text = "Even to think of it renews my terror."
};
Canto canto1 = new Canto
{
Number = 1
};
canto1.AddLine(line1);
canto1.AddLine(line2);
canto1.AddLine(line3);
canto1.AddLine(line4);
canto1.AddLine(line5);
canto1.AddLine(line6);
Book inferno = new Book
{
Number = 1,
Name = "Inferno"
};
inferno.AddCanto(canto1);
Note note = new Note
{
Loc = new Loc
{
Book = "Inferno",
Canto = 1,
Start = 2,
End = 2
}
};
Term wildness = new Term
{
Name = "wood",
Alias = "forest,wildness"
};
wildness.AddNote(note);
wildness.SetMetaphorItem("metaphor", "");
session = sqliteSessionFactory.Session;
{
using (ITransaction transaction = session.BeginTransaction())
{
Assert.That(note.Id == 0);
session.SaveOrUpdate(inferno);
session.SaveOrUpdate(note);
session.SaveOrUpdate(wildness);
transaction.Commit();
}
}
}
