public int UpdateUserAspiration(UserAspiration UserAspiration) { try { using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var param = new DynamicParameters(); param.Add("@Id", UserAspiration.Id); param.Add("@UserId", UserAspiration.UserId); param.Add("@Description", UserAspiration.Description); var result = con.Execute("InsertUpdateUserAspiration", param, sqltrans, 0, System.Data.CommandType.StoredProcedure); if (result > 0) { sqltrans.Commit(); } else { sqltrans.Rollback(); } return(result); } } catch (Exception ex) { throw ex; } }
public IActionResult Edit(int id, UserAspiration Aspiration) { try { _IAspiration.UpdateUserAspiration(Aspiration); return(RedirectToAction("List")); } catch { return(View()); } }
public IActionResult Delete(int id, UserAspiration Aspiration) { try { _IAspiration.DeleteUserAspiration(id); return(RedirectToAction("List")); } catch { return(View()); } }
public IActionResult Create(UserAspiration UserAspiration) { try { // TODO: Add insert logic here if (ModelState.IsValid) { UserAspiration.Id = 0; _IAspiration.InsertUserAspiration(UserAspiration); return(RedirectToAction("List", new { UserId = UserAspiration.UserId })); } return(View(UserAspiration)); } catch (Exception ex) { return(View()); } }