private StringBuilder Add() { var get = new StringBuilder(); get.Append($" public void Insert({NomeTabela.ToFirstCharToUpper()}Model entidade){N}"); get.Append($" {{{N}"); get.Append( $" var sql = $\"INSERT INTO {NomeTabela} ({string.Join(",", ListaAtributosTabela.Select(q => q.FIELD_NAME))}) VALUES\"{N}"); get.Append(AddParams()); get.Append($" ExecuteNonResult(sql); {N}"); get.Append($" }}{N}"); return(get); }
private StringBuilder Update() { var get = new StringBuilder(); get.Append($" public void Update({NomeTabela.ToFirstCharToUpper()}Model entidade){N}"); get.Append($" {{{N}"); get.Append($" var sql = $\"UPDATE {NomeTabela} SET \" {N}"); get.Append(UpdateParams()); get.Append( $" +$\"WHERE {ListaAtributosTabela.First().FIELD_NAME} = {{ entidade.{ListaAtributosTabela.First().FIELD_NAME}}}\"; {N}"); get.Append($" ExecuteNonResult(sql); {N}"); get.Append($" }}{N}"); return(get); }
public string GerarBody() { var atributos = new SQLTables().ListarAtributos(NomeTabela); var classe = new StringBuilder(); classe.Append($"package model;{N}{N}"); classe.Append(Imports()); classe.Append("@XmlRootElement" + N); classe.Append($"public class {NomeTabela.ToFirstCharToUpper()} {{{N}"); classe.Append(AtributosHeader(atributos)); classe.Append(AtributosBody(atributos)); classe.Append("}" + Environment.NewLine); return(classe.ToString()); }
public StringBuilder GerarClasse() { var classe = new StringBuilder(); classe.Append(Imports()); classe.Append($"namespace meuprojeto{N}{{{N}"); classe.Append($" public class {NomeTabela.ToFirstCharToUpper()}Dao : FirebirdRepository {{ {N}{N}"); classe.Append(GetById()); classe.Append(N); classe.Append(GetAll()); classe.Append(N); classe.Append(Add()); classe.Append(N); classe.Append(Update()); classe.Append(N); classe.Append(Delete()); classe.Append($" }}{N}"); classe.Append($"}}"); return(classe); }
public string GerarBody() { var classe = new StringBuilder(); classe.Append("namespace Model" + N); classe.Append("{" + N); classe.Append($" public class {NomeTabela.ToFirstCharToUpper()}" + N); classe.Append(" {" + N + N); foreach (var item in ListaAtributosTabela) { classe.Append($" public string {item.COLUMN_NAME} {{ get; set; }}" + N); classe.Append(N); } classe.Append(" }" + N); classe.Append("}" + N); return(GerarUsing() + classe.ToString()); }