private void edit_bt_Click(object sender, EventArgs e)
{
int obra_id = Int32.Parse(obras_dataGridView1.CurrentRow.Cells[0].Value.ToString());
data.connectToDB();
ObraModel tmp = new ObraModel();
//String sql = String.Format("SELECT * FROM proj_obras WHERE obra_id = '" + obra_id + "'");
SqlCommand com = new SqlCommand("getObrasById", data.connection());
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@obra_id", obra_id);
SqlDataReader reader;
reader = com.ExecuteReader();
while (reader.Read())
{
tmp.obra_id = Int32.Parse(reader["obra_id"].ToString());
tmp.data_ini = DateTime.Parse(reader["data_ini"].ToString());
tmp.data_fim = DateTime.Parse(reader["data_fim"].ToString());
tmp.orcamento = Int32.Parse(reader["orcamento"].ToString());
tmp.condominio = Decimal.Parse(reader["condominio"].ToString());
}
data.close();
tmp.empresa = Decimal.Parse(obras_dataGridView1.CurrentRow.Cells[2].Value.ToString());
AddObra o = new AddObra(tmp);
o.ShowDialog(this);
}
private List <ObraModel> GetObras()
{
data.connectToDB();
List <ObraModel> obras = new List <ObraModel>();
String sql = "SELECT * FROM proj_obras";
SqlCommand com = new SqlCommand(sql, data.connection());
SqlDataReader reader;
reader = com.ExecuteReader();
while (reader.Read())
{
ObraModel tmp = new ObraModel();
tmp.obra_id = Int32.Parse(reader["obra_id"].ToString());
tmp.data_ini = DateTime.Parse(reader["data_ini"].ToString());
tmp.data_fim = DateTime.Parse(reader["data_fim"].ToString());
tmp.orcamento = Int32.Parse(reader["orcamento"].ToString());
tmp.condominio = Decimal.Parse(reader["condominio"].ToString());
obras.Add(tmp);
}
data.close();
return(obras);
}
private void SaveObra(ObraModel o)
{
data.connectToDB();
SqlCommand cmd = new SqlCommand("insertObra", data.connection());
//cmd.CommandText = "INSERT proj_obras (obra_id, data_ini, data_fim, orcamento, condominio) Values(@obra_id, @data_ini, @data_fim, @orcamento, @condominio)";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@obra_id", o.obra_id);
cmd.Parameters.AddWithValue("@data_ini", o.data_ini);
cmd.Parameters.AddWithValue("@data_fim", o.data_fim);
cmd.Parameters.AddWithValue("@orcamento", o.orcamento);
cmd.Parameters.AddWithValue("@condominio", o.condominio);
cmd.Parameters.AddWithValue("@empresa", o.empresa);
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!");
MessageBox.Show(ex.Message);
}
finally
{
data.close();
}
}
private void ok_bt_Click(object sender, EventArgs e)
{
ObraModel obra = new ObraModel();
try
{
obra.obra_id = Int32.Parse(id_textBox.Text);
obra.data_ini = DateTime.Parse(ini_dateTimePicker.Text.ToString());
obra.data_fim = DateTime.Parse(fim_dateTimePicker.Text.ToString());
obra.orcamento = Int32.Parse(orcamento_textBox.Text.ToString());
obra.condominio = (condominio_comboBox.SelectedItem as CondominioView).value;
obra.empresa = (empresa_comboBox.SelectedItem as EmpresaView).value;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (adding)
{
SaveObra(obra);
}
else
{
UpdateObra(obra);
}
Obras parent = (Obras)Owner;
parent.GetObrasByCondominio(obra.condominio);
this.Close();
}
private void UpdateObra(ObraModel o)
{
data.connectToDB();
//cmd.CommandText = "UPDATE proj_obras SET data_ini = @data_ini, "
// + "data_fim = @data_fim, orcamento = @orcamento, "
// + "condominio = @condominio WHERE obra_id = @obra_id";
SqlCommand cmd = new SqlCommand("updateObra", data.connection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@obra_id", o.obra_id);
cmd.Parameters.AddWithValue("@data_ini", o.data_ini);
cmd.Parameters.AddWithValue("@data_fim", o.data_fim);
cmd.Parameters.AddWithValue("@orcamento", o.orcamento);
cmd.Parameters.AddWithValue("@condominio", o.condominio);
cmd.Parameters.AddWithValue("empresa", o.empresa);
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();
}
}
public AddObra(ObraModel o)
{
InitializeComponent();
adding = false;
FillCondominioBox();
FillEmpresaLisBox();
FillObraInfo(o);
}
public async Task <IActionResult> Insert(ObraModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var obra = _mapper.Map <ObraDto>(model);
await _obraRepositorio.Insertar(obra);
return(Ok(model));
}
private void FillObraInfo(ObraModel o)
{
id_textBox.Text = o.obra_id.ToString();
id_textBox.ReadOnly = true;
ini_dateTimePicker.Text = o.data_ini.ToString();
fim_dateTimePicker.Text = o.data_fim.ToString();
orcamento_textBox.Text = o.orcamento.ToString();
condominio_comboBox.Text = getNomeCond(o.condominio);
empresa_comboBox.Text = getNomeEmpresa(o.empresa);
empresa_comboBox.Enabled = false;
}
public async Task <IActionResult> Edit(long id, ObraModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var obra = _mapper.Map <ObraDto>(model);
obra.Id = id;
await _obraRepositorio.Modificar(obra);
return(Ok(model));
}
