public int Delete(tblRegisterStudent tblRegisterStudent)
{
int __rowsAffected = 0;
// Create command
using (SqlCommand sqlCommand = new SqlCommand("tblRegisterStudentDelete"))
{
// Set command type
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
// Attach command
AttachCommand(sqlCommand);
// Add command parameters
SqlParameter vid = new SqlParameter("@id", SqlDbType.BigInt);
vid.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vid);
// Set input parameter values
SqlServerHelper.SetParameterValue(vid, tblRegisterStudent.id);
// Execute command
__rowsAffected = sqlCommand.ExecuteNonQuery();
}
finally
{
// Detach command
DetachCommand(sqlCommand);
}
}
return(__rowsAffected);
}
public virtual void Clone(tblRegisterStudent sourceObject)
{
if (sourceObject == null)
{
throw new ArgumentNullException("sourceObject");
}
// Clone attributes from source object
this._id = sourceObject.id;
this._dateOfBirth = sourceObject.dateOfBirth;
this._populationId = sourceObject.populationId;
this._cityId = sourceObject.cityId;
this._municipality = sourceObject.municipality;
this._email = sourceObject.email;
this._educationalGradeId = sourceObject.educationalGradeId;
this._orientationGroupId = sourceObject.orientationGroupId;
this._coachingSchool = sourceObject.coachingSchool;
this._privateLessons = sourceObject.privateLessons;
this._userId = sourceObject.userId;
}
public int Insert(tblRegisterStudent tblRegisterStudent)
{
int __rowsAffected = 0;
// Create command
using (SqlCommand sqlCommand = new SqlCommand("tblRegisterStudentInsert"))
{
// Set command type
sqlCommand.CommandType = CommandType.StoredProcedure;
// Add command parameters
SqlParameter vid = new SqlParameter("@id", SqlDbType.BigInt);
vid.Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.Add(vid);
SqlParameter vdateOfBirth = new SqlParameter("@dateOfBirth", SqlDbType.DateTime);
vdateOfBirth.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vdateOfBirth);
SqlParameter vpopulationId = new SqlParameter("@populationId", SqlDbType.BigInt);
vpopulationId.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vpopulationId);
SqlParameter vcityId = new SqlParameter("@cityId", SqlDbType.BigInt);
vcityId.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vcityId);
SqlParameter vmunicipality = new SqlParameter("@municipality", SqlDbType.NVarChar, 255);
vmunicipality.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vmunicipality);
SqlParameter vemail = new SqlParameter("@email", SqlDbType.NVarChar, 255);
vemail.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vemail);
SqlParameter veducationalGradeId = new SqlParameter("@educationalGradeId", SqlDbType.BigInt);
veducationalGradeId.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(veducationalGradeId);
SqlParameter vorientationGroupId = new SqlParameter("@orientationGroupId", SqlDbType.BigInt);
vorientationGroupId.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vorientationGroupId);
SqlParameter vcoachingSchool = new SqlParameter("@coachingSchool", SqlDbType.NVarChar, 255);
vcoachingSchool.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vcoachingSchool);
SqlParameter vprivateLessons = new SqlParameter("@privateLessons", SqlDbType.Bit);
vprivateLessons.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vprivateLessons);
SqlParameter vuserId = new SqlParameter("@userId", SqlDbType.BigInt);
vuserId.Direction = ParameterDirection.Input;
sqlCommand.Parameters.Add(vuserId);
// Set input parameter values
SqlServerHelper.SetParameterValue(
vid,
tblRegisterStudent.id,
0);
SqlServerHelper.SetParameterValue(vdateOfBirth, tblRegisterStudent.dateOfBirth);
SqlServerHelper.SetParameterValue(vpopulationId, tblRegisterStudent.populationId);
SqlServerHelper.SetParameterValue(vcityId, tblRegisterStudent.cityId);
SqlServerHelper.SetParameterValue(vmunicipality, tblRegisterStudent.municipality);
SqlServerHelper.SetParameterValue(vemail, tblRegisterStudent.email);
SqlServerHelper.SetParameterValue(veducationalGradeId, tblRegisterStudent.educationalGradeId);
SqlServerHelper.SetParameterValue(vorientationGroupId, tblRegisterStudent.orientationGroupId);
SqlServerHelper.SetParameterValue(vcoachingSchool, tblRegisterStudent.coachingSchool);
SqlServerHelper.SetParameterValue(vprivateLessons, tblRegisterStudent.privateLessons);
SqlServerHelper.SetParameterValue(vuserId, tblRegisterStudent.userId);
try
{
// Attach command
AttachCommand(sqlCommand);
// Execute command
__rowsAffected = sqlCommand.ExecuteNonQuery();
if (__rowsAffected == 0)
{
return(__rowsAffected);
}
// Get output parameter values
tblRegisterStudent.id = SqlServerHelper.ToInt64(vid);
}
finally
{
// Detach command
DetachCommand(sqlCommand);
}
}
return(__rowsAffected);
}
public int Retrieve(tblRegisterStudent tblRegisterStudent)
{
int __rowsAffected = 1;
// Create command
using (SqlCommand sqlCommand = new SqlCommand("tblRegisterStudentGet"))
{
// Set command type
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
// Attach command
AttachCommand(sqlCommand);
// Add command parameters
SqlParameter vid = new SqlParameter("@id", SqlDbType.BigInt);
vid.Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.Add(vid);
SqlParameter vdateOfBirth = new SqlParameter("@dateOfBirth", SqlDbType.DateTime);
vdateOfBirth.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vdateOfBirth);
SqlParameter vpopulationId = new SqlParameter("@populationId", SqlDbType.BigInt);
vpopulationId.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vpopulationId);
SqlParameter vcityId = new SqlParameter("@cityId", SqlDbType.BigInt);
vcityId.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vcityId);
SqlParameter vmunicipality = new SqlParameter("@municipality", SqlDbType.NVarChar, 255);
vmunicipality.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vmunicipality);
SqlParameter vemail = new SqlParameter("@email", SqlDbType.NVarChar, 255);
vemail.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vemail);
SqlParameter veducationalGradeId = new SqlParameter("@educationalGradeId", SqlDbType.BigInt);
veducationalGradeId.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(veducationalGradeId);
SqlParameter vorientationGroupId = new SqlParameter("@orientationGroupId", SqlDbType.BigInt);
vorientationGroupId.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vorientationGroupId);
SqlParameter vcoachingSchool = new SqlParameter("@coachingSchool", SqlDbType.NVarChar, 255);
vcoachingSchool.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vcoachingSchool);
SqlParameter vprivateLessons = new SqlParameter("@privateLessons", SqlDbType.Bit);
vprivateLessons.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vprivateLessons);
SqlParameter vuserId = new SqlParameter("@userId", SqlDbType.BigInt);
vuserId.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(vuserId);
// Set input parameter values
SqlServerHelper.SetParameterValue(vid, tblRegisterStudent.id);
// Execute command
sqlCommand.ExecuteNonQuery();
try
{
// Get output parameter values
tblRegisterStudent.id = SqlServerHelper.ToInt64(vid);
tblRegisterStudent.dateOfBirth = SqlServerHelper.ToDateTime(vdateOfBirth);
tblRegisterStudent.populationId = SqlServerHelper.ToInt64(vpopulationId);
tblRegisterStudent.cityId = SqlServerHelper.ToInt64(vcityId);
tblRegisterStudent.municipality = SqlServerHelper.ToString(vmunicipality);
tblRegisterStudent.email = SqlServerHelper.ToString(vemail);
tblRegisterStudent.educationalGradeId = SqlServerHelper.ToInt64(veducationalGradeId);
tblRegisterStudent.orientationGroupId = SqlServerHelper.ToNullableInt64(vorientationGroupId);
tblRegisterStudent.coachingSchool = SqlServerHelper.ToString(vcoachingSchool);
tblRegisterStudent.privateLessons = SqlServerHelper.ToNullableBoolean(vprivateLessons);
tblRegisterStudent.userId = SqlServerHelper.ToInt64(vuserId);
}
catch (Exception ex)
{
if (ex is System.NullReferenceException)
{
__rowsAffected = 0;
}
else
{
throw ex;
}
}
}
finally
{
// Detach command
DetachCommand(sqlCommand);
}
}
return(__rowsAffected);
}
