/// <summary> /// AtualizaRtuEdit /// </summary> /// <param name="model"></param> /// <param name="usu_id">Id do Usuário Logado</param> /// <param name="ip">IP do Usuário Logado</param> /// <returns>int</returns> public int ReparoTpu_Salvar(TpuDtoModel model, int usu_id, string ip) { using (SqlConnection con = new SqlConnection(new Conexao().strConn)) { try { if (model.rtu_fonte_txt == null) { model.rtu_fonte_txt = ""; } con.Open(); SqlCommand com = new SqlCommand(); com.CommandText = "STP_UPD_REPARO_TPU"; com.Connection = con; com.CommandType = CommandType.StoredProcedure; com.Parameters.Clear(); System.Data.SqlClient.SqlParameter p_return = new System.Data.SqlClient.SqlParameter(); p_return.Direction = System.Data.ParameterDirection.ReturnValue; com.Parameters.Add(p_return); com.Parameters[0].Size = 32000; com.Parameters.AddWithValue("@rpt_id", model.rpt_id); com.Parameters.AddWithValue("@fon_id", model.fon_id); com.Parameters.AddWithValue("@rtu_fonte_txt", model.rtu_fonte_txt.ToString()); com.Parameters.AddWithValue("@rtu_codigo_tpu", model.rtu_codigo_tpu); com.Parameters.AddWithValue("@rtu_preco_unitario", model.rtu_preco_unitario); com.Parameters.AddWithValue("@rtu_data_base", model.rtu_data_base); com.Parameters.AddWithValue("@rtu_id", model.rtu_id); com.Parameters.AddWithValue("@usu_id", usu_id); com.Parameters.AddWithValue("@ip", ip); com.ExecuteScalar(); return(Convert.ToInt32(p_return.Value)); } catch (Exception ex) { int id = 0; new LogSistemaDAO().InserirLogErro(new LogErro(ex, this.GetType().Name, new StackTrace().GetFrame(0).GetMethod().Name), out id); throw new Exception(ex.Message); } } }
/// <summary> /// Editar /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult ReparoTpu_Salvar(TpuDtoModel model) { return(Json(new ReparoBLL().ReparoTpu_Salvar(model), JsonRequestBehavior.AllowGet)); }
/// <summary> /// Salva REPARO TPU /// </summary> /// <param name="model">Dados a serem inseridos</param> /// <returns>int</returns> public int ReparoTpu_Salvar(TpuDtoModel model) { Usuario paramUsuario = (Usuario)System.Web.HttpContext.Current.Session["Usuario"]; return(new ReparoTpuDAO().ReparoTpu_Salvar(model, paramUsuario.usu_id, paramUsuario.usu_ip)); }