public SG_PERSONA_VIAJES entity(FormCollection form)
{
SG_PERSONA_VIAJES entity = new SG_PERSONA_VIAJES();
entity.I_COD_PAIS = Convert.ToInt32(form["clsPais.I_COD_PAIS"]);
entity.C_COD_PERSONA = form["clsPeopleTravel.C_COD_PERSONA"];
entity.I_AÑO = Convert.ToInt32(form["clsPeopleTravel.I_AÑO"]);
entity.V_TIEMPO_PERMANENCIA = form["clsPeopleTravel.V_TIEMPO_PERMANENCIA"];
entity.V_DES_MOTIVO = form["clsPeopleTravel.V_DES_MOTIVO"];
entity.I_COD_PERSONA_VIAJES = Convert.ToInt32(form["clsPeopleTravel.I_COD_PERSONA_VIAJES"]);
return(entity);
}
public int registerPeopleTravels(SG_PERSONA_VIAJES entity)
{
Database db = DatabaseFactory.CreateDatabase(ConfigurationManager.AppSettings["conecion"]);
int resultado = 0;
using (DbConnection cone = db.CreateConnection())
{
cone.Open();
using (DbTransaction trans = cone.BeginTransaction())
{
try
{
DbCommand cmd = db.GetStoredProcCommand("[SG_SP_REGISTRAR_VIAJES_X_PERSONA]");
db.AddInParameter(cmd, "I_COD_PAIS", DbType.Int32, entity.I_COD_PAIS);
db.AddInParameter(cmd, "C_COD_PERSONA", DbType.String, entity.C_COD_PERSONA);
db.AddInParameter(cmd, "I_AÑO", DbType.Int32, entity.I_AÑO);
db.AddInParameter(cmd, "V_TIEMPO_PERMANENCIA", DbType.String, entity.V_TIEMPO_PERMANENCIA);
db.AddInParameter(cmd, "V_DES_MOTIVO", DbType.String, entity.V_DES_MOTIVO);
resultado = Convert.ToInt32(db.ExecuteNonQuery(cmd, trans));
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message);
}
finally
{
if (cone.State == ConnectionState.Open)
{
cone.Close();
}
}
}
return(resultado);
}
}
public int actualizarPeopleTravels(SG_PERSONA_VIAJES entity)
{
return(new peopleTravelDA().actualizarPeopleTravels(entity));
}
public ActionResult registerPeopleTravels(FormCollection form)
{
SG_PERSONA_VIAJES entity = this.entity(form);
return(Json(peopleTravelRepository.registerPeopleTravels(entity)));
}
public int registerPeopleTravels(SG_PERSONA_VIAJES entity)
{
return(new peopleTravelDA().registerPeopleTravels(entity));
}
