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