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());
}
}
