public override ScalarCommand CreateIdentityInsertCommand(string tableName, IDictionary <string, object> columnValues) { var scalarCommand = new ScalarCommand(); var insertCommand = CreateInsertCommand(tableName, columnValues); var selectCommand = _commandFactory.CreateCommand("SELECT CAST(@@IDENTITY AS int)"); scalarCommand.PreparatoryCommands.Add(insertCommand); scalarCommand.ResultCommand = selectCommand; return(scalarCommand); }
public override ScalarCommand CreateIdentityInsertCommand(string tableName, IDictionary<string, object> columnValues) { var scalarCommand = new ScalarCommand(); var insertCommand = CreateInsertCommand(tableName, columnValues); var selectCommand = _commandFactory.CreateCommand("SELECT CAST(@@IDENTITY AS int)"); scalarCommand.PreparatoryCommands.Add(insertCommand); scalarCommand.ResultCommand = selectCommand; return scalarCommand; }
public async Task <IActionResult> Login(string login, string password) { var command = new ScalarCommand(String.Format("select pkg_cmacros.checkAccess('{0}', '{1}') from dual", login, password)); var caller = new DbCaller(command); caller.DoWork(); if (caller.GetResult().ToString().Length == 6) { await Authenticate(new User(login, caller.GetResult().ToString())); return(RedirectToAction("Main", "Sheets")); } else { ViewBag.Message = caller.GetResult().ToString(); return(View()); } }