public void load(FieldsVo field, int mainId, string filtro)
{
List <FieldsVo> fields = new List <FieldsVo>();
fields.Add(field);
load(fields, mainId, null);
}
public int save(FieldsVo field)
{
if (field.ID == 0)
{
return(insert(field));
}
else
{
return(update(field));
}
}
public int update(FieldsVo field)
{
this.QUERY = new StringBuilder(fromDatabase);
this.QUERY.AppendLine("UPDATE fields");
this.QUERY.AppendLine(" SET mainId = " + field.MAINID);
this.QUERY.AppendLine(" , codigo = '" + field.CODIGO + "'");
this.QUERY.AppendLine(" , grouping = '" + field.GROUPING + "'");
this.QUERY.AppendLine(" WHERE id = " + field.ID);
return(getData().DefaultView.Count);
}
public int insert(FieldsVo field)
{
this.QUERY = new StringBuilder(fromDatabase);
this.QUERY.Append("INSERT INTO fields");
this.QUERY.AppendLine("(mainId, codigo, grouping)");
this.QUERY.Append("VALUES(");
this.QUERY.Append("" + field.MAINID + " ,");
this.QUERY.Append("'" + field.CODIGO + "',");
this.QUERY.Append("'" + field.GROUPING + "'");
this.QUERY.AppendLine(")");
return(getData().DefaultView.Count);
}
public void load(List <FieldsVo> fields, int mainId, string filtro)
{
DataTable table = select(mainId, filtro, false);
for (int i = 0; i < table.DefaultView.Count; i++)
{
FieldsVo field = new FieldsVo();
field.MAINID = mainId;
field.ID = (int )table.DefaultView[i]["id"];
field.CODIGO = (string)table.DefaultView[i]["codigo"];
field.GROUPING = (string)table.DefaultView[i]["grouping"];
fields.Add(field);
}
}
public int delete(FieldsVo field)
{
return(delete(field.MAINID, "id = " + field.ID));
}
// load unico
public void load(FieldsVo field, int mainId)
{
load(field, mainId, null);
}