public List <AppVersionDTO> SelectAppVersion(int aplicacion_id)
{
List <AppVersionDTO> listaAppVersiones = new List <AppVersionDTO>();
StringBuilder query = new StringBuilder().Append(@"SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT
ID,
APLICACION_ID,
NUMERO,
RUTA_APLICACION
FROM APPVERSION" );
if (aplicacion_id != 0)
{
query.Append(" WHERE APLICACION_ID=@APLICACION_ID");
}
using (var con = ConectarDB())
{
con.Open();
try
{
using (SqlCommand command = new SqlCommand(query.ToString(), con))
{
if (aplicacion_id != 0)
{
command.Parameters.Add(new SqlParameter("@APLICACION_ID", aplicacion_id));
}
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
AppVersionDTO appVersion = new AppVersionDTO()
{
AppVersion_id = Convert.ToInt32(reader[0]),
Aplicacion_id = reader[1].ToString(),
Numero = reader[2].ToString(),
Ruta_Aplicacion = reader[3].ToString()
};
listaAppVersiones.Add(appVersion);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("No se encontró el registro.");
}
finally
{
con.Close();
}
}
return(listaAppVersiones);
}
/// <summary>
/// Crea una version de aplicacion
/// </summary>
/// <param name="appVersion"></param>
/// <returns></returns>
public ReturnMessage CreateAppVersion(AppVersionDTO appVersion)
{
try
{
//logica de negocio aquí
AppVersionBehavior appVersionBehavior = new AppVersionBehavior();
return(appVersionBehavior.CreateAppVersion(appVersion));
}
catch (Exception ex)
{
ReturnMessage message = new ReturnMessage();
message.TipoMensaje = TipoMensaje.Error;
message.Mensaje = ex.Message;
return(message);
}
}
/// <summary>
/// Crea una estrategia
/// </summary>
/// <param name="aplicacion"></param>
public ReturnMessage CreateAppVersion(AppVersionDTO appVersion)
{
ReturnMessage mensaje = new ReturnMessage();
string query = @"SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
INSERT INTO APPVERSION (APLICACION_ID, NUMERO,RUTA_APLICACION) VALUES (@APLICACION_ID,@NUMERO,@RUTA_APLICACION)
SELECT @@IDENTITY AS 'Identity';";
using (var con = ConectarDB())
{
con.Open();
try
{
using (SqlCommand command = new SqlCommand(query, con))
{
command.Parameters.Add(new SqlParameter("@APLICACION_ID", appVersion.Aplicacion_id));
command.Parameters.Add(new SqlParameter("@NUMERO", appVersion.Numero));
command.Parameters.Add(new SqlParameter("@RUTA_APLICACION", appVersion.Ruta_Aplicacion));
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
appVersion.AppVersion_id = Convert.ToInt32(reader[0]);
}
}
}
mensaje.Mensaje = "La version se creó correctamente";
mensaje.TipoMensaje = TipoMensaje.Correcto;
mensaje.obj = appVersion;
}
catch (Exception ex)
{
Console.WriteLine("No se pudo insertar");
mensaje.Mensaje = ex.Message;
mensaje.TipoMensaje = TipoMensaje.Error;
mensaje.obj = appVersion;
}
finally
{
con.Close();
}
return(mensaje);
}
}
/// <summary>
///初始化,类库在加载时就使用配置文件对所有配置进行初始化
/// </summary>
static Config()
{
try
{
log.Debug(Constant.DEBUG_START);
string configFilePath = AppDomain.CurrentDomain.BaseDirectory + Constant.CONFIG_FILE_NAME;
// Basic
connectionString = XmlUtil.ReadValue(configFilePath, XPATH_BASEC_DB_CONNECTION);
maxLogFileCount = Convert.ToInt32(XmlUtil.ReadValue(configFilePath, XPATH_BASIC_MAX_LOG_FILE_COUNT));
// Security
apiSignSecretKey = XmlUtil.ReadValue(configFilePath, XPATH_SECURITY_API_AUTH_KEY);
// Sms
smsApiKey = XmlUtil.ReadValue(configFilePath, XPATH_SMS_API_KEY);
captchaExpireTime = Convert.ToInt32(XmlUtil.ReadValue(configFilePath, XPATH_SECURITY_CAPTCHA_EXPIRE_TIME));
smsRegTemplate = XmlUtil.ReadValue(configFilePath, XPATH_SMS_TEMPLATE_REG);
smsGetPasswordTemplate = XmlUtil.ReadValue(configFilePath, XPATH_SMS_TEMPLATE_GET_PASSWORD);
smsLoginTemplate = XmlUtil.ReadValue(configFilePath, XPATH_SMS_TEMPLATE_LOGIN);
// AppVersion
string pcVersion = XmlUtil.ReadValue(configFilePath, XPATH_APP_PC_VERSION);
string pcDownloadUrl = XmlUtil.ReadValue(configFilePath, XPATH_APP_PC_URL);
string pcChangeLog = XmlUtil.ReadValue(configFilePath, XPATH_APP_PC_CHANGE_LOG);
pcVersionDTO = new AppVersionDTO(pcVersion, pcDownloadUrl, pcChangeLog);
string androidVersion = XmlUtil.ReadValue(configFilePath, XPATH_APP_ANDROID_VERSION);
string androidDownloadUrl = XmlUtil.ReadValue(configFilePath, XPATH_APP_ANDROID_URL);
string androidChangeLog = XmlUtil.ReadValue(configFilePath, XPATH_APP_ANDROID_CHANGE_LOG);
androidVersionDTO = new AppVersionDTO(androidVersion, androidDownloadUrl, androidChangeLog);
string iosVersion = XmlUtil.ReadValue(configFilePath, XPATH_APP_IOS_VERSION);
string iosDownloadUrl = XmlUtil.ReadValue(configFilePath, XPATH_APP_IOS_URL);
string iosChangeLog = XmlUtil.ReadValue(configFilePath, XPATH_APP_IOS_CHANGE_LOG);
iosVersionDTO = new AppVersionDTO(iosVersion, iosDownloadUrl, iosChangeLog);
log.Debug(Constant.DEBUG_END);
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
}
public ReturnMessage Post([FromBody] AppVersionDTO appVersion)
{
Controller.AppVersionController appVersionController = new Controller.AppVersionController();
return(appVersionController.CreateAppVersion(appVersion));
}
// GET: AppVersion/Create
public ReturnMessage Create([FromBody] AppVersionDTO appVersion)
{
ControllerVulkano.AppVersionController versionController = new ControllerVulkano.AppVersionController();
return(versionController.CreateAppVersion(appVersion));
}