//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;
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);
}
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 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);
}
//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);
}
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 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 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()
{
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();
}
}
//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 bool GuardarRTII()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + RTII + " where NomEst = 'RTII';"));
}
public bool GuardarUT()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + UT + " where NomEst = 'UT';"));
}
public bool GuardarDOTPC()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + DOTPC + " where NomEst = 'DOTPC';"));
}
public bool GuardarOOPE()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + OOPE + " where NomEst = 'OOPE';"));
}
public bool GuardarFWTP()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + FWTP + " where NomEst = 'FWTP';"));
}
public bool GuardarLAC()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + LAC + " where NomEst = 'LAC';"));
}
//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);
}
//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 ReqAuto(IdAutor, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");"))
{
ClsBaseDatos.BDBool("Delete from ReqAuto where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFun where Id = " + id + ";");
return(-1);
}
}
for (int i = 0; i <= (Fuentes.Rows.Count - 1); i++)
{
Fila = Fuentes.Rows[i];
if (!ClsBaseDatos.BDBool("Insert into ReqFuen(IdFuen, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");"))
{
ClsBaseDatos.BDBool("Delete from ReqFuen where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqAuto where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFun where Id = " + id + ";");
return(-1);
}
}
for (int i = 0; i <= (Objetivos.Rows.Count - 1); i++)
{
Fila = Objetivos.Rows[i];
if (!ClsBaseDatos.BDBool("Insert into ReqObj(IdObj, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");"))
{
ClsBaseDatos.BDBool("Delete from ReqObj where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFuen where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqAuto where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFun where Id = " + id + ";");
return(-1);
}
}
for (int i = 0; i <= (Requisitos.Rows.Count - 1); i++)
{
Fila = Requisitos.Rows[i];
if (!ClsBaseDatos.BDBool("Insert into ReqReqR(IdReqr, TipoReq, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + int.Parse(Fila[1].ToString()) + "," + id + ");"))
{
ClsBaseDatos.BDBool("Delete from ReqReqR where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqObj where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFuen where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqAuto where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFun where Id = " + id + ";");
return(-1);
}
}
for (int i = 0; i <= (Actores.Rows.Count - 1); i++)
{
Fila = Actores.Rows[i];
if (!ClsBaseDatos.BDBool("Insert into ReqAct(IdAct, IdReq) values (" + int.Parse(Fila[0].ToString()) + "," + id + ");"))
{
ClsBaseDatos.BDBool("Delete from ReqAct where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqReqR where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqObj where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFuen where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqAuto where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFun where Id = " + id + ";");
return(-1);
}
}
foreach (ClsDatDG Dato in SecNormal)
{
if (!ClsBaseDatos.BDBool("Insert into ReqSecNor(IdReq, Descrip) values (" + id + ",'" + Dato.Descrip + "');"))
{
ClsBaseDatos.BDBool("Delete from ReqSecNor where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqAct where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqReqR where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqObj where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFuen where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqAuto where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFun where Id = " + id + ";");
return(-1);
}
}
foreach (ClsDatDG Dato in SecExcepc)
{
if (!ClsBaseDatos.BDBool("Insert into ReqSecExc(IdReq, Descrip) values (" + id + ",'" + Dato.Descrip + "');"))
{
ClsBaseDatos.BDBool("Delete from ReqSecExc where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqSecNor where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqAct where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqReqR where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqObj where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFuen where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqAuto where IdReq = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqNReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqIReqR where TipoReq = " + DefValues.ReqFun + " and IdReqR = " + id + ";");
ClsBaseDatos.BDBool("Delete from ReqFun where Id = " + id + ";");
return(-1);
}
}
return(0);
}
public bool GuardarM()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + M + " where NomEst = 'M';"));
}
public bool GuardarSR()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + SR + " where NomEst = 'SR';"));
}
public bool GuardarPTS()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + PTS + " where NomEst = 'PTS';"));
}
public bool GuardarDPL()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + DPL + " where NomEst = 'DPL';"));
}
public int CrearBase()
{
if (TipoBD.Equals(DefValues.MySql))
{
ConexionMySql();
if (!ClsBaseDatos.BDConexion(BuilderMySql.ToString(), TipoBD))
{
return(-1);
}
if (CreateMySql)
{
ClsBaseDatos.BDBool("CREATE SCHEMA " + BDMySql, BuilderMySql.ToString(), TipoBD);
BuilderMySql.Database = BDMySql;
}
ClsBaseDatos.BDBool("CREATE TABLE `Actores` (`Id` int not null auto_increment, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` text(500) not null, `Complejidad` int not null, `DescComple` varchar(100) not null, `Categoria` int not null, `Comentario` Text(500) not null, primary key(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `Grupo` (`Id` int not null auto_increment, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Organizacion` varchar(100) not null, `Rol` varchar(100) not null, `Desarrollador` int not null, `Categoria` int not null, `Comentario` Text(500) not null, primary key(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `Objetivos` (`Id` int not null auto_increment, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` varchar(100) not null, `Prioridad` int not null, `Urgencia` int not null, `Estabilidad` int not null, `Estado` int not null, `Categoria` int not null, `Comentario` Text(500) not null, primary key(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `Paquetes` (`Id` int not null auto_increment, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Categoria` int not null, `Comentario` Text(500) not null, primary key(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqFun` (`Id` int not null auto_increment, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` varchar(100) not null, `Paquete` int not null, `Precond` varchar(100) not null, `Postcond` varchar(100) not null, `Complejidad` int not null, `Prioridad` int not null, `Urgencia` int not null, `Estabilidad` int not null, `Estado` int not null, `Categoria` int not null, `Comentario` Text(500) not null, primary key(`Id`), foreign key(`Paquete`) references `Paquetes`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqInfo` (`Id` int not null auto_increment, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` varchar(100) not null, `TiemMed` int not null, `TiemMax` int not null, `OcuMed` int not null, `OcuMax` int not null, `Prioridad` int not null, `Urgencia` int not null, `Estabilidad` int not null, `Estado` int not null, `Categoria` int not null, `Comentario` Text(500) not null, primary key(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNFunc` (`Id` int not null auto_increment, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` varchar(100) not null, `Prioridad` int not null, `Urgencia` int not null, `Estabilidad` int not null, `Estado` int not null, `Categoria` int not null, `Comentario` Text(500) not null, primary key(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `Estim` (`NomEst` VARCHAR(10) NOT NULL, `ValEst` INT NOT NULL, PRIMARY KEY(`NomEst`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ActAuto` (`Id` int not null auto_increment, `IdAutor` int not null, `IdAct` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdAct`) references `Actores`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ActFuen` (`Id` int not null auto_increment, `IdFuen` int not null, `IdAct` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdAct`) references `Actores`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ObjAuto` (`Id` int not null auto_increment, `IdAutor` int not null, `IdObj` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ObjFuen` (`Id` int not null auto_increment, `IdFuen` int not null, `IdObj` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ObjSubobj` (`Id` int not null auto_increment, `IdSubobj` int not null, `IdObj` int not null, primary key(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqAct` (`Id` int not null auto_increment, `IdAct` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdAct`) references `Actores`(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqAuto` (`Id` int not null auto_increment, `IdAutor` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqFuen` (`Id` int not null auto_increment, `IdFuen` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqObj` (`Id` int not null auto_increment, `IdObj` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqReqR` (`Id` int not null auto_increment, `IdReqR` int not null, `TipoReq` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqSecExc` (`Id` int not null auto_increment, `IdReq` int not null, `Descrip` varchar(100) not null, primary key(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqSecNor` (`Id` int not null auto_increment, `IdReq` int not null, `Descrip` varchar(100) not null, primary key(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIAuto` (`Id` int not null auto_increment, `IdAutor` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIDatEsp` (`Id` int not null auto_increment, `IdReq` int not null, `Descrip` varchar(100) not null, primary key(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIFuen` (`Id` int not null auto_increment, `IdFuen` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIObj` (`Id` int not null auto_increment, `IdObj` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIReqR` (`Id` int not null auto_increment, `IdReqR` int not null, `TipoReq` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNAuto` (`Id` int not null auto_increment, `IdAutor` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqNFunc`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNFuen` (`Id` int not null auto_increment, `IdFuen` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqNFunc`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNObj` (`Id` int not null auto_increment, `IdObj` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`), foreign key(`IdReq`) references `ReqNFunc`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNReqR` (`Id` int not null auto_increment, `IdReqR` int not null, `TipoReq` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdReq`) references `ReqNFunc`(`Id`));", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Paquetes(Nombre,Version,Fecha,Categoria,Comentario) VALUES ('No Asignado', 1, '" + ClsFunciones.FechaMySQL(DateTime.Today) + "', 10, '');", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('DSR', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('RTII', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('EUE', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('CIPR', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('RCMBAF', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('IE', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('U', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('CPS', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('ETC', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('HC', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('CS', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('DOTPC', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('UT', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('FWTP', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('AE', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('OOPE', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('LAC', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('M', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('SR', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('PTS', 0);", BuilderMySql.ToString(), TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('DPL', 0);", BuilderMySql.ToString(), TipoBD);
return(0);
}
else
{
ADOX.Catalog cat = new ADOX.Catalog();
string builder = "Provider=Microsoft.ACE.OLEDB.12.0; " + "Data Source=" + RutaAcc + "; ";
if (FlgPass)
{
builder += PassAcc;
}
try
{
cat.Create(builder);
if (!FlgPass)
{
builder += "Persist Security Info = False;";
}
ClsBaseDatos.BDBool("CREATE TABLE `Actores` (`Id` AUTOINCREMENT not null, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` text not null, `Complejidad` int not null, `DescComple` varchar(100) not null, `Categoria` int not null, `Comentario` Text not null, primary key(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `Grupo` (`Id` AUTOINCREMENT not null, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Organizacion` varchar(100) not null, `Rol` varchar(100) not null, `Desarrollador` int not null, `Categoria` int not null, `Comentario` Text not null, primary key(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `Objetivos` (`Id` AUTOINCREMENT not null, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` varchar(100) not null, `Prioridad` int not null, `Urgencia` int not null, `Estabilidad` int not null, `Estado` int not null, `Categoria` int not null, `Comentario` Text not null, primary key(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `Paquetes` (`Id` AUTOINCREMENT not null, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Categoria` int not null, `Comentario` Text not null, primary key(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqFun` (`Id` AUTOINCREMENT not null, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` varchar(100) not null, `Paquete` int not null, `Precond` varchar(100) not null, `Postcond` varchar(100) not null, `Complejidad` int not null, `Prioridad` int not null, `Urgencia` int not null, `Estabilidad` int not null, `Estado` int not null, `Categoria` int not null, `Comentario` Text not null, primary key(`Id`), foreign key(`Paquete`) references `paquetes`(`id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqInfo` (`Id` AUTOINCREMENT not null, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` varchar(100) not null, `TiemMed` int not null, `TiemMax` int not null, `OcuMed` int not null, `OcuMax` int not null, `Prioridad` int not null, `Urgencia` int not null, `Estabilidad` int not null, `Estado` int not null, `Categoria` int not null, `Comentario` Text not null, primary key(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNFunc` (`Id` AUTOINCREMENT not null, `Nombre` varchar(100) unique not null, `Version` double not null default 1.0, `Fecha` date, `Descripcion` varchar(100) not null, `Prioridad` int not null, `Urgencia` int not null, `Estabilidad` int not null, `Estado` int not null, `Categoria` int not null, `Comentario` Text not null, primary key(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `Estim` (`NomEst` VARCHAR(10) NOT NULL, `ValEst` INT NOT NULL, PRIMARY KEY(`NomEst`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ActAuto` (`Id` AUTOINCREMENT not null, `IdAutor` int not null, `IdAct` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdAct`) references `Actores`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ActFuen` (`Id` AUTOINCREMENT not null , `IdFuen` int not null, `IdAct` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdAct`) references `Actores`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ObjAuto` (`Id` AUTOINCREMENT not null , `IdAutor` int not null, `IdObj` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ObjFuen` (`Id` AUTOINCREMENT not null , `IdFuen` int not null, `IdObj` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ObjSubobj` (`Id` AUTOINCREMENT not null , `IdSubobj` int not null, `IdObj` int not null, primary key(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqAct` (`Id` AUTOINCREMENT not null , `IdAct` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdAct`) references `Actores`(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqAuto` (`Id` AUTOINCREMENT not null , `IdAutor` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqFuen` (`Id` AUTOINCREMENT not null , `IdFuen` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqObj` (`Id` AUTOINCREMENT not null , `IdObj` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqReqR` (`Id` AUTOINCREMENT not null , `IdReqR` int not null, `TipoReq` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqSecExc` (`Id` AUTOINCREMENT not null , `IdReq` int not null, `Descrip` varchar(100) not null, primary key(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqSecNor` (`Id` AUTOINCREMENT not null , `IdReq` int not null, `Descrip` varchar(100) not null, primary key(`Id`), foreign key(`IdReq`) references `ReqFun`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIAuto` (`Id` AUTOINCREMENT not null , `IdAutor` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIDatEsp` (`Id` AUTOINCREMENT not null , `IdReq` int not null, `Descrip` varchar(100) not null, primary key(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIFuen` (`Id` AUTOINCREMENT not null , `IdFuen` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIObj` (`Id` AUTOINCREMENT not null , `IdObj` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqIReqR` (`Id` AUTOINCREMENT not null , `IdReqR` int not null, `TipoReq` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdReq`) references `ReqInfo`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNAuto` (`Id` AUTOINCREMENT not null , `IdAutor` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdAutor`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqNFunc`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNFuen` (`Id` AUTOINCREMENT not null , `IdFuen` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdFuen`) references `Grupo`(`Id`), foreign key(`IdReq`) references `ReqNFunc`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNObj` (`Id` AUTOINCREMENT not null , `IdObj` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdObj`) references `Objetivos`(`Id`), foreign key(`IdReq`) references `ReqNFunc`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("CREATE TABLE `ReqNReqR` (`Id` AUTOINCREMENT not null , `IdReqR` int not null, `TipoReq` int not null, `IdReq` int not null, primary key(`Id`), foreign key(`IdReq`) references `ReqNFunc`(`Id`));", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Paquetes(Nombre,Version,Fecha,Categoria,Comentario) VALUES ('No Asignado', 1, '" + ClsFunciones.FechaMySQL(DateTime.Today) + "', 10, '');", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('DSR', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('RTII', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('EUE', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('CIPR', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('RCMBAF', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('IE', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('U', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('CPS', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('ETC', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('HC', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('CS', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('DOTPC', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('UT', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('FWTP', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('AE', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('OOPE', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('LAC', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('M', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('SR', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('PTS', 0);", builder, TipoBD);
ClsBaseDatos.BDBool("INSERT INTO Estim(NomEst, ValEst) VALUES('DPL', 0);", builder, TipoBD);
}
catch
{
return(-2);
}
}
return(0);
}
public bool GuardarRCMBAF()
{
return(ClsBaseDatos.BDBool("Update Estim Set ValEst = " + RCMBAF + " where NomEst = 'RCMBAF';"));
}
