protected void btnSalvar_Click(object sender, EventArgs e) { CalculaPacote(); try { MonitoramentoModel mm = new MonitoramentoModel(); mm.Descricao = txtdescricao.Text; mm.NomeCli = txtnome.Text; mm.Qtd_camera = Convert.ToInt32(txtqtd_camera.Text); mm.Valor_pacote = Convert.ToDecimal(txtvalor_pacote.Text); mm.Plano = txtplano.Text; mm.Fidelidade = chckfidelidade.Checked; new ControleMonitoramento().Insert(mm); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Registro Salvo Com Sucesso')", true); } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('" + ex.Message + "')", true); } Dispose(); carregaGrid(); }
public bool Insert(MonitoramentoModel mm) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Proc_Inserir_MM"; cmd.Parameters.Add(new SqlParameter("@descricao", mm.Descricao)); cmd.Parameters.Add(new SqlParameter("@qtd_cameras", mm.Qtd_camera)); cmd.Parameters.Add(new SqlParameter("@nomeCli", mm.NomeCli)); cmd.Parameters.Add(new SqlParameter("@valorPacote", mm.Valor_pacote)); cmd.Parameters.Add(new SqlParameter("@fidelidade", mm.Fidelidade)); cmd.Parameters.Add(new SqlParameter("@plano", mm.Plano)); con.Open(); cmd.Connection = con; cmd.ExecuteNonQuery(); return(true); }