public int Guardar() { int intEstado = (Estado) ? 1 : 0; if (Id != 0) { if (!ClsBaseDatos.BDBool("Update ReqInfo Set Nombre = '" + Nombre + "', Version = " + ClsFunciones.DoubleToString(Version) + ", Fecha = '" + ClsFunciones.FechaMySQL(Fecha) + "', Descripcion = '" + Descripcion + "', TiemMed = " + TiempoMedio + ", TiemMax = " + TiempoMaximo + ", OcuMed = " + OcurreMedio + ", OcuMax = " + OcurreMaximo + ", Prioridad = " + Prioridad + ", Urgencia = " + Urgencia + ", Estabilidad = " + Estabilidad + ", Estado = " + intEstado + ", Categoria = " + Categoria + ", Comentario = '" + Comentario + "' where Id = " + Id + ";")) { return(-1); } ClsBaseDatos.BDBool("Delete from ReqIAuto where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIFuen where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIObj where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIReqR where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIDatEsp where IdReq = " + Id + ";"); if (GuardarTablas(Id) == -1) { return(-1); } } else { if (!ClsBaseDatos.BDBool("Insert into ReqInfo(Nombre,Version,Fecha,Descripcion,TiemMed,TiemMax,OcuMed,OcuMax,Prioridad,Urgencia,Estabilidad,Estado,Categoria,Comentario) values ('" + Nombre + "'," + ClsFunciones.DoubleToString(Version) + ",'" + ClsFunciones.FechaMySQL(Fecha) + "','" + Descripcion + "'," + TiempoMedio + "," + TiempoMaximo + "," + OcurreMedio + "," + OcurreMaximo + "," + Prioridad + "," + Urgencia + "," + Estabilidad + "," + intEstado + "," + Categoria + ",'" + Comentario + "');")) { return(-2); } if (GuardarTablas((int)ClsBaseDatos.BDDouble("Select Id from ReqInfo order by Id Desc;")) == -1) { return(-2); } } return(0); }
public void Cargar(int id) { DataRow Requisito = ClsBaseDatos.BDTable("Select * from ReqNFunc where Id = " + id + ";").Rows[0]; Id = int.Parse(Requisito[0].ToString()); Nombre = Requisito[1].ToString(); Version = (double)Requisito[2]; Fecha = (DateTime)Requisito[3]; Descripcion = Requisito[4].ToString(); Prioridad = int.Parse(Requisito[5].ToString()); Urgencia = int.Parse(Requisito[6].ToString()); Estabilidad = int.Parse(Requisito[7].ToString()); Estado = ((int)Requisito[8] == 1) ? true : false; Categoria = int.Parse(Requisito[9].ToString()); Comentario = Requisito[10].ToString(); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqNAuto r where g.Id = r.IdAutor and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqNFuen r where g.Id = r.IdFuen and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ReqNObj r where o.Id = r.IdObj and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Requisitos = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); Requisitos.Rows.Clear(); DataTable TablaAux; TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqInfo rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqNFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqFun rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos where Id not IN (select idObj from ReqNObj where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ReqNAuto where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ReqNFuen where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); }
public void CargarTablas() { BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ActAuto aa where g.Id = aa.IdAutor and aa.IdAct = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ActFuen af where g.Id = af.IdFuen and af.IdAct = " + Id + " Order By Categoria Desc, Nombre;"); }
public int Guardar() { int intEstado = (Estado) ? 1 : 0; if (Id != 0) { if (!ClsBaseDatos.BDBool("Update Objetivos Set Nombre = '" + Nombre + "', Version = " + ClsFunciones.DoubleToString(Version) + ", Fecha = '" + ClsFunciones.FechaMySQL(Fecha) + "', Descripcion = '" + Descripcion + "', Prioridad = " + Prioridad + ", Urgencia = " + Urgencia + ", Estabilidad = " + Estabilidad + ", Estado = " + intEstado + ", Categoria = " + Categoria + ", Comentario = '" + Comentario + "' where Id = " + Id + ";")) { return(-1); } ClsBaseDatos.BDBool("Delete from ObjAuto where IdObj = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ObjFuen where IdObj = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ObjSubobj where IdObj = " + Id + ";"); if (GuardarTablas(Id) == -1) { return(-1); } } else { if (!ClsBaseDatos.BDBool("Insert into Objetivos(Nombre,Version,Fecha,Descripcion,Prioridad,Urgencia,Estabilidad,Estado,Categoria,Comentario) values ('" + Nombre + "'," + ClsFunciones.DoubleToString(Version) + ",'" + ClsFunciones.FechaMySQL(Fecha) + "','" + Descripcion + "'," + Prioridad + "," + Urgencia + "," + Estabilidad + "," + intEstado + "," + Categoria + ",'" + Comentario + "');")) { return(-2); } if (GuardarTablas((int)ClsBaseDatos.BDDouble("Select Id from Objetivos order by Id Desc;")) == -1) { return(-2); } } return(0); }
//Métodos Privados private int GuardarTablas(int id) { DataRow Fila; for (int i = 0; i <= (Autores.Rows.Count - 1); i++) { Fila = Autores.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ActAuto(IdAutor, IdAct) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ActAuto where IdAct = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqAct where IdAct = " + id + ";"); ClsBaseDatos.BDBool("Delete from Actores where Id = " + id + ";"); return(-1); } } for (int i = 0; i <= (Fuentes.Rows.Count - 1); i++) { Fila = Fuentes.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ActFuen(IdFuen, IdAct) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ActFuen where IdAct = " + id + ";"); ClsBaseDatos.BDBool("Delete from ActAuto where IdAct = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqAct where IdAct = " + id + ";"); ClsBaseDatos.BDBool("Delete from Actores where Id = " + id + ";"); return(-1); } } return(0); }
public int Guardar() { if (Id != 0) { if (!ClsBaseDatos.BDBool("Update Actores Set Nombre = '" + Nombre + "', Version = " + ClsFunciones.DoubleToString(Version) + ", Fecha = '" + ClsFunciones.FechaMySQL(Fecha) + "', Descripcion = '" + Descripcion + "', Complejidad = " + Complejidad + ", DescComple = '" + DescComplejidad + "', Categoria = " + Categoria + ", Comentario = '" + Comentario + "' where Id = " + Id + ";")) { return(-1); } ClsBaseDatos.BDBool("Delete from ActAuto where IdAct = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ActFuen where IdAct = " + Id + ";"); if (GuardarTablas(Id) == -1) { return(-1); } } else { if (!ClsBaseDatos.BDBool("Insert into Actores(Nombre,Version,Fecha,Descripcion,Complejidad,DescComple,Categoria,Comentario) values ('" + Nombre + "'," + ClsFunciones.DoubleToString(Version) + ",'" + ClsFunciones.FechaMySQL(Fecha) + "','" + Descripcion + "'," + Complejidad + ",'" + DescComplejidad + "'," + Categoria + ",'" + Comentario + "');")) { return(-2); } if (GuardarTablas((int)ClsBaseDatos.BDDouble("Select Id from Actores order by Id Desc;")) == -1) { return(-2); } } return(0); }
//Métodos Privados private int GuardarTablas(int id) { DataRow Fila; for (int i = 0; i <= (Autores.Rows.Count - 1); i++) { Fila = Autores.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ReqNAuto(IdAutor, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ReqNAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFunc where Id = " + id + ";"); return(-1); } } for (int i = 0; i <= (Fuentes.Rows.Count - 1); i++) { Fila = Fuentes.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ReqNFuen(IdFuen, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ReqNFuen where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFunc where Id = " + id + ";"); return(-1); } } for (int i = 0; i <= (Objetivos.Rows.Count - 1); i++) { Fila = Objetivos.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ReqNObj(IdObj, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ReqNObj where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFuen where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFunc where Id = " + id + ";"); return(-1); } } for (int i = 0; i <= (Requisitos.Rows.Count - 1); i++) { Fila = Requisitos.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ReqNReqR(IdReqr, TipoReq, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + int.Parse(Fila[1].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ReqNReqR where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNObj where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFuen where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFunc where Id = " + id + ";"); return(-1); } } return(0); }
public int Guardar() { int intEstado = (Estado) ? 1 : 0, intPaquete = (int)ClsBaseDatos.BDDouble("Select Id from Paquetes where Nombre = '" + Paquete + "';"); if (Id != 0) { if (!ClsBaseDatos.BDBool("Update ReqFun Set Nombre = '" + Nombre + "',Version = " + ClsFunciones.DoubleToString(Version) + ", Fecha = '" + ClsFunciones.FechaMySQL(Fecha) + "', Descripcion = '" + Descripcion + "', Paquete = " + intPaquete + ", PreCond = '" + Precondicion + "', PostCond = '" + Postcondicion + "', Complejidad = " + Complejidad + ", Prioridad = " + Prioridad + ", Urgencia = " + Urgencia + ", Estabilidad = " + Estabilidad + ", Estado = " + intEstado + ", Categoria = " + Categoria + ", Comentario = '" + Comentario + "' where Id = " + Id + ";")) { return(-1); } ClsBaseDatos.BDBool("Delete from ReqAct where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqAuto where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqFuen where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqObj where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqSecNor where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqSecExc where IdReq = " + Id + ";"); if (GuardarTablas(Id) == -1) { return(-1); } } else { if (!ClsBaseDatos.BDBool("Insert into ReqFun(Nombre,Version,Fecha,Descripcion,Paquete,Precond,Postcond,Complejidad,Prioridad,Urgencia,Estabilidad,Estado,Categoria,Comentario) values ('" + Nombre + "'," + ClsFunciones.DoubleToString(Version) + ",'" + ClsFunciones.FechaMySQL(Fecha) + "','" + Descripcion + "'," + intPaquete + ",'" + Precondicion + "','" + Postcondicion + "'," + Complejidad + "," + Prioridad + "," + Urgencia + "," + Estabilidad + "," + intEstado + "," + Categoria + ",'" + Comentario + "');")) { return(-2); } if (GuardarTablas((int)ClsBaseDatos.BDDouble("Select Id from ReqFun order by Id Desc;")) == -1) { return(-2); } } return(0); }
public static bool Iniciar() { if (LeerConf() == -1) { MessageBox.Show(MenErrFic); return(false); } else { if (!Idioma.Equals(DefValues.Español) && !Idioma.Equals(DefValues.Ingles)) { MessageBox.Show(MenErrIdi); return(false); } else { if (!TipoBD.Equals(DefValues.MySql) && !TipoBD.Equals(DefValues.Access)) { MessageBox.Show(MenErrBD); return(false); } else { if (TipoBD.Equals(DefValues.MySql)) { ConexionMySql(); } if (!ClsBaseDatos.BDConexion()) { MessageBox.Show(MenErrConBD); return(false); } return(true); } } } }
public void Cargar(int id) { DataRow Requisito = ClsBaseDatos.BDTable("Select * from ReqFun where Id = " + id + ";").Rows[0]; Id = int.Parse(Requisito[0].ToString()); Nombre = Requisito[1].ToString(); Version = (double)Requisito[2]; Fecha = (DateTime)Requisito[3]; Descripcion = Requisito[4].ToString(); Paquete = ClsBaseDatos.BDString("Select Nombre from Paquetes where Id = " + Requisito[5].ToString() + ";"); Precondicion = Requisito[6].ToString(); Postcondicion = Requisito[7].ToString(); Complejidad = int.Parse(Requisito[8].ToString()); Prioridad = int.Parse(Requisito[9].ToString()); Urgencia = int.Parse(Requisito[10].ToString()); Estabilidad = int.Parse(Requisito[11].ToString()); Estado = ((int)Requisito[12] == 1) ? true : false; Categoria = int.Parse(Requisito[13].ToString()); Comentario = Requisito[14].ToString(); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqAuto r where g.Id = r.IdAutor and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqFuen r where g.Id = r.IdFuen and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ReqObj r where o.Id = r.IdObj and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Actores = ClsBaseDatos.BDTable("Select a.Id as Id, a.Nombre as Nombre from Actores a, ReqAct r where a.Id = r.IdAct and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Requisitos = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqFun rn, ReqReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); DataTable TablaAux; DataRow Fila; SecNormal.Clear(); SecExcepc.Clear(); TablaAux = ClsBaseDatos.BDTable("Select Descrip from ReqSecNor where IdReq = " + Id + ";"); for (int i = 0; i <= (TablaAux.Rows.Count - 1); i++) { Fila = TablaAux.Rows[i]; SecNormal.Add(new ClsDatDG() { Descrip = Fila[0].ToString() }); } TablaAux = ClsBaseDatos.BDTable("Select Descrip from ReqSecExc where IdReq = " + Id + ";"); for (int i = 0; i <= (TablaAux.Rows.Count - 1); i++) { Fila = TablaAux.Rows[i]; SecExcepc.Add(new ClsDatDG() { Descrip = Fila[0].ToString() }); } Requisitos.Rows.Clear(); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqInfo rn, ReqReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqNFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqFun rn, ReqReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos where Id not IN (select idObj from ReqObj where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ReqAuto where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ReqFuen where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); BActores = ClsBaseDatos.BDTable("Select Id,Nombre from Actores where Id not IN (select IdAct from ReqAct where idReq = " + Id + ") Order By Categoria Desc, Nombre;"); }
public void CargarTablas() { BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos Order By Categoria Desc, Nombre;"); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ObjAuto oa where g.Id = oa.IdAutor and oa.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ObjFuen obf where g.Id = obf.IdFuen and obf.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ObjSubobj os where o.Id = os.IdSubobj and os.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); }
public void Borrar() { if (Id != 0) { ClsBaseDatos.BDBool("UPDATE ReqFun SET Paquete = " + ClsBaseDatos.BDString("Select Id from Paquetes Where Nombre = 'No Asignado';") + " Where Paquete = " + Id + ";"); ClsBaseDatos.BDBool("Delete from Paquetes where Id = " + Id + ";"); IniciarValores(); } }
public void Cargar(int id) { DataRow Paquete = ClsBaseDatos.BDTable("Select * from Paquetes where Id = " + id + ";").Rows[0]; Id = int.Parse(Paquete[0].ToString()); Nombre = Paquete[1].ToString(); Version = (double)Paquete[2]; Fecha = (DateTime)Paquete[3]; Categoria = int.Parse(Paquete[4].ToString()); Comentario = Paquete[5].ToString(); }
public void CargarTablas() { BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo Order By Categoria Desc, Nombre;"); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos Order By Categoria Desc, Nombre;"); BRequisitos = ClsBaseDatos.BDTable("Select Id,Nombre from ReqFun Order By Categoria Desc, Nombre;"); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqNAuto r where g.Id = r.IdAutor and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqNFuen r where g.Id = r.IdFuen and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ReqNObj r where o.Id = r.IdObj and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); Requisitos = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqNReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;"); }
public void Borrar() { if (Id != 0) { ClsBaseDatos.BDBool("Delete from ActAuto where IdAct = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ActFuen where IdAct = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqAct where IdAct = " + Id + ";"); ClsBaseDatos.BDBool("Delete from Actores where Id = " + Id + ";"); IniciarValores(); } }
public void Borrar() { ClsBaseDatos.BDBool("Delete from ReqIAuto where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIFuen where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIObj where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIReqR where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIDatEsp where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqInfo where Id = " + Id + ";"); }
public void Cargar(int id) { DataRow Trabajador = ClsBaseDatos.BDTable("Select * from Grupo where Id = " + id + ";").Rows[0]; Id = int.Parse(Trabajador[0].ToString()); Nombre = Trabajador[1].ToString(); Version = (double)Trabajador[2]; Fecha = (DateTime)Trabajador[3]; Organizacion = Trabajador[4].ToString(); Rol = Trabajador[5].ToString(); Desarrollador = ((int)Trabajador[6] == 1) ? true : false; Categoria = int.Parse(Trabajador[7].ToString()); Comentario = Trabajador[8].ToString(); }
public void Borrar() { if (Id != 0) { ClsBaseDatos.BDBool("Delete from ReqNAuto where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFuen where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqNObj where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqNReqR where IdReq = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqNFun + " and IdReqR = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFunc where Id = " + Id + ";"); IniciarValores(); } }
public void Borrar() { if (Id != 0) { ClsBaseDatos.BDBool("Delete from ObjSubobj where IdObj = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ObjFuen where IdObj = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ObjAuto where IdObj = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIObj where IdObj = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqNObj where IdObj = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqObj where IdObj = " + Id + ";"); ClsBaseDatos.BDBool("Delete from Objetivos where Id = " + Id + ";"); IniciarValores(); } }
public void CargarTablaReqRel(int TipoReq) { if (TipoReq == DefValues.ReqInfo) { BRequisitos = ClsBaseDatos.BDTable("Select Id,Nombre from ReqInfo where Id not IN (select IdReqr from ReqIReqR where idReq = " + Id + " and TipoReq = " + DefValues.ReqInfo + ") and Id <> " + Id + " Order By Categoria Desc, Nombre;"); } else if (TipoReq == DefValues.ReqNFun) { BRequisitos = ClsBaseDatos.BDTable("Select Id,Nombre from ReqNFunc where Id not IN (select IdReqr from ReqIReqR where idReq = " + Id + " and TipoReq = " + DefValues.ReqNFun + ") Order By Categoria Desc, Nombre;"); } else if (TipoReq == DefValues.ReqFun) { BRequisitos = ClsBaseDatos.BDTable("Select Id,Nombre from ReqFun where Id not IN (select IdReqr from ReqIReqR where idReq = " + Id + " and TipoReq = " + DefValues.ReqFun + ") Order By Categoria Desc, Nombre;"); } }
//Métodos Privados private int GuardarTablas(int id) { DataRow Fila; for (int i = 0; i <= (Autores.Rows.Count - 1); i++) { Fila = Autores.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ObjAuto(IdAutor, IdObj) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ObjAuto where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from Objetivos where Id = " + id + ";"); return(-1); } } for (int i = 0; i <= (Fuentes.Rows.Count - 1); i++) { Fila = Fuentes.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ObjFuen(IdFuen, IdObj) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ObjFuen where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ObjAuto where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from Objetivos where Id = " + id + ";"); return(-1); } } for (int i = 0; i <= (Objetivos.Rows.Count - 1); i++) { Fila = Objetivos.Rows[i]; if (!ClsBaseDatos.BDBool("Insert into ObjSubobj(IdSubobj, IdObj) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");")) { ClsBaseDatos.BDBool("Delete from ObjSubobj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ObjFuen where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ObjAuto where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqObj where IdObj = " + id + ";"); ClsBaseDatos.BDBool("Delete from Objetivos where Id = " + id + ";"); return(-1); } } return(0); }
public int Guardar() { if (Id != 0) { if (!ClsBaseDatos.BDBool("Update Paquetes Set Nombre = '" + Nombre + "', Version = " + ClsFunciones.DoubleToString(Version) + ", Fecha = '" + ClsFunciones.FechaMySQL(Fecha) + "', Categoria = " + Categoria + ", Comentario = '" + Comentario + "' where Id = " + Id + ";")) { return(-1); } } else if (!ClsBaseDatos.BDBool("Insert into Paquetes(Nombre,Version,Fecha,Categoria,Comentario) values ('" + Nombre + "'," + ClsFunciones.DoubleToString(Version) + ",'" + ClsFunciones.FechaMySQL(Fecha) + "'," + Categoria + ",'" + Comentario + "');")) { return(-2); } return(0); }
public void Borrar() { if (Id != 0) { ClsBaseDatos.BDBool("Delete from ObjAuto where IdAutor = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ObjFuen where IdFuen = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ActAuto where IdAutor = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ActFuen where IdFuen = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqAuto where IdAutor = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqFuen where IdFuen = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIAuto where IdAutor = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqIFuen where IdFuen = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqNAuto where IdAutor = " + Id + ";"); ClsBaseDatos.BDBool("Delete from ReqNFuen where IdFuen = " + Id + ";"); ClsBaseDatos.BDBool("Delete from Grupo where Id = " + Id + ";"); IniciarValores(); } }
public int Guardar() { int intDesarrollador = (Desarrollador) ? 1 : 0; if (Id != 0) { if (!ClsBaseDatos.BDBool("Update Grupo Set Nombre = '" + Nombre + "', Version = " + ClsFunciones.DoubleToString(Version) + ", Fecha = '" + ClsFunciones.FechaMySQL(Fecha) + "', Organizacion = '" + Organizacion + "', Rol = '" + Rol + "', Desarrollador = " + intDesarrollador + ", Categoria = " + Categoria + ", Comentario = '" + Comentario + "' where Id = " + Id + ";")) { return(-1); } } else if (!ClsBaseDatos.BDBool("Insert into Grupo(Nombre,Version,Fecha,Organizacion,Rol,Desarrollador,Categoria,Comentario) values ('" + Nombre + "'," + ClsFunciones.DoubleToString(Version) + ",'" + ClsFunciones.FechaMySQL(Fecha) + "','" + Organizacion + "','" + Rol + "'," + intDesarrollador + "," + Categoria + ",'" + Comentario + "');")) { return(-2); } return(0); }
public void Cargar(int id) { DataRow Actor = ClsBaseDatos.BDTable("Select * from Actores where Id = " + id + ";").Rows[0]; Id = int.Parse(Actor[0].ToString()); Nombre = Actor[1].ToString(); Version = (double)Actor[2]; Fecha = (DateTime)Actor[3]; Descripcion = Actor[4].ToString(); Complejidad = int.Parse(Actor[5].ToString()); DescComplejidad = Actor[6].ToString(); Categoria = int.Parse(Actor[7].ToString()); Comentario = Actor[8].ToString(); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ActAuto aa where g.Id = aa.IdAutor and aa.IdAct = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ActFuen af where g.Id = af.IdFuen and af.IdAct = " + Id + " Order By Categoria Desc, Nombre;"); BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ActAuto where idAct = " + Id + ") Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ActFuen where idAct = " + Id + ") Order By Categoria Desc, Nombre;"); }
public void CargarValores() { //TCF DSR = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'DSR'")); RTII = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'RTII'")); EUE = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'EUE'")); CIPR = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'CIPR'")); RCMBAF = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'RCMBAF'")); IE = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'IE'")); U = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'U'")); CPS = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'CPS'")); ETC = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'ETC'")); HC = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'HC'")); CS = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'CS'")); DOTPC = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'DOTPC'")); UT = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'UT'")); //EF FWTP = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'FWTP'")); AE = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'AE'")); OOPE = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'OOPE'")); LAC = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'LAC'")); M = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'M'")); SR = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'SR'")); PTS = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'PTS'")); DPL = Convert.ToInt32(ClsBaseDatos.BDDouble("Select ValEst From Estim where NomEst = 'DPL'")); //UUCP UUCPSim = Convert.ToInt32(ClsBaseDatos.BDDouble("Select Count(*) From ReqFun where Complejidad = 1")); //Simple UUCPMed = Convert.ToInt32(ClsBaseDatos.BDDouble("Select Count(*) From ReqFun where Complejidad = 2")); //Media UUCPMax = Convert.ToInt32(ClsBaseDatos.BDDouble("Select Count(*) From ReqFun where Complejidad = 3")); //Alta //AW AWSim = Convert.ToInt32(ClsBaseDatos.BDDouble("Select Count(*) From Actores where Complejidad = 1")); //Simple AWMed = Convert.ToInt32(ClsBaseDatos.BDDouble("Select Count(*) From Actores where Complejidad = 2")); //Media AWMax = Convert.ToInt32(ClsBaseDatos.BDDouble("Select Count(*) From Actores where Complejidad = 3")); //Alta }
public void Cargar(int id) { DataRow Objetivo = ClsBaseDatos.BDTable("Select * from Objetivos where Id = " + id + ";").Rows[0]; Id = int.Parse(Objetivo[0].ToString()); Nombre = Objetivo[1].ToString(); Version = (double)Objetivo[2]; Fecha = (DateTime)Objetivo[3]; Descripcion = Objetivo[4].ToString(); Prioridad = int.Parse(Objetivo[5].ToString()); Urgencia = int.Parse(Objetivo[6].ToString()); Estabilidad = int.Parse(Objetivo[7].ToString()); Estado = ((int)Objetivo[8] == 1) ? true : false; Categoria = int.Parse(Objetivo[9].ToString()); Comentario = Objetivo[10].ToString(); Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ObjAuto oa where g.Id = oa.IdAutor and oa.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ObjFuen obf where g.Id = obf.IdFuen and obf.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ObjSubobj os where o.Id = os.IdSubObj and os.IdObj = " + Id + " Order By Categoria Desc, Nombre;"); BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ObjAuto where idObj = " + Id + ") Order By Categoria Desc, Nombre;"); BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ObjFuen where idObj = " + Id + ") Order By Categoria Desc, Nombre;"); BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos where Id not IN (select idSubobj from ObjSubobj where idObj = " + Id + ") and Id <> " + Id + " Order By Categoria Desc, Nombre;"); }
public int ComprobarExistencia(string valor) { int id = (int)ClsBaseDatos.BDDouble("Select Id from Grupo where Nombre = '" + valor + "';"); return((id != -1) ? id : -1); }
public void Buscar(string valor) { Buscador = ClsBaseDatos.BDTable("Select Nombre,Id from Grupo where Nombre LIKE '%" + valor + "%' Order By Categoria Desc, Nombre;"); }
//Métodos Privados private int GuardarTablas(int id) { DataRow Fila; for (int i = 0; i <= (Autores.Rows.Count - 1); i++) { Fila = Autores.Rows[i]; if (ClsBaseDatos.BDBool("Insert into ReqIAuto(IdAutor, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");") == false) { ClsBaseDatos.BDBool("Delete from ReqIAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqInfo where Id = " + id + ";"); return(-1); } } for (int i = 0; i <= (Fuentes.Rows.Count - 1); i++) { Fila = Fuentes.Rows[i]; if (ClsBaseDatos.BDBool("Insert into ReqIFuen(IdFuen, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");") == false) { ClsBaseDatos.BDBool("Delete from ReqIFuen where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqInfo where Id = " + id + ";"); return(-1); } } for (int i = 0; (i <= Objetivos.Rows.Count - 1); i++) { Fila = Objetivos.Rows[i]; if (ClsBaseDatos.BDBool("Insert into ReqIObj(IdObj, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");") == false) { ClsBaseDatos.BDBool("Delete from ReqIObj where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIFuen where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqInfo where Id = " + id + ";"); return(-1); } } for (int i = 0; (i <= Requisitos.Rows.Count - 1); i++) { Fila = Requisitos.Rows[i]; if (ClsBaseDatos.BDBool("Insert into ReqIReqR(IdReqR, TipoReq, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + int.Parse(Fila[1].ToString()) + "," + id + ");") == false) { ClsBaseDatos.BDBool("Delete from ReqIReqR where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIObj where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIFuen where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqInfo where Id = " + id + ";"); return(-1); } } foreach (ClsDatDG Dato in DatosEspeci) { if (ClsBaseDatos.BDBool("Insert into ReqIDatEsp(IdReq, Descrip) values (" + id + ",'" + Dato.Descrip + "');") == false) { ClsBaseDatos.BDBool("Delete from ReqIReqR where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIReqR where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIObj where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIFuen where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqIAuto where IdReq = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqReqR where TipoReq = " + DefValues.ReqInfo + " and IdReqR = " + id + ";"); ClsBaseDatos.BDBool("Delete from ReqInfo where Id = " + id + ";"); return(-1); } } return(0); }