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);
}
