public JsonResult NovoTipoDespesa(Financeiro.Models.TipoDespesa dto) { var currentUserId = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(HttpContext.User.Identity.GetUserId()).Id; Processo.ProcessoFinancas processo = new Processo.ProcessoFinancas(); processo.CriarTipoDespesa(dto, currentUserId); return(Json(true)); }
public void CriarTipoDespesa(Financeiro.Models.TipoDespesa tipoDespesa, string currentUserID) { using (SqlConnection connection = new SqlConnection(StringConnection)) { try { using (SqlConnection cn = new SqlConnection(StringConnection)) using (SqlCommand cmd = new SqlCommand(InsertTipoDespesa, cn)) { cmd.Parameters.Add(new SqlParameter("@Nome", tipoDespesa.Nome)); cmd.Parameters.Add(new SqlParameter("@Cor", tipoDespesa.Cor ?? DBNull.Value.ToString())); cmd.Parameters.Add(new SqlParameter("@CreateTime", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@CreateBy", currentUserID)); cmd.Parameters.Add(new SqlParameter("@Obsoleto", false)); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); } } catch (Exception ex) { } } }