public List <Colectivo> GetAll()
{
List <Colectivo> coles = new List <Colectivo>();
try
{
this.OpenConnection();
SqlCommand cmdColectivos = new SqlCommand("select * from Colectivos", SqlConn);
SqlDataReader drColectivos = cmdColectivos.ExecuteReader();
while (drColectivos.Read())
{
Colectivo c = new Colectivo();
c.ID = (int)drColectivos["id_colectivo"];
c.Marca = (string)drColectivos["marca"];
c.Modelo = (string)drColectivos["modelo"];
c.CantidadAsientos = (int)drColectivos["cantidad_asientos"];
coles.Add(c);
}
drColectivos.Close();
}
catch (Exception Ex)
{
Exception ExcepcionManejada = new Exception("Error al recuperar lista de colectivos", Ex);
throw ExcepcionManejada;
}
finally
{
this.CloseConnection();
}
return(coles);
}
protected void btnCrearColectivo_Click(object sender, EventArgs e)
{
lblMensaje.Visible = true;
try
{
if (txtPatenteColectivo.Text.Equals("") || txtMotorColectivo.Text.Equals("") || ddlModeloColectivo.SelectedIndex == 0 || ddlRecorrido.SelectedIndex == 0)
{
throw new Exception("Ingrese todos los datos del vehiculo");
}
string patente = txtPatenteColectivo.Text;
Modelos modelo = (Modelos)Enum.Parse(typeof(Modelos), ddlModeloColectivo.SelectedValue);
double motor = double.Parse(txtMotorColectivo.Text);
Recorridos recorrido = (Recorridos)Enum.Parse(typeof(Recorridos), ddlRecorrido.SelectedValue);
Colectivo objColectivo = new Colectivo(recorrido, patente, modelo, motor);
if (ControladorVehiculos.addVehiculo(objColectivo))
{
lblMensaje.Text = "Se agrego el colectivo";
limpiarCamposColectivo();
}
else
{
lblMensaje.Text = "Ya existe un vehiculo con esa patente";
}
}
catch (Exception ex)
{
lblMensaje.Text = "Error: " + ex.Message;
}
}
public ActionResult GetColectivos()
{
var res = ActionResult.NoAction;
res.SetSuccess(Colectivo.JsonList(Colectivo.AllASPAD));
return(res);
}
protected void btnAceptar_Click(object sender, EventArgs e)
{
Colectivo c = new Colectivo();
c.Marca = this.txtMarca.Text;
c.Modelo = this.txtModelo.Text;
c.CantidadAsientos = Convert.ToInt32(this.txtCantidadAsientos.Text);
new ColectivoLogic().Insert(c);
this.panelNuevoColectivo.Visible = false;
this.LoadGridColectivos();
}
public CalleViewModel(Calle calle = null, Colectivo colectivo = null)
{
int?cc = null;
if (colectivo != null)
{
cc = colectivo.id;
}
if (calle == null)
{
calles = new ObservableCollection <Calle>(App.Database.GetCalles(cc));
}
else
{
calles = new ObservableCollection <Calle>(App.Database.GetIntersecciones(cc, calle.id));
}
}
public void Insert(Colectivo c)
{
try
{
this.OpenConnection();
SqlCommand cmdSave = new SqlCommand("insert into Colectivos(marca,modelo,cantidad_asientos) values(@marca,@modelo,@cantidad_asientos) select @@identity", SqlConn);
cmdSave.Parameters.Add("@marca", SqlDbType.VarChar, 50).Value = c.Marca;
cmdSave.Parameters.Add("@modelo", SqlDbType.VarChar, 50).Value = c.Modelo;
cmdSave.Parameters.Add("@cantidad_asientos", SqlDbType.Int).Value = c.CantidadAsientos;
c.ID = Decimal.ToInt32((decimal)cmdSave.ExecuteScalar());
}
catch (Exception Ex)
{
Exception ExcepcionManejada = new Exception("Error al crear colectivo", Ex);
throw ExcepcionManejada;
}
finally
{
this.CloseConnection();
}
}
/// <summary>Page's load event</summary>
/// <param name="sender">Loaded page</param>
/// <param name="e">Event's arguments</param>
protected void Page_Load(object sender, EventArgs e)
{
Session["Navigation"] = null;
if (this.Request.UserLanguages != null)
{
this.languageBrowser = this.Request.UserLanguages[0];
}
ServicePointManager.Expect100Continue = true;
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls11 | SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls12;
var url = ConfigurationManager.AppSettings["SalesForceUrl"].ToString();
SforceService binding = new SforceService(url);
try
{
var user = ConfigurationManager.AppSettings["SalesForceUser"].ToString();
var token = ConfigurationManager.AppSettings["SalesForceToken"].ToString();
var loginResult = binding.login(user, token);
Session["SForceSessionId"] = loginResult.sessionId;
Session["SForceWsUrl"] = loginResult.serverUrl;
binding.Url = loginResult.serverUrl;
binding.SessionHeaderValue = new SessionHeader
{
sessionId = loginResult.sessionId
};
Session["SForceConnection"] = binding;
}
catch (Exception ex)
{
ExceptionManager.Trace(ex, "Salesforce login");
}
this.ip = this.GetUserIP();
Session["ColectivosASPAD"] = Colectivo.AllASPAD;
Session["ColectivosASPADJson"] = Colectivo.JsonList(Session["ColectivosASPAD"] as ReadOnlyCollection <Colectivo>);
Session["ProductosASPAD"] = Producto.AllASPAD;
Session["PreciosASPAD"] = AspadLandFramework.Item.Acto.AllASPAD;
}
public void Insert(Colectivo c)
{
new ColectivoAdapter().Insert(c);
}
