private void SaveCondominio(CondominioModel c)
{
data.connectToDB();
SqlCommand cmd = new SqlCommand("insertCond", data.connection());
//cmd.CommandText = "INSERT proj_condominio (num_fiscal, gerente_nif, nome) Values(@num_fiscal, @gerente_nif, @nome)";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@num_fiscal", c.num_fiscal);
cmd.Parameters.AddWithValue("@gerente_nif", c.gerente_nif);
cmd.Parameters.AddWithValue("@nome", c.nome);
cmd.Connection = data.connection();
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Entry Successful!");
}
catch (Exception ex)
{
//throw new Exception("Failed to insert in database. \n ERROR MESSAGE: \n" + ex.Message);
MessageBox.Show("Não foi possível guardar os dados! Verifique os campos inseridos!");
}
finally
{
data.close();
}
}
public AddCondominio(CondominioModel c)
{
InitializeComponent();
FillGerenteLisBox();
FillCondInfo(c);
adding = false; // update
}
private void addCond_button_Click(object sender, EventArgs e)
{
CondominioModel cond = new CondominioModel();
try
{
cond.num_fiscal = Decimal.Parse(num_fical_TextBox.Text.ToString());
cond.gerente_nif = (gerentes_listBox.SelectedItem as GerenteView).value;
cond.nome = nome_cond_textBox.Text.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (adding)
{
SaveCondominio(cond);
}
else
{
UpdateCondominio(cond);
}
CondoForm parent = (CondoForm)Owner;
parent.FillCondominiosLisBox();
parent.Show();
this.Close();
}
private void UpdateCondominio(CondominioModel c)
{
data.connectToDB();
SqlCommand cmd = new SqlCommand("updateCond", data.connection());
//cmd.CommandText = "UPDATE proj_condominio SET gerente_nif = @gerente_nif WHERE num_fiscal = @num_fiscal";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@num_fiscal", c.num_fiscal);
cmd.Parameters.AddWithValue("@gerente_nif", c.gerente_nif);
cmd.Connection = data.connection();
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Update Successful!");
}
catch (Exception ex)
{
//throw new Exception("Failed to update in database. \n ERROR MESSAGE: \n" + ex.Message);
MessageBox.Show("Não foi possível atualizar os dados! Verifique os campos inseridos!");
}
finally
{
data.close();
}
}
private void FillCondInfo(CondominioModel c)
{
num_fical_TextBox.Text = c.num_fiscal.ToString();
num_fical_TextBox.ReadOnly = true;
name_cond_label.Text = c.nome;
add_nome_cond_label.Hide();
nome_cond_textBox.Hide();
}
/// <summary>
/// Altera dados na base de dados
/// </summary>
/// <param name="condominioModel">Dados do modelo</param>
public void Editar(CondominioModel condominioModel)
{
tb_condominio condominioE = new tb_condominio();
Atribuir(condominioModel, condominioE);
unitOfWork.RepositorioCondominio.Editar(condominioE);
unitOfWork.Commit(shared);
}
public void EditarTest()
{
GerenciadorCondominio target = new GerenciadorCondominio();
CondominioModel condominioModel = target.Obter(1);
condominioModel.Nome = "Condimínio Edfício Atlanta";
target.Editar(condominioModel);
Assert.AreSame("Condimínio Edfício Atlanta", condominioModel.Nome);
}
public ActionResult Edit(CondominioModel condominioModel)
{
if (ModelState.IsValid)
{
gCondominio.Editar(condominioModel);
return(RedirectToAction("Index"));
}
return(View(condominioModel));
}
public void RemoverTest()
{
GerenciadorCondominio target = new GerenciadorCondominio();
CondominioModel condominio = target.Obter(1);
Assert.AreSame(condominio.IdCondominio, 1);
condominio.IdCondominio = 1;
target.Remover(condominio.IdCondominio);
}
public ActionResult Create(CondominioModel condominioModel)
{
if (ModelState.IsValid)
{
gCondominio.Inserir(condominioModel);
return(RedirectToAction("Index"));
}
return(View(condominioModel));
}
/// <summary>
/// Insere um novo na base de dados
/// </summary>
/// <param name="condominioModel">Dados do modelo</param>
/// <returns>Chave identificante na base</returns>
public int Inserir(CondominioModel condominioModel)
{
tb_condominio condominioE = new tb_condominio();
Atribuir(condominioModel, condominioE);
unitOfWork.RepositorioCondominio.Inserir(condominioE);
unitOfWork.Commit(shared);
return(condominioE.IdCondominio);
}
public void AtribuirTest()
{
GerenciadorCondominio_Accessor target = new GerenciadorCondominio_Accessor(); // TODO: Initialize to an appropriate value
CondominioModel condominioModel = null; // TODO: Initialize to an appropriate value
tb_condominio condominioE = null; // TODO: Initialize to an appropriate value
target.Atribuir(condominioModel, condominioE);
Assert.Inconclusive("A method that does not return a value cannot be verified.");
}
public void ObterTest()
{
GerenciadorCondominio target = new GerenciadorCondominio();
CondominioModel novoCondominio = target.Obter(1);
CondominioModel actual = new CondominioModel();
actual.IdCondominio = 1;
actual = target.Obter(actual.IdCondominio);
Assert.AreEqual(actual, novoCondominio);
}
/// <summary>
/// Atribui dados do Condominio Model para o Condominio Entity
/// </summary>
/// <param name="condominioModel">Objeto do modelo</param>
/// <param name="condominioE">Entity mapeada da base de dados</param>
private void Atribuir(CondominioModel condominioModel, tb_condominio condominioE)
{
condominioE.IdCondominio = condominioModel.IdCondominio;
condominioE.Nome = condominioModel.Nome;
condominioE.Rua = condominioModel.Rua;
condominioE.Numero = condominioModel.Numero;
condominioE.Bairro = condominioModel.Bairro;
condominioE.Complemento = condominioModel.Complemento;
condominioE.CEP = condominioModel.Cep;
condominioE.Cidade = condominioModel.Cidade;
condominioE.Estado = condominioModel.Estado;
}
//
// GET: /condominio/Edit/5
// [Authorize(Roles = "Adm Sistema")]
public ActionResult Edit(int id)
{
CondominioModel condominio = gCondominio.Obter(id);
return(View(condominio));
}
//
// GET: /condominio/Details/5
//[Authorize(Roles = "Adm Sistema")]
public ViewResult Details(int id)
{
CondominioModel condominio = gCondominio.Obter(id);
return(View(condominio));
}
public ActionResult Edit(CondominioModel modelo)
{
var resul = _condominioBusiness.Actualizar(modelo);
return(Json(resul));
}
public ActionResult Create(CondominioModel modelo)
{
var resul = _condominioBusiness.Agregar(modelo);
return(Json(resul));
}
//
// GET: /condominio/Delete/5
public ActionResult Delete(int id)
{
CondominioModel condominioModel = gCondominio.Obter(id);
return(View(condominioModel));
}
public PartialViewResult Grid(CondominioModel modelo)
{
var resul = condominioBl.Consultar(modelo);
return(PartialView("~/Views/Condominio/Grid.cshtml", (List <DAL.CAT_CONDOMINIOS>)resul.datos));
}
public PartialViewResult Grid(CondominioModel modelo)
{
var resul = _condominioBusiness.Consultar(modelo);
return(PartialView("~/Views/Condominio/CondominioGrid.cshtml", (List <AdminVivienda.DAL.CAT_CONDOMINIO>)resul.datos));
}
