public int CreateBankTrn(BankTrn banktrn)
{
int res = 0;
try
{
using (var sqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings[""].ConnectionString))
{
SqlCommand cmd = new SqlCommand("SaveBankTransactions", sqlconnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TransactionType", banktrn.TransactionType);
cmd.Parameters.AddWithValue("@Amount", banktrn.Amount);
cmd.Parameters.AddWithValue("@DateOfTrn", banktrn.DateOfTrn);
cmd.Parameters.AddWithValue("@TrnDoneBy", banktrn.TrnDoneBy);
sqlconnection.Open();
res = cmd.ExecuteNonQuery();
sqlconnection.Close();
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(res);
}
public IHttpActionResult CreateBankTrn(BankTrn banktrn)
{
var NewBankTrn = _repository.CreateBankTrn(banktrn);
return(Ok(NewBankTrn));
}