public IActionResult DeleteFinca(string numeroRegistro)
{
Respuesta respuesta = new Respuesta();
using (var db = new SIPGAVContext())
{
using (var transsacion = db.Database.BeginTransaction())
{
try
{
Finca finca = db.Fincas.Find(numeroRegistro);
db.Fincas.Remove(finca);
db.SaveChanges();
transsacion.Commit();
respuesta.Exito = 1;
respuesta.Mensaje = "Finca Eliminado Con Exito!";
}
catch (Exception ex)
{
transsacion.Rollback();
respuesta.Mensaje = ex.Message;
}
}
}
return(Ok(respuesta));
}
public IActionResult UpdateFinca(FincaViewModel model)
{
Respuesta respuesta = new Respuesta();
using (var db = new SIPGAVContext())
{
using (var transsacion = db.Database.BeginTransaction())
{
Finca finca = new Finca();
try
{
finca = db.Fincas.Find(model.NumeroRegistro);
finca = Map(model);
db.Entry(finca).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
transsacion.Commit();
respuesta.Exito = 1;
respuesta.Mensaje = "Finca Modificado Con Exito!";
}
catch (Exception ex)
{
transsacion.Rollback();
respuesta.Mensaje = ex.Message;
}
return(Ok(respuesta));
}
}
}
public CargarFinca Agregar(Finca finca)
{
conectar.Open();
SqlCommand cm = new SqlCommand("INSERT INTO COM.FINCA (PER_ID, VER_ID, FIN_DESC) VALUES ('" + finca.per_id + "', '" + finca.ver_id + "', '" + finca.fin_desc + "')", conectar);
cm.ExecuteNonQuery();
CargarFinca cargarFinca = null;
cm = new SqlCommand(" SELECT TOP 1 " +
" 'id' = F.FIN_ID," +
" 'fin_descripcion' = F.FIN_DESC," +
" 'per_id' = F.PER_ID," +
" 'nombres' = CONCAT(PE.PER_APELLIDO1,' ', PE.PER_APELLIDO2, ' ', PE.PER_NOMBRE1, ' ', PE.PER_NOMBRE2)," +
" 'ver_id' = F.VER_ID," +
" 'ver_descripcion' = V.VER_DESC" +
" FROM COM.FINCA F" +
" INNER JOIN COM.PERSONA PE ON PE.PER_ID = F.PER_ID" +
" INNER JOIN COM.VEREDA V ON V.VER_ID = F.VER_ID" +
" ORDER BY F.FIN_ID DESC ", conectar);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cm);
da.Fill(ds, "finca");
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
cargarFinca = getCargarFinca(dr);
}
conectar.Close();
return(cargarFinca);
}
public ActionResult AddFinca(FincaViewModel model)
{
Respuesta respuesta = new Respuesta();
using (var db = new SIPGAVContext())
{
using (var transsacion = db.Database.BeginTransaction())
{
Finca finca = new Finca();
try
{
finca = Map(model);
db.Fincas.Add(finca);
db.SaveChanges();
transsacion.Commit();
respuesta.Exito = 1;
respuesta.Mensaje = "Finca Registrado Con Exito!";
}
catch (Exception ex)
{
transsacion.Rollback();
respuesta.Mensaje = ex.Message;
}
return(Ok(respuesta));
}
}
}
private void cargarAnimales()
{
try
{
SqlConnection conx = new SqlConnection(ConfigurationManager.ConnectionStrings["cadenaConexion"].ConnectionString);
string query = "SELECT * FROM Animales join Raza on Animales.Id_Raza = Raza.Id_Raza join Finca on Animales.Id_Finca = Finca.Id_Finca;";
conx.Open();
SqlCommand comando = new SqlCommand(query, conx);
SqlDataReader dr = comando.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
Raza raza = new Raza(dr.GetInt32(8), dr.GetString(9));
Finca finca = new Finca(dr.GetInt32(10), dr.GetString(11), dr.GetInt32(12), dr.GetString(13), dr.GetInt32(14));
Animal animal = new Animal(dr.GetInt32(0), dr.GetString(1), finca, raza, dr.GetInt32(5), null, null, dr.GetDateTime(4));
animales.Add(animal);
}
}
conx.Close();
}
catch (SqlException x)
{
MessageBox.Show("Error! al cargar datos");
}
}
private void cargarDuenos()
{
try
{
SqlConnection conx = new SqlConnection(ConfigurationManager.ConnectionStrings["cadenaConexion"].ConnectionString);
string query = "SELECT * FROM Duenno join Finca on Duenno.Id_Finca = Finca.Id_Finca;";
conx.Open();
SqlCommand comando = new SqlCommand(query, conx);
SqlDataReader dr = comando.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
Finca finca = new Finca(dr.GetInt32(7), dr.GetString(8), dr.GetInt32(9), dr.GetString(10), dr.GetInt32(11));
Dueno dueno = new Dueno(dr.GetInt32(0), dr.GetString(1), dr.GetString(2), dr.GetString(3), dr.GetString(4), dr.GetInt32(5), finca);
duenos.Add(dueno);
}
}
conx.Close();
}
catch (SqlException x)
{
MessageBox.Show("Error! al cargar datos");
}
}
private void cargarFincas()
{
try
{
SqlConnection conx = new SqlConnection(ConfigurationManager.ConnectionStrings["cadenaConexion"].ConnectionString);
string query = "SELECT * FROM Finca;";
conx.Open();
SqlCommand comando = new SqlCommand(query, conx);
SqlDataReader dr = comando.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
Finca finca = new Finca(dr.GetInt32(0), dr.GetString(1), dr.GetInt32(2), dr.GetString(3), dr.GetInt32(4));
fincas.Add(finca);
}
}
llenarComboFincas();
conx.Close();
}
catch (SqlException x)
{
MessageBox.Show("Error! al cargar datos");
}
}
public async Task <IHttpActionResult> PutFinca(int id, Finca finca)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != finca.IdFinca)
{
return(BadRequest());
}
db.Entry(finca).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FincaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private int obtenerIdF()
{
Finca finca = (Finca)cbxFincas.SelectedItem;
int idFinca = finca.NumFinca;
return(idFinca);
}
public ActionResult DeleteConfirmed(int id)
{
Finca finca = db.Finca.Find(id);
db.Finca.Remove(finca);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void RegistrarFinca(Finca finca)
{
using (controlagricolaContext context = new controlagricolaContext())
{
context.Finca.Add(finca);
context.SaveChanges();
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Finca finca = await db.Fincas.FindAsync(id);
db.Fincas.Remove(finca);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "codigo,nombre,vereda,municipio,departamento")] Finca finca)
{
if (ModelState.IsValid)
{
db.Entry(finca).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(finca));
}
protected void Button1_Click(object sender, EventArgs e)
{
Finca finca = new Finca();
finca.nombre = txtNombre.Text;
finca.area = Int32.Parse(txtArea.Text);
finca.idProductor = Int32.Parse(txtIdProductor.Text);
FincaDA.Agregar(finca);
}
public ActionResult Create([Bind(Include = "codigo,nombre,vereda,municipio,departamento")] Finca finca)
{
if (ModelState.IsValid)
{
db.Finca.Add(finca);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(finca));
}
public async Task <IHttpActionResult> GetFinca(int id)
{
Finca finca = await db.Fincas.FindAsync(id);
if (finca == null)
{
return(NotFound());
}
return(Ok(finca));
}
public async Task <ActionResult> Edit([Bind(Include = "IdFinca,NomFinca,TelefonoFinca,CantidadPultpaFinca,CoordenadasFinca,ImgFinca,FechaFinca")] Finca finca)
{
if (ModelState.IsValid)
{
db.Entry(finca).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(finca));
}
public bool TryAddFinca(ref Finca finca, double?coeficiente = null)
{
if (this.FincasCoeficientes.ContainsKey(finca))
{
return(false);
}
this._CoeficientesCustom = this._CoeficientesCustom || (finca.Coeficiente != coeficiente);
this._FincasCoeficientes.Add(finca, coeficiente ?? finca.Coeficiente);
return(true);
}
public bool TryRemoveFinca(ref Finca finca)
{
if (!this.FincasCoeficientes.ContainsKey(finca))
{
return(false);
}
this._FincasCoeficientes.Remove(finca);
SetCoeficientesCustom();
return(true);
}
public async Task <IHttpActionResult> PostFinca(Finca finca)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Fincas.Add(finca);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = finca.IdFinca }, finca));
}
public static int Agregar(Finca pfinca)
{
int retorno = 0;
using (SqlConnection conn = BDConnection.obtenerCnx())
{
SqlCommand comando = new SqlCommand(String.Format("Insert into Finca (nombre, area, id_productor) values ('{0}','{1}','{2}')",
pfinca.nombre, pfinca.area, pfinca.idProductor), conn);
retorno = comando.ExecuteNonQuery();
}
return(retorno);
}
// GET: Fincas/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Finca finca = db.Finca.Find(id);
if (finca == null)
{
return(HttpNotFound());
}
return(View(finca));
}
// GET: Fincas/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Finca finca = await db.Fincas.FindAsync(id);
if (finca == null)
{
return(HttpNotFound());
}
return(View(finca));
}
private void Editar(Finca finca)
{
if (Validar(finca))
{
using (var db = new AcopioDb())
{
var fincaBusiness = new FincaBusiness(db);
fincaBusiness.Edit(finca);
db.SaveChanges();
}
}
}
public async Task <IHttpActionResult> DeleteFinca(int id)
{
Finca finca = await db.Fincas.FindAsync(id);
if (finca == null)
{
return(NotFound());
}
db.Fincas.Remove(finca);
await db.SaveChangesAsync();
return(Ok(finca));
}
public static Finca fincacon(int id)
{
try
{
using (var db = new FincasCafeterasCon())
{
Finca f1 = db.Finca.Find(id);
return(f1);
}
}
catch (Exception)
{
return(null);
}
}
public Finca Map(FincaViewModel model)
{
Finca finca = new Finca();
finca.NumeroRegistro = model.NumeroRegistro;
finca.IdUsuario = model.IdUsuario;
finca.NombreFinca = model.NombreFinca;
finca.Descripcion = model.Descripcion;
finca.Hectareas = model.Hectareas;
finca.Ubicacion = model.Ubicacion;
finca.Foto = UploadPhoto();
finca.FechaIngreso = DateTime.Now;
return(finca);
}
public static String NombreFinca(int id)
{
try
{
using (var db = new FincasCafeterasCon())
{
Finca f1 = db.Finca.Find(id);
return(f1.Nombre);
}
}
catch (Exception ex)
{
return("" + ex);
}
}
private void Nuevo()
{
nombreTextBox.Clear();
cantidadNumeric.Value = 0;
productorComboBox.SelectedIndex = -1;
comarcaComboBox.SelectedIndex = -1;
this.finca = new Finca();
this.FincaForEdit = false;
EliminarButton.Enabled = false;
}
public ActionResult EditarFinca(int id)
{
try
{
using (var db = new FincasCafeterasCon())
{
//Finca f1 = db.Finca.Where(f => f.Codigo == id).FirstOrDefault();
Finca f1 = db.Finca.Find(id);
return(View(f1));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error editando finca", ex);
return(View());
}
}
