public IHttpActionResult Post(Codetransfer codetransfer) { if (!ModelState.IsValid) { return(BadRequest("You inserted invalid data!")); } var identity = (ClaimsIdentity)User.Identity; String userId = identity.Claims .Where(c => c.Type == "UserId") .Select(c => c.Value).FirstOrDefault(); codetransfer.Creator = Convert.ToInt64(userId); int retVal = _repo.SaveCodeTransfer(codetransfer); if (retVal == 1) { return(Ok()); } else { return(BadRequest("Transfered amount is not valid!")); } }
public int SaveCodeTransfer(Codetransfer codeTransfer) { using (IDbConnection cnn = new SqlConnection(GetConnectionString())) { var p = new DynamicParameters(); p.Add("@SentCodeID", codeTransfer.SentCodeId); p.Add("@ReceivedCodeID", codeTransfer.ReceivedCodeId); p.Add("@FiscalYearId", codeTransfer.FiscalYearId); p.Add("@TransactionAmount", codeTransfer.TransactionAmount); p.Add("@TransactionNote", codeTransfer.TransactionNote); p.Add("@TransactionDate", DateTime.Now); p.Add("@DateCreated", DateTime.Now); p.Add("@Creator", codeTransfer.Creator); p.Add("@flag", DbType.Int32, direction: ParameterDirection.Output); string sql = "dbo.spTransaction_CodeTransfer"; cnn.Execute(sql, p, commandType: CommandType.StoredProcedure); int retVal = p.Get <int>("flag"); return(retVal); } }