protected string Code_iso(string choix, Bien bien = null, string nego = null) { string req = ""; switch (choix) { case "bienIso": req = "SELECT Pays.codeiso FROM (Biens INNER JOIN optionsBiens ON Biens.ref = optionsBiens.refOptions) INNER JOIN Pays ON optionsBiens.PaysBien = Pays.Titre_Pays WHERE (((Biens.ref)='" + bien.REFERENCE + "'))"; break; case "loueur": if (bien.PAYS_VENDEUR != null && bien.PAYS_VENDEUR != "") { req = "SELECT Pays.codeiso FROM Biens INNER JOIN Pays ON Biens.[pays vendeur] = Pays.Titre_Pays WHERE (((Biens.[pays vendeur])='" + bien.PAYS_VENDEUR + "'))"; } else { req = ""; } break; case "negomandat": req = "SELECT Pays.codeiso FROM (Biens INNER JOIN Clients ON Biens.idclient = Clients.idclient) INNER JOIN Pays ON Clients.pays_client = Pays.Titre_Pays WHERE (((Biens.ref)='" + Request.QueryString["ref"] + "'))"; break; case "negoacq": if (nego != null) { req = "SELECT Pays.codeiso FROM (Acquereurs INNER JOIN Clients ON Clients.idclient = Acquereurs.idclient) INNER JOIN Pays ON Clients.pays_client = Pays.Titre_Pays WHERE Acquereurs.idclient =" + nego; } else if (nego == null) { req = "SELECT Pays.codeiso FROM (Acquereurs INNER JOIN Clients ON Acquereurs.idclient = Clients.idclient) INNER JOIN Pays ON Clients.pays_client = Pays.Titre_Pays WHERE (Acquereurs.id_acq)=" + Request.QueryString["acq"]; } break; case "notaire": req = ""; break; } OdbcConnection c = null; string codeiso; if (req != "") { c = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); OdbcCommand requette = new OdbcCommand(req, c); c.Open(); OdbcDataReader reader = requette.ExecuteReader(); reader.Read(); codeiso = reader["codeiso"].ToString(); c.Close(); } else { codeiso = ""; } return(codeiso); }
public IActionResult getBien(Bien bien) { List <Bien> res = Repo.getBien(bien); ViewBag.Message = res; return(View("Bien")); }
public List <Bien> getBien(Bien bien) { List <Bien> res = new List <Bien>(); var connection = GetConnection(); connection.Open(); SqlCommand command = new SqlCommand("Select b.Id , b.Adresse , u.Phone FROM Bien b , [User] u where b.PostalCode = @cp and b.Type = @type and u.id = b.Owner ", connection); command.Parameters.AddWithValue("@cp", int.Parse(bien.PostalCode)); command.Parameters.AddWithValue("@type", bien.Type); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { Bien obj = new Bien(); obj.Type = bien.Type; obj.id = reader.GetInt32(0); obj.Adresse = reader.GetString(1); obj.OwnerTel = reader.GetString(2); obj.PostalCode = bien.PostalCode; res.Add(obj); } } } connection.Close(); return(res); }
public async Task <IHttpActionResult> Post() { var json = HttpContext.Current.Request.Form["data"]; Bien item = JsonConvert.DeserializeObject <Bien>(json); string uploadFolder = HttpContext.Current.Server.MapPath("~/Uploads"); if (!Directory.Exists(uploadFolder)) { Directory.CreateDirectory(uploadFolder); } if (HttpContext.Current.Request.Files.Count > 0) { var file = HttpContext.Current.Request.Files[0]; string filename = Guid.NewGuid().ToString() + Path.GetExtension(file.FileName); file.SaveAs(Path.Combine(uploadFolder, filename)); } item.Id = 0; item.DateCreation = DateTime.Now; db.Biens.Add(item); await db.SaveChangesAsync(); return(Ok()); }
public string EnviarBien(Bien bien) { string result; result = mapperBienes.EnviarBien(bien); return(result); }
public int addBien(Bien bien, int v) { int id = -1; var connection = GetConnection(); connection.Open(); SqlCommand command = new SqlCommand("insert into [dbo].[Bien] (Adresse , Owner , PostalCode , Type) Values( @ad , @ow , @cp , @t) SELECT SCOPE_IDENTITY()", connection); command.Parameters.AddWithValue("@ad", bien.Adresse); command.Parameters.AddWithValue("@ow", v); command.Parameters.AddWithValue("@cp", bien.PostalCode); command.Parameters.AddWithValue("@t", bien.Type); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { id = int.Parse(reader.GetDecimal(0).ToString()); } } } connection.Close(); return(id); }
// GET: cuotas public ActionResult cuotas_pendientes() { Usuario usuario = (Usuario)Session[SessionName.User]; var b = from c in db.Biens where c.idusuario == usuario.id select c; if (b.Count() != 0) { Bien bien = b.FirstOrDefault(); var d = from c in db.Deudas.Include("Bien") where c.id_bien == bien.id select c; if (d.Count() != 0) { Deuda deuda = d.FirstOrDefault(); var aux = from c in db.cuotas.Include("Deuda") where c.Pagado == false && c.id_deuda == deuda.id select c; return(View(aux.ToList())); } else { return(RedirectToAction("Index_Cliente", "Home")); } } return(RedirectToAction("Index_Cliente", "Home")); }
public async Task <ActionResult> Create() { Bien model = new Bien(); using (HttpClient client = new HttpClient()) { var response = await client.GetAsync ( "http://localhost:81/ApiCC/api/Proprietaire" ); if (response.IsSuccessStatusCode) { var json = await response.Content.ReadAsStringAsync(); var proprietaires = JsonConvert.DeserializeObject <IEnumerable <Proprietaire> >(json); model.Proprietaires = proprietaires.Select ( x => new SelectListItem { Text = x.Nom, Value = x.Id.ToString() } ); } } return(View(model)); }
public ActionResult CreateBienAdmin(Bien Bur, FormCollection collection) { if (Session["identifiant"] == null) { return(RedirectToAction("Index", "Home")); } if (ModelState.IsValid) { try { BissInventaireEntities.Instance.Bien.Add(Bur); BissInventaireEntities.Instance.SaveChanges(); return(RedirectToAction("RapportBien")); } catch (Exception ex) { LogThread.WriteLine(ex.Message); return(RedirectToAction("Index", "Error")); } } else { ViewData["depts"] = new SelectList(db.GetBureaux(), "Id", "Description"); ViewData["Bureau"] = new SelectList(BissInventaireEntities.Instance.Depot.ToList(), "id", "Description"); return(View()); } }
/// <summary> /// Créez un nouvel objet Bien. /// </summary> /// <param name="id_bien">Valeur initiale de id_bien.</param> /// <param name="type">Valeur initiale de type.</param> public static Bien CreateBien(int id_bien, string type) { Bien bien = new Bien(); bien.id_bien = id_bien; bien.type = type; return(bien); }
public ActionResult DeleteConfirmed(int id) { Bien bien = db.Biens.Find(id); db.Biens.Remove(bien); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create1(Bien customer) { if (Session["identifiant"] == null) { return(RedirectToAction("Index", "Home")); } return(View()); }
public async Task <ActionResult> DeleteConfirmed(int id) { Bien bien = await db.Bien.FindAsync(id); db.Bien.Remove(bien); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public ActionResult Crear_Posible([Bind(Include = "id,nombre,precio,idusuario")] Bien bien) { if (ModelState.IsValid) { return(RedirectToAction("Crear_Posible", "Deudas")); } ViewBag.idusuario = new SelectList(db.Usuarios, "id", "nombre", bien.idusuario); return(View(bien)); }
public async Task <ActionResult> Edit([Bind(Include = "BienId,BienNombre,BienPrecioCompra,BienPrecioActual,BienFechaIngreso,BienFechaEgreso")] Bien bien) { if (ModelState.IsValid) { db.Entry(bien).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(bien)); }
public async Task <ActionResult> Edit([Bind(Include = "Id,Titulo,Detalle,Precio,Telefono,Email,FechaIngreso,HoraIngreso,Estado")] Bien bien) { if (ModelState.IsValid) { db.Entry(bien).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(bien)); }
public ActionResult Edit([Bind(Include = "id,nombre,precio,idusuario")] Bien bien) { if (ModelState.IsValid) { db.Entry(bien).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idusuario = new SelectList(db.Usuarios, "id", "nombre", bien.idusuario); return(View(bien)); }
public ActionResult Create([Bind(Include = "id,nombre,precio,idusuario")] Bien bien) { if (ModelState.IsValid) { db.Biens.Add(bien); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idusuario = new SelectList(db.Usuarios, "id", "nombre", bien.idusuario); return(View(bien)); }
private NameValueCollection MappearADiccionario(Bien bien) { NameValueCollection valores = new NameValueCollection(); valores["Id"] = bien.Id.ToString(); valores["IdTipo"] = bien.IdTipo.ToString(); valores["IdJugador"] = bien.IdJugador.ToString(); valores["nombre"] = bien.Nombre; valores["precio"] = bien.Precio.ToString(); valores["fecha"] = bien.Fecha.ToString(); return(valores); }
public async Task <ActionResult> Create([Bind(Include = "BienId,BienNombre,BienPrecioCompra,BienPrecioActual,BienFechaIngreso,BienFechaEgreso")] Bien bien) { if (ModelState.IsValid) { db.Biens.Add(bien); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(bien)); }
public string EnviarBien(Bien bien) { try { NameValueCollection parametros = MappearADiccionario(bien); string result = WebApiHelper.Post("http://uba-cai.azurewebsites.net/api/bienes/" + bien.IdJugador.ToString(), parametros); return(result); } catch (System.Exception) { throw; } }
public async Task <IHttpActionResult> Put([FromBody] Bien item) { var olditem = await db.Biens.AsNoTracking().FirstOrDefaultAsync(x => x.Id == item.Id); if (olditem != null) { item.DateCreation = olditem.DateCreation; db.Entry(item).State = EntityState.Modified; await db.SaveChangesAsync(); } return(Ok(item)); }
public static BienModel BienToBienModel(Bien bm) { return(new BienModel() { IdBien = bm.IdBien, Titre = bm.Titre, DescriptionCourte = bm.DescriptionCourte, DescriptionLongue = bm.DescriptionLongue, //Photo =bm.Photo, DateCreation = bm.DateCreation, DateSuppression = bm.DateSuppression, Capacité = bm.Capacité }); }
// GET: Biens/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Bien bien = db.Biens.Find(id); if (bien == null) { return(HttpNotFound()); } return(View(bien)); }
// GET: Bienes/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Bien bien = await db.Bien.FindAsync(id); if (bien == null) { return(HttpNotFound()); } return(View(bien)); }
// GET: Biens/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Bien bien = db.Biens.Find(id); if (bien == null) { return(HttpNotFound()); } ViewBag.idusuario = new SelectList(db.Usuarios, "id", "nombre", bien.idusuario); return(View(bien)); }
public ActionResult CreateBienAdmin(Bien Bur, FormCollection collection) { try { BissInventaireEntities.Instance.Bien.Add(Bur); BissInventaireEntities.Instance.SaveChanges(); return(RedirectToAction("RapportBien")); } catch (Exception ex) { LogThread.WriteLine(ex.Message); return(RedirectToAction("Index", "Error")); } }
public async Task <ActionResult> Create([Bind(Include = "Id,Titulo,Detalle,Precio,Telefono,Email,FechaIngreso,HoraIngreso,Estado")] Bien bien, HttpPostedFileBase image) { if (ModelState.IsValid) { //var filename = image.FileName; //var filePathOriginal = Server.MapPath("/content/uploads/bienes"); //string savedFileName = Path.Combine(filePathOriginal, filename); //bien.image_path = @"/content/uploads/bienes/" + filename; db.Bien.Add(bien); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(bien)); }
public IActionResult addBien(Bien bien) { string id = Request.Cookies["id"]; if (id != null) { int addedBien = Repo.addBien(bien, int.Parse(id)); // le traitement pour lire les fichier et puis les stocker dans le cloud //try //{ // // var postedFile = Request.Form.Files[0]; // var postedFile = Request.Form.Files["photo"]; // var uploadFolder = Path.Combine(Directory.GetCurrentDirectory(), "UploadedFiles"); // if (postedFile.Length > 0) // { // var fileName = ContentDispositionHeaderValue.Parse(postedFile.ContentDisposition) // .FileName.Trim('"'); // var finalPath = Path.Combine(uploadFolder, fileName); // using (var fileStream = new FileStream(finalPath, FileMode.Create)) // { // postedFile.CopyTo(fileStream); // } // } //} //catch (Exception ex) //{ // return StatusCode(500, $"Some Error Occcured while uploading File {ex.Message}"); //} } else { return(View("../Home/Index")); } ViewBag.Message = "added"; return(View("Index")); }
public static void AgregarBien(string idElegido, Usuario u) { Console.WriteLine("Que le vamos a cargar? (Casa, auto, yate, etc)"); string bien = Console.ReadLine(); Console.WriteLine("Que precio tiene?"); string precio = Console.ReadLine(); int precioInt, idElegidoInt; try { if ( bien != null && precio != null && Int32.TryParse(precio, out precioInt) && Int32.TryParse(idElegido, out idElegidoInt)) { Bien nuevoBien = new Bien(1, devolverTipo(bien), Int32.Parse(idElegido), bien, Int32.Parse(precio), DateTime.Now.ToString("dd/mm/yyyy")); BienBBL servicioBien = new BienBBL(); string rtaServer = servicioBien.EnviarBien(nuevoBien); if (rtaServer == "\"OK\"") { BitacoraBBL servicioBitacora = new BitacoraBBL(); servicioBitacora.enviarPost(new Bitacora(u.Codigo, "Se creo un bien al jugador: " + idElegido, TipoConsultaEnum.Crear_jugador)); Console.WriteLine("Se creo el bien: " + bien + " por: $" + precio + " - Con exito!"); userMethods.checkIfContinue(u); } else { Console.WriteLine("Ups! Hubo un error del server:" + rtaServer); AgregarBien(idElegido, u); } } else { Console.WriteLine("Ups cargaste mal algun dato, vamos de nuevo!"); AgregarBien(idElegido, u); } } catch (System.Exception e) { Console.WriteLine("Hubo un error en el server:" + e.ToString()); } }