public IActionResult DepositFromTerminal([FromBody] DepositFromTerminal deposit)
{
bool ok = _terminalService.DepositFromTerminal(deposit);
if (ok)
{
return(Ok("ok"));
}
else
{
return(Ok("error"));
}
}
public bool DepositFromTerminal(DepositFromTerminal deposit)
{
bool ok = true;
try
{
deposit = DepositInsert(deposit);
DepositNotesInsert(deposit);
}
catch
{
ok = false;
}
return(ok);
}
private void DepositNotesInsert(DepositFromTerminal deposit)
{
string strCol = "";
string strVal = "";
foreach (var n in deposit.Notes)
{
strCol += ",Notes" + n.NoteId;
strVal += "," + n.Count;
}
using (MySqlConnection conn = GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("insert into DepositNotes (DepositId " + strCol + ") values (" + deposit.DepositId + " " + strVal + ") ;", conn);
cmd.ExecuteNonQuery();
}
//return _deposit;
}
private DepositFromTerminal DepositInsert(DepositFromTerminal deposit)
{
var _deposit = deposit;
_deposit.Amount = Decimal.ToInt32(Convert.ToDecimal(_deposit.Amount)).ToString();
using (MySqlConnection conn = GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("insert into Deposit (DepositNumber,Amount, DateEnd,TerminalId,UserId) values ('" + _deposit.DepositNumber.ToString() + "'," + _deposit.Amount + ", NOW()," + _deposit.TerminalId + "," + _deposit.UserId + ");SELECT LAST_INSERT_ID();", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
_deposit.DepositId = Convert.ToInt32(reader[0]);
}
}
}
return(_deposit);
}
