public void Excluir(Relator relator)
{
var strQuery = string.Format("DELETE FROM tblrelator WHERE idrelator={0}", relator.RelatorId);
using (cnx = new ConexaoBD())
cnx.CommNom(strQuery);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,NombreCompleto,Edad,AnosExperiencia,NumeroTelefono,Especialidad,CursoId")] Relator relator)
{
if (id != relator.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(relator);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RelatorExists(relator.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CursoId"] = new SelectList(_context.Cursos, "Id", "Nombre", relator.CursoId);
return(View(relator));
}
public void Salvar(Relator relator)
{
if (relator.RelatorId > 0)
{
Alterar(relator);
}
else
{
Inserir(relator);
}
}
public SearchItem_Between_Dto(Relator.Unary unary, Track.Property property, string phrase1, string phrase2)
: base(unary, property, phrase1, phrase2)
{
Check.Require(
property == Track.Property.Bpm || property == Track.Property.Year || property == Track.Property.Laenge, String.Format(
"Argument must be of type {0}, {1}, {2}. It's of type {3}",
Track.Property.Bpm.ToString(),
Track.Property.Laenge.ToString(),
Track.Property.Year.ToString(),
property.ToString()));
}
public ASimpleRelation(Relator.Unary relator, params string[] propertyQueue)
: base(relator)
{
Check.Require(propertyQueue != null, "Null argument.");
/*
* Kein Mensch wird diese Einschraenkung verstehen...
*/
Check.Require(propertyQueue.Length > 1, "Collection lenght.");
this.propertyQueue = propertyQueue;
this.relata.Add(this);
}
private void Alterar(Relator relator)
{
var strQuery = "";
strQuery += "UPDATE tblrelator SET ";
strQuery += string.Format("nome='{0}', matricula='{1}', nomeguerra='{2}', consaud='{3}', lotacao='{4}', status={3} ",
relator.Nome, relator.Matricula, relator.NomeGuerra, relator.ConsAud, relator.Lotacao, relator.Status.ToString());
strQuery += "WHERE idrelator=" + relator.RelatorId.ToString();
using (cnx = new ConexaoBD())
cnx.CommNom(strQuery);
}
public async Task <IActionResult> Create([Bind("Id,NombreCompleto,Edad,AnosExperiencia,NumeroTelefono,Especialidad,CursoId")] Relator relator)
{
if (ModelState.IsValid)
{
_context.Add(relator);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CursoId"] = new SelectList(_context.Cursos, "Id", "Nombre", relator.CursoId);
return(View(relator));
}
/// @todo Naming.
public static ComplexRelation combine(Relator.Binary binaryRelator, ASimpleRelation s1, ASimpleRelation s2)
{
Check.Require(s1 != null && s2 != null, "No null arguments!");
ComplexRelation s1_s2;
if(binaryRelator == Relator.Binary.AND)
s1_s2 = new ComplexRelation();
else
s1_s2 = new ComplexRelation(Relator.Binary.OR);
s1_s2.addRelata(s1, s2);
return s1_s2;
}
private void Inserir(Relator relator)
{
var strQuery = "";
int id;
var lid = new List <Relator>();
lid = ListAll();
id = lid[lid.Count - 1].RelatorId + 1;
strQuery += "INSERT INTO tblrelator(idrelator, nome, matricula, nomeguerra, consaud, lotacao, status) ";
strQuery += string.Format("VALUES ({0}, '{1}', '{2}', '{3}', '{4}', '{5}', {6})", id,
relator.Nome, relator.Matricula, relator.NomeGuerra, relator.ConsAud, relator.Lotacao,
relator.Status.ToString());
using (cnx = new ConexaoBD())
cnx.CommNom(strQuery);
}
public static ASimpleRelation getSimpleRelation(Relator.Unary unaryProperty, string searchPhrase, Track.Property trackProperty )
{
string mappedTrackPropertyPropertyAsString = Track.getChildPropertyAsString(trackProperty);
if( trackProperty == Track.Property.Bpm || trackProperty == Track.Property.Year)
return new IntSearch(
unaryProperty,
int.Parse(searchPhrase),
trackProperty.ToString(),
mappedTrackPropertyPropertyAsString );
else
return new StringSearch(
unaryProperty,
searchPhrase,
trackProperty.ToString(),
mappedTrackPropertyPropertyAsString );
}
private Relator One(DataTable dt, int pos)
{
if (dt.Rows.Count > 0)
{
var registro = new Relator()
{
RelatorId = int.Parse(dt.Rows[pos]["idrelator"].ToString()),
Nome = dt.Rows[pos]["nome"].ToString(),
Matricula = dt.Rows[pos]["matricula"].ToString(),
NomeGuerra = dt.Rows[pos]["nomeguerra"].ToString(),
ConsAud = dt.Rows[pos]["consaud"].ToString(),
Lotacao = dt.Rows[pos]["lotacao"].ToString(),
Status = int.Parse(dt.Rows[pos]["status"].ToString())
};
return(registro);
}
else
{
return(new Relator());
}
}
public ARelation( Relator.Binary relator ) : this() {
this.binaryRelator = relator;
}
public ARelation( Relator.Unary relator ) : this() {
this.unaryRelator = relator;
}
public SearchItem_Like_Dto(Relator.Unary unary, Track.Property property, string searchPhrase)
: base(unary, property, searchPhrase)
{
}
public void setRelator(Relator relator)
{
this.relator = relator;
}
public ComplexRelation( Relator.Binary relator, params ARelation[] relata )
: base(relator)
{
this.addRelata( relata );
}
public void Add(Class element)
{
Elements.Add(element.ClassName, element);
Relator.Add(element.ClassName, RelatorId++);
}
public void setRelator(Relator relator)
{
this.relator = relator;
}
public static ASimpleRelation getSimpleRelation(Relator.Unary unaryProperty, Ending.Attribute attribute )
{
return new EndingAttributeSearch( unaryProperty, attribute, "dummy1", "dummy2");
}
public ASearchItemDto(Relator.Unary unary, Track.Property property, params string[] searchPhrase)
{
this.unaryRelator = unary;
this.trackProperty = property;
this.searchPhrase = searchPhrase;
}
public ComplexRelation( Relator.Binary relator )
: base(relator)
{
}
