/// <summary>
/// Method that calls a stored proc for updating a player training record from database
/// </summary>
/// <param name="args">List of strings with the new and values for updating a player training record from data base</param>
/// <returns>Returns the integer code result of the stored proc execution</returns>
public int updateTraining(List <String> args)
{
List <DataAccess.storedProcData> procParams = new List <DataAccess.storedProcData>();
DataAccess.storedProcData parameter;
parameter = new DataAccess.storedProcData();
parameter.storedProcParam = "@fechaV";
parameter.storedProcParamType = SqlDbType.Date;
parameter.userParams = args[0];
procParams.Add(parameter);
parameter = new DataAccess.storedProcData();
parameter.storedProcParam = "@fechaN";
parameter.storedProcParamType = SqlDbType.Date;
parameter.userParams = args[1];
procParams.Add(parameter);
parameter = new DataAccess.storedProcData();
parameter.storedProcParam = "@horaN";
parameter.storedProcParamType = SqlDbType.Time;
parameter.userParams = args[2];
procParams.Add(parameter);
return(dataAccess.executeStoreProcedure(procParams, "actualizarEntrenamiento"));
}
/// <summary>
/// Method to update data
/// </summary>
/// <param name="args"> The list of parameters that i want to update </param>
/// <returns> Return the status of the update </returns>
public int updateSchoolLevelsInfo(List <String> args)
{
String[] procParams =
{
"@numNivelViejo"
, "@numNivelNuevo"
, "@nombreEsc"
};
SqlDbType[] dataTypes =
{
SqlDbType.TinyInt
, SqlDbType.TinyInt
, SqlDbType.VarChar
};
/*Se declara la estructura para los parámetros*/
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData paramStruct;
/*Se llena la estrucutra con los parámetros*/
for (int index = 0; index < args.Count; ++index)
{
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[index];
paramStruct.storedProcParamType = dataTypes[index];
paramStruct.userParams = args[index];
//MessageBox.Show("Parametro proc: " + procParams[index] + ", Tipo: " + dataTypes[index].ToString() + ", Valor otorgado: " + args[index]);
parameters.Add(paramStruct);
}
return(dataAccess.executeStoreProcedure(parameters, "ActualizarNivelesDeEscuela"));
}
/// <summary>
/// Method to delete data
/// </summary>
/// <param name="args"> The list of parameters that i want to delete </param>
/// <returns></returns>
public int deleteSchool(List <String> args)
{
String[] procParams =
{
"@nombre"
};
SqlDbType[] dataTypes =
{
SqlDbType.Char
};
/*Se declara la estructura para los parámetros*/
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData paramStruct;
/*Se llena la estrucutra con los parámetros*/
for (int index = 0; index < args.Count; ++index)
{
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[index];
paramStruct.storedProcParamType = dataTypes[index];
paramStruct.userParams = args[index];
//MessageBox.Show("Parametro proc: " + procParams[index] + ", Tipo: " + dataTypes[index].ToString() + ", Valor otorgado: " + args[index]);
parameters.Add(paramStruct);
}
return(dataAccess.executeStoreProcedure(parameters, "eliminarEscuela"));
}
/// <summary>
/// Method that calls a stored proc to insert a new legal manager into database
/// </summary>
/// <param name="args">List of strings with the values for the new legal manager</param>
/// <returns>Returns int value result from stored proc execution</returns>
public int insertNewEncargado(List <String> args)
{
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData paramStruct;
String[] procParams =
{
"@Cedula"
, "@Nombre"
, "@Apellido1"
, "@Apellido2"
};
SqlDbType[] dataTypes =
{
SqlDbType.NChar
, SqlDbType.NVarChar
, SqlDbType.NVarChar
, SqlDbType.NVarChar
};
for (int index = 0; index < args.Count; ++index)
{
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[index];
paramStruct.storedProcParamType = dataTypes[index];
paramStruct.userParams = args[index];
parameters.Add(paramStruct);
}
return(dataAccess.executeStoreProcedure(parameters, "insertarEncargado"));
}
/// <summary>
/// Method that call a stored proc in database to update a selected player information
/// </summary>
/// <param name="args">List of strings with the new and old values to call stored proc</param>
/// <returns>Return the integer value result from executing the stored procedure</returns>
public int updatePlayerTrainingInfo(List <String> args)
{
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData param;
String[] storedProcParamNames =
{
"@CedJugador"
, "@NuevoFecha"
, "@ViejaFecha"
};
SqlDbType[] paramDataTypes =
{
SqlDbType.NChar,
SqlDbType.Date,
SqlDbType.Date
};
for (int index = 0; index < args.Count; ++index)
{
param = new DataAccess.storedProcData();
param.storedProcParam = storedProcParamNames[index];
param.storedProcParamType = paramDataTypes[index];
param.userParams = args[index];
parameters.Add(param);
}
return(dataAccess.executeStoreProcedure(parameters, "actualizarEntrenamientoJugador"));
}
/// <summary>
/// Method that execute a delete action of a player from database
/// </summary>
/// <param name="args">List of strings that contains the values for deleting a players</param>
/// <returns>Return int value with the result of the query from database</returns>
public int deletePlayer(List <string> args)
{
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData param = new DataAccess.storedProcData();
param.storedProcParam = "@Cedula";
param.storedProcParamType = SqlDbType.NChar;
param.userParams = args[0];
parameters.Add(param);
return(dataAccess.executeStoreProcedure(parameters, "Eliminar_Jugador"));;
}
/// <summary>
/// Method that inserts a new player in the database.
/// </summary>
/// <param name="args">List of strings that contains information to insert a new player into database</param>
/// <returns>Return int value with the result of the query from database</returns>
public int insertNewPlayer(List <String> args)
{
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData paramStruct;
String[] procParams =
{
"@nombreJ"
, "@Apellido1J"
, "@tel1J"
, "@tel2J"
, "@cedulaJ"
, "@Apellido2J"
, "@fechaNac"
, "@sexo"
, "@escuela"
, "@nombreE"
, "@Apellido1E"
, "@fechaIngreso"
, "@cedulaE"
, "@Apellido2E"
};
SqlDbType[] dataTypes =
{
SqlDbType.NVarChar
, SqlDbType.NVarChar
, SqlDbType.NVarChar
, SqlDbType.NVarChar
, SqlDbType.NChar
, SqlDbType.NVarChar
, SqlDbType.Date
, SqlDbType.NChar
, SqlDbType.NVarChar
, SqlDbType.NVarChar
, SqlDbType.NVarChar
, SqlDbType.Date
, SqlDbType.NChar
, SqlDbType.NVarChar
};
for (int index = 0; index < args.Count; ++index)
{
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[index];
paramStruct.storedProcParamType = dataTypes[index];
paramStruct.userParams = args[index];
parameters.Add(paramStruct);
}
return(dataAccess.executeStoreProcedure(parameters, "insertarJugador"));
}
/// <summary>
/// Method to call a stored proc to delete a existing player from database
/// </summary>
/// <param name="args">List of strings with the identifiers values for deleting a player</param>
/// <returns>Return the integer value result from executing the stored procedure</returns>
public int deletePlayerTraining(List <String> args)
{
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData param;
param = new DataAccess.storedProcData();
param.storedProcParam = "@CedJugador";
param.storedProcParamType = SqlDbType.NChar;
param.userParams = args[0];
parameters.Add(param);
param = new DataAccess.storedProcData();
param.storedProcParam = "@FechEntren";
param.storedProcParamType = SqlDbType.Date;
param.userParams = args[1];
parameters.Add(param);
return(dataAccess.executeStoreProcedure(parameters, "EliminarEntrenamientoDeJugador"));
}
/// <summary>
/// Insert a new payment in the database.
/// </summary>
/// <param name="args"></param> Used to pass values to the stored procedure insertarPagoJugador.
/// <returns>(0, if the insert is correct)</returns>.
public int insertNewPay(List <String> args)
{
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData paramStruct;
String[] procParams =
{
"@nombreEscuela"
, "@numeroRecibo"
, "@Fecha"
, "@Monto"
, "@Detalle"
, "@Cedula"
, "@Tipo"
};
SqlDbType[] dataTypes =
{
SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.Date
, SqlDbType.Int
, SqlDbType.VarChar
, SqlDbType.Char
, SqlDbType.TinyInt
};
for (int index = 0; index < args.Count; ++index)
{
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[index];
paramStruct.storedProcParamType = dataTypes[index];
paramStruct.userParams = args[index];
parameters.Add(paramStruct);
}
return(dataAccess.executeStoreProcedure(parameters, "insertarPagoJugador"));
}
/// <summary>
///Insert monthly payments from the initial month to the final month.
/// </summary>
/// <param name="args"></param> Used to pass values to the stored procedure insertarPagoJugador.
/// <param name="initM"></param> Used to know what the initial month is.
/// <param name="finM"></param> Used to know what the final month is.
/// <param name="year"></param> Used to know what is the year of the payment date.
public void insertNewMonthPay(List <String> args, string initM, string finM, int year)
{
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData paramStruct;
String[] procParams =
{
"@escuela"
, "@numRecibo"
, "@mes"
, "@ano"
};
SqlDbType[] dataTypes =
{
SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.Char
, SqlDbType.Char
};
for (int index = 0; index < args.Count; ++index)
{
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[index];
paramStruct.storedProcParamType = dataTypes[index];
paramStruct.userParams = args[index];
parameters.Add(paramStruct);
}
string[] months = { "ENE", "FEB", "MAR", "ABR", "MAY", "JUN", "JUL", "AGO", "SEP", "OCT", "NOV", "DIC" };
int initMonth = 0;
for (int i = 0; i < 12; i++)
{
if (initM == months[i])
{
initMonth = i;
break;
}
}
int iterator = initMonth;
iterator--;
do
{
iterator++;
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[2];
paramStruct.storedProcParamType = dataTypes[2];
paramStruct.userParams = months[iterator % 12];
parameters.Add(paramStruct);
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[3];
paramStruct.storedProcParamType = dataTypes[3];
if (iterator % 12 >= initMonth)
{
paramStruct.userParams = year.ToString();
}
else
{
paramStruct.userParams = (year + 1).ToString();
}
parameters.Add(paramStruct);
dataAccess.executeStoreProcedure(parameters, "InsertarPagoMes");
parameters.RemoveAt(2);
parameters.RemoveAt(2);
} while (months[iterator % 12] != finM);
}
}/// <summary>
/// Method that update player information. New information is given in the list of strings 'args'
/// </summary>
/// <param name="args">List of strings that constains new player information</param>
/// <returns>Return int value with the result of the query from database</returns>
public int updatePlayerInformaction(List <String> args)
{
DataAccess.storedProcData param;
String[] procParams =
{
"@ViejaCedJugador"
, "@ViejoTelefono1Jugador"
, "@ViejoTelefono2Jugador"
, "@NuevaCedJugador"
, "@Edad"
, "@Sexo"
, "@FechaNacimiento"
, "@NuevaCedEncargado"
, "@FechaIngreso"
, "@NombreJug"
, "@Apellido1Jug"
, "@Apellido2Jug"
, "@NombreEncargado"
, "@Apellido1Encar"
, "@Apellido2Encar"
, "@NomEscuela"
, "@Nivel"
, "@NuevoTelefono1Jugador"
, "@NuevoTelefono2Jugador"
};
SqlDbType[] dataTypes =
{
SqlDbType.Char
, SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.Char
, SqlDbType.TinyInt
, SqlDbType.Char
, SqlDbType.Date
, SqlDbType.Char
, SqlDbType.Date
, SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.VarChar
, SqlDbType.TinyInt
, SqlDbType.VarChar
, SqlDbType.VarChar
};
/*Se declara la estructura para los parámetros*/
List <DataAccess.storedProcData> parameters = new List <DataAccess.storedProcData>();
DataAccess.storedProcData paramStruct;
/*Se llena la estrucutra con los parámetros*/
for (int index = 0; index < args.Count; ++index)
{
paramStruct = new DataAccess.storedProcData();
paramStruct.storedProcParam = procParams[index];
paramStruct.storedProcParamType = dataTypes[index];
paramStruct.userParams = args[index];
//MessageBox.Show("Parametro proc: " + procParams[index] + ", Tipo: " + dataTypes[index].ToString() + ", Valor otorgado: " + args[index]);
parameters.Add(paramStruct);
}
return(dataAccess.executeStoreProcedure(parameters, "actualizarJugador"));
}
