public static int InsertRecordSession(SessionUrl data) { int x = 0; WithConnection(conn => { x = InsertRecordSession(data, conn); }); return(x); }
public static int InsertRecordSession(SessionUrl data, SqlConnection conn) { SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(); var query = "insert into SessionUrl (url,bctenantid) OUTPUT INSERTED.ID values('" + data.url + "','" + data.bcTenantId + "')"; SqlCommand sqlCommand = new SqlCommand(query, conn); sqlDataAdapter.InsertCommand = new SqlCommand(query, conn); var val = sqlDataAdapter.InsertCommand.ExecuteScalar(); sqlCommand.Dispose(); return((Int32)val); }
public ActionResult MobilePay([FromBody] BCClientModel content) { int insertedId = 0; string baseURL = GetBaseUrl(); string returnedURL = GenerateAuthURL(content); Server.Start(REDIRECT_URL); Thread.Sleep(2); try { SessionUrl su = new SessionUrl(); su.url = returnedURL; su.bcTenantId = content.password; insertedId = DBManager.InsertRecordSession(su); } catch (Exception eexx) { throw eexx; } string dataToPassWithUrl = baseURL + "/MobilePayIndex" + "/?sessionId=" + insertedId; return(Content(dataToPassWithUrl)); }