public JsonResult CrearEspacio(FormCollection collection) { try { CondominioDAL cond = new CondominioDAL(); ESPACIOS_COMUNES nuevo = new ESPACIOS_COMUNES(); nuevo.ID_CONDOMINIO = int.Parse(collection["condominio"].ToString()); nuevo.NOMBRE_ESPACIO = collection["nombre"].ToString(); nuevo.DESCRIPCION_ESPACIO = collection["descripcion"].ToString(); var model = cond.InsertarEspacio(nuevo); if (model) { var result = new { Success = true, Message = "Succes Message", model }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { var result = new { Success = false, Message = "Error Message" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { throw e; } }
public JsonResult CrearVivienda(FormCollection collection) { try { CondominioDAL cond = new CondominioDAL(); VIVIENDA nuevo = new VIVIENDA(); nuevo.ID_CONDOMINIO = int.Parse(collection["condominio"].ToString()); nuevo.NOMBRE_CALLE = collection["direccion"].ToString(); nuevo.NUMERO = collection["numerodire"].ToString(); nuevo.PLANTA_UBICACION = collection["planta"].ToString(); var model = cond.InsertarVivienda(nuevo); if (model) { var result = new { Success = true, Message = "Succes Message", model }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { var result = new { Success = false, Message = "Error Message" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { throw e; } }
public JsonResult CrearCondominio(FormCollection collection) { try { CondominioDAL cond = new CondominioDAL(); CONDOMINIO nuevo = new CONDOMINIO(); nuevo.ID_COMUNA = int.Parse(collection["comuna"].ToString()); nuevo.NOMBRE = collection["nombre"].ToString(); nuevo.DIRECCION = collection["direccion"].ToString(); string num = collection["numerodire"].ToString(); nuevo.NUMERO_DIRECCION = int.Parse(num); nuevo.TELEFONO = int.Parse(collection["fono"].ToString()); var model = cond.InsertarCondominio(nuevo); if (model) { var result = new { Success = true, Message = "Succes Message", model }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { var result = new { Success = false, Message = "Error Message" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { throw e; } }
private void txtIdCondominio_Click(object sender, EventArgs e) { CondominioDAL B = new CondominioDAL(); txtIdCondominio.DataSource = B.Listar(); txtIdCondominio.ValueMember = "Id"; txtIdCondominio.DisplayMember = "nome_condominio"; }
private void AlimentarGrid() { try { CondominioDAL c = new CondominioDAL(); grid_condominio.DataSource = c.Listar();//Popular o grid } catch (Exception ex) { MessageBox.Show("Não foi possivel exibir os dados" + ex); } }
private void btnIncluir_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtId.Text)) { Condominio c = new Condominio(); c.Nome_condominio = txtNome.Text; c.Cep = txtCep.Text; c.Endereco = txtEndereco.Text; c.Bairro = txtBairro.Text; c.Cidade = txtCidade.Text; c.Estado = txtEstado.Text; c.Numero = Convert.ToInt32(txtNumero.Text); c.Complemento = txtComplemento.Text; c.Observacao = txtObservacao.Text; CondominioDAL C = new CondominioDAL(); C.Record(c); //Gravando o condominio MessageBox.Show("Condominio cadastrado com sucesso!", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information); AlimentarGrid(); LimparCampos(); } else { Condominio c = new Condominio(); c.Id = Convert.ToInt32(txtId.Text); c.Nome_condominio = txtNome.Text; c.Cep = txtCep.Text; c.Endereco = txtEndereco.Text; c.Bairro = txtBairro.Text; c.Cidade = txtCidade.Text; c.Estado = txtEstado.Text; c.Numero = Convert.ToInt32(txtNumero.Text); c.Complemento = txtComplemento.Text; c.Observacao = txtObservacao.Text; CondominioDAL C = new CondominioDAL(); C.Update(c); //Gravando o condominio MessageBox.Show("Condominio atualizado com sucesso!", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information); AlimentarGrid(); LimparCampos(); } }
public JsonResult GetCondominios(FormCollection collection) { try { CondominioDAL cond = new CondominioDAL(); var model = cond.GetCondominios(); if (model != null) { var result = new { Success = true, Message = "Succes Message", model }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { var result = new { Success = false, Message = "Error Message" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { throw e; } }
private void BtnExcluir_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtId.Text)) { MessageBox.Show("Escolha um item na lista"); } else { if (MessageBox.Show("Deseja Excluir este registro? \nEssa ação não poderá ser desfeita!", "Atenção", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { Condominio C = new Condominio(); CondominioDAL c = new CondominioDAL(); C.Id = Convert.ToInt32(txtId.Text); c.Delete(Convert.ToInt32(C.Id)); MessageBox.Show("Registro " + txtId.Text + " excluído com sucesso!", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information); AlimentarGrid(); LimparCampos(); } } }
public JsonResult ObtenerCondominiosPorUsuario(FormCollection collection) { try { string usuario = collection["Usuario"].ToString(); CondominioDAL cond = new CondominioDAL(); var model = cond.GetCondominioPorUsuario(usuario); if (model != null) { var result = new { Success = true, Message = "Succes Message", model }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { var result = new { Success = false, Message = "Error Message" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { throw e; } }
public JsonResult ObtenerInfoViviendasPorResidente(FormCollection collection) { try { string usuario = Session["UserID"].ToString(); CondominioDAL cond = new CondominioDAL(); var model = cond.RetronarVistaInfoVivienda(usuario); if (model != null) { var result = new { Success = true, Message = "Succes Message", model }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { var result = new { Success = false, Message = "Error Message" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { throw e; } }
public JsonResult ObtenerResidenciasPorCondominio(FormCollection collection) { try { int condominio = int.Parse(collection["Condominio"].ToString()); CondominioDAL cond = new CondominioDAL(); var model = cond.GetViviendasPorCondominio(condominio); if (model != null) { var result = new { Success = true, Message = "Succes Message", model }; return(Json(result, JsonRequestBehavior.AllowGet)); } else { var result = new { Success = false, Message = "Error Message" }; return(Json(result, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { throw e; } }