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());
}
}
