public ActionResult Create(TimkenModel collection) { try { // TODO: Add insert logic here var x = _iTimkenRepo.AddData(collection); return(RedirectToAction("Index")); } catch { return(View()); } }
public int AddData(TimkenModel collection) { var parameterDapper = new DynamicParameters(); parameterDapper.Add("@JobId", collection.JobId); parameterDapper.Add("@DesignationId", collection.DesignationId); parameterDapper.Add("@ManagerId", collection.ManagerId); parameterDapper.Add("@Name", collection.Name); parameterDapper.Add("@StateId", collection.StateId); parameterDapper.Add("@CityName", collection.CityName); parameterDapper.Add("@JobDescription", collection.JobDescription); parameterDapper.Add("Result", dbType: DbType.Int32, direction: ParameterDirection.Output); con.Query <int>("[UserDataInsert]", parameterDapper, commandType: CommandType.StoredProcedure); return(parameterDapper.Get <int>("Result")); }