protected override bool Body(DbConnection connection)
{
DbCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "[dbo].[RP_UpdateJobApplication]";
command.Parameters.Add(DataAcessUtils.CreateParam("@ApplicationId", DbType.Int32, _application.Id));
command.Parameters.Add(DataAcessUtils.CreateParam("@CandidateId", DbType.Int32, _application.ApplicantId));
command.Parameters.Add(DataAcessUtils.CreateParam("@CandidateName", DbType.String, _application.ApplicantName));
command.Parameters.Add(DataAcessUtils.CreateParam("@State", DbType.String, _application.CurrentState));
command.Parameters.Add(DataAcessUtils.CreateParam("@WorkflowId", DbType.Int32, _application.WorkflowId));
DbParameter para1 = new SqlParameter();
para1.DbType = DbType.Int32;
para1.ParameterName = "@outPutID";
para1.Direction = ParameterDirection.Output;
command.Parameters.Add(para1);
command.ExecuteNonQuery();
int result = Convert.ToInt32(para1.Value);
if (result > 0)
{
return(true);
}
return(false);
}
protected override string Body(System.Data.Common.DbConnection connection)
{
string spName = "ExceWorkStationGetGymConnection";
string conection = string.Empty;
try
{
DbCommand command = CreateCommand(System.Data.CommandType.StoredProcedure, spName);
command.Parameters.Add(DataAcessUtils.CreateParam("@GymCode", System.Data.DbType.String, _companyCode));
conection = (string)command.ExecuteScalar();
return(conection);
}
catch
{
return(string.Empty);
}
}
