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